Loading

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

Julkaisupäivä: Oct 13, 2022
Kuvaus
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. 
Ratkaisu
Note
The solution below is provided as a courtesy and point of reference but is not directly supported by Salesforce. Please note that it falls outside the scope of Support's boundaries to modify customer data, so implementation, troubleshooting and the function of the following will need to be performed and managed locally.


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 formula on the following line and paste it into cell C2: ="RENAME "&A2&" """&B2&""""
  4. The resulting cell should look like this: RENAME 00P300000046RlaEAE "Technical Specifications V1_2.docx"
  5. Double-click the lower right corner of cell C2 to copy all the way down to column C.
  6. Select column C and copy it. 
  7. Open Notepad. 
  8. Paste the copied cells into Notepad. 
  9. Click File then Save in Notepad, and save the file in your exported ContentVersion Folder as "Fix.bat" (without the 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 will hold up to approximately 512 MB). Copy the "Fix.bat" file in the ContentVersion folder in each of the .zip files.
 
  1. Navigate to your exported ContentVersion directory and double-click 'Fix.bat.' It should rename all the Files appropriately.
  2. If there are files that are not converted, it means that the files have the same file name inside the folder. To convert the remaining unconverted files, create a new folder and copy the unconverted files and the fix.bat file to that new folder. Double click the fix.bat file again. Repeat the process on all ContentVersion folders until all files are converted. Another approach, when there are duplicate names, is to modify the name so that it's unique.
  3. Close 'ContentVersion.csv' in Excel without saving any changes.
Knowledge-artikkelin numero

000386370

 
Ladataan
Salesforce Help | Article