You need to sign in to do that
Don't have an account?
chikpea
Attachment download issue
We want to use the Excel Connector to download the PDF Attachments. After the download, whole attachment data is copied in BODY column. How can we create the attachment file again from that BODY column data? | |
But if the Excel Connector for PE is used, the BODY data gets truncated, henceforth can't be decoded to PDF, seems to be a Connector bug.
The stuff in the BODY column is Base64 encoded. You'll have to unencode it somehow, plus keep it from getting truncated.
Frankly I think you're using the wrong tool for the job. I don't see how it makes sense to try to have the Excel Connector decode binary files. I don't think that's a bug, it's just not meant to do that.
The reason behind using the Excel Connector is, Professional Edition doesn't support Data Loader tool.
If I decode the body using Data Loader, it works fine. But if we use Excel Connector then Body can't be decoded.
I checked the Body, I think connector is not downloading the Body completely, it's truncating.
Thanks
Bhaskar
Case Detachifier is not really solution for us, as we have to download multiple attachments (like invoices) at a time.
SFDC is also looking at this issue of Excel Connector.
Thanks
Bhaskar