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:30] sylvainair [Changing the DCOM settings] |
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> | ||
| - | <WRAP round info> | ||
| - | This solution also avoids a number of problems related to the use of macros in Excel templates. | ||
| - | </WRAP> | ||
| Line 24: | 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 31: | 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 60: | Line 68: | ||
| * validate dialog box | * validate dialog box | ||
| + | |||
| + | ==== Interactive user ==== | ||
| + | |||
| + | <WRAP round alert> | ||
| + | The use of the interactive user to launch Excel requires that he always has an active session on the server where Vigilens Web is installed (preferably that of the user associated to the "Vigilens Web" service in order to avoid possible access right problems) or on the workstation/server executing the scheduled requests (preferably that of the user associated to the scheduled task in order to avoid possible access right problems). | ||
| + | |||
| + | This is the operating mode recommended and supported by Microsoft. | ||
| + | </WRAP> | ||
| + | |||
| + | How to proceed: | ||
| + | * Run the DCOM configuration tool. | ||
| + | * "DCOMCNFG.EXE" if you have 32-bit MS Excel on a 32-bit MS Windows system or 64-bit MS Excel on a 64-bit MS Windows system. | ||
| + | * in the case of 32-bit MS Excel on a 64-bit MS Windows system, run "MMC comexp.msc /32". | ||
| + | * Under "Component Services - Computers - Workstation - DCOM Configuration" select the "Microsoft Excel Application" line. | ||
| + | * In the "Action" menu, click "Property". | ||
| + | * In the properties box, select the "Identity" tab. | ||
| + | * Select "The interactive user". | ||
| + | * Validate the properties box | ||
| + | |||
| + | {{:en:v8_0_0:installation:pasted:20200723-133522.png?nolink}} | ||
| + | |||
| + | ===== Rights management ===== | ||
| + | |||
| + | The execution of Excel by the interactive user in web or scheduled mode is done through a system user account. The Excel functionalities implemented for the creation or update of a file requires the use of the temporary directory (that of the system consequently). By default, this directory is set to "C:\windows\TEMP". It is, therefore, necessary that this directory be accessible in read and write mode to the user associated with the Vigilens Web service or the execution of the scheduled task. | ||
| + | |||
| + | To know the directory defined on your system, you need to access the environment variables. | ||
| + | |||
| + | {{:en:v8_0_0:installation:pasted:20200723-134327.png?nolink}} | ||
| + | |||
| + | Two alternatives are possible: | ||
| + | * 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. | ||
| + | |||