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:designer:menus:accueil:nouvellerequete:restitution:excel [2020/09/25 14:20] sylvainair [Excel file] |
en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel [2021/02/01 16:44] (current) sylvainair [Mandatory parameters] |
||
|---|---|---|---|
| Line 31: | Line 31: | ||
| * **Macro to launch**: Automatic execution of a macro at the end of editing. For the macro to run, remember to uncheck the box "Remove personal information from file properties when saving" in the Excel options when saving the model. | * **Macro to launch**: Automatic execution of a macro at the end of editing. For the macro to run, remember to uncheck the box "Remove personal information from file properties when saving" in the Excel options when saving the model. | ||
| + | |||
| + | <WRAP round alert> | ||
| + | Warning: Running a macro or updating fields requires the use of the Excel application (even if the document type is "Excel 2007 workbook"). This being said, in the case of an "Excel 2007 workbook", only the execution of the macro or the updating of the fields will require the use of the Excel application (the data insertion will be done without the use of the Excel application, therefore, faster). | ||
| + | </WRAP> | ||
| - | ===== Running from Excel by adapting the Macro ===== | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel:exemplemacro|Macro example to be completed]] | ||
| ===== Running from Excel / Calling up external data ===== | ===== Running from Excel / Calling up external data ===== | ||
| - | The call of a Vigilens query from Excel is done through the menu''Data''→''External Data''→''From web''. \\ {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-135346.png?nolink&400}} | + | The call of a Vigilens query from Excel is done through the menu''Data''→''Get & transform data''→''From web''. \\ |
| - | ==== Mandatory parameters ==== | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143334.png?nolink&650}} |
| + | url exemple : ''http://my-server/vigilens/table.php?vglCtrlName="%2FDEMO%2F01%20Fiche%20CLIENT"&vglOutput="XLTable"&CLIENT=4245&vglNumFormat="%2C%2E"&vglUserName="srivier"'' | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-135545.png?nolink&400}} | + | |
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143828.png?nolink&650}} | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143941.png?nolink&650}} | ||
| + | ==== Mandatory parameters ==== | ||
| * Root Adress: http:<nowiki>//</nowiki><ServeurWeb>/vigilens/table.php? | * Root Adress: http:<nowiki>//</nowiki><ServeurWeb>/vigilens/table.php? | ||
| Line 50: | Line 57: | ||
| * vglUserName=<NomUtilisateur> | * vglUserName=<NomUtilisateur> | ||
| - | <WRAP round info>[[en:v8_0_0:howto:url|See url syntax guide]]</WRAP> | + | <WRAP round info> |
| + | * [[:en:v8_0_0:howto:url|See url syntax guide]] | ||
| + | * use [[:en:v8_0_0:designer:menus:accueil:start|commande line wizard]] in the designer, with output option "* Run query from Excel" | ||
| + | </WRAP> | ||
| <WRAP round tip> Parameters order does not matter </WRAP> | <WRAP round tip> Parameters order does not matter </WRAP> | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-135950.png?nolink&}} \\ | + | <WRAP round tip> |
| - | You can keep formats by checking the box ''Format Text Only'' in the import options. | + | It is possible to automate this processing by using Excel macros. Here is an example of a macro to be adapted according to the needs:[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel:exemplemacro|Example macro]] |
| - | + | </WRAP> | |
| - | + | ||
| - | Once result imported into Excel, it is possible to refresh data with ''Update'' button. | + | |
| - | + | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-140405.png?nolink&300}} | + | |
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-140435.png?nolink&300}} | ||