You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 24
Next »
In this article you will learn how to transfer data from Salesforc to a file stored in an FTP server. The file will follow a CSV format. First, you will see a data map, explaining the relationship between fields in Salesforce and fields in the file stored in an FTP server.
As we are transferring data from a file stored in an FTP file to Salesforce, we need to find the correspondence between the fields from Salesforce and the fields in our file. The fields from Salesforce are defined by the chose table (for example Accounts). The fields in the file are defined by the user, although it is a good practice to keep the same nomenclature. In the example we will use data from Salesforce's table Accounts. However, the user many define other cases, such as:
- Salesforce Leads - FTP (CSV file)
- Salesforce Accounts - FTP (CSV file)
- Salesforce Contacts - FTP (CSV file)
- Salesforce Cases - FTP (CSV file)
- other cases defined by the user
![](/docs/download/attachments/25428788/image2018-11-6_21-7-20.png?version=1&modificationDate=1541531069000&api=v2)
Thus, we can map the fields from Salesforce into fields of different names created in the file stored in the FTP server. It is a good practice to keep the same nomenclature. The figure that appears below shows an example for the Accounts table from Salesforce. However, be aware that any other table from Salesforce could have been considered.
![](/docs/download/attachments/25428788/image2018-11-6_21-31-28.png?version=1&modificationDate=1541532518000&api=v2)
In order to transfer data from Saleforce to an FTP server (and vice versa), do the following steps:
- Go to www.mydbsync.com, click on Customer Login. Enter your Username and Password and click on Development Studio to open the Projectconsole .
- Create a project with project, process, workflow. Use names of your choice.
- Click on Connectors on the left section of Project Console and create a Salesforce and an FTP connector. (Note: Enter the required details in the Salesforce and FTP credentials in the fields and validate the connections).
- Click on Project ->Process -> Workflow
- From the Workflow section, proceed to the Trigger Section.
- In Triggers section, you can use three tabs, namely, Query Builder, Advanced Query Builder & Properties. You need to select data-source as FTP. You can make additional changes to Query by using the Advanced View section of Advanced Query Builder.
- In Rules section, select target connector as "Salesforce", operation, target object respectively.
- Click on Map to see Mapping screen. You will see the list of Salesforce fields in the left section. On the right section, in Schema you see list of selected File columns.
- Drag & drop the fields from Schema next to the required Salesforce fields. Click on Save and Close once the mapping is completed. Now, click on Save Workflow.
- Ensure that Workflow status is On.
- You are now ready to run the sync. Click on the Run Button on the Top Right corner of the page.
- After the successful sync, open the log and check if everything is fine. Check if the data has been transferred to Salesforce.
Note: to transfer from Salesforce to an FTP server, define the Trigger using the Salesforce connector and the Rule using the FTP connector.
You can find additional information in the following links:
How to conveniently transfer data to and from FTP servers using DBSyn : this article contains a detailed description on how to transfer data between Salesforce and a file contained in an FTP server.