How to extract images from OLE files?

Thanks John. Based on this pointer I found how to remove the OLE header from the files. If I just download all the images with a SQL script, run a script to remove the header and then load them back as just JPEG files with another SQL script, would I be able to open the images in any computer.

It would be a lot of work, but I guess that much better than rescanning all the pictures.

F

Fernando,

When you add a file to Research>Documents, it uses OLE to save the file to the database.  There are some known issues that are documented in the link below.  After you look through that, if you still have questions, please open a ticket in TASK and we can go from there.

http://www.tessituranetwork.com/en/network/learning/tessitura%20knowledgebase/constituents/other/30559.aspx

John Wozniak

Hi everyone

We had an intern that worked on a project to upload photos of some of our patrons in Tessitura, under Research -> Documents.

When our fund-raising department decided to start using the photos, they found that they cannot access the files. They are getting different errors depending on the default application set to open the JPEG files. The intern is long gone and we only know that they were store as JPEGs images. In Tessitura they appear as Document Type "Package".

I was able to extract the binary data from the database into a file, and after some research I found that they are stored as OLE objects. Probably, the software that the intern used to scan the photos, somehow created this OLE from the JPEG files. I am not familiar with the OLE format, I thought it was something like a ZIP or a RAR file, but it does not seem to be that straight forward. I was not able to found a software that would extract the information from the OLE file.

Is anyone familiar with this format and/or knows how to extract these files?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!