Variable use in FTP using FileMask

Toad Data Point
1
  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

2

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.