Map Columns

When running Data Loader in batch mode from the command line, you must create a properties file that maps values between Salesforce and data access objects.

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

Note

Create a mapping file and give it an extension of .sdl.
Observe the following syntax:
- On each line, pair a data source with its destination.
- In an import file, put the data source on the left, an equals sign (=) as a separator, and the destination on the right. In an export file, put the destination on the left, an equals sign (=) as a separator, and the data source on the right.
- Data sources can be either column names or constants. Constants can be specified for insert, update, and upsert operations. Surround constants with double quotation marks, as in “sampleconstant”. Values without quotation marks are treated as column names.
- Destinations must be column names.
- You can map constants by surrounding them with double quotation marks, as in:
  1"Canada"=BillingCountry
In your configuration file, use the parameter process.mappingFile to specify the name of your mapping file.

If your field name contains a space, you must escape the space by prepending it with a backslash (\). For example:

1Account\ Name=Name

Note

Column Mapping Example for Data Insert

The Salesforce fields are on the right.

1SLA__C=SLA__c
2    BILLINGCITY=BillingCity
3    SYSTEMMODSTAMP=
4    OWNERID=OwnerId
5    CUSTOMERPRIORITY__C=CustomerPriority__c
6    ANNUALREVENUE=AnnualRevenue
7    DESCRIPTION=Description
8    BILLINGSTREET=BillingStreet
9    SHIPPINGSTATE=ShippingState

Column Mapping Example for Data Export

The Salesforce fields are on the left.

1Id=account_number
2  Name=name
3  Phone=phone

Column Mapping for Constant Values

Data Loader supports the ability to assign constants to fields when you insert, update, and upsert data. If you have a field that must contain the same value for each record, you must specify that constant in the .sdl mapping file instead of specifying the field and value in the CSV file or the export query.

The constant must be enclosed in double quotation marks. For example, if you're importing data, the syntax is "constantvalue"=field1.

If you have multiple fields that must contain the same value, you must specify the constant and the field names separated by commas. For example, if you're importing data, the syntax is "constantvalue"=field1, field2.

Here's an example of an .sdl file for inserting data. The Salesforce fields are on the right. The first two lines map a data source to a destination field, and the last three lines map a constant to a destination field.

1Name=Name
2  NumEmployees=NumberOfEmployees
3  "Aerospace"=Industry
4  "California"=BillingState, ShippingState
5  "New"=Customer_Type__c

A constant must contain at least one alphanumeric character.

If you specify a constant value that contains spaces, you must escape the spaces by prepending each with a backslash (\). For example:

1"Food\ &\ Beverage"=Industry

Note

Data Loader Guide

Map Columns