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:
Mapping values
Wed Nov 07 10:47:38 EST 2012
ARTotal=AR_Total_c
Addr1=BillingStreet
Zip=BillingPostalCode
AcctOwner=OwnerId
JobReq=JobReq_c
RepName=SlsRep_c
LPymt=LstPay_c
CID=RMAcctNbr_c
POReq=POReq_c
State=BillingState
AROver30=AR_Over_30D__c
AROver60=AR_Over_60D__c
AROver90=AR_Over_90D_c
StatusDesc=Status_c
Phone=Phone
CName=Name
LActivity=LstTrans__c
FaxNbr=Fax
ARCurr=AR_Current_c
City=BillingCity
TerrName=Terr_c
AROver120=AR_Over_120D__c
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'
]
row='-1'
column='-1'
Any help would be appreciated!