- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
01-12-2010 12:07 AM
I have imported few data sheets into SF - sandbox. But there are quite a lot of duplicates being created.
I want to delete the data using Apex Data Loader. I am new to the this data loader. When I login to the data loader and Use the 'Delete' option, it asks to select the SF object. This is fine. But then it also needs a CSV file. I am here to delete the data.(Not import/Update). Kindly help me
Solved! Go to Solution.
01-12-2010 01:05 AM
To delete, you need to be able to identify the records you want to remove. For you case, you need to export the content of your table in a CSV file. Keep in that CSV file the records you'll like to remove.
When you ran the Apex Data Loader again, use that CSV file to remove the records.
01-14-2010 06:33 AM
01-14-2010 06:35 AM
01-15-2010 02:21 PM
02-01-2010 06:41 AM
As the others have mentioned, you first need to export the data you want to delete so you can get the record IDs, then you use that CSV file for the Data Loader's Delete action.
If you choose to export through a report to Excel, remember that the record ID is truncated to 15 characters instead of 18 characters. You must use the Excel connector's FIXID function to correct this before using the CSV file for deleting.
If you export through Data Loader, the record ID is 18 characters, so this usually the better method. However, the interface is not as easy to use.
05-25-2013 10:00 AM - edited 05-25-2013 10:02 AM
how to restrict dublicate values when i insert data through data loader in to salesforce object.
please suggest ,