Data Loader Guide

Data Loader
When to Use Data Loader
Installing Data Loader
Configure Data Loader
Using Data Loader
Running in Batch Mode (Windows Only)
Installed Directories and Files
Encrypt from the Command Line
Upgrade Your Batch Mode Interface
Run Batch File With Windows Command-Line Interface
Configure Batch Processes
Data Loader Process Configuration Parameters
Data Loader Command-Line Operations
Configure Database Access
Map Columns
Run Individual Batch Processes
Command-Line Quick Start (Windows Only)
Data Loader Third-Party Licenses
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Run Batch File With Windows Command-Line Interface

For automated batch operations, such as nightly scheduled loads and extractions, run Data Loader from the Windows command-line.
Available in: Salesforce Classic (not available in all orgs) and Lightning Experience
Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions

The Data Loader command-line interface is supported for Windows only.

Note

Include your encrypted password in the configuration file to run a batch operation. For more information, see Data Loader Command Line Introduction and Encrypt from the Command Line. From the command line, navigate to the bin directory, and enter process.bat. This file takes the following parameters.
  • The directory containing config.properties
  • The name of the batch process bean contained in process-conf.xml

You use the process-conf.xml file to configure batch processing. Set the name of the process in the bean element's id attribute: (for example <bean id="myProcessName">).

You can change parameters at run time by giving param=value as program arguments. For example, adding process.operation=insert to the command changes the configuration at run time.

The process.bat file supports running JAR with up to two parameters. The format for two parameters is:
1java -cp ..\dataloader-xx.0.0-uber.jar -Dsalesforce.config.dir=<configdir> com.salesforce.dataloader.process.ProcessRunner <operation> parameterName1=ParemeterValue1 parameterName2=ParemeterValue2
An example of running the JAR with two parameters is:
1"%JAVA_HOME%\bin\java" -cp ..\dataloader-44.1.0-uber.jar -Dsalesforce.config.dir="C:\Users\username\dataloaderconfig" com.salesforce.dataloader.process.ProcessRunner accountInsert process.outputSuccess=c:\temp\accountInsert_success.csv process.outputError=c:\temp\accountInsert_error.csv

If you experience login issues in the command-line interface after upgrading Data Loader, try encrypting your password again to solve the problem. For information, see Encrypt from the Command Line.

Tip