[Solved] FTP List files - VisualCron - Forum

Community forum

osirisja
2011-11-11T10:56:46Z
Hi support

On the (S)FTP task, there doesn't seem to be a way to list the files that are in any particular folder on an FTP server which means you have to download everything to find out what's there. Am I missing some obvious functionality ?

Cheers

Andy
Support
2011-11-11T11:01:15Z
No, you can't list files. But you could use a file filter when downloading.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
osirisja
2011-11-11T11:17:17Z
Hi Henrik

A File Filter would be fine if I knew what filenames to filter 😂

Enhancement request perhaps?

Cheers

Andy

Support
2011-11-11T11:33:27Z
Could you give an example how you would use the possible "List FTP Files" Task?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
osirisja
2011-11-11T11:56:13Z
Hi Henrik

Yes - a pretty simple and straight forward request I think...

In our environment, a customer transfers 'Data' files to our SFTP server. Once the files have been sent from the customer end, they then send a reconciliation file (the famous RECCY.TXT file I have been working with lately). This is a list of files and file sizes that 'they' say they have sent.

So, we are looking for the 'RECCY.TXT' file in a particular folder on the SFTP server. At the moment, there is no Event Trigger so we do this on a 5 minute scheduled trigger basis. (Hint at new feature request there).

Once the RECCY file is received we then read the contents, so we know what the customer 'says' they sent to us. The piece that is missing is that WE need to List the actual physical files that ARE in the customers SFTP folder and compare our list with the Customers RECCY list. IF they both agree, then we continue downloading. If they Don't agree, then we leave what's there and instigate a Notification process (Email to the customer) asking them politely to sort their files out 😂

So, it basically is an Audit facility that protects both the customer and ourselves.

Somehow we need to put this process in place immediately as we can't bypass the audit checks for business compliance reasons. For now it will have to be a manual process (aaargh) as I can't even run a Powershell script to check the folders as the 'get-ftp' cmdlet is not supported in VC :-(

Hope that makes it a wee bit clearer?

Cheers

Andy
Support
2011-11-11T12:02:57Z
Yes, it makes sense. Thanks. I am moving this topic to Feature requests.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
osirisja
2011-12-28T11:39:15Z
Hi Henrik

I was wondering if any more thought had been given to introducing this topic as a new feature?

Also, any updated on the FTP FILE LIST request from a previous post?

Cheers

Andy
Support
2011-12-29T09:17:50Z
It will definitely be implemented. We have some features in the queue and we cannot say when right now.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2012-02-23T13:44:45Z
Scroll to Top