Command Line Data Loader – Phil’s Salesforce Tip of the Week #450

Tip 1 – Command Line 

(2 words that can strike fear into ‘non-developers’) Thank you to our Lead Developer Simon for sharing a use of the Command Line that many probably do not know about…

“Did you know that DataLoader can be launched from the command line? Setup can be fiddly, but once working this can be a robust solution for getting data in and out of Salesforce. Run a command after exporting data from databases, run a scheduled job to ensure Salesforce data is ready for work, or leave a shortcut to a batch file on the desktop of a User who needs to import data occasionally. See this for more info”.

Here is some further information from the Data Loader guide

When running Data Loader in batch mode from the command line, several operations are supported. An operation represents the flow of data between Salesforce and an external data source, such as a CSV file or database. You can use the following operations. Enter values in the process.operation parameter in lowercase

Operation Description
extract Uses the Salesforce Object Query Language to export a set of records from Salesforce. The exported data is written to a data source. Soft-deleted records are not included.
extract all Uses SOQL to export a set of records from Salesforce, including existing and soft-deleted records. The exported data is written to a data source.
insert Loads data from a data source into Salesforce as new records.
update Loads data from a data source into Salesforce, and updates existing records with matching ID fields.
upsert Loads data from a data source into Salesforce. Existing records with a matching custom external ID field are updated. Records without matches are inserted as new records.
delete Loads data from a data source into Salesforce, and deletes existing records with matching ID fields. Deleted records are moved to the Recycle Bin.
hard delete Loads data from a data source into Salesforce, and deletes existing records with matching ID fields without first storing them in the Recycle Bin.

Tip 2 – Help when you can

I know there are a lot of important causes vying for our attention. We at Cloud Galacticos wanted to show our support for our friends and colleagues in India, but were unsure of how to do so. Just in case anyone is looking, we found the DEC a reliable and trustworthy place to donate.

Final Tip – Sign up

Remember if you have enjoyed this week’s tip then sign up for the weekly email, direct to your inbox here!