CAINE 1.5 Installed and .docx and .xls file conversion to .txt

[joetekno]

Using CAINE and commands/applications to convert data formats to text

One major problem with keyword searching a hard drive or image file is when it contains files that are not saved in a searchable format. These files are not keyword searchable through the use of strings, grep, etc. To fix this problem you can install other applications that will convert the files to text. The following instructions will walk you through installing an application that will convert Word (.docx) documents and Excel spreadsheets to text. Use a script to convert multiple files.

Installing docx2txt
1. Open a browser and go to http://docx2txt.sourceforge.net/
2. Download docx2txt-1.0.tgz
3. Save the docx2txt-1.0.tgz file to your desktop
4. Double Click the docx2txt-1.0.tgz file
5. Highlight the docx2txt-1.0 folder and Click the “Extract” button
6. Type “docx2txt” and Click Extract

Using docx2txt
1. Open a terminal window
2. Maneuver to the docx2txt.1.0 directory on the Desktop in a terminal window
3. Use the docx2txt to convert the documents into a text format
a. perl docx2txt.pl /evidence/docxdata/{filename}.docx {filename}.txt

Installing python-excelerator
1. Click “Menu”… System… Administration… Synaptic Package Manager
2. Type the administrators password if prompted
3. Click the “Search” button
4. Type “xls2txt” and Click the “Search” button
5. Click the python-excelerator checkbox and Select “Mark for Installation”
6. Click the “Apply” button
7. Click the “Apply” button
8. Exit Synaptic Package Manager… (File… Quit)

Using py_xls2txt
1. Open a terminal window
2. Maneuver to the directory where you have stored the excel documents to be converted
a. cd /evidence/scalpeloutput/xls-0-0
3. Use the py_xls2txt command to convert the documents into a text format
b. py_xls2txt {filename}.xls > {filename}.txt