Salesforce Admin Tutorial Chapter – 13
When conducting data manipulation operations on a bulk of data, you need the help of a dedicated tool to speed up the process. Data Loader is one of the most popular Salesforce-authorized tools used for this task.
Previous article, Salesforce Admin Tutorial – 12, Roles.
Data loader allows you to process a maximum of 5 million records. You can perform insert, update, upsert (insert and update), delete, hard delete, export, and export all operations on data within this limit. In the case of export and import operations, the tool uses CSV file format to deal with data by default.
Working with Data Loader on Salesforce starts with downloading and installing the tool. If you search for “Data Loader” on the Quick Find box, it’ll take you to a page with links and guides to help with the installation on your device.
After installing the Data Loader on your device, you’ll find options that allow you to carry out different DML tasks once you open the app.
Let’s first see how to export data from Salesforce with the help of Data Loader.
Start the process by clicking on the Export button and choosing the environment to download data from (Production or Sandbox).
It prompts you to log into Salesforce with your credentials.
Next, choose the objects you want to export and provide the export location.
You can also select the list of fields to export under each object. It also allows you to filter records based on certain filter conditions.
The end of the export process saves the CSV file with data to the provided location.
Similarly, to conduct an insert operation, you can select the Insert option on the Data Loader app. Pick the object corresponding to new data and provide the location of the CSV file containing data for the new records.
Make sure to populate all the mandatory fields of the object in this insert file.
Next, you have to create a mapping between the field names in the CSV file and the object’s fields.
If such a mapping already exists, you can use that file instead of creating one anew.
Once this process is completed, you can check the Salesforce org to check whether new data appears in the object table.
You can try working with update, upsert, and other operations through the Data Loader in a similar manner.
Next article, Salesforce Admin Tutorial – 14 explains about Classic Email Templates.