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:installation:setupexcel [2020/07/23 13:48] sylvainair [Configuration for running Excel] |
en:v8_0_0:installation:setupexcel [2020/09/14 10:08] (current) sylvainair [Rights management] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| The use of "Excel file" output type requires the execution of Excel via DCOM. | The use of "Excel file" output type requires the execution of Excel via DCOM. | ||
| + | |||
| + | <WRAP round info> | ||
| + | Since version 7.5, it is possible to generate "Excel file" type restitutions without using the MS Excel application. | ||
| + | To do this, you must choose to generate a document of the ''Excel 2007 Workbook'' type (without specifying a macro or requesting the updating of fields after data insertion). | ||
| + | </WRAP> | ||
| + | |||
| By default, DCOM is configured so that Excel is launched by the executing user. However, this is a problem when the call to Excel is made from a Windows service (case of the Vigilens Web interface) or from the task scheduler. | By default, DCOM is configured so that Excel is launched by the executing user. However, this is a problem when the call to Excel is made from a Windows service (case of the Vigilens Web interface) or from the task scheduler. | ||
| Line 10: | Line 16: | ||
| <WRAP round alert> | <WRAP round alert> | ||
| - | When Excel output is triggered by Vigilens Web interface or Task Scheduler, Excel is launched without its graphical interface being displayed. In order to avoid any risk of blocking the process, make sure that no dialog box will be displayed (Example: "Tips" box, Office account settings box, document retrieval window). | + | When Excel output is triggered by Vigilens Web interface or Task Scheduler, Excel is launched without its graphical interface being displayed. In order to avoid any risk of blocking the process, **make sure that no dialog box will be displayed** (Example: "Tips" box, Office account settings box, document recovery panel). |
| </WRAP> | </WRAP> | ||
| Line 21: | Line 27: | ||
| This setup is not documented by Microsoft</WRAP> | This setup is not documented by Microsoft</WRAP> | ||
| - | However, from our experience, it is functional and has the advantage of allowing MS Excel output in all cases, without having to modify the DCOM configuration for Excel : | + | However, from our experience, it is functional and **has the advantage** of allowing MS Excel output **in all cases**, without having to modify the DCOM configuration for Excel : |
| * whether there is an active Windows session or not on the server where Vigilens Web is installed (or on the computer/server where the scheduled requests are executed). | * whether there is an active Windows session or not on the server where Vigilens Web is installed (or on the computer/server where the scheduled requests are executed). | ||
| * In Web mode as in Windows mode (Vigilens Designer) | * In Web mode as in Windows mode (Vigilens Designer) | ||
| Line 28: | Line 34: | ||
| <WRAP round alert> | <WRAP round alert> | ||
| - | Sur une machine 64 bits, il peut s’avérer nécessaire de créer le répertoire suivant : ''C:\Windows\SysWOW64\config\systemprofile\Desktop'' </WRAP> | + | On a 64-bit machine, it may be necessary to create the following directory: ''C:\Windows\SysWOW64\config\systemprofile\Desktop'' </WRAP> |
| + | <WRAP round info> | ||
| + | This solution also avoids a number of problems related to the use of macros in Excel templates. | ||
| + | </WRAP> | ||
| ==== Changing the DCOM settings ==== | ==== Changing the DCOM settings ==== | ||
| + | === For a given user === | ||
| + | |||
| <WRAP round important> | <WRAP round important> | ||
| This option has the advantage of allowing MS Excel reports even when no Windows session is active on the server where Vigilens Web is installed or on the computer/server where the scheduled requests are executed.</WRAP> | This option has the advantage of allowing MS Excel reports even when no Windows session is active on the server where Vigilens Web is installed or on the computer/server where the scheduled requests are executed.</WRAP> | ||
| Line 89: | Line 100: | ||
| * Giving the rights to this directory to users profiles | * Giving the rights to this directory to users profiles | ||
| * Modify the system variables TEMP and TMP so that they use a directory that is already accessible by users profiles. | * Modify the system variables TEMP and TMP so that they use a directory that is already accessible by users profiles. | ||
| + | |||