Skip to main content
Question

Reading BLOBs from Access DB


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!

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings