We recently had a user that had to extract Word and Excel documents from a Thomson Reuters FileCabinet CS database using SQL Blob Export. The user was helpful enough to send us a couple of samples of the raw data stored in the table, allowing us to inspect the data in detail.
Turns out Thomson Reuters stores the files in a different manner to what SQL Blob Export expected, so we had to make some adjustments to the export process.
Beginning with version SQL Blob Export 6.1, you can now export items from your FileCabinet CS database. The same feature is found in SQL Image Viewer. When you run a query to return the items, it will be shown as OLE Structured Storage packages.
You can then export the files using the export wizards.
If you encounter a situation where SQL Blob Export or SQL Image Viewer is unable to export your files, please send us an email at support@yohz.com.
It would be very helpful to also attach a couple of samples of the rows that failed to be exported. To extract the data exactly as stored in the database in SQL Blob Export, please do the following:
- select the Extract bin files option on the Options page
- once the export process has completed, you will find files with the .bin extension. Please send us a couple of those files so that we may check how the data is stored in your database.