Loading

Associate a rich text field image with its parent record

Publiseringsdato: Nov 26, 2024
Beskrivelse

The Weekly Export Service offers the ability to include images, documents, and attachments in the backup of your organization. When this option is selected, the Other Collateral file included in the export contains images from rich text fields in your organization.

It's possible to use three CSV files included in the export to identify which images go with which records in the organization. Those three export files are: 
 
  • ContentReference.csv - This document helps you identify the ID of the field that contains the image.
  • RichTextAreaFieldData.csv - This document helps you identify the object that contains the field.
  • Objectname_c.csv - The name of this document reflects the object name found in the RichTextAreaFieldData document, and helps you identify the specific record that contains the image.

 
Løsning
These are the files you get from your Weekly Data Export. Objectname_c.csv refers to any custom object. 
 
 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.

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


See also:
Rename exported attachments or document files
Rich Text Area Field Limitations
Knowledge-artikkelnummer

000387694

 
Laster
Salesforce Help | Article