Some of our opportunities are created in Salesforce and others are created in another system. I'm trying to make sure they all end up in both systems.
When using upsert, in the data loader (just using the gui to start with), I have an external ID and the Salesforce Opportunity ID in my csv file.
I'm getting an error, "Opportunity ID; id value of incorrect type" on the records not in Salesforce (i.e. No Salesforce ID in the file.).
Because of my two-way snychronization situation, am I going to have to do a separate insert (based on external id) and update (based on Salesforce Opportuntity ID)? This would also require to separate csv files since one file can't contain both the external and the Salesforce Opportunity ID.