Table of Contents
Additional applications
VglUpdateQueries
The VlgUpdateQueries application automatically modifies the data source, environment and Excel templates for all queries in a given tree structure. It can be used through a Windows interface or from the command line by executing the VglUpdateQueries.exe file present in the Vigilens installation directory.
It is recommended to make a backup of the directories to be processed before running the VglUpdateQueries application.
Windows Interface
To determine the name of the data source and the environment to be replaced it is possible to use the button 
to select a query from which the application will extract the information.
If the check box to get a log file is checked without specifying a directory the log file will be created in the application directory.
Command line
The easiest way to generate a command line with the options corresponding to the expected result is to use the “Copy command line” or “Copy PowerShell command line” button from the Windows interface after selecting the desired options.
The options that can be used on the command line are as follows:
- vglDir=“<Directory>”: Root of the directory to process
- vglPrevDB=“<Data_Source_Data>”: Name of the data source to replace
- vglPrevEnv=“<Environment>”: Name of the environment to replace
- vglNewDB=“<Data_Source>”: Name of the data source replacing the existing one
- vglNewEnv=“<Environment>” : Name of the environment replacing the existing environment
- vglPrevXLTemplate=“<Character_String>”: String to replace in Excel template names
- vglNewXLTemplate=“<Character_String>” : String replacing the existing one in the Excel template names
- vglLog=“<Directory>”: Directory where the log file will be created (if not specified, the log file will be created in the application directory)
- vglNoLog : Disables the creation of a log file