topic Re: FTP Most Recent File Get in Talend Studio

FTP Most Recent File Get

Anonymous — Sat, 16 Nov 2024 13:26:01 GMT

Hey,
In Talend/Java: I need to get the most recent .zip file off a SFTP server. I know how to get a file with the current date, how do I get a file that is not the current date, but the one closest to the current date?
For example:
Today?s date is May 12, 2010
File On the SFTP:
20100510.zip
20100503.zip
20100427.zip
etc...
I only want to grab the 20100510.zip file and put it on my local drive. Then the next week a new file will appear (20100517.zip), and this job will be scheduled to run again, and I want it to grab that file....and so on and so on...
Any thoughts?
Attached is a screen shot with what I have now, which only gets the current date.
Thanks,
Ryan

Re: FTP Most Recent File Get

Anonymous — Thu, 13 May 2010 08:16:49 GMT

Hello
First, using a tFtpFileList to iterate each file, cut the file name and parse it to a date, hard code to get the newest date and return the file name.
Second, get the newest file from ftp server.
Best regards
Shong

Re: FTP Most Recent File Get

Anonymous — Mon, 19 Sep 2011 09:48:06 GMT

I got the same problem. Can you give me a hint for the correct solution?

Re: FTP Most Recent File Get

Anonymous — Fri, 30 Sep 2011 01:12:12 GMT

Does anyone know, how to create a simple text file with current date in it. The file will contain just the current date. Every time the job runs successfully, a text file will be created with current date in it.

Re: FTP Most Recent File Get

Anonymous — Fri, 30 Sep 2011 02:23:25 GMT

Does anyone know, how to create a simple text file with current date in it. The file will contain just the current date. Every time the job runs successfully, a text file will be created with current date in it.

Dear xanworld
I have replied you on 18102
Best regards
Shong