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:jdeutil:start [2021/07/13 15:43] sylvainair [Text Block Security] |
en:v8_0_0:jdeutil:start [2021/07/13 15:55] (current) sylvainair [Execution from JDE] |
||
|---|---|---|---|
| Line 65: | Line 65: | ||
| ===== Installation & Setup ===== | ===== Installation & Setup ===== | ||
| + | ==== Pre-requisite ==== | ||
| + | |||
| + | * VIGILENS Version above 7.0 | ||
| + | * JD Edwards Version above 8.12 | ||
| ==== Installation in JDE ==== | ==== Installation in JDE ==== | ||
| === Delivered JDE Objects === | === Delivered JDE Objects === | ||
| Line 95: | Line 99: | ||
| * 2) This is the Vigilens user for accessing shared directories | * 2) This is the Vigilens user for accessing shared directories | ||
| * 2.1) Named user or JDE user? | * 2.1) Named user or JDE user? | ||
| - | * If \'\' or 1 JDEUTIL takes the user connected to JDE to access VIGILENS (Warning, it is necessary that the JDE user is also created as a VIGILENS user cf import user JDE) if the JDE user does not exist in the VIGILENS users then JDEUTIL will take the user of option 2.2 | + | * If empty or 1 JDEUTIL takes the user connected to JDE to access VIGILENS (Warning, it is necessary that the JDE user is also created as a VIGILENS user cf import user JDE) if the JDE user does not exist in the VIGILENS users then JDEUTIL will take the user of option 2.2 |
| * Otherwise the user of option 2.2 will be the user VIGILENS | * Otherwise the user of option 2.2 will be the user VIGILENS | ||
| * 2.2) Vigilens User | * 2.2) Vigilens User | ||
| * 3) Used only to access tables F59VGSEC and F00950 for security purposes (no link with query result data) | * 3) Used only to access tables F59VGSEC and F00950 for security purposes (no link with query result data) | ||
| - | * If option 6 is set to \'\' or N then options 3 and 4 are used to define the data source for security (the environment for the data will be the one defined in VIGILENS Designer) | + | * If option 6 is set to empty or N then options 3 and 4 are used to define the data source for security (the environment for the data will be the one defined in VIGILENS Designer) |
| * If option 6 is set to Y then options 3 and 4 are not used | * If option 6 is set to Y then options 3 and 4 are not used | ||
| * 4) Same as OT 3 | * 4) Same as OT 3 | ||
| Line 107: | Line 111: | ||
| * Otherwise enter the path and name of the query to execute (Note that the path defined should not start from the root but from the user's root folder cf https://vigilens.wiki/dokuwiki/doku.php?id=v8_0_0:en:admintool:menus:gestion:utilisateur:start&s[]=user ) | * Otherwise enter the path and name of the query to execute (Note that the path defined should not start from the root but from the user's root folder cf https://vigilens.wiki/dokuwiki/doku.php?id=v8_0_0:en:admintool:menus:gestion:utilisateur:start&s[]=user ) | ||
| * 6) Data source for the query data | * 6) Data source for the query data | ||
| - | * If '\' or N the data source for the DATA will be that defined in VIGILENS Designer | + | * If empty or N the data source for the DATA will be that defined in VIGILENS Designer |
| * If Y, the data source for the DATA will be the one used in the JDE environment | * If Y, the data source for the DATA will be the one used in the JDE environment | ||
| + | ==== Execution from JDE ==== | ||
| + | |||
| + | There are 2 possibilities to use JDEUTIL: | ||
| + | * Calling directly in the menus the P59VLVIG. The selected version will define the actions to be performed | ||
| + | |||
| + | {{:v8_0_0:jdeutil:pasted:20210713-135255.png}} | ||
| + | |||
| + | * Call the P59VLVIG shortcut. This process allows you to create only one version of the P59VLVIG and to control the processing options directly in the URL | ||
| + | |||
| + | {{:v8_0_0:jdeutil:pasted:20210713-135352.png}} | ||
| + | |||
| + | ''http://adresse_de_JDE/jde/ShortcutLauncher?OID=P59VLVIG_W59VLVIGA_Version_du_P59VLVIG&FormDSTmpl=|1|2|3|4|5|6|7|&FormDSData=|option_de_traitement_1| option_de_traitement_2| option_de_traitement_3 | option_de_traitement_4| option_de_traitement_5| option_de_traitement_6| option_de_traitement_7|'' | ||
| + | ==== Setting up VIGILENS ==== | ||
| + | === Define access to the F59VGSEC table === | ||
| + | {{:v8_0_0:jdeutil:pasted:20210713-135829.png}} | ||
| + | === Enable record deletion === | ||
| + | {{:v8_0_0:jdeutil:pasted:20210713-135840.png}} | ||