Post reply

Salesforce attachments stored as binary data needed to be rendered viewable.

  • April 15, 2011 at 8:38 am

    #147788

    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

    #1312184

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 15, 2011 at 8:56 am

    #1312193

    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. Selburg

  • April 15, 2011 at 2:10 pm

    #1312343

    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