April 15, 2011 at 8:38 am
Hello Everyone,
When we extract attachments using Salesforce's (Cloud) data loader and store the attachments in a SQL server table field, what we get is a binary file which is nothing but the base 64 encoded form of what the attachment contains. For us that data is not of much use as we can’t make any sense of it. We need to be able extract the attachments and render the data in a viewable form. Thiese attachments can contain everythinf from Images, Text, .pdfs etc.
Has anyone used SQL Server 2005 and/or any of it functions...etc to render attachements that are stored as binary data, viewable. Please let me know as this is very important to me. Thank you.
We are using SQL Server 2005 Developer Edition...
April 15, 2011 at 8:44 am
it depends on what you mean by viewable;
see this forum post on examples of how to
RE: How to retrieve Image file from a SQL Table
Sean Lange provided a fine example of streaming the results out to a web page, based on knowing the mime type, which is proably what you were looking for.
I provided an example of dumping the binary objects to disk.
Lowell
April 15, 2011 at 8:56 am
Sounds like a Salesforce or forceAmp question. Have you contacted support?
http://www.forceamp.com/support.htm
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 15, 2011 at 2:10 pm
If you don't know the mime type it can still work as long as you know the extension. If it is just a binary and you don't know either the mime type or the original file extension you are going to have a bigger challenge.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply