Loading

Rename and convert exported Chatter files, content, and feed attachments

Publiseringsdato: May 21, 2026
Beskrivelse
When you export Chatter files, content, and feed attachments with the weekly or monthly data export service, you'll notice the following behavior: 
  • The records are exported in MIME format which appears to be unreadable. They need to be converted back to their original format before they can be opened.
  • The exported records are named after the record ID (starting with 068) and not the original name of the file. 
Løsning

Note: The solution below is provided as a courtesy. It falls outside the scope of Salesforce Support's boundaries to modify customer data — implementation and troubleshooting must be performed locally.

Steps to Rename Exported Chatter Files (Windows)

The following steps can be taken on a Windows-based machine where the user should have administrator privileges to rename the records.

  1. Open the file "ContentVersion.csv" in Excel.
  2. Delete all columns except "ID" and "PathOnClient." Once all the other columns are deleted, "ID" should be in column A and "PathOnClient" should be in column B.
  3. Copy the following formula and paste it into cell C2:

="RENAME "&A2&" """&B2&""""

  1. The resulting cell should look like this:

RENAME 00P300000046RlaEAE "Technical Specifications V1_2.docx"

  1. Double-click the lower-right corner of cell C2 to copy the formula down through column C.
  2. Select column C and copy it.
  3. Open Notepad.
  4. Paste the copied cells into Notepad.
  5. Click File > Save in Notepad and save the file in your exported ContentVersion folder as "Fix.bat" (without quotation marks). This is where the records to be renamed are located.

Note: Large exports are broken up into multiple .zip files (each .zip file created holds up to approximately 512 MB). Copy the "Fix.bat" file into the ContentVersion folder in each .zip file.

  1. Navigate to your exported ContentVersion directory and double-click "Fix.bat." This should rename all files appropriately.

Handling Duplicate File Names

If there are files that are not converted, it means that some files have the same file name inside the folder.

To convert the remaining unconverted files:

  • Create a new folder.
  • Copy the unconverted files and the Fix.bat file into the new folder.
  • Double-click the Fix.bat file again.
  • Repeat the process on all ContentVersion folders until all files are converted.

Another approach, when duplicate names exist, is to modify the file name so that it becomes unique.

  1. Close "ContentVersion.csv" in Excel without saving changes.
Knowledge-artikkelnummer

000386370

 
Laster
Salesforce Help | Article