How to Associate a Rich Text Field Image with Its Parent Record Using Salesforce Weekly Data Export Files

These are the files you get from your Weekly Data Export. Objectname_c.csv refers to any custom object. 

Step-by-Step Instructions:

1.  Open the "Other Uploaded Collateral" folder.
2.  Copy the name of one of the images in the folder. This name reflects the 18-digit alphanumeric Salesforce ID for the image.
3. Open the file ContentReference.csv in the list of exported files.
4. Search for the image name by pasting the 18-digit ID in the search tool.
5. Copy the value in the "ID" column.
6. Open the file RichTextAreaFieldData.csv.
7. Search for the copied ID.
8. Copy the value in the "Parent Id" column corresponding to the "ID" value.
9. Open the file Objectname_c.csv.
10. Search for the Parent ID to find the record that the image is associated with. 

Example: Finding an Image from an Article Rich Text Field

Here's a specific example of how to find an image from Article Rich Text Field using a specific image URL. Suppose the end user adds an image to Article Rich Text Field. Right click on the image and choose the copy image location, the image URL is the following:

• https://company--c.na0.content.force.com/servlet/rtaImage?eid=ka100000000030c&feoid=00N00000008sQE3&refid=0EM0000000059zq 

Take 0EM0000000059zq and search for this 15-digit record ID in the data export file ContentReference.csv. The ID in ContentReference.csv is 18-digit so be aware when searching. Take a look at ContentContentId value. In the Data Export zip, look for the folder “Other Uploaded Collateral”. Find the matching ContentContentId file for the actual image.