function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
James_DeanJames_Dean 

DataLoader upsert problem

I have encountered a problem using the Dataloader command line tool when i upsert data. I do and soql query like the following....select Id,productCode,Name,AssetCodeId(reference field). from Product. The problem seems to be the last field if i leave that out it matches the Id in my database with the salesforce Id and does not add new records but when i use the last reference field then it adds new records in salesforce. I am upserting from an sql table with 4 fields all of tpe varchar. Both Id and AsetCodeId are just strings containing the unique ids in salesforce......what could be the problem?.