This is an application that can import up to five million records at a time of any data type. It works via both user interface and command line. You need to specify the field mappings, data sources and other configurations.
It can also be automated through programming using the API facilities. This can be used to allow the automatic uploading of transactional information into the BDE staging object through the control of an external application.
To use the application via the user interface, follow these steps:
Open the Data Loader.
Select Insert, Update, Upsert, Delete or Hard Delete, depending on the operation you wish to perform. Normally you will import data into the BDE Items object and use the Insert option.
Enter your Salesforce Username and Password to log in and click the Log in button. When you are logged in, click Next.
Choose the object you wish to import data into. In this case, we want to select the BDE Item object.
If you cannot see the BDE Item object, tick the Show all Salesforce objects checkbox.
Select your CSV file by clicking the Browse button.
Map your CSV fields to Salesforce fields. If you have already created an existing mapping, click Choose an Existing Map button and find the mappings. If you want to create a new mapping, click the Create or Edit a Map button.
For the field mappings for arrange of common data sources, please check the end of this document.
The Data Loader will generate two CSV log files. One file name starts with “Success,” and the other starts with “Error.” To specify the directory of these files, click the Browse button.
Click Finish to complete the operation, and then click Yes to confirm. As the operation proceeds, a progress information window reports the status of the data movement.
To view your success or error files, click View Successes or View Errors. To close the wizard, click OK.