Ask Search:
Tammy HermanTammy Herman 

How do I export all attachments?

I found Knowledge Article Number: 266927
but how can i open the files from the weekly export?

How do I export all attachments, content, or documents?

Knowledge Article Number: 266927


Currently Data Loader does exports attachments in MIME type and customers must use workarounds such as the weekly export


For those of you looking for a way to easily pull all Documents, Attachments, and/or Content files, see the handy utility: (requires data loader and Windows XP or above).

Previously, one would need to use the weekly export option or an API tool that converted MIME files back to the original format.

Jared MillerJared Miller
The weekly export will provide you with all of the files (within a seperate folder). 

I have never used the FileExporter, but that looks like a great option. 

Did you need more information? The knowledge article seems to answer this question.

Shell BlackShell Black
If you have Enterprise or Unlimited edition, you can grab all your attachments through the Data Export feature:

Setup > Administration Setup > Data Management > Data Export

Here is a step-by-step tutorial:

You'll see in the tutorial there is a step (checkbox) to include attachments :)

I hope that helps!
Tammy HermanTammy Herman

Thank you for your answer.
i want to open the files from the weekly export and not from the FileExporter.
how can i open the attachments in thier original type?

Tammy HermanTammy Herman
i change the suffix of one file for xls and it didn't succeed.
how can i convert the attachments files into thier original type?


Josh GrubermanJosh Gruberman
I know this is old, but I found it looking for an answer and now that I've discovered the answer, here it is direct from Salesforce:

Once you have the ZIP files, look for the Attachment.csv and Attachments folder. 

1. Open the file "Attachment.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 Attachment 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 Attachment folder in each of the .zip files.

10. Navigate to your exported Attachment directory and double-click "Fix.bat". It should rename all the Files appropriately.

11. 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 Attachment folders until all files are converted.

12. Close "Attachment.csv" in Excel without saving any changes.