FTP question

Automise Discussion
1

Hello all,

I am new to Automise so this may have a simple answer:

We connect to an FTP site (read-only) and the data is provided to is in the format: FRED_MMDDYY.CSV

So the files in the FTP directory look like:

FRED_042212.CSV

FRED_042112.CSV

I want to download only the latest file.  Is there a way to do this? Or should I try to get read/write access and script a deletion after the file is downloaded?

Thanks

2

 

Forgot to mention, the file may not be FRED_%TODAY%.CSV it might be days or weeks old.

3

FTP is not real good at this sort of thing.

One way might be to start with today’s date and try to get it, and loop backwards x number of days till you find one.

or

Use the List directory action and use some script to parse the output (a lot more work)

or

Use the FTP mirror action, it works well with most FTP servers.

4


Thanks Vincent, good to know I wasn’t missing anything obvious. Thanks for the reply.