You are not logged in.
Is there any easyway to syncronise data between a salesforce object and a CSV file.
I have the situation where we are receiving amendments and new reocrds in a csv file and need to use this to update existing records and insert new records into SalesForce.
Thanks in advance for any help.
I don't think the tSalesforceOutput component currently supports upserting using External Id fields:
When this feature is available, the easiest way would be to upsert using an existing external Id field.
Without this feature, a workaround would be to requery Salesforce or otherwise maintain a list of Salesforce.com Ids within the CSV file for the dataset and use the existing functionality to UPSERT based on that.