You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Salesforce syncronisation
#1 2009-11-02 13:38:42
- RoyK
- Guest
Salesforce syncronisation
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.
#2 2009-11-03 14:14:18
- chivallier123
- Member
- Registered: 2009-06-18
- Posts: 19
Re: Salesforce syncronisation
I don't think the tSalesforceOutput component currently supports upserting using External Id fields:
http://www.talendforge.org/bugs/view.php?id=9529
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.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Salesforce syncronisation