Data Loader Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
PDF

Newer Version Available

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

Step Five: Import the Data

Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions

User Permissions Needed
To insert records: “Create” on the record
To update records: “Edit” on the record
To upsert records: “Create” or “Edit” on the record
To delete records: “Delete” on the record
To hard delete records: “Delete” on the record

Now that all the pieces are in place, you can run Data Loader from the command line and insert some new accounts.

  1. Copy the following data to a file name accountInsert.csv. This is the account data that you'll import into your organization.
    1swfobject.registerObject("clippy.codeblock-0", "9");Name,Industry,NumberOfEmployees
2Dickenson plc,Consulting,120
3GenePoint,Biotechnology,265
4Express Logistics and Transport,Transportation,12300
5Grand Hotels & Resorts Ltd,Hospitality,5600
6
  2. In the command prompt window, enter the following command:

    process.bat "<file path to process-conf.xml>" <process name>

    • Replace <file path to process-conf.xml> with the path to the directory containing process-conf.xml.
    • Replace <process name> with the process specified in process-conf.xml.

    Your command should look something like this:

    process.bat "C:\DLTest\Command Line\Config" accountInsert

    After the process runs, the command prompt window displays success and error messages. You can also check the log files: insertAccounts_success.csv and insertAccounts_error.csv. After the process runs successfully, the insertAccounts_success.csv file will contain the records that you imported along with the ID and status of each record. For more information about the status files, see Reviewing Output Files.