Getting Started with the Apex Data Loader
The Apex Data Loader can be used by System Admins as a desktop tool to help manage date with imports, updates, exports, and delete.
It offers features not found in the import wizards that are native salesforce.
With the data loader you can:
- Update records which have multiple parent organizations (i.e. Connections)
- Insert new records and update existing records at the same time (upsert)
- Insert null values into existing fields that already have data in them
- Access to the fields Opportunity Approval Manager and VL Approval Manager (which are not available through the import wizareds)
- and much more
Serious data management gurus will find the data loader their tool of choice for managing data.
NOTE: The Apex Data Loader requires windows. Mac users will find a similar tool called LexiLoader which is developed by an outside developer and not directly offered through Salesforce. It can be found here: http://www.pocketsoap.com/osx/lexiloader/
Downloading the Apex Data Loader
In order for you to use the Apex Data Loader you will need to have the unique security token associated with your UserID. If you are going to be using the data loader often, then maintain the security token in a secure location to avoid having to reset it often.