Monday, May 18, 2009

litsupport summary for the week ending on 05/17/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. Sample interview questions for a litsupport person and practical advice?
A. There is more than one correct answer to the questions below. Tech-centered questions are important, but so are questions that probe a candidate's legal knowledge.
  • What's the difference between an RFA and an RFP?
  • How many days does a party have to respond to a document request in your jurisdiction? State court? Federal court?
  • Are there any locally important issues, cases, or personalties with respect to e-discovery in your jurisdiction? What/who are they? (e.g. we appear> before J. Grimm);
  • Name one case that's important for electronic discovery and/or review, and explain why it's important;
  • What is the best evidence rule?
  • What is a third party subpoena?
  • What differences in approach to data collection, processing, and review, if  any, are there when responding to a third-party subpoena and a subpoena in an active matter of your client's?
  • A partner calls you at 4:30 and says she has a floppy disc with half a dozen files to print before she leaves. You get to her office and find the "floppy" is a DVD and the files are 7 PSTs totalling 4 GB. What do you tell the partner?
  • What is spoliation?
  • How would you document the steps you took for a document production?
  • A lawyer says he has an SEC securities fraud case. The "client's IT guy" has already removed and sent the hard drive from the computer of a trader who recently left the client's firm under questionable circumstances. The lawyer wants your help "to take a look at" what's on the drive. What do you do and what do you tell him?
  • How would you explain slack space and unallocated space to an attorney who was techno-phobic?
  • At an overarching level, look at your own specific needs. Talk to the people doing the job already. Look back at help tickets or problems you've faced in the last month or two;
  • Don't denigrate an entire class of job applicants (e.g. "button pushers" and "load monkeys" [sic]) or go into an interview with a disdain for applicants who can't do X. The good applicants will pick up on that and won't want to work for you;
  • Don't get hung up on whether an applicant knows terms that are reasonably open to synonyms or alternate uses. In one state it may be RFPs and in another - "doc requests";
  • What to look for in a candidate? Willing and able to: adapt workflows to current context; learn just about anything quickly, preferably autodidactic; strong sense of personal accountability; handle stress well (ie: doesn't become a "crab in a basket").
This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

litsupport summary for the week ending on 05/10/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. Sample pst or nsf data that is public and can be used to prepare open presentations, for testing, etc.
A. Enron email dataset in various forms and from various sources:
  • The latest and best can be downloaded from EDRM, other sources include:
  • http://bailando.sims.berkeley.edu/enron_email.html
  • http://www.enronemail.com/
  • http://www.cs.cmu.edu/~enron/


This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

Monday, May 4, 2009

litsupport summary for the week ending on 05/03/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. What are the possible approaches to "I want to redact now" need, and can one redact native documents?
A. The editors understand that the topic may be broader than what is addressed in this week's responses. Our goal is to accurately summarize the responses made without adding any material on our own. There are three approaches. We will use the term TIFF, but it applies equally to PDF.
  • TIFF everything up-front, keep it hidden in the database, and "turn it on" when you want to redact. It may be called "TIFF on demand," but in reality the TIFFs are there. The potential downsides are higher processing costs and larger database, which may slow down performance;
  • "Image on the fly" generates TIFF when needed, and one may have to wait while the document is generated, unless the vendor generates individual pages when viewed. Potential issues are documents that are hard to image, such as spreadsheets with pivot tables;
  • "Native redaction" are tools that overlay redactions over the native document, giving more flexibility and allowing to modify redactions. The potential problem to watch is that the coordinates of the redactions must be burned precisely into the image of the document on production.


Q. Should self-promotion with cartoons be allowed in the group, and can the cartoons be considered self-promotion?
A.


Pros: it is fun, and we need fun; we are all vendors here anyway, and litsupport staff too has to "sell" their services to their firms; we are all self-promoting, even a business card or a signature is self-promotion;
Cons: the rules of the group disallow direct promotion; the cartoons are too much pro-business; they are not directly related to the purpose of the group, there are also many buyers here.


This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

Wednesday, April 29, 2009

litsupport summary for the week ending on 04/26/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. How to convert Oracle.DMP to a useable format, such as Excel?
A.
  • Go back to the client and asked if their IT department can export just the data you need to Excel. If that fails...
  • Oradump will convert to Excel without any row limitations, as well to Access or MySQL;
  • Oracle Express is free.You have to do the import from a command line like this (don't use the parentheses in the command): C:\>imp fp/fp file=(name of the DMP file).dmp full=y
This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

litsupport summary for the week ending on 04/19/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. JD Edwards is often used for tasks such as accounting, labor and job tracking. Can one forensically get the data from it?
A. 
  • With any database application, SAP, JD Edwards, etc., you can usually forensically extract the data from behind the scenes. But then it takes an understanding of how that data is calculated, combined, represented, etc. with the interface in order to form opinions on what you are seeing.
  • The other option is to forensically capture the entire server. Then translate the forensic image into a VMWare session to run the server, log into JD Edwards and start your analysis, testing, etc.;
  • Experience proves that without some documentation on the table structure it can be a very daunting task to look at the backend database and make determinations as to what is going on. But through testing, observation and analysis it is possible to understand information in the database that may not be accessible through the interface, information such as the contents of "deleted" records, when transactions occurred, when they were modified, who did the modification, etc.;
  • It is incumbent upon the "requester" to request the data in whatever form it wants to receive the data.  You can hack the files, but don't do it.
This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

Tuesday, April 14, 2009

litsupport summary for the week ending on 04/12/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.

Q. No technology questions of general interest were discussed this week, therefore
A. Happy Passover and Happy Easter.

This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.

Wednesday, April 8, 2009

litsupport summary for the week ending on 04/05/09

A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.


Q. PDF to TIFF converter?
A. 
  • Black Ice Printer Driver 
  • PDFDocs
  • ZAN Print
  • AdultPDF 
  • Download.com is a good starting point for this and similar questions.
  • Open PDF files with Adobe Reader, click print to file, select printer as MicroSoft Document Image Writer. Upon clicking OK, you will receive a dialog box asking where to put the file. Name it with the extension of .TIF. Document Image Writer should be part of Office.
  • Omniformat is free. It requires pdf995, a free pdf print driver. You dump the pdfs in a watch directory and launch the program. It follows your naming option from an ini file and you have either single-page or multi-page tiffs. Takes a bit of reading to get it right, but once set up, it's a workhorse.
  • Batch process using Acrobat professional version.
This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.