meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:v8_0_0:howto:schedule [2020/07/07 17:48] sylvainair [/vglNumFormat=DecimalesMilliers] |
en:v8_0_0:howto:schedule [2020/07/22 12:56] (current) sylvainair |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Scheduled processing ====== | + | ====== Scheduled run ====== |
Automatically launching a query or a set of queries at regular intervals is a common need in companies. This is why Vigilens offers you a mechanism for scheduling your queries. | Automatically launching a query or a set of queries at regular intervals is a common need in companies. This is why Vigilens offers you a mechanism for scheduling your queries. | ||
Line 15: | Line 15: | ||
You have to define users who will be allowed to connect with a command line. | You have to define users who will be allowed to connect with a command line. | ||
- | #TODO {{:v8_0_0:howto:faa09f498d1d36583bb796df4130e68d.png?nolink&500}} | + | {{:en:v8_0_0:howto:pasted:20200708-092836.png?nolink}} |
===== Assistant ===== | ===== Assistant ===== | ||
Line 26: | Line 25: | ||
<WRAP round tip> | <WRAP round tip> | ||
- | If you want to be sure that a free connexion will be available at the moment job is triggered, it may be useful to create [[:env8_0_0:admintool:menus:gestion:utilisateur:start#general|a specific user with "Vigilens Dedicated" profile type.]] | + | If you want to be sure that a free connexion will be available at the moment job is triggered, it may be useful to create [[:en:v8_0_0:admintool:menus:gestion:utilisateur:start#general|a specific user with "Vigilens Dedicated" profile type.]] |
</WRAP> | </WRAP> | ||
Line 43: | Line 42: | ||
==== /vglAuto ==== | ==== /vglAuto ==== | ||
- | * Processes all queries inside a directory provided by user | + | * Processes all queries inside a directory __**interactively**__ provided by user |
+ | * For fully automated run, use /vglDir instead. | ||
Line 69: | Line 68: | ||
The numerical values returned will use : | The numerical values returned will use : | ||
- | * the first character specified as the decimal separator. | + | * the first character as the decimal separator. |
- | * the second specified as the thousands separator | + | * the second as the thousands separator |
- | ==== /vglOutput=TypeSortie ==== | + | ==== /vglOutput=OutputType ==== |
- | + | * This optionnal setup is used combined with /vglExe. | |
- | * Ce paramètre optionnel s’utilise avec le paramètre /vglExe. | + | * Force an output type other than the one defined at query level. |
- | * Force un type de sortie autre que celui prévu au niveau de la requête. | + | * possible values are |
- | * Les valeurs possibles sont : | + | * Grid : default |
- | * Grid : Ecran de restitution (défaut) | + | |
- | * PDF : Fichier PDF | + | * XLS |
- | * XLS : Fichier Excel | + | * TXT |
- | * TXT : Fichier texte | + | |
- | + | ||
- | ==== /vglPDFType=TypeFichierPDF ==== | + | |
- | + | ||
- | * Spécifie le type de sortie PDF. | + | |
- | * Les valeurs possibles sont : | + | |
- | * 0 Grille | + | |
- | * 1 Etat | + | |
- | * Ce paramètre est obligatoire avec le paramètre vglOutput=PDF . | + | |
- | + | ||
- | ==== /vglPDFModel=ModeleImpression ==== | + | |
- | * Spécifie le modèle d’état ou d’impression de la grille. | ||
- | * ce paramètre est obligatoire avec le paramètre vglOutput=PDF | ||
- | ==== /vglMaxLineNumber=Valeur ==== | + | ==== /vglPDFType=PDFFileType ==== |
- | * Spécifie le nombre maximum d’enregistrements à restituer. | + | * Specify PDF output type |
- | * Au-delà l’exécution de la requête s’arrête et renvoie un message d’erreur. | + | * possibles values are : |
- | * Ce paramètre permet de sécuriser l’emploi des ressources machine. | + | * 0 Grid |
+ | * 1 Report | ||
+ | * this parameter is mandatory with /vglOutput=PDF . | ||
- | ==== Passage de paramètres ==== | + | ==== /vglPDFModel=PrintTemplate ==== |
- | * Les valeurs des paramètres à l’exécution sont spécifiées dans la ligne de commande en utilisant leur code court | + | * Specify the grid print template or report template |
- | * syntaxe : ''/CodeCourt=ValeurSelectionnee'' | + | * this setup is mandatory with /vglOutput=PDF |
- | * On peut ne pas les prendre en compte (autoriser toutes valeurs) par le caractère * en lieu et place de la valeur de sélection | + | |
- | ~~NOCACHE~~ <WRAP round download> <todo @contenu showdate:yes #erica:2020-07-06>à faire</todo> \\ <todo @orthographe showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @liens_internes showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @liens_casss showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @page_absente showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @todo showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @coherence_graphique showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @taille_images showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @version_mobile showdate:yes #jacobt:2020-07-06>à faire</todo> \\ <todo @version_anglaise showdate:yes>à faire</todo> \\ </WRAP> | + | ==== /vglMaxLineNumber=Number ==== |
+ | * Specify the maximum number of lines in the output. | ||
+ | * Beyond, query stops and returns an error message. | ||
+ | * This setup secures machines resources use. | ||
+ | ==== Parameters passing ==== | ||
+ | * Processing parameters values are passed in the command-line using their short code | ||
+ | * syntax : ''/ShortCode=SelectedValue'' | ||
+ | * You cannot use wildcards as a parameter to set a selection |