Toad World® Forums

Variable use in FTP using FileMask

  1. Hi -
    I am attempting to use a variable in the file name to download files for the current day, but I’m having difficulty attempting to do this. I have created a variable, but using in the filemask from within an FTP File Activity is not working.

Here is the pseudo code for what I am trying to do:

  1. Initiate automation
  2. Create variable to retrieve ‘CurrentDate’
  3. connect to FTP and download filename + ‘CurrentDate’
  4. import data from all files into access database
  5. run some queries to create reporting
  6. export data to specific format
  7. Not sure if this is possible considering I will need powerpoint or some other file form
  • email reporting
    Please let me know if you need additional information or if this functionality is not available currently. I was under the impression that it would be available with the latest 3.5 release, but I’m unable to get it working.

Thanks,

Trent

We currently do not support automation variables in FTP upload/download activity. I have entered QAT-2761 for this. Perhaps you can download all files and then filter by date using Import Folder option of import wizard or Copy Activity. I know that is not much of a work around. I also can’t promise a quick turn around on this one but I will see what I can do for this release.