Keller, Chris
2013-10-31T21:42:00Z
I can nicely store/load all emails/attachments from outlook to mysql back and forth. Works very well.

Now the question (I am a beginner..): how can I extract (if I wish) directly in the MySQL db the attachments to let's say a local disk? I can see in the table (column GC_Attach_Binary) the record of the attachement for the BLOB entry/and a .bin file. But I don't know how to extract/convert this back to the originally attached file format/-extension (such as xls, ppt etc). Please advise.



GC: Private V501501 32-bit
Outlook 2013, 32-bit (on 64-bit Win8 OS)
ODBC: 5.2 driver (32-bit)
MySQL: 5.5.34 (on ubuntu 13.10.1 server)
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2013-10-31T23:17:00Z
Hello,

You can config in GeniusConnect an extraction folder: Assign table->Item attachments -> "Extract attachments to a folder".

More info:
https://www.geniusconnec...WebHelp/Attachments.html 

If you want to decode the blobbinary stored in your DB, you have to check Attachment method etc.., more info:
http://support.geniusconnect.com/Posts/t334- 

binary attachment in your DB is an exact copy of a binary attachment in Outlook
Keller, Chris
2013-11-13T22:20:00Z
great thanks, this helps! (and works well..)
Similar Topics