Technics:CoPlanner Win-Client

From CoPlanner 10
Jump to navigationJump to search

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>



<?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: 

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

<Area 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 und national character set. You find a list about available languages in the PowerUser-Handbook.

coplanner.exe.config Datei

This file contains generally User settings. It is located in execution directory of the Client.

  • <add key="logonProperties.showPlan" value="True"/>

Block plans at logon, if there is „False“

  • <add key="logonProperties.showCorporation" value="True"/>

Block corporations at logon, if there is „False“

  • <add key="logonProperties.showCurrency" value="True"/>

Block currency at logon, if there is „False“

  • <add key="logonProperties.showLanguages" value="True"/>

Block language selection at logon, if there is „False“

  • <add key="layoutProperties.additionalHeightMeasureLine" value="10"/>

Additional height of measure line (Agg and mask of line (incl. Copspy++)) - pixel, which are added additionally to line wideness of actual font

  • <add key="layoutProperties.additionalSpaceBeneathFilter" value="6"/>

Space filter area (Agg mask and line mask)

  • <add key="layoutProperties.additionalHeightHorizDimensionline" value="18"/>

Additional height of horizontal dimension line – pixel, which are added additionally to line wideness of actual font

  • <add key="layoutProperties.MeasureLineTextColor" value="5B5B9A"/>

Color for text of measure line

  • <add key="layoutProperties.MeasureLineHighLightTextColor" value="ffffff"/>

Color for selection of measure line and chosen dimension

  • <add key="layoutProperties.MeasureLineHighLightBackColor" value="9CB1D8"/>

Color for selection of measure line and chosen dimension

  • <add key="layoutProperties.MeasureLineBackColor" value="DFE4F2"/>

Color for background of measure line

  • <add key="layoutProperties.HighlightColorBack" value="C9D2EA"/>

Color for selection of background

  • <add key="layoutProperties.HighlightColorFore" value="000000"/>

Color for selection of foreground

  • <add key="layoutProperties.SwitchOffMoreLineMarkingInHorizDims" value="False"/>

NYI switch off selection in horizontal dimension

  • <add key="layoutProperties.Filtercolor" value="C9D2EA"/>

Color of filters

  • <add key="layoutProperties.FilterMainColor" value="F0EEE1"/>

Main color of filters

  • <add key="layoutProperties.SpaceBewtweenFilter" value="4"/>

Color of filters

  • <add key="layoutProperties.PermitIsolationInAggMask" value="True"/>

Switch off function of isolation with a left mouse click in Aggmask

  • <add key="layoutProperties.PermitHideInAggMask" value="True"/>

Switch off hide-function with a right mouse click in Aggmask

  • <add key="logonProperties.showWaitWindow" value="False"/>

To display "please wait" window at the Client start

  • <add key="CommandTimeOut" value="0"/>

Datarequest TimeOut for SerialObjects (MB/Excel) in seconds. Default is 0and means no TimeOut.

  • <add key="MatrixBuilder.RefreshDataAfterFilterChangeSelectable" value="true"/>

Activate checkbox "filterchenge – reload data instantly" Attention: ALSO Hostinterface needs tob e activated!

  • <add key="MatrixBuilder.RefreshDataAfterFilterChangeSelection" value="true"/>

Activate "filterchenge – reload data instantly" Attention: ALSO Hostinterface needs tob e activated! Defaultvalue only available if: MatrixBuilder.RefreshDataAfterFilterChangeSelectable == true


Qualifications

At successful logon to CoPlanner-Server a XML-file is set up in Client-directory, which contains settings. At next logon these settings are proposed. The user requires rights of writing in the Client-directory in order that this is possible.

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

Required files/folders

Requirements:

  • .Net Framework 2.0 has to be installed on computer of the Client. This means, that the computer requires .Net Framework on which CoPlanner Client should be installed via ClickOnce!
  • Local administrator rights are essential for the installation of .Net Framework!!!

A deployment packet consists of the following files:

  • Setup.exe
  • copstart_versionnumber.console
  • coplanner.htm
  • Copstart.console

A deployment packet contains the following directories:

  • coplanner_versionnumber
  • Client

All files or directories are Microsoft standard directories except for Client-Directory. The Client-Directory is CoPlanner specific. It contains customized files, which are downloaded after the Client-Installation, if CoPlanner is started.

Hint  Client-Directory MUST contain in deployment packet.

The following files have to exist in Client-Directory:

  • Attention - Version.txt is not allowed to set up manually on the Server, but with the tool CreateVersionAndChecksum.exe, which you only have to click doubly in data system of web folder.
  • Version.txt It contains a version number, which is checked at each start of the Client. At first start of the Client this file does still not exist. This means that at first start files are always downloaded. If you change after that something (ClientConfig.xml change of port), which should be allocated on all Clients, this number has to be increased. Thus files are updated automatically at next start of the Client.

Files in the Client-Directory have to have the same folder structure as in the Windows-Client. Would you like to allocate e.g. a customized start.html file, so it has to be located in directory ./Client/html/

Problems in Installation

If an error message appears after starting ClickOnce Setup with the following content (abstract at display of error details),

This can have two known reasons:

  • That user, who would like to carry out ClickOnce-Installation, does not have the right to read required files in that directory, which contains the Client-Setup. If an http-Server provides Deployment, you have to consider that the IIS-User (per default ISUER_[Servername]) has the right of reading on directories at activation of anonymous access. If the integrated NT-Authentication is active and an anonymous access is not allowable, the user, who carries out ClickOnce-Installation, has to have rights of reading on those directories.
  • A ClickOnce-Installation has been already carried out, but from another directory/Server. Although the previous version was correctly deinstalled about software overview of the system, directories in the NT-User-directory remain.

By this installation is interrupted due to errors.This problem can be solved in the following way: Directory C:\documents and settings\[NT-Username] \Local properties\Apps\2.0 contains those program files, which were installed via ClickOnce. To be able to find these directories, the option „Show hidden files and folders“ has to be activated in the windows explorer (Click on “Tools” [[Image:arrow.jpg]“Folder Option”). There are sub directories in this folder, which contains the ClickOnce program components as already mentioned. Therefore all sub folders of folder „C:\Dokumente und Einstellungen\[NT-Benutername] \Lokale Einstellungen\Apps\2.0\“ have to be deleted. After that you can start ClickOnce-Installation from the new Deploy Server/Directory again.

Problem with copstart.exe.manifest

If you start the installation, it is possible that a 404 – „Folder not found“ – error message can appear.

The following MIME-Type has to be defined (details look properties IIS):

Error creating thumbnail: File missing
Technik, MIME - Typ

Properties IIS

If Deployment is provided via HTTP, you need therefore an IIS (Internet Information Server). Directory of Deployment has to be defined as „Standardwebsite“.

Error creating thumbnail: File missing
Technik, Einstellungen IIS

Webapplication Settings

The following properties are necessary to enable access to a Client:

  • Therefore click “Start” “Administrative Tools” “Internet Information Services (IIS) Manager”
  • Click on “local computer”, “websites” and then with the right mouse button on “a website” and choose “properties”, so you can have a look at the following windows:

To ScreenShot on the bottom right: remove .config from the list.

MIME Types im IIS

It can occur that not all files are copied onto the Client-computer at Deployment via IIS. In this case MIME Types have to be defined for appropriate files.

For definition of MIME Types please do it in the following way:

1. Open IIS Management Console
2. Right click on computer name and choose settings
3. Click on MIME Types


Error creating thumbnail: File missing
Technik, Eigenschaften von WAWISNEU1
4. Click on New
Error creating thumbnail: File missing
Technik, MIME - Typ

Definition: MIME Types should be defined for following extensions:

  • .config
  • .lic
  • .dat
  • .scc
  • .rdl
  • .rptproj
  • .suo

Definition: MIME Type „application/x-ms-manifest“:

  • .manifest

Type is here „application/x-ms-manifest.

An IIS Reset should be carried out after MIME Types are entered in. At the same time Webservice is restarted. For the new start you have to enter iisreset in command line.


Additional IIS 7 Settings

The „Frontpage Server extensions“ need tob e installed on the Server.

Additionaly the following entries in the file: %windir%\System32\inetsrv\config\applicationHost.config need tob e adapted:

  • <section name="customMetadata" allowDefinition="AppHostOnly" overrideModeDefault="Allow" />
  • <add fileExtension=".config" allowed="true" />
  • <section name="directoryBrowse" overrideModeDefault="Allow" />

The root directory of the Click Once Deployment should contain a „web.config“ file with the following content:

File:T Codesnip7.jpg

Generally “hidden files” and “files with umlauts” cannot be transferred.

.config oder exe… Dateien werden nicht übertragen

Nach einem Rechtsklick auf das IIS Projekt auf Eigenschaften gehen und in der Konfiguration die Extension „.config“ entfernen. Dies kann auch für die anderen Dateien gemacht werden die nicht übertragen werden.

Error creating thumbnail: File missing

Properties Share

For Deployment via Share you have to consider that the user has reading rights on Share.

Properties Internet Explorer

It can happen that Internet Explorer can not download all files. In this case there is an error message in log file of Webserver: Copstart.console' was not be able to be downloaded. This problem is connected with properties of local Internet Explorer: You find properties to this under: Tools -> Internet Options -> Security (local Intranet) -> Custom level -> User-Authentication. The field „Prompt for user name and password“ has to be activated:

Error creating thumbnail: File missing

Optional Debugmode (since 2007-07-02)

There can be a lot of reasons, that diverse files are not transferred from Webserver to the Client. For this case an optional Debug-Informationwindow was implemented. It is not allowed to increase manually the Serverversion, but about command line CreateVersionAndChecksum.exe, which has to be clicked doubly in directory of Webserver (data system!).

That's how it goes then:

Error creating thumbnail: File missing
Technik, Optionaler Debugmode

This tool writes all files of Server and its size in folder Version.txt, which is transferred from CopRun at installation to Client. With this list the installation program checks availability and right size of each file of Server. If any files are not transferred successfully, a window appears and offers to enable the Debugmode. That's how it can go:

Error creating thumbnail: File missing
Technik, FFClickOnce

(Please note, that it is possible with both Add- on „FFClickOnce“ and Firefox-browser to carry out ClickOnce-Installations). The window offers the possibility to reset version number, so you can start the next attempt (e.g. after new configuration of IIS). It is not necessary to edit manually file Version.txt on Client due to version is set to 0 from installation program. Consequently, the whole transmission procedure is started again, if you click „Install“ on the website or at Performing by Start/Program Folders/CoPlanner Client. If errors are indifferent, you can choose „Ignore und close“ (so you can hope that the Client will work even so).

You also can activate Debugmode by checking the checkbox. In this case you have to reset the version number (otherwise Debugmode does not make sense). It is done in this Walkthrough and the version number is reset. With anew click on „Install“ on the website, the following window appears:

Error creating thumbnail: File missing
Technik, Debugmode

After clicking on „start Install “, it is started and information are written subsequently for transmission. You can have a look (at this example), why some files were not transferred and on this way you probably get on to the problem. If all problems are solved, you can switch off the Debugmode and continue your work.

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:

Error creating thumbnail: File missing
Technik, Event Properties

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

Error creating thumbnail: File missing
Error creating thumbnail: File missing
Technik, Sicherungsziel auswählens

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

Error creating thumbnail: File missing
Technik, Sichern einer Datenbank im Management Studio
Error creating thumbnail: File missing
Technik, Sichern einer Datenbank im Management Studio, Sicherungsziel auswählen

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

Error creating thumbnail: File missing
Technik, Sichern einer Datenbank im CoPlanner
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“.

Error creating thumbnail: File missing
Technik, Sichern einer OLAP Datenbank

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

Error creating thumbnail: File missing
Technik, SQL Server 2005

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:

Error creating thumbnail: File missing

Analysis Services:

Error creating thumbnail: File missing


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

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Technics:CoPlanner_Win-Client&oldid=10583"