|
|
| (10 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| __TOC__ | | __TOC__ |
| The Setup package consists of the following files:
| | <br> |
| :*setup.exe
| |
| :*CopAddinSetup.msi
| |
| :*CoPlanner 9.1 and higher: Install.bat
| |
| :*The folder KB908002
| |
|
| |
|
| Please run setup.exe to start the installation procedure. The folder KB908002 contains the Microsoft .Net Framework Update components that are required for running an Automation Add-In. This update is an official extension of the .Net Framework 2.0 and is created and supported by Microsoft.
| | The installation setup for the Excel Client 1.0 will be run by double-clicking the executable file ''CoPlanner Excel Client 1.0.msi''. |
|
| |
|
| {| {{Bausteindesign1}} | | {| {{Bausteindesign1}} |
| |- | | |- |
| | <span style="color: darkblue;">'''Hint'''</span> If the computer on which you are installing the CoPlanner Excel Client already contains the previous version, CoPlanner Com-Client, please verify before starting the Setup procedure that the file excel.exe.config is located in the same folder as excel.exe. | | | <span style="color: darkblue;">'''Hint'''</span> To ensure a clean installation, make sure before starting the installation that no CoPlanner Excel client is already installed on your system. If this is the case, uninstall it before reinstalling. |
| |} | | |} |
|
| |
|
|
| |
|
| Excel.exe is located in the Microsoft Office installation folder. The default installation folder is C:\Program Files\Microsoft Office. Depending on your version of Microsoft Office (XP, 2003, 2007), the name of the subfolder that contains excel.exe will be Office10, Office11, or Office12.
| | == Installation steps== |
|
| |
|
| If you find the file excel.exe.config in this folder, please delete the file. This file causes Microsoft Excel to be started under the .Net Framework runtime 1.1. However, the CoPlanner Excel Client requires the runtime of .Net Framework 2.0.
| | Start the installation by starting the client 1.0.msi CoPlanner Excel file. A wizard guides you through the installation. |
|
| |
|
| If you are installing the CoPlanner Excel Client via setup.exe and you see an error message indicating that there is no connection to the Internet, please proceed as follows: Cancel the setup routine. Manually install the setup packages located in the folder KB908002. Then continue installing the Excel Client by means of CopAddinSetup.msi. Please note that you must install the components of the folder KB908002 before you install the Excel Client. You do not need to install the office2003-kb907417sfxcab-ENU.exe package unless you are running Microsoft Office 2003.
| | {| class="wikitable" width={{{breite|70%}}} |
| | | |- {{Tabellentitel}} |
| | | |width="40%" |Installation step |
| ==Installation steps== | | |width="60%" |Description |
| | |
| CoPlanner 9.0 and older versions: Start the installation procedure by running setup.exe.
| |
| CoPlanner 9.1: Start the installation procedure by running install.bat. You must have local administrator rights to be able to run this setup procedure.
| |
| | |
| The following dialogue will be displayed to inform you that the .Net Framework Update components are required and will now be installed.
| |
| | |
| {| {{Bausteindesign1}}
| |
| |- | | |- |
| | <span style="color: darkblue;">'''Hint'''</span> The user running the setup routine must have local administrator rights. The CoPlanner Excel Client must be installed separately for each NT user. To make the Excel Client available for more than one user on the same computer, the MSI package must be run for each user. (For details, please see the section on Installing Excel Client for more than one user.) | | |[[Image:EC1_Installationsdialog_1.png|thumb|center|Excel Client, Installation step 1]] |
| |} | | |Startscreen of the installation |
| | |
| | |
| To ensure that the CoPlanner Excel Client is available in Microsoft Excel, macro security (Developer tab, Code group, Macro Security button) must be set to Medium or Low.
| |
| Click on the “Install” button to install the required components on your computer.
| |
| | |
| | |
| | |
| {| style=cellspacing="1" cellpadding="5" border="0" width={{{breite|100%}}}
| |
| |- | | |- |
| |[[Image:Excel setup 1.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_2.png|thumb|center|Excel Client, Installation step 2]] |
| |Klicken Sie hier auf Install, um die erforderlichen Komponenten auf dem Rechner zu installieren. | | |Licence conditions must be accepted in order to proceed the installation |
| |- | | |- |
| |[[Image:Excel setup 2.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_3.png|thumb|center|Excel Client, installation step 3]] |
| |Nachfolgender Dialog gibt über den Status der .Net Framework-Komponenten Installation Auskunft. Nach Beendigung der Komponenteninstallation folgt die eigentliche CoPlanner Excel Client Installation. | | |The installation directory of the Excel client can be changed |
| |- | | |- |
| |[[Image:Excel setup 3.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_4.png|thumb|center|Excel Client, installation step 4]] |
| |Klicken Sie auf Next, um mit der Installation fortzufahren. | | |Installation will be started |
| | {| {{Bausteindesign1}} |
| |- | | |- |
| |[[Image:Excel setup 4.jpg|thumb|left]] | | | <span style="color: darkblue;">'''Hint'''</span> Therefor you need administration rights. |
| |Klicken Sie auf Next, um mit der Installation fortzufahren. | | |} |
| |- | | |- |
| |[[Image:Excel setup 5.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_5.png|thumb|center|Excel Client, installation step 5]] |
| |Durch diesen Dialog können Sie den Speicherort des CoPlanner Addins bestimmen. Nachdem Sie den gewünschten Speicherort ausgewählt haben klicken Sie auf Next, um mit der Installation fortzufahren. | | |Overview of the status of the install procedure. |
| |- | | |- |
| |[[Image:Excel setup 6.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_6.png|thumb|center|Excel Client, installation step 6]] |
| |Die Installationseinstellungen wurden nun getroffen. Der Dialog zeigt an, dass das Setup fertig für die Durchführung ist. Klicken Sie auf Next, um die Installation zu starten. | | |Dialog for entering the server connection |
| | {| {{Bausteindesign1}} |
| |- | | |- |
| |[[Image:Excel setup 7.jpg|thumb|left]] | | | <span style="color: darkblue;">'''Hint'''</span> That dialog does not appear if in the installation directory is already the configuration file [[Excel Client:Connection to server|ClientConfig.xml]] configured for the Excel client. |
| |Übersicht über den Status der Installation. | | |} |
| |- | | |- |
| |[[Image:Excel setup 8.jpg|thumb|left]] | | |[[Image:EC1_Installationsdialog_7.png|thumb|center|Excel Client, installation step 7]] |
| |Ist der Installationsvorgang erfolgreich durchgeführt worden erscheint dieser Dialog. Klicken Sie auf Close. Der CoPlanner Excel-Client wurde installiert und ist nun im Hauptmenü von Microsoft Excel durch den Menüpunkt CoPlanner 8.2 verfügbar. | | |Confirmation of a successful installation |
| |} | | |} |
| <br> <br>
| |
|
| |
|
| == Excel Client für mehrere Benutzer installieren ==
| |
|
| |
|
| Die Voraussetzung für die Installation des Excel Clients für einen Benutzer, der keine lokalen Administrationsrechte besitzt, ist die bereits erfolgte Installation des Excel Client, durch einen Administrator des betroffenen Rechners.
| | The file Silent_install.bat is also used for the Excel Client installation. There you don't have to go through the steps, as decribed above, you went through the installation in one step without displaying a user interface. For this the [[Technics:CoPlanner_Win-Client#ClientConfig.xml|ClientConfig.xml]] is used which is in the same directory. This must be configured accordingly. This type of installation is preferably carried out when the Excel client will be rolled out on multiple systems without any interaction by a user. |
| | |
| | |
| | {| {{Bausteindesign1}} |
| | |- |
| | | <span style="color: darkblue;">'''Hint'''</span> Frequently asked questions about the installation, see the [[Excel_Client:FAQs|FAQs]]. |
| | |} |
| | <br> |
| | |
|
| |
|
| Da durch die Administrator Installation die benötigten Registrierungen erfolgen, muss der Benutzer, für welchen der Excel Client verfügbar sein soll, die Installation durch die Datei CopAddinSetup.msi starten.
| | ====Installation with parameters (from 9.5 HF 3.5)==== |
|
| |
|
| Die Installationsschritte sind die Selben wie unter [[Excel_Client:Installation#Installationsschritte|Installationsschritte]]. Nach der Beendigung der Installationsschritte ist auch für den Benutzer der CoPlanner Excel Client verfügbar.
| | Starting with version 9.5 HF 3.5 Add-Ins can be installed via command line using parameters. If no parameter(s) is/are given installation will act as before. |
|
| |
|
| == Erweiterte Konfiguration ==
| |
|
| |
|
| Erweiterte Konfigurationsmöglichkeiten bestehen durch die Datei Cop.AddIn.dll.config, die ab der Version 2007-11-20 mit ausgeliefert wird. Diese wird durch das Setup im Installationsverzeichnis mit abgelegt. Der Aufbau entspricht dem einer App.exe.config Datei.
| | The following parameters can be used: |
|
| |
|
| Folgende erweiterte Einstellungen können vorgenommen werden:
| | *COP_SERVER |
| | *COP_PORT |
| | *COP_MAXROWS |
| | *COP_MAXCELLS |
| | *COP_TCPFORMATTER |
| | *COP_SSLCOMMONNAME |
| | *COP_LANGUAGES |
|
| |
|
| *<add key="logonProperties.showPlan" value="True"/> <br>Planauswahl beim Logon anzeigen/ausblenden<br>
| | Example: |
| *<add key="logonProperties.showLanguages" value="True"/><br>Sprachauswahl beim Logon anzeigen/ausblenden<br>
| |
| *<add key="logonProperties.showUnternehmen" value="True"/><br>Unternehmensauswahl beim Logon anzeigen/ausblenden<br>
| |
| *<add key="layoutProperties.Filtercolor" value="C9D2EA"/><br>Farbe der Filter<br>
| |
| *<add key="layoutProperties.FilterMainColor" value="F0EEE1"/><br>Hauptfarbe der Filter<br>
| |
| *<add key="layoutProperties.SpaceBewtweenFilter" value="4"/><br>Abstand zwischen den einzelnen Filter<br>
| |
| *<add key="compatibility.PreventCustomMouseCursorVisualisation" value="False"/><br>Erweiterte Mouse Cursor bei Drag&Drop aktivieren/deaktivieren<br>
| |
| *<add key="SSPITimeOut" value="180"/><br>Clienttimeout bei SSPI Logon (in Sekunden)<br>
| |
| *<add key="CommandTimeOut" value="0"/><br>Commandtimeout bei Datenanforderungen in Sekunden. 0 bedeutet kein Timeout bei Anforderungen.<br>
| |
| *<add key="MatrixBuilder.RefreshDataAfterFilterChangeSelectable" value="true"/><br><!-- Im Matrixbuilder "filteränderung - daten sofort laden" per checkbox aktivierbar sein Achtung - zieht nur, wenn AUCH in Hostinterface eingeschaltet! --><br>
| |
| *<add key="MatrixBuilder.RefreshDataAfterFilterChangeSelection" value="true"/><br><!-- Im Matrixbuilder "filteränderung - daten sofort laden" per checkbox aktivierbar sein <br>Achtung - zieht nur, wenn AUCH in Hostinterface eingeschaltet! Diese Einstellung legt den<br>Defaultwert fest und zieht nur, wenn MatrixBuilder.RefreshDataAfterFilterChangeSelectable ==true --><br>
| |
|
| |
|
| Häufig gestellte Fragen zur Installation finden Sie in den [[Excel_Client:FAQs|FAQs]].
| | msiexec /i CoPlannerExcelClient_v1.0.msi COP_SERVER=ServerXY COP_PORT=8965 COP_LANGUAGES="Deutsch|English" |
|
| |
|
|
| |
|
| __NOEDITSECTION__ | | __NOEDITSECTION__ |
| [[category:Excel_Client|Installation]] | | [[Category:Excel_Client|Installation]] |
| | [[de:Excel_Client:Installation]] |
The installation setup for the Excel Client 1.0 will be run by double-clicking the executable file CoPlanner Excel Client 1.0.msi.
| Hint To ensure a clean installation, make sure before starting the installation that no CoPlanner Excel client is already installed on your system. If this is the case, uninstall it before reinstalling.
|
Installation steps
Start the installation by starting the client 1.0.msi CoPlanner Excel file. A wizard guides you through the installation.
The file Silent_install.bat is also used for the Excel Client installation. There you don't have to go through the steps, as decribed above, you went through the installation in one step without displaying a user interface. For this the ClientConfig.xml is used which is in the same directory. This must be configured accordingly. This type of installation is preferably carried out when the Excel client will be rolled out on multiple systems without any interaction by a user.
| Hint Frequently asked questions about the installation, see the FAQs.
|
Installation with parameters (from 9.5 HF 3.5)
Starting with version 9.5 HF 3.5 Add-Ins can be installed via command line using parameters. If no parameter(s) is/are given installation will act as before.
The following parameters can be used:
- COP_SERVER
- COP_PORT
- COP_MAXROWS
- COP_MAXCELLS
- COP_TCPFORMATTER
- COP_SSLCOMMONNAME
- COP_LANGUAGES
Example:
msiexec /i CoPlannerExcelClient_v1.0.msi COP_SERVER=ServerXY COP_PORT=8965 COP_LANGUAGES="Deutsch|English"
