Skip to main content
Question

Reading BLOBs from Access DB

  • April 22, 2020
  • 0 replies
  • 112 views
janka
Contributor
Forum|alt.badge.img

Hi,

I have attachments (pdf, jpg, doc, txt) which are stored in Access DB as BLOBs.

I tried to use template from link below to extract files. Files have been exported but I cannot open any of them. Except of *txt or *doc where I have only a binary information, like "4D5343..."

https://hub.safe.com/publishers/safe-lab/templates/read-blobs-from-a-database-and-write-out-files

 

In AttributeFileWriter I used 'Binary (fme-binary)' encoding for JPGs and 'UTF-8' for txt, doc and pdf.

For JPGs I tried also use a RasterReplacer (JPEG format) to decode a binary attribute, but all records were rejected.

I'm using FME 2019.1

 

What am I missing?

 

Thanks in advance!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.