Excel Client:Installation - Revision history

Admin at 13:15, 15 April 2019

2019-04-15T13:15:06Z

← Older revision		Revision as of 15:15, 15 April 2019
Line 58:		Line 58:
	\|}		\|}
	<br>		<br>


			====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"

Admin at 13:49, 14 October 2015

2015-10-14T13:49:42Z

← Older revision		Revision as of 15:49, 14 October 2015
Line 42:		Line 42:
	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}
	\|-		\|-
	\| <span style="color: darkblue;">'''Hint'''</span>  That dialog does not appear if in the installation directory is already the configuration file for the Excel client.		\| <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.
	\|}		\|}
	\|-		\|-
Line 48:		Line 48:
	\|Confirmation of a successful installation		\|Confirmation of a successful 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 [[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.


Line 55:		Line 58:
	\|}		\|}
	<br>		<br>


	__NOEDITSECTION__		__NOEDITSECTION__
	[[Category:Excel_Client\|Installation]]		[[Category:Excel_Client\|Installation]]
	[[de:Excel_Client:Installation]]		[[de:Excel_Client:Installation]]

Admin at 09:52, 18 June 2015

2015-06-18T09:52:24Z

Show changes

Admin at 08:13, 5 May 2011

2011-05-05T08:13:50Z

← Older revision		Revision as of 10:13, 5 May 2011
Line 123:		Line 123:

	<font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">MatrixBuilder.RefreshDataAfterFilterChangeSelectable</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>		<font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">MatrixBuilder.RefreshDataAfterFilterChangeSelectable</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>
	~~<!--~~ “Filter changes – load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well~~! -->~~		“Filter changes – load data immediately” can be activated by means of a check box in the matrix builder. <br>Note: Used only if activated in host interface as well!

	~~Im Matrixbuilder "Filteränderung - Daten sofort laden" per Checkbox aktivierbar sein.<br>~~
	~~Achtung - zieht nur, wenn AUCH in Hostinterface eingeschaltet~~!

	<font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">MatrixBuilder.RefreshDataAfterFilterChangeSelection</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>		<font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">MatrixBuilder.RefreshDataAfterFilterChangeSelection</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>
	~~Im Matrixbuilder "Filteränderung - Daten sofort laden" per Checkbox aktivierbar sein.<br>~~		“Filter changes - load data immediately” can be activated by means of a check box in the matrix builder.<br>
	~~Achtung - zieht nur, wenn AUCH in Hostinterface eingeschaltet! Diese Einstellung legt den Defaultwert fest und zieht nur, wenn MatrixBuilder.RefreshDataAfterFilterChangeSelectable = True.~~		Note: Used only if activated in host interface as well! This setting determines the default value and is used only if Analyzer.<br>
			RefreshDataAfterFilterChangeSelectable ==true





	*<add key="MatrixBuilder.RefreshDataAfterFilterChangeSelectable" value="true"/><br><!-- “Filter changes – load data immediately” can be activated by means of a check box in the matrix builder. ~~Note: Used only if activated in host interface as well! -->~~<br>
	*<add key="MatrixBuilder.RefreshDataAfterFilterChangeSelection" value="true"/><br><!-- “Filter changes - load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well! This setting determines the default value and is used only if Analyzer.RefreshDataAfterFilterChangeSelectable ==true ~~--><br>~~

	__NOEDITSECTION__		__NOEDITSECTION__
	[[category:Excel_Client\|Installation]]		[[category:Excel_Client\|Installation]]
	[[de:Excel_Client:Installation]]		[[de:Excel_Client:Installation]]

Admin at 08:12, 5 May 2011

2011-05-05T08:12:30Z

@@ Line 98: / Line 98: @@
 Show/hide Select Plan dialogue at login time
-*&lt;add key="logonProperties.showLanguages" value="True"/&gt;<br>Show/hide Select Language dialogue at login time<br>
+ <font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">logonProperties.showLanguages</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>
-*&lt;add key="logonProperties.showUnternehmen" value="True"/&gt;<br>Show/hide Select Company dialogue at login time <br>
+Show/hide Select Language dialogue at login time
-*&lt;add key="layoutProperties.Filtercolor" value="C9D2EA"/&gt;<br>Filter colours <br>
-*&lt;add key="layoutProperties.FilterMainColor" value="F0EEE1"/&gt;<br>Main filter colour <br>
+ <font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">logonProperties.showUnternehmen</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>
-*&lt;add key="layoutProperties.SpaceBewtweenFilter" value="4"/&gt;<br>Distance between individual filters <br>
+Show/hide Select Company dialogue at login time
-*&lt;add key="compatibility.PreventCustomMouseCursorVisualisation" value="False"/&gt;<br>Activate/deactivate extended mouse cursor on drag & drop <br>
-*&lt;add key="SSPITimeOut" value="180"/&gt;<br>Client timeout (in seconds) at SSPI login <br>
+ <font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">layoutProperties.Filtercolor</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">C9D2EA</font><font color="#000000">"</font><font color="#0000ff">/></font>
-*&lt;add key="CommandTimeOut" value="0"/&gt;<br>Command timeout (in seconds) for data requests. 0 means no timeout for data requests.<br>
+Filter colours
 *&lt;add key="MatrixBuilder.RefreshDataAfterFilterChangeSelectable" value="true"/&gt;<br>&lt;!-- “Filter changes – load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well! --&gt;<br>
 *&lt;add key="MatrixBuilder.RefreshDataAfterFilterChangeSelection" value="true"/&gt;<br>&lt;!-- “Filter changes - load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well! This setting determines the default value and is used only if Analyzer.RefreshDataAfterFilterChangeSelectable ==true --&gt;<br>

Admin at 08:09, 5 May 2011

2011-05-05T08:09:28Z

← Older revision		Revision as of 10:09, 5 May 2011
Line 95:		Line 95:


	*<add key="logonProperties.showPlan" value="True"/~~>~~ <br>Show/hide Select Plan dialogue at login time~~<br>~~		<font color="#0000ff"><</font><font color="#a31545">add </font><font color="#ff0000">key</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">logonProperties.showPlan</font><font color="#000000">"</font> <font color="#ff0000">value</font><font color="#0000ff">=</font><font color="#000000">"</font><font color="#0000ff">True</font><font color="#000000">"</font><font color="#0000ff">/></font>
			Show/hide Select Plan dialogue at login time

	*<add key="logonProperties.showLanguages" value="True"/><br>Show/hide Select Language dialogue at login time<br>		*<add key="logonProperties.showLanguages" value="True"/><br>Show/hide Select Language dialogue at login time<br>
	*<add key="logonProperties.showUnternehmen" value="True"/><br>Show/hide Select Company dialogue at login time <br>		*<add key="logonProperties.showUnternehmen" value="True"/><br>Show/hide Select Company dialogue at login time <br>

Admin at 07:40, 15 July 2010

2010-07-15T07:40:10Z

← Older revision		Revision as of 09:40, 15 July 2010
Line 65:		Line 65:
	\|[[Image:Excel setup 8.jpg\|thumb\|left]]		\|[[Image:Excel setup 8.jpg\|thumb\|left]]
	\|In the next screen, you will be asked for the server name and the port number.		\|In the next screen, you will be asked for the server name and the port number.
	This information is saved in the file ClientConfig.xml in the target install folder and can be changed afterwards using the CoPlanner Excel Client by users who have write privileges.		This information is saved in the file [[Technics:CoPlanner_Win-Client#ClientConfig.xml\|ClientConfig.xml]] in the target install folder and can be changed afterwards using the CoPlanner Excel Client by users who have write privileges.
	\|}		\|}
	<br> <br>		<br> <br>

Admin at 11:40, 6 May 2010

2010-05-06T11:40:06Z

Admin at 11:36, 6 May 2010

2010-05-06T11:36:55Z

← Older revision		Revision as of 13:36, 6 May 2010
Line 23:		Line 23:
	==Installation steps==		==Installation steps==

	CoPlanner 9.0 and older versions: Start the installation procedure by running setup.exe.		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.		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.

Line 69:		Line 70:

	==Installing Excel Client for more than one user ==		==Installing Excel Client for more than one user ==

			===CoPlanner 9.0 and older versions===

	To install the Excel Client for a user who does not have local administrator rights, the Excel Client must first be installed on the machine by a user who has administrator rights on the computer.		To install the Excel Client for a user who does not have local administrator rights, the Excel Client must first be installed on the machine by a user who has administrator rights on the computer.
	As the necessary registrations are performed during installation by the administrator, the user for whom the Excel Client will be made available must start the installation process by running the file CopAddinSetup.msi.		As the necessary registrations are performed during installation by the administrator, the user for whom the Excel Client will be made available must start the installation process by running the file CopAddinSetup.msi.

	The installation steps are the same as those described in ~~section 3.1,~~ Installation steps. After completing the installation procedure, the user will be able to access the CoPlanner Excel Client.		The installation steps are the same as those described in [[Excel_Client:Installation#Installation_steps\|installation steps]]. After completing the installation procedure, the user will be able to access the CoPlanner Excel Client.

			===CoPlanner 9.1 and higher===

			The CoPlanner Excel Add-In is automatically made available for all users when it is installed by running install.bat.

			{\| {{Bausteindesign1}}
			\|-
			\| <span style="color: darkblue;">'''Hint'''</span>  After installation, the CoPlanner Excel Add-In may not be immediately visible, as it will not be activated for the current user until MS Excel is started. If you cannot see the add-in, please close and restart MS Excel to display the new menu item.
			\|}


			==Extended configuration==

	~~== Erweiterte Konfiguration ==~~		EThe file Cop.AddIn.dll.config, which is included in all versions 2007-11-20 and higher, offers extended configuration options. This file is placed in the target install directory during setup. The structure of the file corresponds to that of an App.exe.config file.

	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 extended configuration options are available:

	~~Folgende erweiterte Einstellungen können vorgenommen werden:~~

	*<add key="logonProperties.showPlan" value="True"/> <br>Planauswahl beim Logon anzeigen/ausblenden<br>		*<add key="logonProperties.showPlan" value="True"/> <br>Planauswahl beim Logon anzeigen/ausblenden<br>

Admin at 11:34, 6 May 2010

2010-05-06T11:34:14Z

← Older revision		Revision as of 13:34, 6 May 2010
Line 42:		Line 42:
	\|-		\|-
	\|[[Image:Excel setup 1.jpg\|thumb\|left]]		\|[[Image:Excel setup 1.jpg\|thumb\|left]]
	\|~~The following dialogue reports~~ the ~~status of the .Net Framework Component installation procedure.~~		\|Click on the “Install” button to install the required components on your computer.
	~~After~~ the components ~~have been successfully installed, CoPlanner Excel Client setup will be started~~.
	\|-		\|-
	\|[[Image:Excel setup 2.jpg\|thumb\|left]]		\|[[Image:Excel setup 2.jpg\|thumb\|left]]
	\|~~Nachfolgender Dialog gibt über den Status der~~ .Net Framework~~-Komponenten Installation Auskunft~~. ~~Nach Beendigung der Komponenteninstallation folgt die eigentliche~~ CoPlanner Excel Client ~~Installation~~.		\|The following dialogue reports the status of the .Net Framework Component installation procedure. After the components have been successfully installed, CoPlanner Excel Client setup will be started.
	\|-		\|-
	\|[[Image:Excel setup 3.jpg\|thumb\|left]]		\|[[Image:Excel setup 3.jpg\|thumb\|left]]
Line 52:		Line 51:
	\|-		\|-
	\|[[Image:Excel setup 4.jpg\|thumb\|left]]		\|[[Image:Excel setup 4.jpg\|thumb\|left]]
	\|~~Klicken Sie auf Next, um mit der~~ Installation ~~fortzufahren~~.		\|Installation notes. Click the “Next >” button to continue installing the CoPlanner Excel Client.
	\|-		\|-
	\|[[Image:Excel setup 5.jpg\|thumb\|left]]		\|[[Image:Excel setup 5.jpg\|thumb\|left]]
	\|~~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~~.		\|In this dialogue you can specify the folder to which you want to install the CoPlanner Add-In. Select the desired installation folder, then click the “Next >” button to continue installing the CoPlanner Excel Client.
	\|-		\|-
	\|[[Image:Excel setup 6.jpg\|thumb\|left]]		\|[[Image:Excel setup 6.jpg\|thumb\|left]]
	\|~~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~~.		\|Your install settings are now complete. The dialogue shows that Setup is now ready to install the Add-In. Click the “Next >” button to continue the installation procedure.
	\|-		\|-
	\|[[Image:Excel setup 7.jpg\|thumb\|left]]		\|[[Image:Excel setup 7.jpg\|thumb\|left]]
	\|~~Übersicht über den Status der Installation~~.		\|Overview of the status of the install procedure.
	\|-		\|-
	\|[[Image:Excel setup 8.jpg\|thumb\|left]]		\|[[Image:Excel setup 8.jpg\|thumb\|left]]
	\|~~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~~.		\|In the next screen, you will be asked for the server name and the port number.
			This information is saved in the file ClientConfig.xml in the target install folder and can be changed afterwards using the CoPlanner Excel Client by users who have write privileges.
	\|}		\|}
	<br> <br>		<br> <br>

	== Excel Client ~~für mehrere Benutzer installieren~~ ==		==Installing Excel Client for more than one user ==

	~~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~~.		To install the Excel Client for a user who does not have local administrator rights, the Excel Client must first be installed on the machine by a user who has administrator rights on the computer.
			As the necessary registrations are performed during installation by the administrator, the user for whom the Excel Client will be made available must start the installation process by running the file CopAddinSetup.msi.

	~~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.~~		The installation steps are the same as those described in section 3.1, Installation steps. After completing the installation procedure, the user will be able to access the CoPlanner Excel Client.

	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~~.

	== Erweiterte Konfiguration ==		== Erweiterte Konfiguration ==

← Older revision		Revision as of 13:40, 6 May 2010
Line 95:		Line 95:


	*<add key="logonProperties.showPlan" value="True"/> <br>~~Planauswahl beim Logon anzeigen~~/~~ausblenden~~<br>		*<add key="logonProperties.showPlan" value="True"/> <br>Show/hide Select Plan dialogue at login time<br>
	*<add key="logonProperties.showLanguages" value="True"/><br>~~Sprachauswahl beim Logon anzeigen~~/~~ausblenden~~<br>		*<add key="logonProperties.showLanguages" value="True"/><br>Show/hide Select Language dialogue at login time<br>
	*<add key="logonProperties.showUnternehmen" value="True"/><br>~~Unternehmensauswahl beim Logon anzeigen~~/~~ausblenden~~<br>		*<add key="logonProperties.showUnternehmen" value="True"/><br>Show/hide Select Company dialogue at login time <br>
	*<add key="layoutProperties.Filtercolor" value="C9D2EA"/><br>~~Farbe der~~ Filter<br>		*<add key="layoutProperties.Filtercolor" value="C9D2EA"/><br>Filter colours <br>
	*<add key="layoutProperties.FilterMainColor" value="F0EEE1"/><br>~~Hauptfarbe der Filter~~<br>		*<add key="layoutProperties.FilterMainColor" value="F0EEE1"/><br>Main filter colour <br>
	*<add key="layoutProperties.SpaceBewtweenFilter" value="4"/><br>~~Abstand zwischen den einzelnen Filter~~<br>		*<add key="layoutProperties.SpaceBewtweenFilter" value="4"/><br>Distance between individual filters <br>
	*<add key="compatibility.PreventCustomMouseCursorVisualisation" value="False"/><br>~~Erweiterte Mouse Cursor bei Drag~~&~~amp;Drop aktivieren/deaktivieren~~<br>		*<add key="compatibility.PreventCustomMouseCursorVisualisation" value="False"/><br>Activate/deactivate extended mouse cursor on drag & drop <br>
	*<add key="SSPITimeOut" value="180"/><br>~~Clienttimeout bei SSPI Logon~~ (in ~~Sekunden~~)<br>		*<add key="SSPITimeOut" value="180"/><br>Client timeout (in seconds) at SSPI login <br>
	*<add key="CommandTimeOut" value="0"/><br>~~Commandtimeout bei Datenanforderungen~~ in ~~Sekunden~~. 0 ~~bedeutet kein Timeout bei Anforderungen~~.<br>		*<add key="CommandTimeOut" value="0"/><br>Command timeout (in seconds) for data requests. 0 means no timeout for data requests.<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.RefreshDataAfterFilterChangeSelectable" value="true"/><br><!-- “Filter changes – load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well! --><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>		*<add key="MatrixBuilder.RefreshDataAfterFilterChangeSelection" value="true"/><br><!-- “Filter changes - load data immediately” can be activated by means of a check box in the matrix builder. Note: Used only if activated in host interface as well! This setting determines the default value and is used only if Analyzer.RefreshDataAfterFilterChangeSelectable ==true --><br>

	~~Häufig gestellte Fragen zur Installation finden Sie in den [[Excel_Client:FAQs\|FAQs]].~~


	__NOEDITSECTION__		__NOEDITSECTION__
	[[category:Excel_Client\|Installation]]		[[category:Excel_Client\|Installation]]
			[[de:Excel_Client:Installation]]