I am new to SalesForce (a former Goldmine user), but have dealt with mapping before. I am trying to set up the data loader so that I can run it from a batch file each night and insert / update our accounts. I have successfully run the upsert from the Data Loader Wizard and have saved the mapping as a .sdl file. The accounts are linked on an external id field; SalesForce custom field RMAcctNbr_c = CID, the field name in our csv file.
Here's the mapping from the sdl file:
Wed Nov 07 10:47:38 EST 2012
I've created the upsert bean in the process-conf file, but I think there's a problem with the following line:
[entry key="sfdc.externalIdField" value="RMAcctNbr_c"/]
where the brackets are actually '<' and '>' (sorry....didn't know how else to get it displayed correctly in this message)
RMAcctNbr_c is a custom field in SalesForce that contains a unique account number that is mapped to the CID field in my csv file.
When I run this command line from the batch file, it throws the following error:
ERROR [accountUpsert] client.PartnerClient runOperation (PartnerClient.java:332) - Error while calling web service operation: upsert, error was:
[InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD' exceptionMessage='Field name provided, RMAcctNbr_c does not match an External ID for Account'
Any help would be appreciated!