Search Community
- Force.com Discussion Boards
- :
- Salesforce User Discussions
- :
- Product Discussion
- :
- Upsert/Data Loader Question!!!
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Upsert/Dat a Loader Question!! !
[ Edited ]
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
09-26-2009 04:19 PM - last edited on 10-02-2009 06:29 PM
I can't seem to find anybody that has a solution for this!
I am trying to upsert my csv file and I am using the company names as the unique external id field because it's the only field that I have data on for all of my contacts. However, when using the data loader, if it sees more than two identical cells, it ignores them and kicks back an error in the follow up report it creates.
For example: When using upsert in the data loader - if you have 2 contacts that work for "company x" it will merge their data and update your records on Salesforce. However, I have many contacts that work for "company x". The data loader thinks I have a data quality problem, I guess, and decides to ignore them because there are more than 2.
Is there some kind of work around, best practice, or solution for this?
Thanks for any help you can give. I really need to get my data into Salesforce. Surely people upload files where they have hundreds if not thousands of companies where they have more than 2 employees to upload from their csv file.

