-
Title
Automation variables not being applied in Export Wizard. Incorrect filename created from Export Wiz -
Description
Within Automation, the Export Wizard does not apply the Automation variable value when using them as suffixes for the file name.
Sample:
In automation "Set Variable" is set with variable VAR1 and a value of "Nov12".
In automation "Export Wizard" the file name \ToadExport_#VAR1#.xlsx is not created as expected. The file is saved as ToadExport_#VAR1#.xlsx and not as ToadExport_Nov12.xlsx
-
Cause
Toad does not support the use of Automation variables within the Export/Import Wizard modeles even if they are accessed through the Autoamtion. The Export/Import wizards are separate modules. -
Resolution
WORKAROUND
Instead of using the "Export Wizard" activity, use the "Select to File" activity. This will support the use of Automation variables in file names.When specifying the file name in "Select to File" there is a field for suffix. Use the drop down and choose the Automation variable. It will be enclosed in with 2 '#' symbols (i.e. #VAR1#).
STATUS
This limitation has been addressed in Toad Data Point 3.5, variables can now be used in the file name/path of the exported file.