Technics:CoPlanner Win-Client: Difference between revisions
No edit summary |
No edit summary |
||
| Line 192: | Line 192: | ||
==Installation of Windows-Client by ClickOnce== | ==Installation of Windows-Client by ClickOnce== | ||
It's possible to intall the CoPlanner Client by [[Technics:CoPlanner_Win-Client_Installation_by_ClickOnce|ClickOnce]] via Webserver (Microsoft Internet Information Services) or via deploying the required files. The big advantage of the ClickOnce installation is that after you have installed it once, changes can be rolled out automatically to the other clients. Principally deploying the required files is much easier because no webserver has to be configured. | |||
Revision as of 11:14, 26 January 2015
As soon as Client directory was copied onto the computer, which should act as Win-Client, the Client is installed. You only have to adopt file ClientConfig.xml onto your system. This file is located in execution-directory of the Client.
ClientConfig.xml
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ClientConfig>
<IpSettings>
<Version>1</Version>
<Server>localhost</Server>
<Port>8963</Port>
<MaxRows>100000</MaxRows>
<MaxCells>0</MaxCells>
<TcpFormatter>Bin</TcpFormatter>
</IpSettings>
<Languages>
<Available>Deutsch|English</Available>
</Languages>
</ClientConfig>
or
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ClientConfig>
<IpSettings>
<Version>1</Version>
<Server>localhost</Server>
<Port>8963</Port>
<MaxRows>20000</MaxRows>
<MaxCells>200</MaxCells>
<TcpFormatter>Text</TcpFormatter>
</IpSettings>
<Languages>
<Available>Deutsch|English</Available>
</Languages>
</ClientConfig>
The following points have to be adopted:
| Inscription | Description |
| Server | Computer name, on which CoPlanner Server was installed. |
| Port | Portnumber of CoPlanner Server. Please fill in the same portnumber, which was filled in SvrConfig.xml as well. |
| MaxRows | This is the number of data sets, which the Server can receive maximally. Files should stand in relation to capacity of Client's computers.
If the maximal determined number of data sets exceeds at loading of data sets in an input mask, the loading process will be interrupted and you get a message with the special request to reduce the quantity of files with the aid of filters. |
| MaxCells (ab 20080807) | This is the number of cells, which the Server can receive maximally via Matrix Builder. If this tag isn't available or 0, there is no limitation. |
| TcpFormatter | It determines the mode of transmission between client and server. It is possible to choose between „Bin“ for binary transmission and „Text“ for text transmission. The chosen mode has to be adjusted both on server and on client (ClientConfig.xml) and both have to come to an agreement. |
| Languages Available | Those languages, which are indicated, are available as Logon language, so long as they are supported by CoPlanner Server. The description of language should be entered in national language and national character set. You find a list about available languages here. |
coplanner.exe.config File
This file contains generally User settings. It is located in execution directory of the Client.
| Inscription | Description |
| logonProperties.showPlan | Block plans at logon, if there is „False“ |
| logonProperties.showUnternehmen | Block corporations at logon, if there is „False“ |
| logonProperties.showWaehrung | Block currency at logon, if there is „False“ |
| logonProperties.showLanguages | Block language selection at logon, if there is „False“ |
| logonProperties.additionalHeightMeasureLine | Additional height of measure line (Agg mask and mask of line (incl. Copspy++)) - in pixel, which are added additionally to line wideness of actual font |
| logonProperties.additionalSpaceBeneathFilter | Space filter area (Agg mask and line mask) |
| logonProperties.additionalHeightHorizDimensionline | Additional height of horizontal dimension line – pixel, which are added additionally to line wideness of actual font |
| logonProperties.MeasureLineHighLightTextColor | Color for selection of measure line and chosen dimension |
| logonProperties.MeasureLineHighLightBackColor | Color for selection of measure line and chosen dimension |
| logonProperties.HighlightColorBack | Color for selection of background |
| logonProperties.HighlightColorFore | Color for selection of foreground |
| logonProperties.SwitchOffMoreLineMarkingInHorizDims | NYI switch off selection in horizontal dimension |
| logonProperties.Filtercolor | Color of filters |
| logonProperties.FilterMainColor | Main color of filters |
| logonProperties.SpaceBewtweenFilter | Space bewtween filters |
| logonProperties.PermitIsolationInAggMask | Switch off function of isolation with a left mouse click in Aggmask |
| logonProperties.PermitHideInAggMask | Switch off hide-function with a right mouse click in Aggmask |
| logonProperties.showWaitWindow | To display "please wait" window at the Client start |
| CommandTimeOut | Datarequest TimeOut for SerialObjects (MB/Excel) in seconds. Default is 0and means no TimeOut. |
| UsedDevXStyle | Style to be used in CoPLanner. |
| PlanAdministrationShowExtendedTimeSettings | Defines whether day and several year planning settings will be shown in scenario manager. |
| PlanAdministrationTaskAndSecurityAvailable | Defines whether task settings will be shown in scenario manager. |
| SupportMailUrl | Url of support e-mail in CoPlanner menu. |
| HelpWebSiteUrl | Url of online help in CoPlanner menu. |
| MatrixBuildInitialMeasureCount | Number of measure initial shown in CoPlanner Analyzer. |
| MatrixBuilderShowDimNames | Defines whether dimension names will be shown in CoPlanner Analyzer if there are only empty rows. |
| MatrixBuilderMaxDimCountPerAxis | Defines the default value for maximum number of dimensions on axis. This value can be overwritten in each mask. |
| MatrixBuilder.RefreshDataAfterFilterChangeSelectable | Activate checkbox "filterchenge – reload data instantly" Attention: ALSO Hostinterface needs tob e activated! |
| MatrixBuilder.RefreshDataAfterFilterChangeSelection | Activate "filterchenge – reload data instantly" Attention: ALSO Hostinterface needs tob e activated! Defaultvalue only available if: MatrixBuilder.RefreshDataAfterFilterChangeSelectable == true |
| reportViewer.ParameterPromptMode | Defines the layout of parameters in CoPlanner ReportViewer.
|
| DisableMainFormOnWaitWindow | Defines whether mainform is locked if the waitwindow is shown. |
| LoopUpSearchOnKeyDown | Defines whether search will be shown after entering a key on a lookup. |
| ShowWaitWindow | Defines whether a waitwindow will be shown. |
| ExpertMode | Defines whether objects will be checked out immediately in design mode. |
| LogonForeColor | Defines the font color of the login dialogue. |
| UppercaseConversion | Defines the uppercase conversion in the ribbon. |
Qualifications
At successful logon to CoPlanner Server a XML-file is set up in User-directory, which contains settings. At next logon these settings are proposed.
The directory „pdf“ serves as temporary storage for CoPlanner Reporting. Reviews are saved temporary in it. For this reason the user requires rights of writing in this directory to be able to apply CoPlanner Reporting
Installation of Windows-Client by ClickOnce
It's possible to intall the CoPlanner Client by ClickOnce via Webserver (Microsoft Internet Information Services) or via deploying the required files. The big advantage of the ClickOnce installation is that after you have installed it once, changes can be rolled out automatically to the other clients. Principally deploying the required files is much easier because no webserver has to be configured.
Virus scanner, Firewalls, etc……
Virus scanner, Firewalls and diverse other tools can affect attitude of CoPlanner. Generally folder of installation of CoPlanner should be excluded in a virus scanner. Firewalls have to be configured that they are not able to affect transmission of CoPlanner.
For an accurate action of system please check at regular intervals the eventlog, because CoPlanner writes error messages in the event log as well.
Example of an error message because of a virus scanner:
Save a relational Database
It is recommended to save databases at regular intervals. You can save a database from the SQL-Server or from CoPlanner.
Save a database in Enterprise Manager (SQL-Server 2000)
Click with the right mouse button on that database, which you want to save. As below displayed choose under „All Tasks“ the command „Backup Database“.
The above displayed windows offer you the choice, where the database should be saved. To restore such a saved database, please look under Restoring the relational database
Save a database in Management Studio (SQL-Server 2005)
Click with the right mouse button on that database, which you want to save. As below displayed choose under „Tasks“ the command „Back Up“.
These windows offer you the choice, where the database should be saved. After clicking on “Add” you get the window “Select Backup Destination”.
To restore such a saved database, please look under Restoring the relational database
Save a database from CoPlanner
Choose simply „Developer“ and „Backup “.
| Hint A backup is established instantly. This file is located in backup directory of SQL-Server (Standard: C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP). The indication for this file is COP_SYS_date time.bak (e.g.: COP_SYS_20.04.2004 12.59.36.back). |
To restore such a saved database, please look under Technics:Databases
Save an OLAP Database
SQL-Server 2000
You can save an OLAP-Database in Analysis Manager by clicking on database with the right mouse button and then choose the command „Archive Database“.
Then choose a file name and a path and click on „Archive“.
After saving a database you find on this place a file called .CAB. To restore such a saved OLAP-database, please look under Restoring the relational database
SQL-Server 2005
You can save an OLAP-Database in Analysis Manager by clicking on database with the right mouse button and then choose the command „Back Up“.
After clicking on “Browse” you get the window “Save File As”. After saving a database you find on this place a file called .CAB.
To restore such a saved OLAP-database, please look underRestoring the relational database
Examples Connectionstring to Databaseserver
Connection „Mixed Mode“
Server=SQL Server;Initial Catalog=database name;user id=User in the SQL Server; password=Password of user
Examples:
- User sa does not have any password
- Server=workstation1;Initial Catalog=COP_SYS;user id=sa; password=
- User sa with password
- Server=workstation1;Initial Catalog=COP_SYS;user id=sa; password=mypwd
Connection „NT Security“
Server= SQL Server;Initial Catalog=database name;Integrated Security=SSPI
Example:
- Server= workstation1;Initial Catalog=COP_SYS;Integrated Security=SSPI
Service Pack Information SQL- and Analysis-Server
Analysis Manager: Hilfe – Info SQL Server: select @@version
SQL-Server:
Analysis Services:
Framework 1.1 Information (SP1)
Install ServicePack 1 for .Net Framework
For .NET Framework a new registration structure was created to simplify search of Service Pack-Level. Start the registration-editor and look for the following keys of registration: Keyname: HKEY_LOCAL_MACHINE\Software\Microsoft\NET Framework Setup\NDP\v1.1.4322
Value: SP
Datatype: REG_DWORD
Files in SP-Value give information on which Service Pack for .NET Framework 1.1 is installed. If the value of SP is e.g. 0, none Service Pack for .NET Framework 1.1 is installed. Is the value, however, 1, Service Pack for .NET Framework 1.1 is installed.
Further Information: http://support.microsoft.com/kb/318785/DE/
Framework 2.0 Informationen
The Coplanner Server and the CoPlanner Client need the same .NET Framework Service Pack. If a Server has installed the SP 2 for the .NET Framework 2.0 all the CoPlanner Clients need to have SP 2 installed.
To remove SP 1 from a Computer all following Service Packs need to be removed
