6 Setting up Travel using C-tree as the local database

Before you start this installation you have to have a standard network SuperOffice 4.02 installation on Microsoft SQL Server up and running. See chapter 2 for further information.

Installing SuperOffice Travel is done in three steps:

  • Prepare SuperOffice to use Travel
  • Install and generate a update prototype
  • Setting up the area file
  • Install SuperOffice Travel on the clients

6.1 Check the sentral database
The table so.travelcurrent in the sentral Microsoft SQL Server database stores information about how Travel should work. By using ISQL/W you should check a column in this table and change it if needed.

  1. Start ISQL/W from a workstation or the NT-Server.
  2. Connect to the SuperOffice database on the SQL Server.
  3. Run this query:
    SELECT databasetype FROM so.travelcurrent
  4. If the result of this query is the value 1 you have to change the value by running this query:
    UPDATE so.travelcurrent SET databasetype = 2
  5. Remember to commit this transaction

6.2 Prepare SuperOffice to use Travel

  1. Log on to SuperOffice as a user with userlevel 0 and select Preferences from the Maintenance. Activate the checkbox "Allow use of SuperOffice Travel". Then press OK to save this option.
  2. Enter the employee dialog by selecting Employees from the Maintenance menu. All users who wants to run Travel must have the Travel checkbox active. Set the checkbox "Travel" active for all users that are going to have permissions to use Travel and click "Save".
  3. For more information on this subject, use the "SuperOffice user guide".

6.3 Setting up the area file

  1. Delete area.db from the SO_ARC\TEMPLATE\TRAVEL folder on your hard disk
  2. Copy SUPEROF4.DA_ from the SO_ARC\DATA folder on your installation CD or disk 2 on the installation disks. Copy the file to the SO_ARC\TEMPLATE\TRAVEL folder on your hard disk.
  3. Decompress SUPEROF4.DA_ to AREA.DAT by using the EXPAND command from folder INSTUTIL on the installation CD or disk 6 on the installation disks.

6.4 Install SuperOffice Travel on the clients.
Now you have to perform the travel installation on every machine that is going to use SuperOffice Travel.

  1. Run setup.exe from the SOWRKSTN directory
  2. Select the SuperOffice Travel button when prompted for type of workstation installation.
  3. Follow the instructions on the screen to finish the travel installation.
  4. Before you start SuperOffice you have to edit the SUPEROF4.INI file in your local program folder. Remove the line which contains this text: "local_datapath=ODBC:SuperOfficeLocal".

The user should always have only one SuperOffice-icon on his computer. On a travel machine make sure that there are only one icon available for the user and that this icon loads superof4.exe from the local harddisk (c:\superoff\superof4.exe).

For more information on installing SuperOffice Travel see "SuperOffice Userguide".