Salesforce Features

Apex Data Loader

Dataloader Prior to Summer ’05, loading data in Salesforce was accomplished through import wizards or by using Apex API directly. The Apex data loader is an easy-to-use, highly scalable data management tool that can perform large uploads of data, mass updates, mass deletes, and exports for any object (Salesforce, Supportforce, and custom objects).

This feature is available in Enterprise and Unlimited Editions.


Training, Resources, & Documentation


Feature Details

  • Easy-to-Use Wizard: The Apex data loader’s simple, wizard-based interface guides users through selecting data sources, mapping fields, and viewing errors. The included drag-and-drop mapping editor makes associating external fields with existing Sforce data types simple and error free.
  • Reusable Maps: Save mapping files so you can easily load files from multiple data sources. By reusing existing maps, common imports can be easily repeated without remapping.
  • Large File Support: Unlike Web-based imports, the Apex data loader supports very large data sets containing millions of rows, allowing for massive data loads and migration of information from existing systems.
  • Extraction Capabilities: In addition to supporting loading, the data loader allows Salesforce-based information to be bulk extracted into CSV text files for use in other systems.
  • Command Line Interface: In addition to the wizard, the data loader can be controlled via the command line, allowing imports and exports to be scheduled and repeated on an automated basis.

5 Comments

miranda
October 20

Is this tool available now, or is it coming out in the Winter '06 version?

Werewolf
November 29

This tool is available in the current release (if you have Enterprise or Unlimited Edition) -- you don't have to wait for Winter '07.

To get it, log into Salesforce.com and go to Setup. There, go to Data Management->AppExchange Data Loader and click the Download link.

Rob
February 11

I have setup the Contact section in Salesforce as follows:
- Each Contact is related to it's parent Account by the Account ID (this is default Salesforce behavior I believe?)
I have also made the following custom field for a Contact:
- Email. I have flagged this custom field as 'external Id', so that I can use it to match with when field-mapping during a Data Loader UPSERT.

I have also related Contacts to a custom object I built called Form Submissions. The idea behind this Form Submissions custom object is to enable us to keep a list of the names of all the forms the Contact has submitted (that we track through our own website). When creating the relationship between Form Submission and Contact, the 'Record Name' field was used as it appeared to be the only way to create the type of relationship I require (i.e. a listing of Form Submissions for each Contact). I believe the relationship that Salesforce applies in this instance between Form Submission and Contact is the Contact Id - is this correct?

My main question is concerning how I can use Data Loader to INSERT Form Submissions for each Contact:
Currently I can easily INSERT new Contacts into Salesforce because I know the Account Id to which I want the Contacts to belong (and the Account Id doesn't change). Thus, when making the CSV file of Contacts to INSERT, I simply include the Account Id which ensures that the Contact is INSERTED with the correct Account association.

In addition, by field-mapping the Email address in the CSV to the 'external id' Email__c custom field I made for the Contact, I can perform UPSERTS on the Contacts. However, I would like to be able to use the 'standard' Email field that Contact's already have to 'match' on as described above, but this doesn't appear to be possible? In the mean time (as described above) I have created a custom 'external id' Email__c field in order to enable me to perform the UPSERT, however it does mean that a Contact has two 'email' fields, which is far from ideal.

What I cannot seem to figure out how to do is to upload Form Submissions (described earlier in this email) via the Data Loader, and have them correctly related to their respective Contacts? Since the Form Submission custom object is related to the Contact by the 'Record Name' field, there appears to be no way that I can create a CSV to upload via the Data Loader that will correctly associate a Form Submission to a Contact. Given that I will not know the Contact Id when uploading Form Submissions, how can I go about doing this?

Dinesh Nasipuri
March 27

When I am tring to run AppExchangeDataLoader 8 from UNIX machine I am facing some problem.
It shows an error likr below

Error loading config file: /exporome/train/dinesh/conf/config.properties. Please make sure that it exists and is readable
Exception in thread "main" java.lang.RuntimeException: com.salesforce.lexiloader.exception.ControllerInitializationExcepti Error loading config file: /export/home/train/dinesh/conf/config.properties. Please make sure that it exists and is reade

Does AppExchangeDataLoader 8 runs on an UNIX machine?

Renat Khasanshyn
May 5

To Rob: Perhaps you could take a look at Apatar, a free tool that can take data from any custom object or a custom field in SFDC, and load it into any other SFDC table.

Apatar supports data integration between Excel files, databases, and SalesForce.Com, without having to write a single line of code. Users install a visual application, link data between the source(s) and the target(s), and schedule one-time or recurring data transformations. Apatar Features:
1. Visual job designer and mapping enable non-developers to design and perform transformations.
2. Connectivity to CSV, TXT, MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), Compiere ERP, Goldmine CRM, XML (local and web-based), Webdav, Buzzsaw, LDAP, Amazon and even Flickr;
3. Job Scheduling

Apatar listing on AppExchange: http://www.salesforce.com/appexchange/detail_overview.jsp?NavCode__c=a0130000006P6IoAAK-31&id=a03300000032Vm0AAE
Online Demos: http://www.apatar.com/web_demo.html
Apatar forums about SFDC and other connectors: http://www.apatar.com/forums/
Free download of Apatar: http://www.apatar.com/data_integration_for_salesforce_com.html