function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ramesh y 10Ramesh y 10 

How to move attachments from one salesforce org to another ?

Rahul_kumar123Rahul_kumar123
Hi Ramesh,

Please follow the below Step to move Attachments from one Salesforce org to another.
  • Create attachments.csv file (the name of the file is unimportant) with the following column headers:
    • ParentId - ID of the record to which the attachment should be associated Name - Name of the attachment 
    • ContentType - Format of the extension (e.g. .xls, .pdf, etc) 
    • OwnerID - ID for the owner of the attachment
    • Body - File path to the Attachment on the local machine (C:\documents and settings\schun\desktop\attachments\file.xls)
  • Log in to the Data Loader. 
  • Select the "Insert" command. 
  • In the 'Select Sforce Object' step, select the 'Show all Sforce Objects' checkbox and then select "Attachments". 
  • Choose the attachments.csv file. 
  • In the mapping step, map the following fields:
  • Parent ID 
  • Name 
  • Owner ID 
  • Body - Make sure to map the Body column which you created previously with the file extension. This is how you designate the file and location of the attachments to be inserted. 
Click "OK" to proceed with the insert. It may take a few minutes but the attachments should be successfully uploaded to your salesforce org.
Also make sure you are using valid Parent Id / Owner Id, as ParentId would be different in the second org. So that attachment would get attached to correct Record. 

For further reference refer the below link.
I hope it will be helpful.

BestRegards
RahulKumar
Ratandeep SRIVASTAVA 10Ratandeep SRIVASTAVA 10

@rahulKumar, 

Body - File path to the Attachment on the local machine

The query is for Org to Org attachment migration. Can you please advise steps to export attachment to local machine too. 
Nikita Meshram 2Nikita Meshram 2
You can do this by using the Satrang Mass File Download AppExchange App and Dataloader, Using Satrang Mass File Download you can export all files and attachments along with CSV files and import these files with ParentIds in the new org.

URL - https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EcsAOUAZ&tab=e (#)

Disclaimer: I work at Satrang Technologies, the publisher of this Mass File Download AppExchange App.