topic Re: Multiple use of TfileList in Talend Studio

Multiple use of TfileList

daez — Fri, 11 May 2018 15:36:52 GMT

Hello everyone,

I'm currently working on a project which need to GET on a FTP the most recent file (Date in filename). Then convert XML to CSV, doing some formatting & PUT it back on FTP. All of this is done by now.

I do need now to delete the oldest file, using the same logic. My question sounds pretty easy but I would like to know if I can use a tricky way on my current project to do that, instead of recreate all the JOB since its just doing the opposite. Tho, i see no possible way to use tFileList sorting twice.

Here a screenshot of my current job, getting the new file & put it back, working good thanks to @manodwhb

Any idea is good to take, Thanks for your precious time

Re: Multiple use of TfileList

manodwhb — Fri, 11 May 2018 17:10:04 GMT

As I said you can delete old file using tftpdelete in tPostgresqloutput job.

Re: Multiple use of TfileList

manodwhb — Fri, 11 May 2018 17:19:25 GMT

Otherway,that you can use tFTPFileDelete after the tFTPPut by using On Component Ok,you can specify the patter like *.XML in tFTPFileDelete.

Re: Multiple use of TfileList

daez — Fri, 11 May 2018 20:54:00 GMT

@manodwhb Thanks for you answer again.

How can I specify in the tFTPDelete to ONLY delete the oldest files tho? Because *.XML will delete all of my XML files.

Thanks for your help!

Re: Multiple use of TfileList

manodwhb — Sat, 12 May 2018 08:17:58 GMT

You can use the same pattern what you used in tFTPGet to delete the file in tFTPDeletefile.

Re: Multiple use of TfileList

manodwhb — Tue, 22 May 2018 08:30:26 GMT

@daez,still do you have issue?

Re: Multiple use of TfileList

manodwhb — Tue, 22 May 2018 10:26:35 GMT

@daez,Please provide Kudos also.