Mass Import/Export of images stored in Rich Text Area fields in Salesforce : Amit Chaudhary
by: Amit Chaudhary
blow post content copied from Apex Hours
click here to view original post
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:
- 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
- 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.
The post Mass Import/Export of images stored in Rich Text Area fields in Salesforce appeared first on Apex Hours.
February 14, 2021 at 05:31PM
Click here for more details...
=============================
The original post is available in Apex Hours by Amit Chaudhary
this post has been published as it is through automation. Automation script brings all the top bloggers post under a single umbrella.
The purpose of this blog, Follow the top Salesforce bloggers and collect all blogs in a single place through automation.
============================

Post a Comment