Mass Import/Export of images stored in Rich Text Area fields in Salesforce

When it comes to doing mass data manipulation – there are a lot of choices, but if you try finding something that will let you mass upload images to Rich Text Area fields – it won’t be easy.

Salesforce provides a detailed set of instructions of how to do it, but it involves uploading images as ContentDocuments, then getting their Ids, populating the HTML for Rich Text with these Ids and finally uploading the data using Data Loader. Not ideal, and it will probably take you several hours to do just a simple data load.

Xappex has come up with a way to do both directly from an Excel spreadsheet using their XL-Connector plug-in:

Video goes here. https://youtu.be/5uQ1jIRXCC0

When no images are involved – XL-Connector will pull the contents of the Rich Text Area fields normally, i.e. as HTML.

When there’re images in that field, you can control how XL-Connector will work with them using the following box in the Get Data dialog box:

Mass Update
  1. When there are no images in the field or the checkbox highlighted above is unchecked – its contents will come through normally, i.e. as HTML
  2. When there’s at least one image in the field and the above box is checked, XL-Connector will only pull images, but keep the rest of the html (including any text) hidden. Uploading of such image(s) will preserve the original HTML only replacing the image(s).

 If you decide to give XL-Connector a shot, check out other unique things it is capable of:

·      Mass uploading images, automatically linking them to the required parent records and libraries.

·      Mass managing your validation rules, processes, picklists, etc.

·      The regular data loads are a breeze too. It’s probably the easiest to set up data loader that lives in Excel.

Leave a Comment