Reply
Regular Contributor
Camp Eagle
Posts: 10

Upsert/Data Loader Question!!!

[ Edited ]

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.  

Message Edited by Camp Eagle on 10-02-2009 06:29 PM