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.