====== 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.
<WRAP center round important>
It is recommended to make a backup of the directories to be processed before running the VglUpdateQueries application.
</WRAP>

==== Windows Interface ===

{{:en:v8_0_0:appscomp:pasted:20210201-161748.png?nolink}}

<WRAP center round tip>
To determine the name of the data source and the environment to be replaced it is possible to use the button {{:v8_0_0:appscomp:pasted:20210128-172510.png?nolink}} to select a query from which the application will extract the information.
</WRAP>

<WRAP center round info>
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.
</WRAP>

==== 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