topic Re: Download specific files from FTP that don't exist in Salesforce in Talend Studio

Download specific files from FTP that don't exist in Salesforce

Anonymous — Sat, 16 Nov 2024 11:39:54 GMT

Hi,
I am trying to build a process that download files from a FTP that don't exist in Salesforce, and those which don't exist, load them in Salesforce. I am having problems to get the files that don't exist in Salesforce.
This is the process that i have
Any help will be appreciated.

Re: Download specific files from FTP that don't exist in Salesforce

Anonymous — Thu, 01 May 2014 06:06:39 GMT

Hi,
From screenshot it seems that you are implementing a join(not sure which) to get the list of files from ftp that don't exists salesforce and again load them in salesforce. If this is correct
- Implement InnerJoin in tMap with FTP files list as main and SalesForce as lookup
- Get InnerJoinReject from tMap output - This will give you list of files which are not avaiable in SalesForce
- Iterate on each file to load into SalesForce
Check one of the useful post - http://www.talendforge.org/forum/viewtopic.php?pid=23969#p23969
Vaibhav

Re: Download specific files from FTP that don't exist in Salesforce

Anonymous — Mon, 05 May 2014 01:19:17 GMT

Thank you for your solution. It really helped!

Re: Download specific files from FTP that don't exist in Salesforce

Anonymous — Mon, 05 May 2014 03:29:14 GMT

Hi sbravo,
Would you mind marking your post as "resolved" so that other users can identify it.
Best regards
Sabrina