Install WorkZone for Office server

Install manually

  1. Double-click the KMD WorkZone Office Server.msi file. The Open file – Security Warning dialog box is displayed.
  2. Click Run. The KMD WorkZone Office Server Setup wizard is displayed.
  3. Click Next. The End-User License Agreement page is displayed. Read the terms and conditions and select the I accept the terms in the License Agreement check box.
  4. Click Next. The Choose Setup Type page is displayed.

  5. Click Typical. The Ready to install KMD WorkZone Office Server page is displayed.
  6. Click Install. After installation, the Completed Setup Wizard page is displayed.
  7. Click Finish.

Important: After you install WorkZone for Office server, you must update the database manually via dbconnect.exe.

Update the database

The Office Server installer installs all configuration files and tools into the file system under C:\Program Files (x86)\KMD\WorkZone\Modules\Office.

When you have completed the installation, you can load the configuration into the database via the dbconnect.exe command line tool. It is located in the Office folder.

dbconnect.exe is a command line tool which enables you to load and unload database configuration files, SQL scripts, and XAMLs (dialog boxes).

This tool has the following options:

  • /dbdsn=<dsn> – The name of the database to be updated (required).
  • /dbuser=<user> – The name of the database user (required).
  • /dbpassword=<password> – The password of the database user.
  • /serveruri=<protocol>://<hostname> – Protocol and hostname for the oData service.
  • /u – Unloads installed data from the database (optional).
  • /log=<path> – Writes log to the file at the specified address (optional).

Example:

c:\Program Files (x86)\KMD\WorkZone\Modules\Office\dbconnect.exe /dbdsn=demo /dbuser=sjsysadm /dbpassword=xyzz /serveruri=https://demo.captialive.com /u

The copy image is missing

Important:

  • Restart IIS (Internet Information Services) for the configuration changes to take effect on the server.
  • dbconnect.exe updates only one database at a time. If you want to update multiple databases, run it several times with a different /dbdsn option.

Upgrade the WorkZone for Office server

Prerequisite: Before you upgrade the WorkZone for Office server, it is recommended you remove from the database the data installed as a part of the current installation.

  1. Run dbconnect.exe with the /u option to remove previously installed data from the database.
  2. Uninstall the old WorkZone for Office server package from Programs and Features.
  3. Install the new WorkZone for Office server package.
  4. Run dbconnect.exe without the /u option to update the database.

Update the database

The Office Server installer installs all configuration files and tools into the file system under C:\Program Files (x86)\KMD\WorkZone\Modules\Office.

When you have completed the installation, you can load the configuration into the database via the dbconnect.exe command line tool. It is located in the Office folder.

dbconnect.exe is a command line tool which enables you to load and unload database configuration files, SQL scripts, and XAMLs (dialog boxes).

This tool has the following options:

  • /dbdsn=<dsn> – The name of the database to be updated (required).
  • /dbuser=<user> – The name of the database user (required).
  • /dbpassword=<password> – The password of the database user.
  • /serveruri=<protocol>://<hostname> – Protocol and hostname for the oData service.
  • /u – Unloads installed data from the database (optional).
  • /log=<path> – Writes log to the file at the specified address (optional).

Example:

c:\Program Files (x86)\KMD\WorkZone\Modules\Office\dbconnect.exe /dbdsn=demo /dbuser=sjsysadm /dbpassword=xyzz /serveruri=https://demo.captialive.com /u

Important:

  • dbconnect.exe updates only one database at a time. If you want to update multiple databases, run it several times with a different /dbdsn option.
  • Restart IIS (Internet Information Services) for the configuration changes to take effect on the server.

Repair

You can restore damaged installation files by repairing the installation. Right-click the .msi file, and then select Repair, or go to Programs and Features, and select Repair.