Most recent file in an FTP directory using FTPCaller

Here's the basic info for anyone testing.

Hi @nickintosh,

I tried to connect in this FTP, but is necessary to has login and password to access.

Do you have this information?

Thanks,

Danilo

Yes, it's public/public

 

 

Also, the full path to the folder that I'm most interested in would be sftp://xfer.shelbycountytn.gov/BusinessLicenses

 

 

Hi @nickintosh,

 

I suggest you to build a Workspace using the FTPCaller and to extract a list of Attributes all file names in FTP.

 

After you split the result and extract the filenames and generate a xls file ( with transformer FeatureWriter ).

 

Also, you can compare by filenames ( FTP * XLS ) if the workspace doenst find the value in commum, is a recent file in your FTP.

 

 

 

On Inspector you can continue this Workspace connecting another transformer FTPCaller, and this transformer make download only the recent files presents in your FTP.

 

 

Attached the Workspace.

 

 

Thanks, - workspace-ftp.fmw

 

Danilo

Awesome, I'm trying to modify the workflow now (path, filetype, etc.) I'm also getting some weird sorting issues in the XLS output, but I think the logic will be what I need. The next step will be testing and getting it to run M-F only (but I'm assuming I'll just set up a Windows task scheduler to do that). Thanks for the help! I'll mark as answered as soon as I can get it to work!

 

 

Great :)