Loading

Using other delimiters while loading data in the Data Loader

Publiceringsdatum: Oct 13, 2022
Beskrivning
If the source files uploaded are delimited by tab or any other delimiters like  pipe , semicolon, etc and has values containing commas. This makes the data loader fails since it interprets both as column separation.
Lösning
If commas aren’t appropriate for your locale, use a tab or other delimiter to process your data. You can use Data Loader in two different ways:

User interface —  Specify your delimiter in Data Loader Settings (Settings | Settings) and follow the steps to Insert, Update, or Delete Data Using Data Loader .

Command line (Windows only) — When you use the command line, you specify the configuration, data sources, mappings, and actions in files. This enables you to set up Data Loader for automated processing. 

Read a Quick guide for Using Data Loader from the command. 
After following the steps mentioned in the quick guide update the process-conf.xml file with below bean properties. 
  
<entry key="loader.csvOther" value="true"/> 
<entry key="loader.csvOtherValue" value="+"/>
Note, the entry loader.csvOtherValue represent the delimiter value.

For more information regarding Data Loader, please refer below:


Data Loader Command-Line Operations
Data Loader Command Line Introduction
 
Knowledge-artikelnummer

000384015

 
Laddar
Salesforce Help | Article