How to extract images from OLE files?

Former Member
Former Member $organization

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?

Parents
  • Version 11 has a T)DEFAULTS setting for this which will help

    DOC_OLE_OVERRIDE_JPG

    When set to YES, overrides the use of OLE automation to view JPG files.

    We had the issues as Windows changed their default app for images with windows 7, so we had all our images classed as packages, but setting DOC_OLE_OVERRIDE_JPG to Y in t_defaults has solved that for us, At least we ca open the files now.

    Mark

Reply
  • Version 11 has a T)DEFAULTS setting for this which will help

    DOC_OLE_OVERRIDE_JPG

    When set to YES, overrides the use of OLE automation to view JPG files.

    We had the issues as Windows changed their default app for images with windows 7, so we had all our images classed as packages, but setting DOC_OLE_OVERRIDE_JPG to Y in t_defaults has solved that for us, At least we ca open the files now.

    Mark

Children
No Data