(c) Copyright 1992-2002 Milum Corporation. All rights reserved. Office Tracker and Milum are trademarks belonging to Milum Corporation. All other trademarks mentioned belong to their respective owners. 

This manual, as well as the software described in it, is furnished under license and may be used or copied only in accordance with the terms of such license. The content of this manual is furnished for informational use only, is subject to change without notice, and should not be construed as a commitment by Milum Corporation. Milum Corporation assumes no responsibility or liability for any errors or inaccuracies that may appear in this book.

For defense agencies: Restricted Rights Legend. Use, reproduction, or disclosure is subject to restrictions set forth in subparagraphs (a) through (d) of the commercial Computer Software Restricted Rights clause at 52.227-19 and the limitations set forth in the license agreement for this software. Unpublished rights reserved under the copyright laws of the United States.

First Printing October 1993

Last Printing July 2002

Version 5.0

MILUM Corporation
P.O. Box 5807
Austin, TX 78763
Business: 512-469-2966
Support:  512-469-2967
www.officetracker.com

Trademark Notification
Office Tracker and MILUM are trademarks belonging to Milum Corporation.  All other trademarks or trade names mentioned belong to their respective owners.

Printed in the U.S.A.

Part number: 90002


 

 

Introduction

Welcome to Office Tracker, the ultimate scheduling solution.  Office Tracker is a network group scheduling tool that lets users maintain personal and group calendars, schedule and reserve rooms and other resources, and arrange group events with other Office Tracker users. With Office Tracker, everyone on the network can create and share schedules, keep track of tasks, meetings and projects, and schedule personal and group events - all from one easy-to-use interface.

Office Tracker Server Administration

The Office Tracker Server is the central repository for all client user data. The server is set up on one machine and the client software is installed on several machines, depending on the total number of users in your license agreement. Each client user has the ability to schedule and share schedule information with the other Office Tracker users.

The Office Tracker Server Administrator is the person who controls the Server, adds user names, creates sharing privileges and generally maintains the server machine. This guide covers the Server Administration features of the Office Tracker software.

Note: Running client/server software requires specific expertise. It is necessary to have a person experienced with network management and terms such as "TCP/IP" and "Routers" handling the Office Tracker Server.

This guide should help to get your server and your clients up and running on the Office Tracker system. It covers server operations and gives a basic client overview. Please read over the entire guide before beginning to set up your server. You should also read the Office Tracker Client Guide to familiarize yourself with the client software. Most features in the client software are not covered in this Server Guide to avoid repetition.

HTML Server and Client Guides (Online Guides)

The Office Tracker Server and Client Guides have been included as a set of html documents on your install disks. As the Server Administrator you can allow all of your client users to access the client guide by giving them the URL for your server, along with the secondary /Help directory. For example:

http://yourOTserverIPaddress:8001/Help

You can distribute the “OT Client Guide (html format)” folder to your client users or move it to your internet/intranet server (if applicable) and allow them to access it just as they do other html documents.  Client users can read the guide with any Internet browser capable of viewing frames and graphics such as Netscape 2.0 or Internet Explorer 3.0.

The Office Tracker client software runs on X86 or Pentium-based PCs running Windows 95/98/NT 4.0/2000 Macintosh or Power Macintosh computers with System 8.6 or later.

Once you've installed the Office Tracker Server, you can access the Office Tracker Server Help Guide from your Start/Programs/Office Tracker Server menu, or by pressing the "Help" button in the Office Tracker Server Administration Pages.

Support

Office Tracker comes with free* support for 30 days after the purchase date. Support includes telephone and/or e-mail communication. Visit the milum.com web site for more details. After the 30-day period you will need to purchase one of our continued support packages in order to have access to a support representative.

To order a support package, visit the Milum web site at: www.milum.com or call the Milum order line at 512-469-2966.

When contacting support by phone or e-mail, please be prepared to give your server hardware and software (OS) information and the current version of the Office Tracker software you are using. Fill out the following information so you will have it on hand when you call:

Serial #:_____________________ Server version: _________________

Hardware CPU: ________________ RAM:________________________

Name of person who installed Server software:_____________________________________________________

Note any modifications you made to install:_______________________________________________________

____________________________________________________________

To get support under your support plan agreement, call the Support Line at: 512-469-2967 or send support questions via e-mail to: support@milum.com.

*some limitations and restrictions apply, please contact Milum Corporation for details.

 

Overview

How the Office Tracker Server Works

The Office Tracker Server is the central repository for schedule data. The server software lets you create your Name Lists, set Sharing Privileges for client users, assign e-mail addresses, maintain Log Files of client-user activity, and control general administrative tasks all from a convenient web-based administration system. 

The Office Tracker Server is based on Java and utilizes the JAVAW.exe (Java Runtime Environment). Client users must have the "Office Tracker" client software installed on their individual machines in order to begin scheduling and using calendars. Client users can create schedule views containing the names and sharing privileges created at the Office Tracker Server. Client users can schedule events with one another or schedule events for resources such as conference rooms and equipment. Each time a client user creates an event, the information is sent to the Server and stored in the Server’s database. Client users can work “offline” while disconnected from the Server and when they reconnect their changes are synchronized to the server Office Tracker Server.

The Office Tracker Server is a background or "invisible" application. There are no visible windows when the application is running; however you administer the Office Tracker Server through a web browser via html pages called “Admin” pages. The Admin web pages provide a graphical user interface to view and control all of the administration functions.  The Server performs best when you leave it running. 

How Office Tracker Updates Event Information
Schedules are updated automatically at minimum every 10 minutes or less, depending on the setting in the Server Preferences (default is 10 mins., minimum is 3 mins.). In addition, each time you move to a different day, add a new name to the view or press the F2 key, your schedule will be updated with any new events added since your last update.To reduce the chance of scheduling conflicts in version 3.7.3 or earlier, you should press the F2 key and allow the update to occur before scheduling an event (you will see messaging in the lower right corner of the Office Tracker main window) . You should then use the Find Open Time feature if you are trying to schedule an event into the future.In version 4.0 and later you can use the conflict checking feature to reduce the chance of scheduling conflicts.

Overview of Steps Involved in Setting up Office Tracker

1. Make sure the machine you are using for the Office Tracker Server has a static IP address or you have the Computer Name.

2. Install Office Tracker Server software.

3. The server is set by default to start automatically unless you cancelled this option at the end of the install. If it is not running, start the Office Tracker Server (from the launcher in your Start menu or from the Services Control Panel if it’s installed as a Service under Windows NT , 2000 or XP)

4. Open your web browser to access the Server “Admin” pages by entering : http://yourserverIPaddress:8001

5. Add client user's names and names of resources (rooms, etc.)

6. Install Office Tracker client software on each client machine.

7. Give the Office Tracker Server IP address or MachineName and log on names to client users.

8. Connect client users and instruct them on how to create group schedule views.

Where Schedule Information is Stored
The Office Tracker Server maintains the "master" data files. The Office Tracker client software stores a local data file on each client machine ("otclient.mdb" on Windows "Schedule Data" on the Macintosh). The files automatically synchronize to the Office Tracker Server's files when the client users are connected to the server. This allows clients to work offline and to update the server when they reconnect. For example, if you shut down your server for maintenance, your client users can continue to schedule "offline" and their information will update automatically when the server is available again.

Office Tracker and Shared Files (NOT SUPPORTED)
Office Tracker does not use the “Shared file” concept. Office Tracker is a true client/server system. The client will send its information to the server and other clients will communicate with the server to get updated information from the other clients. This is a powerful structure that can support large numbers of uses simultaneously.Important: Do not attempt to place the .ots files (“views”) created by the Office Tracker client in a shared directory and share them with other users. This can cause undesired results and strange behavior.How Clients Know When They are OfflineThe Office Tracker client software displays a message “Server offline no conflict check” on Windows or a small "disconnected" icon on Macintosh, in the upper right corner of the main Office Tracker window any time the server machine is unavailable. This lets the users know that the schedule information they are viewing may not be completely up to date.

How Clients Know When They are Offline
The Office Tracker client software displays a message "Server offline no conflict check" on Windows or a small "disconnected" icon on Macintosh, in the upper right corner of the main Office Tracker window any time the server machine is unavailable. This lets the users know that the schedule information they are viewing may not be completely up to date.

The Office Tracker Server Administration Pages

The Office Tracker Server Administration pages are html web pages. Since they work in the same way other web site pages work, you can administer the Office Tracker Server from any machine on the Internet provided you have an Internet (web) browser available and you know the correct IP address and password of your Office Tracker Server . Your web browser must support frames, tables and JavaScript. Netscape version 3.0 and Internet Explorer 4.0 or later are the only browsers with full support for Office Tracker at this time.

The section in this guide "Getting Started" describes how to access the Administration Pages. You may decide to leave the main "Admin" page open on your server machine for easy access to the administrative functions. After reading through the installation section and "Getting Started" section you should have a good idea how the Server Administration Pages work.

WebViewer™ Overview

The Office Tracker WebViewer is an option that you may or may not have purchased with your Office Tracker Software License. If you do not have a license to use the WebViewer you can find out how to order it by contacting Milum Corporation at: 512-469-2966 or by sending e-mail to: info@officetracker.com.

The Office Tracker Web Viewer allows client users to view daily, weekly, and monthly calendars in their web browser. Users on the road can log onto the calendar from any internet connection. Web-based server administration is also accessible from any point on the Internet. The Office Tracker Server with the Web Viewer option can be set up to control which schedules have web access, and how often the web schedules are updated (from every 15 minutes. to 12 hours.).

Schedule information is always stored locally on your server machine, whether or not you are using the WebViewer option. Sometimes users are confused by this and think that because they can access information via the web, that it is in some way "public" information. This is not the case. You control which schedules are available through the web and you also control who has access (via a Name and Password) to view them.

 

Installation

Office Tracker System Requirements

The Office Tracker Server requires the following:

Server Requirements (Minimum)

• Pentium III or better
• 128 MB RAM minimum – 256 or higher recommended
• 128 MB of available disk space
• Windows NT 4.0 /2000 or XP Note: Windows 98 will work but is not recommended as a “server class” operating system
• TCP/IP Network Support
• A static IP address on the Office Tracker Server machine (Computer Name can be used in Windows only environments over a LAN)
• Internet Explorer 4.0 or later or compatible

WebViewer Requirements

• Windows NT, 2000 or XP
• Memory and disk space requirements may be considerably higher than the above defaults, depending on the number of names and the number of events you schedule 

Office Tracker Windows Client Requirements

• 486 or greater PC recommended
• 16MB RAM (32 MB or higher recommended)
• 16MB of available hard disk space
• Windows 98/2000/XP or NT 4.0 or greater client 
• TCP/IP Network Support  

Office Tracker Macintosh Client Requirements

• Macintosh with System 8.6 or greater 
• 8 MB RAM (32 MB recommended)
• 8MB of available hard disk space
• OpenTransport Version 1.1.1 or later

Installing the Office Tracker Server

Installing on Windows 98

Installation Notes
It is recommended you accept the default settings when you are installing the Office Tracker Server. The Office Tracker Server may be installed on any local drive you choose.

If you are performing an upgrade please see the section “Upgrading the Office Tracker Server” later in this guide.

To install, follow the steps below.

Step 1.  Insert the Office Tracker CD-ROM and open it from your CD ROM drive (Open "My Computer" then double-click the “Tracker” CD-ROM icon). Double-click the “Tracker” folder then the “Server” folder. 

Step 2. Locate the “Otserver.exe” and double-click it to install the Office Tracker Server components.

Step 3. Moving through install screens.

1. When the installer launches you will see the Welcome screen. Click the “Next” button to move to the next screen which is the License Agreement. After reading and agreeing to the license, click “next” to move to the next step of the installation process.

2. You will be prompted to choose the folder and drive for the Office Tracker Server directory “OTServer.” It is recommended you leave this with the default setting unless you have a need to install to a different drive location. The default location is: “C:/Program Files/OTServer”

3. Continue clicking the “Next” button on each screen to complete the install. Before the Java components are installed you will need to accept the IBM license agreement by reading it and clicking the “Yes” button.

4. After the IBM Java Installer completes you will be taken back to the Office Tracker Install to finish the installation process.

5. A DOS window will open and at the bottom of the text window the message “Press any key to continue” Will display.

Press a key on your keyboard to continue. If you’re running Windows 98 you’ll need to click the close box to close this window.

6. The last screen in the installer will have two options (checked “on” by default). One is to automatically start the Office Tracker Server and the other is to open the Admin page.

It is recommended that you leave both “on” and click the Finish button to complete the installation.

The following items will be installed on your drive:

“OTServer” directory 

"Server Quick Start”

“Office Tracker Server” - shortcut installed in your Start menu

“JavaSoft” folder installed in your Program Files directory (contains the JAVAW)

Step 4.  Locate your server IP address or Machine Name and make a note of it.

Client users will need this IP Address to make their initial connection to the server.

To locate your TCP/IP Address:

1. Choose “Settings>Control Panel” from your “Start” menu.

2. When the Control Panel window opens, double-click the "Network" icon.

3. Click on TCP/IP from the listing in the Network window to select it, then click the "Properties" button.  Click the IP Address tab at the top of the Properties window.

Optionally you can get your IP address this way:

Windows 98:

1. Choose “Run” from the “Start” menu.

2. Type “winipcfg”.

3. Press “Enter”.

Windows NT/2000/XP:

1. Choose “Command Prompt” from the Start menu: Start>Programs>Command Prompt. look under "Accessories" if you can't find it under Programs.

2. Type “ipconfig” in the window that opens.

3. Press the Enter key on your keyboard.The current IP address for the machine is displayed. If you do not have a server IP address you will need to specify one now. You must have the IP Address or server Machine Name to make changes (add names, etc.) to the Office Tracker Server.

4. Make a note of your server IP address. You will need it to access the Office Tracker Server administration pages. If your IP addresses are dynamically allocated, or you can’t find the address using the method indicated above, try the following steps.

To set an IP address on your server machine (if you do not have one), follow the 1-4 steps above to get to the IP Address area, then enter an IP Address and make a note of it. If you do not understand how to assign IP addresses please refer to your Windows NT, 95/98/2000 System software documentation and read the section in this guide on Basic TCP/IP Setup.

Step 5.  Close the Control Panel windows and other desktop windows. 

 Step 6.  The Client User Guide is installed on your Office Tracker Server  machine along with the Office Tracker Server application. You can instruct your client users to access Help through the following URL:

http://yourIPaddresshere:8001/Help

WebViewer Installer
If you have purchased a license to use the "WebViewer" option, you will need to run the Wvsetup.exe installer on the same machine you installed the Office Tracker Server software.  This is covered later in the section on "Using the WebViewer."

Short cuts to the Office Tracker Server:  If you are creating a Short Cut to the Office Tracker Server you will need to make sure the working directory is set correctly. The best way to make sure the working directory is correct it is to copy the default Short Cut that is installed in the Start menu or the Desktop of the Office Tracker Server after you’ve done the install.

Installing on Windows NT, 2000 or XP

Important: If you are running another version of Office Tracker as a “Service” under Windows NT, 2000 or XP you need to disable the Office Tracker Service before you begin this install. Also, you should make a backup copy of your entire OTServer directory to another disk before installing a new version of the software. See “Upgrading the Office Tracker Server” for more information.

The server installer will default to installing on Windows NT and 2000 as a “Service.” This is the recommended install setting but if you do not want to install the application as a service be sure to make this change to “application” during the install process when you are prompted by the installer.

Installer Changes and Notes
The Office Tracker Server installer can be installed on any drive you choose. If you are doing an upgrade and originally installed and ran Office Tracker from your C: Drive, you do not need to move your files. If you were running it on your C: drive but  decide to install on another drive this time, you need to move your database and settings files after install. See “Upgrading the Office Tracker Server” for more information.

WebViewer Installer
If you have purchased a license to use the "WebViewer" option, you will need to run the Wvsetup.exe installer.  This is covered later in the section on "Using the WebViewer."

Office Tracker Installation Steps

Step 1.  Insert the Office Tracker CD-ROM and open it from your CD ROM drive (Open "My Computer" then double-click the “Tracker” CD-ROM icon). Double-click the “Tracker” folder then the “Server” folder.

Step 2.  Locate the “Otserver.exe” and double-click it to install the Office Tracker Server components.

Step 3.

1. When the installer launches you will see the Welcome screen. Click the “Next” button to move to the next screen which is the License Agreement. After reading and agreeing to the license, click “next” to move to the next step of the installation process. 

2. You will be prompted to choose the folder and drive for the Office Tracker Server directory “OTServer.” It is recommended you leave this with the default setting unless you have a need to install to a different drive location. The default location is: “C:/Program Files/OTServer”

3. Continue clicking the “Next” button on each screen to complete the install. Before the Java components are installed you will need to accept the IBM license agreement by reading it and clicking the “Yes” button.

4. After the IBM Java Installer completes you will be taken back to the Office Tracker Install to finish the installation process.

5. A DOS window will open and at the bottom of the text window the message “Press any key to continue” will display. Press a key on your keyboard to continue.

6. The last screen in the installer will have two options (checked “on” by default). One is to automatically start the Office Tracker Server and the other is to open the Admin page.

It is recommended that you leave both “on” and click the Finish button to complete the installation.

The following items will be installed on your drive:

“OTServer” directory 
"Server Quick Start”
“Office Tracker Server” - shortcut installed in your Start menu
“JavaSoft” folder installed in your Program Files directory (contains the JAVAW)
“JigAdmin” utility software

Step 4.   Locate your server IP address and make a note of it. If you kept the default install settings the server will be running in the background already and you can look at the main “Admin” page to locate your IP Address and Machine Name. Client users will need the IP Address or Machine Name to make their initial connection to the server.

To locate your TCP/IP Address:

1. Choose “Settings>Control Panel” from your “Start” menu.

 

2. When the Control Panel window opens, double-click the "Network" icon.

3. If you're running Windows 98, click on TCP/IP from the listing in the Network window to select it, then click the "Properties" button.  Click the IP Address tab at the top of the Properties window.

If you're running Windows NT, click the "Protocols" tab, and then double-click the TCP/IP protocol.

Optionally you can get your IP address this way:

Windows 98:

1. Choose “Run” from the “Start” menu.

2. Type “winipcfg”.

3. Press “Enter”.

Windows NT:

1. Choose “Command Prompt” from the Start menu: Start>Programs>Command Prompt

2. Type “ipconfig” in the window that opens.

3. Press the Enter key on your keyboard.

The current IP address for the machine is displayed. If you do not have a server IP address you will need to specify one now. You must have the IP Address to make changes (add names, etc.) to the Office Tracker Server.

 

4. Make a note of your server IP address. You will need it to access the Office Tracker Server administration pages. If your IP addresses are dynamically allocated, or you can’t find the address using the method indicated above, try the following steps.

To set an IP address on your server machine (if you do not have one), follow the 1-4 steps above to get to the IP Address area, then enter an IP Address and make a note of it. If you do not understand how to assign IP addresses please refer to your Windows NT, 98/2000 or XP System software documentation and read the section in this guide on Basic TCP/IP Setup.

Step 5.  Close the Control Panel windows and other desktop windows. 

Step 6.  The Client User Guide is installed on your Office Tracker Server machine along with the Office Tracker Server application. You can instruct your client users to access Help through the following URL:

http://yourIPaddresshere:8001/Help  or  http://servermachinename:8001/Help

 

Advanced Installation Topics

Shortcuts to the Office Tracker Server 

If you installed the Office Tracker Server as an “application” and not a “service” and you are creating a Short Cut to the Office Tracker Server you will need to make sure the working directory is set correctly. The best way to make sure the working directory is correct it is to copy the default Short Cut that is installed in the Start menu or the Desktop of the Office Tracker Server after you’ve done the install.

Upgrading from a Demo: Registering Your Serial Number in the Office Tracker Server

1. From the Admin Page, press the underlined link “Serial Number” to access the Serial number and Server Name page. Important Note: Do NOT change the Office Tracker Server name once your client users have connected or they will no longer see events!

2. Enter your serial number in the field: “Enter Serial Number:”

3. Press the “Register” button

 

Getting Started with Office Tracker

To begin using Office Tracker as a network group scheduling solution you must set up the Office Tracker Server and add your client user and resource names. This section covers how to do both. Before you go on, here is a list of Do’s and Don’ts you should read and refer to often in order to run the Office Tracker Server effectively.

Office Tracker Server Do’s and Don’ts

DO read the documentation for both the server and the client. You should be familiar with all features (client and server) in order to act as the Server Administrator.

DON’T let an inexperienced user run the Office Tracker Server. Schedules are important information to your company, don’t allow this valuable asset to be in the wrong hands.

DO install the html client guide on your client machines (or your internal web server) and show your client users how to access it.

DON'T make copies of the OTServer directory while the server is running as this is not the proper method for baking up. See the section on Server Administration for backup instructions.

 

DO read the documentation on your operating system and network configuration. TCP/IP is complicated if you’ve never read the instructions.

DON’T upgrade client software versions without upgrading the Server version, unless specifically instructed to do so by Office Tracker technical support.

DO keep a current backup of the OTP_Backups and the OTPSettings file on a backup device as often as practical. We recommend at least daily.

 

DON’T move the Office Tracker Server to a new machine before you thoroughly understand what’s involved and how to move it.

DO read periodic e-mail updates sent to you by Milum identified with "Office Tracker" in the subject area and keep up with recommended maintenance updates.

 

DON'T change your server IP address without understanding how to re-connect your clients.

DO instruct client users how to set-up their initial schedule views (.ots files). Each user will need to have their own schedule view(s) created on their local machine.

DON’T attempt to place the .ots files created by the Office Tracker client in a shared directory and share them with other users. This can cause undesired results and strange behavior.

 

 

DON'T forget to make backups of your data files as described in “Making Backups of Your Data File” later in this guide.

 

Starting and Stopping the Office Tracker Server
Below are instructions for stopping and starting the Office Tracker Server. Read the section pertaining to your particular installation – the Office Tracker Server  will be installed as either as a “Standard” application or as a “Service.” If you do not know how your Office Tracker Server is installed you will need to contact your network administrator or the person who installed the Office Tracker Server software at your location.

Starting and Stopping the Office Tracker Server as a “Standard Application”
If you chose to install the Office Tracker Server as a standard application, once you run the installer, you will have a mini-application or “launcher” accessible from your Task Tray right next to the time display at the bottom of your screen. The launcher icon looks like a small calendar with a network connection on the bottom. Right click on the launcher icon and choose to “Start” or “Stop” the Office Tracker Server from the launcher menu.

Starting and Stopping the Office Tracker Server as a “Service”

If you chose to install the Office Tracker Server as a “Service” once you’ve run the installer you will have a new service called “Office Tracker Server” in your Services window.

Starting the Office Tracker Service on Windows NT

If you leave the Office Tracker Service set to Startup “Automatically” in your Services window,  when you restart the machine the Office Tracker Server will start. If you have set the Office Tracker Service to startup “Manually”  and you Stop the service, you will need to open the Services window, select the Office Tracker Server and press the “Start” button to start the server again.

Stopping the Office Tracker Service on Windows NT

To Stop the Office Tracker Server Service, open your Services window and click on “Office Tracker Server” to select it, then click the “Stop” button.

Starting the Office Tracker Service on Windows 2000

If you leave the Office Tracker Service set to Startup “Automatically” in your Services window when you restart the machine the Office Tracker Server will start. If you have set the Office Tracker Service to startup “Manually”  and you Stop the service, you will need to open the Services window, double-click the Office Tracker Server and press the “Start” button to start the server again.

Stopping the Office Tracker Service on Windows 2000

To Stop the Office Tracker Server Service, open your Services window and double-click on “Office Tracker Server” to open it, then click the “Stop” button.

How to Prepare the Server for Client Connections

Step 1. Starting the Office Tracker Server

1. If the server is not running, start it as described in the previous section. It is set to start automatically on the install, so unless you’ve stopped it, it is most likely running.

Step 2. Opening the Office Tracker Server Administration Pages

1. The Office Tracker Server Admin page is set to automatically open after install unless you cancelled this option. If your web browser is not open to the Admin page, open your web browser now. Enter your Office Tracker Server machine IP address or machine name followed by a colon “:” and the Office Tracker Server port number which is “8001”

If your server IP address is “122.22.22.22” you would enter: <http://122.22.22.22:8001>

or

If your server machine name was “ServerXYZ” you would enter: <http://ServerXYZ:8001>

The Office Tracker Server “splash” screen displays for a moment. If you do not have Javascript “active”, this window will continue to display and you will need to turn Javascript "on". To turn Javascript “on” check your web browser “Preferences” or "Options" menu.

Step 3. Enter Administrator’s Name and Password (Server Password)

The Office Tracker Administrator Pages uses a password to protect access from unauthorized users.   Enter the following password into the password field. The name and password are case sensitive. Note: Don’t hold down the shift key when pressing the “=” key.

Administrators Name:   Admin

Administrators Password:   ot=timesavings

You can change the Office Tracker Server password, please read the section later in this guide under Server Administration.

Tip!: Create a “bookmark” in your browser for the Main Admin page or the Names List page.  If you do not create a bookmark you will have to enter the full path each time you want to access the Office Tracker Server Administration Pages. 

What To Do If You Can’t Access the Admin Pages

a.) If your web browser is set to use a Proxy Server, it will block the ability to connect to the local server. Turn the Proxy Server option “Off” prior to any administration tasks. From Internet Explorer choose "Internet Options" from the "View" menu, then click the Connections tab. From Netscape, choose "Preferences" and click on the Advanced settings to access the Proxy Server option.

b.) If you are using MS Internet Explorer, be sure you've entered the full path for your server including the "http://" at the beginning and the ":8001" port number after your IP address.

c.) Stop the Office Tracker Server, wait 2 minutes and start it again. The communication port may not have be initialized properly the first time it started.

Step 4. Registering Your Serial Number and Server Name

1. Click the Admin button if you are not already at the Admin page, then click the underlined Serial Number link on the Admin page.

2. Enter your serial number in the field provided.

Serial Number: The Office Tracker Server serial number is located on your installation CD ROM. The serial number tracks the number of licensed users and can be changed by contacting Office Tracker sales if you want to purchase additional user licenses at a later date.

Enter a server name if you want to change the default “Schedule Server” but don’t change the name if you’ve already begun using Office Tracker and you have clients who have connected. If you change the server name after you’ve been using Office Tracker, your client users will not be able to see events created when the server had a different name.

Server Name:  It is recommended that you leave the default name “Schedule Server” unless you are installing a second Office Tracker Server at your location. The name you choose is up to you, but be sure to make a note of the name if you decide to change it from the default name. Put the name with your CD ROM and serial number in a safe place.

3. Click the Register button to complete your serial number registration. This is your local registration only and does not send the serial number or server name to Milum Corporation. You should fill out the registration card that came with your software and send it in to register with Milum Corporation.

Step 5. Adding Names for People and Resources

About Adding Names (People, Rooms and Resources)You must add each of your client users’ names before they can log them into the Office Tracker Server and begin sharing schedules. You must also add any resources such as conference rooms in order for users to begin creating schedules displaying the rooms. Whether you enter a person’s name or resource name you will follow the same procedure. In Office Tracker each name (people and resources) has an “Identity”. Each identity may have a corresponding e-mail address, sharing privileges and password. Sharing Privileges are accessed after you add the names and are described in detail in the section "Security and Sharing Privileges" later in this guide.

When a client user launches the Office Tracker application they enter their “Identity” Name. A client user can sign on with their own identity or the identity of any other user or resource if they have the correct password.The Identity of the name scheduling events will display in the event block on client machines as “Scheduled by: Identity Name”. This is important because whenever an event is created no matter what schedule it is placed on, the person who scheduled the event "Scheduled by: Identity Name" is the owner of that event.

To add a new name, follow these steps:

Important Note: Be sure you have decided on your standard naming formats before you begin adding new names. Client users must use this “Identity” name exactly as you enter it. We recommend a straightforward “Firstname Lastname” approach. If you choose to enter each clients’ identity as “Lastname Firstname” they may have more difficulty using the system as most people are used to using first names. Names are case sensitive.

1. Click on the Names List button from the Admin page.

If you are not at the Admin page, open your web browser and enter your Office Tracker Server machine IP address followed by a colon “:” and the Office Tracker Server port number which is “8001”  If your server IP address is “122.22.22.22” you would enter: <http://122.22.22.22:8001> , then click on the Names List button.

2. Click the “Add Name”  button. The Name Record window displays.

TIP: If the Name Record window does not display the Add Name button, drag the bottom corner of the window to resize it.

3. Enter the name of the person or resource in the name field.

4. Choose a “Type” from the drop down menu. Each name can have one corresponding “type” which identifies it by an icon client users see in their schedule displays. Types can also be useful when you export schedule data for reporting. For example, you may want to create a report of conference room usage and having the “conference room” type assigned to all rooms makes it easier to retrieve this information.

5. Info (Optional)- Enter any desired information about the name in the Info. field (many users like to use this field for the phone extension of the client or conference room, or serial number of the equipment). For conference rooms you might also put the total number of occupants the room can handle.

6. Password (Optional)- Set a password for the name. If you set the password from the server, client users will need to enter this password when they launch Office Tracker. Client users can also set a password for themselves once they log onto the Office Tracker Server (preferred).

7.  E-mail (Optional)- This is for use with MAPI e-mail notifications) Enter the e-mail address you want to associate with this name. (You may want to associate a user’s e-mail address to your resources.)

8. Click the “Add Name” button to create the new name record. A new blank name record displays. You can add another name or close the Name Record window. When you are done adding names, close the Name Record window.

9.Click the Update button in the Names List window to view the names you added. Each time you add names, edit names or delete names, the Names List window will require an “update” to reflect the changes. Click the update button after making name changes to view the changes in the Names List.

Once you have added all names (you can add additional names later as needed) you are ready to

connect your client users. They will need to have the Office Tracker client software installed on

their individual machines.

Step 6. Install Office Tracker on Users Machine
Detailed instructions for installation
on Windows 95/98/NT/2000/XP and Macintosh client machines are included in the sections "Windows Client Overview" and "Macintosh ClientOverview" later in this guide.

Step 7. Give Users the IP Address or Machien Name, Log-On Name and Serial Number

Distribute the IP Address or Machine Name and serial number to each user and give them their “Identity” name so they can connect to the Office Tracker Server. The “Identity” name needs to match exactly as it is entered at the Office Tracker Server on the Names List.

How Users Connect
Office Tracker users (called "client users") will enter their log on Name "Identity" when they make their initial server connection in the Identity window. If you set an Office Tracker password for them, they will enter it in the Password field. Then they click the “Connect to Server…” button and enter either the Office Tracker Server IP address or Machine name and click OK, then when they see the server name display in the button, click OK again in the Identity window to dismiss it.

How Office Tracker Updates Event Information
Office Tracker events are sent to the server automatically when the user presses the OK button in the New Event or Edit Event window. Office Tracker schedule views are updated automatically every 10 minutes or less, depending on the setting in the Server Preferences (default is 10 mins., minimum is 3 mins.). In addition, each time the user moves to a different day, adds a new name to the view or presses the F2 key, the schedule view will be updated to reflect any changes and events that are modified or added will be retrieved from the server.

Instruct Clients About Working Offline
Client users can work while connected to the server as well as when they are “offline” or disconnected from the server. They may disconnect physically to take their computer home with them or they may get disconnected temporarily if the Office Tracker Server is taken off line.

If clients become disconnected the offline icon will display in the top right corner of their schedule window. When the server is available again they will automatically be reconnected and the icon no longer displays.

When client users work offline, Office Tracker keeps track of the changes they make on their local machines and waits to reconnect to the server to synchronize the changes. The synchronization process happens automatically and takes place in the “background” however there are some “rules” to be aware of. In general, the server will always have the ruling events.  In other words, changes to events on the server usually hold precedence over changes clients make while offline. - Events that are added by other users while clients are offline will show up on their schedules once they reconnect and synchronize to the server.- Events that were edited while clients were offline.  An event edited by another connected user will override.  In this case, Office Tracker will use the event on the server as the ruling event.  This means a client’s schedule may reflect the changes made by the other connected user once they synchronize.  - Events clients create and edit while offline should be reflected once they synchronize.  

 

Server Administration

This section covers the various “Admin” tasks and provides details about how to perform them.

Overview of Common Server Administration Tasks

• Adding new names to the Names List as new employees come on board, or new resources such as meeting rooms are added.

• Making frequent backups of the server data files to a separate disk. These are fundamental to the operation of the Office Tracker system and if your server machine has a problem or your hard drive fails you do not want to be without backups!

• Setting your client’s sharing privileges to give or restrict access to schedules.

• Stopping and Starting the Office Tracker Server properly. Detailed instructions are included in this section under the heading "Stopping the Office Tracker Server."

• Regularly checking the “View Log” for errors and Startup information and the “Names List” to be sure it is displaying your names.

• Troubleshooting: For example, if a particular client user is having a problem with their data such as events not displaying correctly or error messages, you may need to re-set the client’s local data file.  Or, if users have trouble with their connection to the server they will see an "offline" icon in the right hand corner of their Office Tracker window. You should check the Server Admin pages “View Log” to see if there are any error listings.

 

Server Admin Pages

The Office Tracker Administration pages (“Admin” pages) act as the front end to the various controls and features of the Office Tracker Server application. The Admin pages are a series of html pages that were installed on your server during your server installation process.  They are located in the OTServer directory (the full path is: OTServer/Jigsaw/Jigsaw/www/milum).

To view the main server Admin page,  follow the steps below.

1. Open your web browser and use the bookmark you created in the “Getting Started” section of this guide, or enter the following:  http://yourserveripaddress:8001  or http://servermachinename:8001 into the address area (url area) of your web browser, then press the “Enter” key.

Note: If the Office Tracker Server application is not running you will see the “Page Not Found” message in your browser. If so, start the Office Tracker Server and try again. See “Starting and Stopping the Office Tracker Server” in the Getting Started section of this guide.

2. The Administration window displays. You will also see the name you gave your server when you first set it up, the status of your server (whether or not it’s running), your IP address, Machine Name, your serial number and version information.

From the main Admin page you can access the other administrative tools you will use in the Office Tracker Server. The Names List is where you will enter your user’s names as well as the names of any rooms or other resources you will be scheduling. The View Log is used for troubleshooting server activity. The Backup page lets you set your backup times (we recommend you backup the  files to another drive, see “Backing up the Server Data Files” later in this guide.

Server Status: This shows the last startup time of the server and indicates if the client port 4300 is opened correctly. If not, you may need to Stop the Office Tracker Server and restart it.

Name: This is the name of the Office Tracker Server. Many users will leave the default name “Schedule Server” which is fine. Do not change the name once you’ve begun connecting your client users. If you decide to purchase an additional Office Tracker Server you will need to give it a unique name.

Machine Name: This is the name of the machine where the Office Tracker Server is installed and running. You can allow your Windows client users to use this name instead of the IP address if they are connecting from a Local Area Network.

IP Address: This is the IP address of the machine where the Office Tracker Server is installed and running.

Client Port Number: This is the port used for all Office Tracker client connections. You may need to allow this port number access if you are using firewalls for your network.

Serial Number: Your serial number will display in this area. If you have not registered your serial number yet, it will say “Demo”. To register, click the underlined Serial Number link.

Version Number: This displays the version of the Office Tracker Server you are currently running. Please have this information available if you call for support.

Palm Serial Number: This is only pertinent if you have purchased the optional OTPalm software.

Passwords: Click this link to set the Administrative, label, and keyword editing passwords.

 

Starting and Stopping the Office Tracker Server

Starting and Stopping the Office Tracker Server as a Standard Application

If you chose to install the Office Tracker Server as a standard application (not a “service”, once you run the installer, you will have a mini-application or “launcher” accessible from your Task Tray at the bottom of your screen. The launcher icon looks like a small calendar with a network connection on the bottom.

You can right click on the launcher icon and choose to “Start” or “Stop” the Office Tracker Server from the launcher menu.

Starting and Stopping the Office Tracker Server as a “Service”

If you chose to install the Office Tracker Server as a “Service” once you’ve run the installer you will have a new service called “Office Tracker Server” in your Services window. The service will start automatically upon completion of your install and should be ready to use. If you stop the service, you will start it as described below.

Starting the Office Tracker Service on Windows NT

If you have the Office Tracker Service set to Startup “Automatically” in your Services window when you restart the machine the Office Tracker Server will start automatically. If you have set the Office Tracker Service to startup “Manually”  and you Stop the service, you will need to open the Services window  from your Start/Settings/Control Panel/, select the Office Tracker Server and press the “Start” button to start the server again.

Stopping the Office Tracker Service on Windows NT

To Stop the Office Tracker Server Service, open your Services window from your Start/Settings/Control Panel/  click on “Office Tracker Server” to select it, then click the “Stop” button.

Starting the Office Tracker Service on Windows 2000

If you have the Office Tracker Service set to Startup “Automatically” in your Services window when you restart the machine the Office Tracker Server will start automatically. If you have set the Office Tracker Service to startup “Manually”  and you Stop the service, you will need to open the Services window from your Start/Settings/Control Panel/Administrative Tools double-click the Office Tracker Server and press the “Start” button to start the server again.

Stopping the Office Tracker Service on Windows 2000

To Stop the Office Tracker Server Service, open your Services window from your Start/Settings/Control Panel/Administrative Tools, double-click on “Office Tracker Server” to open it, then click the “Stop” button.

Working with the Names List

The Office Tracker Server's Names List window is accessible from the Admin page. This is the page you will likely use the most, especially as you are just beginning with Office Tracker. The Names List is where you enter all of your Office Tracker client user names and resource names.  

Adding Names to the Names List

1. Open the Office Tracker Administration Page in your web browser window by using the bookmark you created or by entering <http://yourserveripaddress:8001> in the address area.

2. Click the Names List button.  The Names List window displays as shown below – however if you have not added names, the lower portion will be empty.

3. Click the “Add Name” button. The Name Record window displays.

TIP: If the Name Record window does not display the Add Name button, drag the bottom corner of the window to resize it.u Important Note: Be sure you have decided on your standard naming formats before you begin adding new names. Client users must use this “Identity” name exactly as you enter it. We recommend a straightforward “Firstname Lastname” approach. If you choose to enter each clients’ identity as “Lastname Firstname” they may have more difficulty using the system.

4. Enter the name of the person or resource in the Name field.

5. Choose a “Type” from the drop down menu. Each name can have one corresponding “type” which identifies it by an icon client users see in their schedule displays. Types can also be useful when you export schedule data for reporting. For example, you may want to create a report of conference room usage and having the “conference room” type assigned to all rooms makes it easier to retrieve this information.

6. Info.(Optional)- Enter any desired information about the name in the Info. field (many users like to use this field for the phone extension of the client or conference room, or serial number of the equipment). For conference rooms you might also put the total number of occupants the room can handle.

7. Password (Optional)- Set a password for the name. If you set the password from the server, client users will need to enter this password when they launch Office Tracker. Client users can also set a password for themselves once they log onto the Office Tracker Server (preferred).

8. E-mail (Optional)- for use with MAPI e-mail notifications) Enter the e-mail address you want to associate with this name. (You may want to associate a user’s e-mail address to your resources.)

9. Click the “Add Name” button to create the new name record. A new blank name record displays. You can add another name or close the Name Record window. When you are done adding all names you want for this session close the Name Record window.

10. Important: Click the Update button  to view the names you added.

Viewing, Editing (Changing), and Deleting Names

The most likely reason you will want to edit the names in your Names List is to assign various Sharing Privileges. You may also want to delete a name, edit the spelling of a name if you entered it wrong or change a name to a different name.

Important Note: When you edit the spelling of a name on the Names List or delete a name, instruct client users to edit any saved views containing the original spelling of the name.

When you want to make a change to a Name record or to remove a Name, follow the steps below.

To View or Edit a Name Record, follow these steps.

1. Open the Office Tracker Administration Pages in your browser window by using the bookmark you created or by entering <http://yourserveripaddress:8001>

2. Click the Names List button.  The Names List window displays.

3. Click on the underlined Name in the first column of the Names List to edit the record.

4. The Edit Name window for that user or resource displays.

TIP: If the Edit Name window does not display the buttons at the bottom you may need to drag the bottom corner of the window to resize it.

5. Make your changes to the name record. Note: See the section on "Security and Sharing Privileges" for details on the specifics of the "Privileges" areas.

6. Click the Update button to accept your changes. To delete a name, click the Delete Name button.

7. Click the Update button in the Names List window to update your list when you delete or modify names.

8. Instruct all client users to remove the old name from any saved views, press the F3 key to get an update of names from the server, then add the new name into their schedule view.

Sending e-mail to a name on the Names List
Provided you have your web browser configured properly, you can send e-mail to any name on the Office Tracker Names List by clicking on the underlined e-mail address in the Names List window.

Viewing the Currently Connected Users in the Names List
When you are viewing the Names List window you can click the “Connected” button to view a list of currently connected users on your Office Tracker Server. This is helpful to diagnose network trouble and usage of the system. The “Connected Users” list may not be able to resolve the user’s name and will display an “Unknown User” in the space for the name of the connected user. You can make a note of the IP address however and resolve the name from the IP address yourself.

1. Click the “Connected” button.

2. The Names List window displays a list of connected users.

Note: If the name shown is "unknown" this is because Office Tracker had a problem resolving the name associated to the IP address listed. 

Adding Client Users (Increasing User License)

If you would like to add additional client users to Office Tracker you can upgrade your user license at any time by contacting Milum at: 512-469-2966.

Changing the Spelling of Name on the Server List

Changing the spelling of a name on the server will require client users with saved views to remove the old name and add the new name. This is accomplished by choosing “Names Shown” from the “View” menu with the view open. The client should remove the old name and add the corrected name by choosing it from the Names Available field.

Deleting a Name from the System

You may want to delete a user or resource name from the server if the user is no longer working with your organization or the resource is no longer available for scheduling.

Note: Removing a name means that some client users will have saved views with the removed name still included. Unless you want client users to be able to access the information for historical record keeping, they should be instructed to remove the name from their saved views as well. Once a name is removed from the server and the client has received a full update, the name will no longer display in the Names Available list.

When you delete a name from the Names List, events with the name (any events including this name as an “Attendee”) will remain.  This is to preserve the history of that user or resource's schedules. Your current client users will no longer have access to the deleted user’s name from their Names Shown and Attendees lists.

Security and Custom Sharing Privileges

Office Tracker users can share information in a number of ways. Sharing Privileges can be assigned at the Office Tracker Server for client users as well as for resources such as conference rooms and equipment. Sharing privileges allow users to view each other's schedules and to schedule meetings and group events.

Important Note: Office Tracker has default sharing privileges that meet the needs of most offices. Before making a lot of changes to the privileges, please review this information and the needs of your office. A large number of non-default Sharing Privileges can slow down server performance when a new user connects for the first time and needs to retrieve all permission information concerning their name.

In addition to the default privileges, you can create custom Sharing Privileges. Custom Sharing Privileges can be assigned at the server. For example, if you use Office Tracker to set meeting times for conference rooms you may want to set privileges to restrict who is allowed to schedule (create events) on the conference room schedules.

Passwords
Security is provided on the client user’s machine by allowing users to set a password for themselves.  The password simply keeps other network users from signing on with an unauthorized identity and obtaining schedule information.  

Event Ownership
When an event is created, ownership is based on the current Identity selected at the Office Tracker client. The Identity may or may not be the user's name. When an Office Tracker client has Sharing Privileges to schedule events for a person or resource other than their own name, the event that is created is still owned by the client (identity) scheduling the event. If a user wants to modify an event that is scheduled on a conference room calendar they must have privileges to “Edit events” for the name who scheduled the event.

To check the identity of any client, go to the client machine and choose "Identity" from the "File" menu. The Identity window displays and shows the current Identity in the "Name" field. If you want to change the Identity, select the users name from the drop down menu if it is available. If  it is not available, enter their name exactly as it is entered on the Server's Names List.

When a user schedules an event the event will show the "Scheduled by" name in the edit event window (double-click on any event to view this information in the lower left corner of the event window). The "Scheduled by" name is the name of the Identity used when the event was created.

Setting Sharing Privileges for Resource Names
Sharing privileges can be set for resource names from the Office Tracker Server.  For example, if you use Office Tracker to set meeting times for conference rooms you may want to set privileges to restrict who is allowed to schedule conference rooms. Resources have an “identity” just like client users. Think of the resource as a regular user name when you are creating privileges.

Sharing Privileges For Client Users
When client users connect for the first time they will gather all Sharing Privileges for their name from the Office Tracker Server. If you make a large number of changes to the Sharing Privileges before allowing clients to connect, then you instruct ALL of your clients to connect at the same time, you will notice a delay time and slow server performance as the server updates all the connecting clients.

Everyone” Option in Sharing Privileges (Use with care)
The “Everyone” option in the Sharing Privileges window actually creates individual “exceptions” to the default Office Tracker Sharing Privileges. What this means is that a large number of sharing “permission slips” must be sent to each client user when this option is used. The more often you use the “Everyone” privilege, the more hits your server performance will take on initial client connections. Use this option with care.

Creating or Assigning Sharing Privileges for Users

To create custom sharing privileges for any name (client user or resource),  follow the steps below.

1. Open the Office Tracker Administration Page in your browser window by using the bookmark you created or by entering  <http://yourserveripaddress:8001>

2. Click on the Names List button. The Names List window displays.

3. Click on the underlined name corresponding to the name of the person or resource you want to set privileges for. The Name Record for that person or resource displays.

4. Choose a name from the "Assign Privileges to" drop down menu to give privileges to the name. For example, if you click on "Gymnasium" the Edit Name for “Gymnasium” will display as shown above. If you choose “John Smith” from the "Assign Privileges to" menu, you will be assigning privileges to John for the Gymnasium’s schedule.

5. Click on the corresponding privileges to check the boxes or uncheck them to grant or remove privileges for the user who is selected in the "Assign Privileges to" drop down menu. See the definitions for Sharing Privileges below.

6. Click the “Update Name” button to send the changes to the Office Tracker Server.

Sharing Privileges Defined
Two Sharing Privileges are on by default. These are: “View Schedule” and “Add Events.” This allows your client users to get up and running quickly and have the ability to create meetings and appointments for the people and resources you’ve included in the Names List.

Each sharing privilege is described in detail along with a brief overview of when you would want to assign the privilege. The settings you select affect the user’s name you have selected in the drop down menu.

View Schedule- allows the selected user to view the schedule for this name. If off, the name column displays in italics on that user’s machine. This is on by default.

Add Events- allows the selected user to schedule events for this name. Assign this to anyone in your workgroup who may need to set up events or meetings that include this person or resource. This is on by default.

Edit/Delete Events- allows the selected user to edit or delete events created by this name. Users with this privilege can edit the contents of any event created by the user who is granted Edit/Delete. Assign this privilege to a user who does all of the scheduling for an office for each of the names they schedule.

View Private Events- allows the selected user to view Private Events. This privilege requires View My Schedule to be checked. It overrides the Private Event checkbox in the Event window. Assign this only when you want a user to have viewing access to all of another user's or resource's private events. When an event is displayed that is set to "private" and the user who is viewing does not have privileges to view the private events for this name, the event  block displays with no readable text.

Allow Conflicts-allows the selected user to create conflicting events for this name/resource. Some organizations may need this ability in order to schedule shared rooms or to accommodate other specific scheduling needs where more than one event takes place at the same time.

 

Backing up Your Office Tracker Server Database Files

Please read this section thoroughly and make backups frequently.

Important: Please do not make a backup copy of the OTServer folder while the Office Tracker Server is running. It is a “live” database and trying to copy it while it is running could corrupt the files. Check the backup software you plan to use to ensure it will not copy “live” files.

How and Why You Should Make Backups
In general, data corruption is not common but on occasion it can happen.  With a mission critical application like scheduling software there is never a good time for a corruption problem so backups are very important. If the server files become corrupt or get damaged you will have to recover a backup. 

You make backups on your local drive by opening your Admin page, pressing the Backup button to go to the Backup page, then pressing the Backup button. You will also want to make copies of your backups to a separate disk (not local) in case of a hard drive failure. All of this is covered in this section.

What to Expect from Backups
Your backups only reflect the information you had at the time they were made. The 5.0 and later versions of the Office Tracker Server include a Backup setting that allow you to make backups as frequently as every 3 hours. This doesn’t mean you will have 8 copies each day, the backup scheme is handled on a rotating basis, keeping only 2 of the most recent copies of the file (“OTDATABackupA.xml” and “OTDATABackupB.xml”) and one for the start of the day such as “OTDATAWed.xml.” The backup files will be created every “x” number of hours apart depending on the setting you choose. The default setting is every 24 hours at midnight.

What to do if you suspect corruption?
If you suspect a database problem, don’t delay, immediately instruct users to Exit the Office Tracker application, then go to the server machine and Stop the Office Tracker Server. After the server has been stopped, try opening one of the client’s machines and see if you can print some reports reflecting data added since the last backup. This will give you something to use if necessary. You can at minimum pass around some printed reports to use while you are getting the backup copy in place. See “Restoring a Backup” for more information.

Automatic Server Backups
The Office Tracker Server is configured by default (if you haven’t changed it) to automatically back up the data files once every night at midnight– provided you leave the machine and the server software running. This is only partial protection as you may have a hard drive failure or other hardware/software problem where you can’t access this backup. You should make additional copies of the data files to another drive or backup system on a regular basis. This is covered later in this section under the heading “Making Manual Backups to Another Drive.”

Important!: In addition to Office Tracker's automatic backups, it is important to make backups to another drive. If your server machine has a hard drive failure for example, you would lose all the automatic backups unless you had copied them to another drive. See "Making Manual Backups to Another Drive."

Where Backups are Stored

The Office Tracker Server utilizes the XML (extendable markup language) format for backup files. This means with a web browser such as MS Explorer or any other XML parser you can open the backup and look at the data. You may even modify the file and use it for your data file – though this is for advanced users and we recommend consulting with a technical support person at Milum before you do this.

The automatic backup feature exports the Office Tracker master data file to an .xml file that is stored by default in a backup directory on your Office Tracker Server machine. This occurs by default each night at midnight, provided the Office Tracker Server software is running.

You can view the backup location by clicking the Backup button in the Admin pages. The default backup directory is located in the path that follows:

C::/Program Files/OT Server/Jigsaw/Jigsaw/WWW/Milum/OTP_Backups

Note: C: could be a different letter drive if you installed the Office Tracker Server to a different drive during installation.

The .xml backup files will be named OTDatamon.xml, OTDatatue.xml,  etc. for each day of the week.

Changing Your Backup Storage Location
To change the path where your backup files will be located, open the Backup page from the Office Tracker Administrator and change the path from the default to the location of your choice. Be sure to enter the path explicitly with the correct backslashes indicating sub-directories. If the path you enter is invalid for any reason, the Office Tracker Server will default to the original path to save the backups.

Making a Manual Backup
Ideally you should make backups during “down” time on your network when client users are not trying to access the Server. If client users are accessing the server they may be temporarily disconnected during the Backup process.

When using this manual method of backup, the backup of your data file will have numbers appended to the end of the file name such as "OTDATA27100114629.xml." Each backup will have a different number appended. To locate the most recent backup, view the file by "Detail" to locate the most recently created file.

Your manual backups will be stored in the same location as your automated server backups. See above under “Server Backup File Location.”

1. Open the Office Tracker Administration Pages in your web browser window by using the bookmark you created or by entering  <http://yourserveripaddress:8001>.

2. Click the Admin button.

3. In the Backup Now section on the page, click the “Back-up” button. Note: Backups can take several minutes from 10-30 or more depending on the size of your data files (how many events you have) and the speed of your server machine.

Important: Do not Shut Down the machine during the backup process as it can corrupt your backup.

4. When complete you will see a “Backup Complete” page. It should say that it was “successful.” If so, you can continue with other administration tasks at that time. If not, you may need to try a Rebuild and/or restore a previous backup copy.

 Making a Backup to Another Drive

Important!: In addition to Office Tracker's automatic backups, it is important to make backups to another drive. If your server machine has a hard drive failure for example, you would lose all the automatic backups unless you had copied them to another drive or changed the path for the automatic backup to another drive. Please do not make copies of the entire “OTServer” directory while the server is running as this may corrupt your database files.

Since the Office Tracker Server keeps the database files open while the Office Tracker Server software is running you will not be able to backup the files by simply copying them.  Instead, you should backup the xml files the Office Tracker Server automatically creates every night at midnight such as the  OTDATAWed.xml for the backup of the data file from Tuesday. The name for the backup reflects the day after the actual backup since the backup starts at 12:01 am.

Following are the recommended file names to backup: OTDATASun.xml, OTDATAMon.xml, OTDATATue.xml, OTDATAWed.xml, OTDATAThu.xml, OTDATAFri.xml, OTDATASat.xml.

These files are located in your OTServer directory in the following path by default: (Note, C: could be a different letter drive if you installed the Office Tracker Server to a different drive)

C:/Program Files/OT Server/Jigsaw/Jigsaw/www/Milum/OTP_Backups

If you have set the backups to be saved to another directory you can check the setting on your Backup page in the Admin pages.

When the Office Tracker Server creates the automatic backups (provided the machine is on and the Office Tracker Server is running) it will replace the file from the last backup. At no time will there be more than seven (7) daily data backup files.

If your server has not been running for an entire week you may not have all the files listed. If you're using an automated backup system you might want to create empty files with the missing names as place holders for your backup system or just back up the complete OTP_Backups directory.

Restoring a Backup of the Data File

Before trying to restore a backup copy you might want to try “Rebuilding” the data file. See “Rebuilding the Data File” later in this section.

If your data file becomes damaged due to a hard crash or other problem you may need to restore a backup copy. This is not a common procedure but one you will value if a minor catastrophe occurs. If you have trouble with the server and begin getting error messages or see errors in your log file it is an indication that something may be wrong with the data file. If rebuilding the data file does not fix the problem you will need to use a backup file.

Note: You must restore the backup data file at the server machine unless you have remote access software.

Office Tracker Server Backup Files
The  backups are stored by default in the “OTP_Backups” directory in the following path “C:/Program Files/OTServer/Jigsaw/Jigsaw/www/Milum/OTP_Backups” If you made a change to your backup storage location, you should check your Backup page to verify the correct location.

Restoring the Office Tracker Server data file using a backup file.

To restore the Office Tracker Server data file from a backup file, complete the following steps.

1. Exit all Office Tracker client users.

2. Stop the Office Tracker Server by either choosing “Stop Office Tracker Server” from your launcher icon (in your Task Bar) or if it’s running as a service open your Services Control Panel window and Stop the Office Tracker Server service. See the Chapter on Getting Started for more complete Starting and Stopping instructions.

3. Locate the directory “OTP_Backups” in the following path (Note, C: could be a different letter drive if you’ve moved the Office Tracker Server to a different drive)

“C:/Program Files/OTServer/Jigsaw/Jigsaw/WWW/Milum/OTP_Backups”

4. Make a copy of the most recent backup file you have such as “OTDATAMon.xml” The day of the backup is indicated prior to the .xml suffix. Mon, Tue, Wed, etc. Will indicate the day the backup was generated. Since the day of the backup is 12:00:01 AM the day Mon is really the backup form Sunday night at midnight.

5. Rename the directory “OTDataBase” in the C:\Program Files/OTServer directory to “OTDataBaseOld”. (Note, C: could be a different letter drive if you installed the Office Tracker Server to a different drive)

6. Move a copy of the backup file ex: “OTDATAMon.xml” to the “Import” directory at “C:/Program Files/OTServer/Jigsaw/Jigsaw/WWW/Milum/Import.” (Note, C: could be a different letter drive if you’ve moved the Office Tracker Server to a different drive)

The Office Tracker Server looks for an Import file in the Import folder and scans the contents. If it finds any .xml files it imports their contents and then renames the file ".xml.done".

7. Start the Office Tracker Server application by choosing it from the launcher or by starting the service in your Services Control Panel window. The import process will begin immediately. Don’t turn off the machine or interrupt this process.

8. Log in to your Admin pages like you normally do. The import process page will display until the import is complete. Don’t turn off your machine or try to do other tasks until the Import is complete. The Import Complete page will display to notify you when the import is complete.

9. Once the Import Complete page displays, go to your Admin page, then check your Names List to verify your names are displaying properly. Check the View Log to make sure there are no errors. You may need to Refresh your web browser or Delete cached files to see the current View Log information. To delete cached files in Internet Explorer, choose the Tools menu, then Internet Options, select the General Tab,  then click the “Delete Files” button under the Temporary Internet Files section. Click OK and then click the Refresh button.

View Log - Using the Office Tracker Server Log

The Office Tracker Server automatically logs server activity and creates a text file or “log” for each day of the week.  The log is useful for spotting error messages that may indicate a need to rebuild your database files. You can view the “active” server log in your Admi n pages by clicking the “View Log”  button. You can also access stored text versions of your inactive logs.

Where Log Files are Stored
The log files are stored in the Office Tracker Server folder on the hard drive in the following directory: "C: /Program Files/OTServer/Jigsaw/Jigsaw/logs."  You can view the current log from the Server Administration Pages. Note: If you installed the Office Tracker Server on a drive other than the C: drive, the letter will be different.

Office Tracker will generate a file for each day of the week but only hold one week at a time.  For example “Monday” will always reflect the most recently passed Monday. The Server Log can indicate problems on your server such as low memory, low disk space, or overuse of large group views. They can also be used to track changes made to events. You will likely read the server log only if you are experiencing some difficulty on your Office Tracker system, such as users being unable to connect to the server or slow access times.

The Server Log must be backed up (copied) if you want to save the log information for more than the current week. Office Tracker automatically overwrites each weekday with the most current day’s information, storing just a week’s worth of log files at a time.

To View the Office Tracker Current Log, follow these steps.

1. Open the Office Tracker Administration Page in your browser window by using the bookmark you created or by entering: <http://yourserveripaddress:8001>.

2. Click the Admin button. The Administration window opens.

3. Click the View Log button. The Server Log window displays.

4. Press the “Reload” button in your browser to get updates.

Note: Only a portion of the current log file will be displayed in the View Log window. If you want to look at the entire log file you will need to open a word processor first, then open the log file by choosing "Open" from the "File" menu and locating the log file in the following directory: "C: /Program Files/OTServer/Jigsaw/Jigsaw/logs."  You can view the current log from the Server Administration Pages. Note: If you installed the Office Tracker Server on a drive other than the C: drive, the letter will be different.

Note: You must press the “Refresh” button in your browser window to see the most current log report.  You will likely press this button several times during troubleshooting to watch the progress or activity.

Exporting Events for Reports

With the Office Tracker Server you can export events to a xml file for use in a spreadsheet or database program. This is a useful reporting and archiving tool. You may for example, export all the events for a particular month with particular attendees for use in a time-billing scenario. Events are exported with all information fields in the following order: (Start Date and Time, End Date and Time, Actual Time, Description, Attendees, Scheduled by, Keyword, Label, Recurring)

Exporting in XML Format

XML stands for eXtensible Markup Language, and is a data format for structured document interchange on the Web. Like HTML, it is a markup language derived from SGML. However, unlike HTML, which was created to allow cross-platform formatting of information for display, XML is best suited for organizing data.

XML looks much like HTML, but the principle difference is that XML describes the type of content, whereas HTML describes how to display content. You can also think of each XML file or document as a mini-database. Tags (the text surrounded by angle brackets) in an XML document delineate the records and fields. The text between the tags is the data. Use the [CDATA[<data>]] block to include raw character data.

XML tools are available for just about any platform and many are free. The SGML/XML Web Page (see below) maintains a very thorough list of publicly available software for XML. You can find it at http://www.oasis-open.org/cover/publicSW.html .

To export events from the Office Tracker Server, follow these steps:

1. Open the Office Tracker Administration Page in your browser window by using the bookmark you created or by entering <http://yourserveripaddress:8001>.

2. Click the Admin button. The Administration window opens.

3. Click the Export Events button. The Export Events window displays.

4. Enter the desired date range in the format MM/DD/YY.

5. Choose the name or “Everyone” option in the Attendees menu. The Everyone option exports events for all attendees for the date range given.

6. Choose the format for the exported file.

7. Enter a name for the exported file.

8. Press the “Export” button. The exported file will be located in the following directory: "Program Files/OTServer/Jigsaw/Jigsaw/www/milum/Export."

Deleting Events (Clearing Historical Data)

Important Note: Make a backup of the Server data file first. Once you clear old data client users will not have access to the information. You cannot reverse the deletion process. The Server data file is the “master” file and changes made to the Server override those made by clients.

To clear data from the Office Tracker Server follow the steps below.

1. Open the Office Tracker Administration Page in your browser window by using the bookmark you created or by entering <http://yourserveripaddress:8001>.

2. Click the Admin button. The Administration window opens.

3. Make a backup of the data file. (See Backing up the Office Tracker Server)

4. Click the Delete Events button. The Delete Events window displays.

5. Enter the desired date range in the format MM/DD/YY.

6. Select the Attendee Name or “Everyone” to indicate events you want to delete that have a specific name or nonspecific name in them.

7. Press the “Delete” button.

Rebuilding the Office Tracker Server Data File

The Office Tracker Server has an automatic rebuild feature built in however there are times when you may need to do a manual rebuild as well.  If your Server machine crashes or a network error causes some file corruption there may be a need to manually rebuild your data file. Also, if you want to upgrade, you should rebuild your data file prior to installing the upgrade. If you begin getting error messages in your Server Log file or client users report strange difficulties with events, this may be an indication you need to rebuild the file as well.

To rebuild the Office Tracker Server Data file follow these steps.

1. Open the Office Tracker Administration Pages in your browser window by using the bookmark you created or by entering  <http://yourserveripaddress:8001>.

2. Click the Admin button.

3. Click the “Rebuild” button.

4. You are prompted to be sure you want to rebuild.

5. As long as you have a backup of your data file, and you have notified client users to disconnect from the server, click the “Rebuild” button to begin. Important Note: Do not shut down the machine during the rebuild process or you will corrupt your database file. This may take some time- 10- 60 minutes or more, depending on the size of your data file and the speed of your machine. The “Rebuild Successful” page will display when process is complete.

6. When you see the “Rebuild Successful” page click the Admin button to go back to your Admin page. Check your Names List page to be sure all your names are displaying properly, then check the View Log to be sure there are no errors being reported. If you see errors you may need to restore a backup copy of your database files.

Note: The View Log may not update on it’s own due to the way some browsers handle caching of pages. To empty your cache in Internet Explorer select Internet Options, then Tools, click the Delete Files button then click OK. Close the Internet Options window then press your F5 key to refresh the page.

Increasing the Memory Allocation for the Server

If the server data file becomes too large for the default memory setting (larger than 50MB) you may need to increase the memory size of the Office Tracker Server application.

To change the memory setting for the Office Tracker server follow these steps.

1. Go to the Office Tracker Server computer.

2. Stop the Office Tracker Server application or service.

3. Open regedit

4. Expand HKEY_LOCAL_MACHINE

5. Expand Software under HKEY_LOCAL_MACHINE

6. Expand Milum Corporation

7. Click on Office Tracker Server

8. You should see the Item LaunchCmd in the right pane

9. Double click the LaunchCmd to open the editor

10. Change the current string to the following line with no returns:

 javaw -Xrs -Xms32m –Xmx128m -cp "C:\Program Files\OTServer\Jigsaw\classes\OTPServ.zip" OTPServer -root "C:\Program Files\OTServer\Jigsaw\Jigsaw"

11. Press Ok to close and save the changes

12. Close Regedit

13. Start the Office Tracker Server.

14. Log into the server admin and check the view log to make sure the server is started and no errors are being logged.

15. Press the backup button to see if the server creates a backup file. If the server does not create the backup you will need to increase the memory in Regedit to a higher value. The –Xmx128m is the memory setting to change to increase the memory allocation.

Setting Passwords for Admin, Labels and Keywords

The Office Tracker Server Admin pages can be accessed from any computer on your local area network provided you know the IP address and the Admin password.  The default Admin password is “ot=timesavings”  If you change the password you should write it down in a safe place and let at least one other person at your organization know what it is.

The Office Tracker Server gives you password control over the Label edit and Keyword edit functions if you choose to password protect these items. If you password protect the labels and keywords, Office Tracker users cannot change or add to the labels or keywords menus unless they enter the correct password.

Changing Passwords

From the main Office Tracker Server Admin page (enter in your web browser - http://yourserveripaddress:8001), you can access the Passwords page by clicking on  the passwords link.

The Edit Passwords page will display.

Enter the new password in the appropriate field and click the “Update Passwords” button to save your changes.

Note: To change the WebViewer password, please see the section on “Using the Office Tracker WebViewer.”

 

Windows Client Overview

This chapter provides a brief overview for your Windows client users. Please refer to the complete Client Guide for more specific instructions.Accessing Online WinHelp
To access the Office Tracker WinHelp System: Choose “Contents” from the Help menu in the Office Tracker application. The Office Tracker Help window will open. Click on any topic.

More “How-To” Information
Refer to the browser based OTGUIDE.htm  (included on install disks in html format) for more detailed instructions. Client users can access these html based guides at the following address: http://yourserveripaddress:8001/Help  (of course you must substitute your Office Tracker Server IP address where it says yourserveripaddress).

Office Tracker Windows System Requirements:

• 486 or greater PC recommended
• 16MB RAM (32 MB recommended)
• 16MB of available hard disk space
• Windows 98/2000/XP or NT 4.0 or greater client 
• TCP/IP Network Support  

Step 1. Installing the Windows Client

1. Insert the Office Tracker Windows CD ROM in the CD drive.

2. Double-click the "Tracker" folder to open it.

3. Double-click the "Clients" folder to open it.

4. Double-click the "Win98-xp" folder to open it.

5. Double-click the "OTCLIENT.exe" to start the installer.

6. Follow the on-screen instructions.

When complete, you should have an “Office Tracker” program group with the application icon, a “Help” file, a “Read Me” file, and an Office Tracker short cut on the desktop. 

Step 2. Check Your Time Zone Before scheduling events

Office Tracker relies on your System clock to be set at the correct time zone for your location. Check your Control Panel to be sure your time zone is set to the right zone. To check your current time zone, choose "Settings>Control Panel" from the "Start" menu. From the control panel, double-click on the Date/Time icon. In the Date/Time window click the Time Zone tab and verify your time zone. All client users in your office (or in the same time zone) should have the same zone set on their computers.

Step 3. Starting Up the Office Tracker Windows Client

1. Open the Office Tracker application by pressing the Start button and choosing “Programs” > “Office Tracker” > “Office  Tracker” from the menu or by double-clicking the Office Tracker shortcut on the desktop.

Step 4. Entering Your Identity and connecting to the Server

The first time you launch Office Tracker you are prompted to enter your serial number, then your identity.  The serial number is on the Office Tracker CD ROM sleeve.  Enter it and click OK.

1. Type your name into the “Identity” window exactly as your network administrator has instructed you to do (i.e. Firstname Lastname). If your network administrator has given you an Office Tracker password enter it here, otherwise leave the password blank.

2. Click on the Connect to Server button. The IP Address screen displays.

Enter the IP address, machine name, or the domain name your Office Tracker Server Administrator has given you. If you do not have an IP address or domain name to enter, contact your administrator.  Note: Do NOT append the :8001 after the IP address on the client.

3. Click “OK” once you’ve entered the IP address or name. The Office Tracker Server name should display in the Identity window in the "Server" button.  If you receive a message that you cannot connect to the Office Tracker Server, contact your Server Administrator and verify the Server is running and your name is on the Names List.

You will connected to the server automatically each time you open Office Tracker from this point on.

4. Click “OK” to close the Identity window.

If your name is on the Office Tracker Server you will connect to the server immediately. If your name is not on the server a window displays notifying you that you are not yet on the server. Contact your network administrator if you cannot connect to the Office Tracker Server.  The server may not be ready yet, your name could be entered in a different manner or the server could be temporarily offline.

Note: Events added to your personal schedule will also be stored on this server. You only need to choose your server once. The connection is automatic the next time you open Office Tracker.

Step 5. Using Your Schedule

Switching Views, Daily, Weekly, Monthly

To switch to a Daily, Weekly or Monthly view, click the Daily or Weekly button at the top of the program window, or choose “Daily View,” “Weekly View” or “Monthly View” from the “View” menu.

Creating Events

Clients can create new schedule events in the Monthly calendar by selecting a day and clicking the New Event button or by choosing “New Event” from the Schedule menu. In the Daily or Weekly view, click-drag down the range of time. The New Event window will open. Enter event details (keyword, labels, agendas, etc.) here.Step 6. Group Scheduling

Once the client is connected to the Office Tracker Server they can create group schedule views.

Creating a Group Schedule View

1. Choose “New View” from the “File” menu.

2. Select the names to include from the Names Available list on the right and click the “<<<” button to move them to the Names Shown list.

3. Click “OK”.

A new group view opens. Choose “Save” from the “File” menu to save this view and give it a name that corresponds to the names you are viewing such as “Sales Schedule.”

Note: The Windows client’s schedule data is not stored in the view but in a data file called “otclient.mdb” The server data file still rules and is the “master” file.

Scheduling Time for Other Users
Office Tracker users can create appointments and events on other  user’s schedules provided they have been given privileges to do so. Clients can drag across one or more names in a Daily view or create an event with multiple names in their Monthly or Weekly view, then set the time and other details in the New Event window. Keep in mind, when viewing multiple names in a Weekly or Monthly view, if a client creates an event, all names will  be included as “attendees” and the event will be posted to each attendee’s schedule.   

Sharing Privileges
Sharing Privileges are set at the Office Tracker Server. Most users can begin working with group schedules using the “default” privileges already set up on the server.

Group Event Notifications
When this preference is “on,” each time a user creates a group event, Office Tracker creates a "Notification” message to send to all attendees for the event. The user can choose to “Send” or “Cancel” the Notification. If they do not want to create notifications at all, they can turn off the Notification feature by unchecking it in the “Preferences” window. Choose “Preferences” from the ”Edit” menu, click the “Events” tab and click the “Auto-Create Notifications” to uncheck it.

Finding Open Times
Clients can find open times for meetings and other events automatically. They can even look for specific days that are available. For example: Find a 1 hr time between tomorrow and next month on a “Monday” between “8 am and 11 am”

1. Choose “Find Open Time” from the “Schedule” menu.

2. The “Find Open Time” window opens.

3. Choose the names, times, and dates you want.

4. Click the “Find” button.

5. If a time is found, click the “Schedule” button to create the event.

"Zoom In” and “"Zoom Out” or “Zoom to Fit””Zoom In” and “Zoom Out” commands are available under the “View” menu. Use the Daily or Weekly view to change the time increments shown or to see more information.  In the monthly view, the calendar will enlarge or reduce in size to display more events.TIP!:  Force Server Update Windows Users- To force an update from the Office Tracker Server anytime you are connected, Press F2 on your keyboard. 


Macintosh Client Overview

This chapter provides a brief overview for your Macintosh client users. Please refer to the complete Client Guide for specific instructions or the OTGUIDE.htm  (included on install disks in html format).

Macintosh System Requirements

• Macintosh with System 8.6 
• 32  MB RAM (64  MB recommended)
• OpenTransport Version 1.1.1 or later

Differences Between the Windows Client and Macintosh Client

There are several differences between the two clients in the current version. An upcoming version of both will add features and adjustments for the slight variations to make the two clients as close as practical.

• Windows client has more extensive Find Open Time feature. Macintosh clients must open a group view with the names they want to search before doing a Find Open Time

• Windows client has an “Alarmer.exe” application to set reminders for events and the Macintosh uses a script an application called “PTM.”

• No scripting support on Windows clients. Macintosh users can create and use AppleScripts.

• No Export Found Set on Macintosh clients. Windows users can find event information and export the found information to a text file for use in reports.

Step 1. Installing the Macintosh Client

To install the Macintosh client software, follow these steps.

1. Insert the Office Tracker CD ROM on the Macintosh you want to install on.

2. Double-click the "Tracker" folder to open it.

3. Double-click the "Clients" folder to open it.

4. Double-click the "Mac" folder to open it.

5. Double click the Office Tracker installer icon.

6. Choose the disk to install on and click the "Install" button.

A folder titled "Office Tracker Pro will be created on the hard drive.

Step 2. Connecting to the Server

To connect to the Office Tracker Server in 3.0, follow these steps:

1. Locate the Office Tracker folder on your hard drive, double-click to open it and double-click the Office Tracker application to launch it.

2. You will be prompted to enter your identity and choose a server.

3. Type the client "Identity" name in the "Name" field the same as it is listed on the Names List on the server. 

4. Leave the password field empty unless  one has been set from the Office Tracker Server and your Server Administrator has notified you to enter it.

5. Choose the Server Type "TCP/IP"  from the Server pop-up menu.

6. Enter the Server IP Address.

7. Once the server is chosen server, click "OK."

Clients will be connected to the server automatically from now on, each time you open Office Tracker. If the server is "down" they will be working "offline" and connect automatically when the server is back "up."

 

Step 3. Using Your Schedule

Switching Views, Daily, Weekly, Monthly

To switch to a Daily or Weekly view, click the Daily, Weekly or Monthly button at the top of the schedule window, or choose "Daily View, ""Weekly View," or "Monthly View" from the "View" menu.

Creating Events

Clients can create new schedule events in the Monthly calendar by selecting a day and clicking the New Event button or by choosing "New Event..." from the Schedule menu. In the Daily or Weekly view, users can click-drag across the range of time much like selecting a range of cells in "Excel." The New Event window will open, allowing the user to enter the details for the event.

Step 4. Creating a New Group View

After making the server connection, the first thing most Office Tracker users want to do is to create a group view. Follow these steps to create a group view:

1. Choose "New" from the File menu.

2. Click "OK" in the "Identity" window.

3. Select the names to include in the group view from the Names Available list in the right in column the "New Document View" window.

4. Click the "Add Name" button to add the selected names.

5. Click "OK" A new Daily group view will open.

6. Choose "Save" from the File menu to save this view.

Sharing Privileges

In addition to allowing you to set Sharing Privileges from the Server, Office Tracker allows clients to create Sharing Privileges for other users on the network from their individual machines. They can begin working with group schedules using the "default" privileges Office Tracker comes with (or the ones you’ve created on the Server).

If a client wants to allow additional privileges or limit the access of certain users, they will follow these steps:

1. Choose Sharing from the "Edit" menu.

2. Choose a name from the "Users" pop-up menu.

3. Click on the checkboxes to assign the corresponding privilege to the user.

4. Click "OK".

Group Event Notifications

Each time clients create a group event, Office Tracker will automatically create a "Notification" message to send to all attendees for the event. They can choose to "Send" or "Cancel" the Notification or if they do not want to create notifications at all, they can turn off the Notification feature by unchecking it in the "Preferences" window. Choose "Preferences" from the "Edit" menu, click the "Events" icon and click the "Auto-Create Notifications" checkbox to uncheck it.

Memory Guidelines for Macintosh Clients

Each event in Office Tracker takes approximately 2K in memory to display on the client’s screen. It will take slightly more if an Agenda is attached and a label is set. If a client is viewing 1 name in a monthly view and has 200 events on that month, the required memory for the view would be approximately 400K (in addition to the memory required for Office Tracker to display it’s menu commands, windows, etc.)

Memory Space Low Messages

If a client user begins getting "Memory Space is Low" messages, it is an indication that they need to allocate more memory to the Office Tracker application. To allocate more memory,  follow these steps:

1. Quit the Office Tracker™ application.

2. Select the Office Tracker™ application icon at the Finder level.

3. Choose "Get Info" from the "File" menu. The Office Tracker "Info" window displays.

4. Increase the Preferred and Minimum Memory Fields by 1000K more.

5. Close the window.

6. Re-launch the Office Tracker application. This section covers e-mail integration with the Office Tracker client software. By using the client preferences and setting up e-mail addresses at the Office Tracker Server you can offer your clients the option of receiving their meeting and event notifications via e-mail.

 

E-Mail Integration for Client Users

This section covers e-mail integration with the Office Tracker client software. By using the client preferences and setting up e-mail addresses at the Office Tracker Server you can offer your clients the option of receiving their meeting and event notifications via e-mail.

Notifications and E-Mail Integration

Office Tracker provides several options for messaging. Event notifications are created by the Office Tracker system at the client side each time a group event is created (any event with multiple attendees or an attendee other than the person scheduling the event). Client users can turn the automatic notification feature "off" by choosing "Preferences" from the "Edit" menu and clicking on the "Event" icon, then click the "Auto Create Notifications" to uncheck it (off)..

Built-in Notification Message System

Meeting and event notifications are created automatically when client users schedule an event for multiple Office Tracker users. If they have chosen another mail program to use for their notifications, the message is created as a mail message of that type. See below for more information on using optional mail applications.

Once clients create or edit a group meeting or event and accept the New Event information by clicking OK, Office Tracker opens the Notification window displaying a default message indicating who scheduled the event, the time, location, and current attendees list. The message is composed automatically based on the event or meeting information. They can add to the message or edit it before sending.

Client users click the Send button to send the notification to all attendees. If they Cancel the notification the attendees will not be notified, however the event is added to their schedule.

Receiving Notifications

When another Office Tracker user creates or edits an event which includes a client’s name as an attendee, they are notified. The Event Notification informs them of the event, location, duration, who scheduled it, and the attendees. The event notification window displays automatically as long as Office Tracker is open or running in the background. The event is added to their schedule automatically provided the user scheduling it has access privileges to create events for them.

Replying to Notifications

Client users can reply to a notification by clicking on the "Reply" button at the top of the notification window. Replies are sent to everyone on the "Attendees" list, which may or may not include their own name.

E-mail Messaging Integration

All client users must have e-mail addresses set on the Office Tracker server if you want to give them the option to use a Mapi compliant e-mail system in place of the built-in Office Tracker messaging system.

Setting e-mail addresses for client users from the server

1. Click on the underlined name from the "Names List" window on the Office Tracker Server. The Name Record window opens.

2. Enter the e-mail address in the E-mail field.

3. Press the "Update" button.

5. Close the Name Record window.

6. Click the "Update" button in the "Names List" window.

Note: You must have e-mail addresses set for each of the client names on the Office Tracker server if you want to give your client users this option.

Setting up Windows Clients to use e-mail notifications

Office Tracker uses its internal (part of the Office Tracker application) notification structure by default. Each time a client user creates an event with names other than their own included as "attendees" the notification is created (unless they have the notification feature turned "off" in the "Preferences").

As an alternative, clients can choose any MAPI-compliant e-mail application as the "carrier" of notifications instead of using the internal notification structure. This option will create e-mail messages which will be stored along with their other e-mail in your "In" and "Out" box of the mail application of choice.

Note: Client users must have a "Profile" set up in their e-mail application program and have the application set up to be the default MAPI application. See your mail application user guide for more detailed instruction.

Choosing a MAPI-compliant e-mail application from the Office Tracker Windows client machine.

1. Choose "Preferences" from the "Edit" menu.

2. Click on the "Mail" tab.

3. Select the Preferred Notification Method from the drop-down menu.

4. Choose your Default Profile Name from the drop-down menu.

5. If you have a password set in your mail application for this profile, enter the password in the Default Profile Password field.

6. Click OK to accept the changes.

Office Tracker will now use this mail application to create group event notifications. 

 

How to Setup a MAPI Profile in Outlook

Note: These procedures only apply if you have installed Outlook with the Corporate or Workgroup (CW) option. This option allows you to use Messaging Application Programming Interface (MAPI) services. To determine your installation type on the Help Menu click About Microsoft Outlook. In About Microsoft Outlook you should see "Corporate or Workgroup" if you have the Corporate or Workgroup installation.

If you do not have the Corporate or Workgroup installation you can run the Outlook installer again and choose to install the components to update your outlook to the Corporate or Workgroup installation.

In Microsoft Outlook, Information Services enable you to control how e-mail systems address and deliver your mail, as well as how your mail and folders are stored. This article discusses Information Services that are available with Outlook and how to add them to your user profile

User Profiles

A user profile is a group of settings that define how Outlook is set up for a particular user. For example, a profile may include access to a mailbox on Microsoft Exchange Server and specify that the Outlook Address Book appear in the Address Book dialog box. A profile can contain any number of information services.

Generally, you only need one user profile. If you sometimes need to work with a different set of information services, it may be helpful to create an additional profile to use those services. If more than one person uses the same computer, each person should have a separate profile to keep personal items secure.

You can copy an existing user profile, rename it, and then modify it as needed to create your profile. You can have Outlook start with the same profile every time, or you can select a profile to use each time you start.

To Add a User Profile

To add a User Profile to your computer, follow these steps:

Click Start, point to Settings, and click Control Panel.

1. Double-click the Mail (or Mail and Fax) icon.

2. Click Show Profiles.

3. In the Mail and Fax dialog box, click Add.

4. Follow the prompts of the Inbox Setup Wizard.

Internet E-mail
With the Internet E-mail service, Outlook functions as a full- featured e-mail client integrated with desktop information management and the Outlook document explorer. You store messages locally in a .pst file, and remotely connect to and download messages from an Internet e-mail service provider (ISP). You can store e-mail addresses in the Outlook Contacts folder or a Personal Address Book.

Microsoft Mail
Using the Microsoft Mail service, you store messages locally in a .pst file, but work connected primarily through the Local Area Network (LAN) to a post office. The postoffice provides the messaging transport and central address book or e-mail directory. In this configuration, Outlook functions as a full-featured e-mail client.

Using MAPI with IMAP Servers
Microsoft does not supply a Messaging Application Programming Interface (MAPI) service to allow Outlook in Corporate/Workgroup mode, to access e-mail on an Internet Message Access Protocol (IMAP4) Internet mail server.

More Information
IMAP MAPI Service Provider is a MAPI service for IMAP4 connectivity, available from Syntegra (USA) Inc. The following information is from the Syntegra Web site:

IMAPSP enables IMAP server mail folder access with Microsoft(R) Windows clients. Also included is a MAPI SMTP Transport Provider to facilitate "sending" e-mail messages, and an Exchange Client Extension (ISTORX) to add commands and dialogs to the client interface.

For more information visit to the Syntegra Web site at:  http://www.us.syntegra.com/imapsp/

 

GMT Time Zone Support

Office Tracker supports GMT (Greenwich Mean Time) so clients can schedule more easily with colleagues in other time zones. Your time zone may be set to the correct area, however you should check it to be certain. Events are stored on the Office Tracker Server in GMT Time. When a client user accesses schedule information they see the events based on the time zone they are in. For example, a user in California may see an event three hours earlier if it was scheduled by someone in New York.

Note: Be sure to set the System time zone on client machines before they begin scheduling.

Setting Time Zone on Windows Clients

You should be sure you have your computer set to the proper time zone before using Office Tracker.

1. Choose Settings: Control Panel: Date/Time from your Start menu.

2. When the Date/Time control panel displays click on the Time Zone tab.

3. Select your time zone from the drop down menu.

Setting Time Zone on Macintosh Computers

To set the time zone on Macintoshc omputers, follow these steps:

1. Open the "Date and Time" Control Panel.

2. Click the "Set Time Zone..." button.

3. Choose a city that is in your time zone.

4. Click OK.

 

Using Office Tracker With Firewalls

This section should help you allow access to the Office Tracker Server if you are running a firewall. If you do not have a firewall this section will most likely not be relevant to your operation of the Office Tracker Server.

There are several ways a firewall can protect your network. Three key techniques are filtering, proxy servers, and encryption. In this section we are going to provide the

necessary information to setup a filter to allow Office Tracker clients to have access to the Office Tracker server.

A firewall can screen TCP/IP packets and deny or grant access based on criteria such as IP address and TCP/IP protocol. When TCP/IP sends data packets to the firewall, the

filtering function in the firewall looks at the header information in the packets and directs them accordingly.

Firewalls make their decisions based on tables of data and rules. You can manipulate these rules so that, for example, only data from certain addresses is allowed to pass through the firewall. Filters are one way the Firewall controls traffic from one network to another. The filters operate on criteria such as IP source or destination address range, TCP ports, UDP responses, Internet Control Message Protocol (ICMP) responses, and TCP responses.

The following contains the information needed to set a filter for the Office Tracker system.

The Office Tracker server maintains two port for communications one at 8001 for the HTTP web admin interface and 4300 for the client application to connect to.

Office Tracker uses TCP not UDP.

Office Tracker Server Port information

HTTP Source Port: 8001

HTTP Destination Port: 8001

Client connection Source Port: 4300

Client connection Destination Port: 4300

Office Tracker Client Port information

Client Source Port: 4300

Client Destination Port: 4300

If you need more detailed information, please contact Milum at support@milum.com.

 

Basic TCP/IP Network Setup Information

Note: This information is provided as a general overview only. As there are many different types of network software products, Milum cannot offer specific help with setting up your TCP/IP addresses and network. Please refer to the manual for the network software you use, such as 3Com, Microsoft, etc.

Most of the pain of dealing with TCP/IP networks is setting up connections between your machines. Although most people connect on the Internet using names like

(info@milum.com), there are always numbers underlying those names someplace. Setting up your own LAN (Local Area Network) with TCP/IP means that you get to deal with setting up the numbers or IP addresses for your machines on your local network.

IP addresses are 32-bit numbers, usually written out as four numbers separated by periods, example 192.168.123.10. There are three sizes of networks: A, B, and C. If the first number is below 128, the network is a class A network, a massive address space capable of holding millions of computers. Class B addresses start with numbers between 128 and 191, and can hold tens of thousands of machines. Class C addresses start with numbers from 192 to 223, and can hold about 250 machines. All that you really need to know for your network is how to pick numbers that will work.

If you plan on connecting this network to a larger net later, you might want to ask your administrator or Internet service provider for a list of valid Internet address so you don’t have to re-configure your system later.

The easiest numbers to use are the private address IP numbers. Even if you are connected to the Internet, all traffic from these numbers will simply get dropped and never retransmitted across the internet. Even if you don’t think you’ll ever connect to the Internet, it makes sense to use these numbers - it’s just one less thing to worry about. The class C private addresses are all addresses from 192.168.0.0 to 192.168.255.0. For a network, I recommend using class C. Pick your favorite number from 0 to 255 and make your network IP address 192.168.(your number).0. For your private network’s subnet mask, use 255.255.255.0, which will work fine on any class C network. Always pick your number consecutively it makes it a lot easier to keep track of the numbers you have in use.

Adding and Configuring the TCP/IP Protocol

Confirming the Default Network Settings:

1. Open up the Control Panel from the "Start>Settings>Control Panel" menu.

2. Double-click on the Network icon

Adding TCP/IP Protocol

If you're using Windows NT, click the "Protocols" tab fist.

1. Click on the Add button.

2. Click on Protocol.

3. Click on Microsoft.

4. Click on TCP/IP.

5. Click on OK and re-boot if necessary.

Configuring TCP/IP IP Address

1. Click on TCP/IP

2. Select IP Address: If you have a DHCP serviced subnet, Select Obtain an IP Address Automatically, Go to Configure WINS Server for DHCP. If not, enter your IP address and Subnet Mask.

3. Click on WINS Configuration.

Configuring TCP/IP WINS

1. If you do not have a WINS Server, select Disable WINS Resolution.

If you have a WINS Server but not a DHCP serviced subnet:

1. Select Enable WINS Resolution.

2. Type in the Primary and Secondary IP addresses for your WINS Servers.

3. If you have a DHCP serviced subnet, select Use DHCP for WINS Resolution.

4. Click on Gateway Configuration.

Configuring TCP/IP Gateway

1. Type in the IP address of your Gateways or Routers.

2. Click on ADD after each one.

3. Click on DNS Configuration.

Configuring TCP/IP DNS IP Addresses

1. Type in your Host Name.

2. Type in your Domain Name.

3. Type in the IP address for your network’s Domain Name Server(s).

4. Click on Add.

5. If you have more than one DNS server, add subsequent IP addresses.

6. Bindings and Advanced should not need to be modified.

7. Click on OK and re-boot. You should then have network access.

 

Using NAT to Setup a Public Internet Address for Your Office Tracker System for Remote Access

You will need to read the specific instructions in your router guide but this overview will give you a basic understanding of how to use NAT in your company to provide external access (remote access) to your Office Tracker system.

NAT is an acronym for Network Address Translation. Developed by Cisco, NAT is used by a device such as a router, firewall or computer. NAT is an IP translation and mapping technology. It allows your entire network to share internet access over a single IP address. A single cable mode, DSL modem, or even 56k modem could connect all the computers in your small business to the internet simultaneously.

Your ISP provider assigns a registered IP address to your company. This address must be registered by the IANA, an acronym for Internet Assigned Numbers Authority. You set up a NAT – enabled router with these IP addresses at your company. Using NAT, you can map this registered IP address to the internal machine IP address you want to use as the Office Tracker Server. In addition you will need to set up “port forwarding” for the Office Tracker Server port 8001. This provides a publically accessible IP address and port so users outside of your network can access the Office Tracker system using the client software “Office Tracker” or the web software “WebViewer.”

How does NAT work? NAT acts as an interpreter between two networks. In the case of a small business or home network, it sits between the internet and your network. The internet is considered the‘public’ side and your home network is considered the ‘private’ side. When a computer in the private side requests data from the public side (the internet), the NAT device will open a conduit between your computer and the destination computer. When the public computer returns results from the request, it is passed back through the NAT device to the requesting computer.

Using the Office Tracker WebViewer

The Office Tracker WebViewer is an option that you may have purchased with your Office Tracker Software License. If you do not have a license to use the WebViewer you can order it by contacting Office Tracker sales at: 512-469-2966 or by sending e-mail to: sales@officetracker.com.

WebViewer™ Overview

The Office Tracker Web Viewer allows client users to view daily, weekly, and monthly calendars right in their web browser from any location in the world.  Users on the road can easily check their schedules. You can also give access to your customers, vendors, friends and the general public so they can view the schedules for any of the Office Tracker names you’ve assigned to be “published” to the web.

The Office Tracker WebViewer consists of a cgi on the Office Tracker Server and a set of calendar web pages (.html files) on your Office Tracker Server machine. You control which schedules are published to the web from the Office Tracker Server Names List by clicking on a name and setting the “Publish to Web” setting “on” (checked). Schedules are updated based on a frequency setting you choose in the Web Settings area in the Office Tracker Admin pages. You can set the frequency of web updating from every 15 mins. to every 12 hrs. A User Name and Password requirement provides security.

Both the Office Tracker Web Viewer and the Office Tracker Client software use TCP/IP as their communications protocol.

Limitations

The Office Tracker Web Viewer currently does not offer the ability to create or edit schedule items, automatically find open times, set alarms or the display of multiple names side-by-side, upcoming releases are planned to provide scheduling functions via the web.

With the WebViewer, scheduling of events and appointments must be done from the Office Tracker client, however e-mail reservation requests can be easily made and you can customize the WebViewer to include an e-mail reservation button if you like. See below on “How to Customize the WebViewer Interface.”

WebViewer Requirements

The Office Tracker WebViewer requires you to have at minimum one multi-user Office Tracker Client and the Office Tracker Server running on your network.  Windows NT/2000/XP is the recommended operating system for use with the WebViewer.

Windows 98 WebViewer Issue

There is a known issue with Windows 98 that may cause the perl code to load into memory multiple times. If you cannot run the Office Tracker Server on a machine other than a Windows 98 machine, you will need to instruct your client users to allow the WebViewer calendar pages to fully load before clicking on another link or loading another calendar name. Otherwise you will find your server machine loading many copies of perl and running out of system resources.

Installing the WebViewer

Step 1.   Insert the Office Tracker CD ROM and open it from your CD ROM drive (Open "My Computer" then double-click the Tracker CD ROM icon). Double-click the “Tracker” folder then the “Server” folder.

Step 2.   Locate the “Wvsetup.exe” and double-click it to install the Office Tracker WebViewer components.  Follow the on-screen instructions.

 

Step 3.   Once you’ve completed the installation of the WebViewer you can adjust the settings and turn on the names you’d like to have accessible via the Web by following the instructions on “WebViewer Settings” and “Setting up Your User, Room and Resource Schedules for the WebViewer.”

WebViewer Settings 

The WebViewer Settings page lets you change the logon name and password for the WebViewer, the range of dates to publish to the web and the frequency of the updating.

To view the WebViewer Settings page, first open your Admin page in your web browser by entering <http://myserveripaddress:8001>, then click the “Names List” button. Next click the “Web Settings” button.

Export Settings

The Export Settings effect how often the WebViewer Is updated and which range of dates are exported. You can adjust these settings as needed.

Range of events to display - This setting controls the range of events to export to the web. It is recommended that you export a moderate range such as 1 month back and 6 months forward for best performance. This will be affected by the performance capability of your Office Tracker Server machine. A high end server machine with only one server application running can handle a much larger date range and more names than a less powerful machine or one running multiple server applications.

Update Web Schedules Every: X minutes. This setting controls the frequency of the schedule exporting to the WebViewer. It is recommended that you set this at 1 hour or greater for best performance, unless your Office Tracker Server machine has a very fast processor. A high end server machine with few server applications running can handle more frequent web updates.

If you set the update time to “Don’t Export” this will stop all web schedules from updating. This is handy when you want to work on the server and you want a minimum amount of server activity.

WebViewer Login Name and Password

You have the option to leave the WebViewer Login Name and Password with the default settings, change them to a new login name and password, or allow users to access the WebViewer without a login name and password. 

Default Name: View 

Default Password: Please

To change the login settings open the Office Tracker Server Admin page in your web browser, press the Names List button, then the Web Settings button.

Enter the password desired in the WebViewer password: field. You will only see •••••• bullet marks where the letters would display for security reasons. Keep the password listed in a separate place where you keep all of your passwords.

Enter the login name in the name field. This is the name users will enter when they access the WebViewer (as described following in “How Users Connect to the WebViewer.”

Logging In Without a Name and Password

Click on the “Login required” checkbox to turn it off if you prefer to allow users to log in to the WebViewer with no log in name or password.

Click the Update Settings button at the bottom of the page to save your changes.

Note: If you have trouble with adding the Logon name or Password you may need to use the JigAdmin tool.  Please contact Milum’s customer support for instructions on using the JigAdmin tool.

Setting Up Your User, Room and Resource Schedules for the WebViewer

Once you have entered your users or resource names in the Office Tracker Names List on your server, you can access the web viewer settings.

1. Click on a name in the Names List window. When the Edit Name Record window opens, set the WebViewer Access to be “on” by clicking on the checkbox “Publish Schedule to WebViewer,”  then press the update button and close the window. The next scheduled export time (see Export Settings below) will include the schedule for this name.

Note: If you don’t wait for the next export time and try to access the schedule with your web browser you may not see events. In this case, wait at least 15 mins. and try again.


How Users Connect to the Web Viewer

To connect to the web viewer, users will follow these steps:

1. Open a web browser and enter the IP path of the Office Tracker Server followed by the word “Calendar” such as:

http://your.IP.Address.here:8001/Calendar

2. The user is prompted for their name and password for access to the web schedules.

The default name and password are as follows:

Name: View

Password: Please

3. The user can choose any name from the WebViewer drop down Calendar menu at the top of the window.  The names that display in this menu are the names on the Office Tracker Server Names List that have the WebViewer Access turned on “Publish Schedule to WebViewer.”

4. Web Viewer users can access one schedule in the drop down menu at a time. They have the ability to view the schedule in Monthly, Daily or by Event List  (7 ,14 ,20 or 30 days) views.

 

How to Customize the Web Viewer Interface:

Important: This Information is only for advanced users and the use of this information is solely the responsibility of the end user. If you need help making changes to the system Milum Corporation can provide customization pricing. If you are going to do the work in-house and need technical support for the modification,  you can purchase hourly support from Milum Corporation. Contact support@officetracker.com for more info.

HTML Authors:

The Calendar CGI uses standard CGI calling conventions. You can make your own calls to the Calendar CGI to create your own custom interface to the schedule data.  The following are the calls to the CGI. You will need to verify the users schedules you want to access are set to “Publish schedule to WebViewer.”

30 Day Calendar view:

To display a 30 day calendar in a window or a frame you can use the following call.

http://your.IP.Address.here:8001/cgi-bin/Calendars/calendar.cgi?calendar=”Put User Name Here”

Real Example:

http://205.241.20.251:8001/cgi-bin/Calendars/calendar.cgi?calendar=Bill_Smith

The user name should have no spaces if the name is “Bill Smith” on your server you would use “Bill_Smith” to access the schedule for Bill Smith.

List upcoming events:

To create a list of upcoming events you can make the following call to the CGI.

http://your.IP.Address.here:8001/cgi-bin/Calendars/calendar.cgi?calendar=”Put User Name Here”&list=on&days=”any number of days”

Real Example:

http://205.241.20.251:8001/cgi-bin/Calendars/calendar.cgi?calendar=Bill_Smith&list=on&days=10

The previous call will generate a list of events for the next ten days from the current day.

You can also go directly to a day view by making the following CGI call.

http://205.241.20.251:8001/cgi-bin/Calendars/calendar.cgi?day=2&year=1998&month=7&session_file=&calendar=Bill_Smith&View_day=on

The example above will display a day view for Bill Smith for the day of 7/2/98.

If you intend on creating your own interface to the Office Tracker  CGI and you have technical questions there will be a charge for the support call.  This is not covered under the standard support program.

Setting a Default Calendar for WebViewer to Display

To set a default calendar for the WebViewer to open (so users don’t have to select a calendar) you need to make a change in JavaScript in the button bar html used to open the Web Viewer.

In the file "buttonbartmpl.html" in the following directory "C:/Program Files/OTServer/Jigsaw/Jigsaw/WWW/Calendar" modify the script as shown below.

The "buttonbartmpl.html" is a template used to create the button bar. The template is used every time the Office Tracker Server is restarted and automatically generates the button bar in the WebViewer. After you make the modifications you will need to "Stop" the Office Tracker Server, then restart it from the Start menu to see the change.

updateCalDisplay(CalNameObj) {

nameInteger=CalNameObj.selectedIndex

CalInteger=CalNameObj.selectedIndex

CalString=CalNameObj.options[nameInteger].text if (CalString =="") {

//alert ("This is not a valid calendar please select an item from the menu") pathHolder=("/cgi-bin/Calendars/"+ "calendar.cgi?calendar=NameOfCalendar")

//in the line above replace "NameOfCalendar" with the name of the calendar you wish to display by default.

Perl Programmers:

If you are a Perl programmer you can edit the Perl script “calendar.cgi” to make it behave the way you want. Milum will not support customized versions of the Perl code. If you make changes to the Perl code all changes must be sent to Milum Corporation and become property of Milum. If you fail to send in your customized version of the Perl code you will be in breach of your license contract.

Warning: Milum will be updating the Perl code for the WebViewer and changes you make can be lost if you don’t backup your modified version before installing any updates to the server.

Milum also reserves the right to modify the calls to the CGI without notice.

Potential WebViewer Problem and Solution

Note:  This is a Windows NT Fix to a problem where the WebViewer’s use of Perl may cause your Office Tracker Server to crash.

The WebViewer uses Perl, a special programming language. Perl stays resident in  the computer's memory if a user does not wait for the perl process to finish sending the browser the html message. The following steps will fix this by removing any perl.exe at a scheduled time.

Instructions on how to automate the clean up process of Perl.exe from memory

1. Create a patch file with only this line in it.

e:\tools\kill.exe perl.exe

Name the file “ killperl.cmd”

Save it in the e:\tools folder.

2. Copy kill.exe file from the winnt resource kit into the e:\tools folder.

3. At the command prompt window, enter the following command exactly as shown.

C:\>at 22:00 /every:M,T,W,TH,F,S,SU "e:\tools\killperl.cmd"

4. Repeat the above command changing the time from 22:00 to the desired time for each scheduled time you would like to ensure the perl has been cleared from memory.

5. To confirm the results type c:\at and you’ll see a list of your scheduled times.

6. To delete a scheduled time line, type c:\at 2 /delete  (where 2 is the ID for the line that is shown when you type AT).

 

Running Multiple Office Tracker Servers

The Office Tracker client supports the ability to have multiple server connections. In larger organizations where there is a need to divide the users among several servers, the users on one server can share schedule information with the users on another. There are some items you should be familiar with before attempting to set up a multi-server installation.

Important: Each of the Office Tracker Servers must have a unique name. Since the server name cannot be changed once clients begin scheduling information, it is very important that you decide on your naming scheme before allowing your clients to connect.

If you try to connect the Office Tracker client to two Office Tracker Servers with the same name this will cause the client to produce unusual results. You will need to start the clients data file over from a fresh connection to fix the problem. Also events could be lost if the client schedules events while connected to the server with the same name as their primary server.

To use multiple Office Tracker Servers, set up each of the Office Tracker Servers as described earlier in this guide making sure each server has a unique name. Set up your “Names List” on each server and instruct your clients of their appropriate IP address to connect to their “primary” server.

The client’s primary server is the server that contains their name in the Names List.

Once you have established the connection to the primary server you can now connect the client to a secondary server. To connect the Office Tracker client to a secondary server follow these steps.

1. With the Office Tracker client open go to the Edit menu and Choose “Preferences…”

2. In the Preferences windows select the Servers tab.

3. Type the IP address of the secondary server in the IPAddress field.

4. Press Add to add the Office Tracker Server to your list of Office Tracker Servers.

How to work with names from multiple Office Tracker Servers:

Once the Office Tracker client has a connection to a secondary server they will be able to see names from that server in their “Names Available” fields when creating new views or adding attendees to events.

To create a view with names from the secondary server client users should follow these steps:

1. Choose "New" from the "File" menu. When the Names Shown window opens it will display the names from the primary server by default.

2. Select the secondary server from the servers drop down menu under the “Names Available” field in this window. This will change the list of names available to the names from the secondary server. To include names from the Names Available list select the name and  click the "<<<" button to move the names to the Names Shown list.

3. Click "OK". A new daily view opens with the names you select. Choose "Save" from the "File" menu to save this view.

 

Troubleshooting and Tips

The following troubleshooting tips are useful in diagnosing and assisting with server and client trouble.

#1-  Client Connection Problem - I've installed the server but my clients aren't showing connected (there's a server offline icon in the upper right corner of their window).

First Possibility:

Have you made the initial client connection by choosing from the File menu “Identity” and clicking the “Connect to Server” button? If not, you will need to do this in order to establish the connection for the first time. After the first time, the client will “find” the server automatically.

Second Possibility:

The Office Tracker Server machine must have a "static" IP address so client users can connect. To check the IP address, go to the server machine, then follow the steps below.

Windows 98

1. Choose "run" from the "Start" menu.

2. Type "winipcfg"

3. Press the Enter key.

Windows NT, 2000, XP:

1. Choose “Command Prompt” from the Start/Programs/Accessories menu, then type “ipconfig”

3. Press the Enter key.

The current IP address for the machine should display. Make sure this is the same address you entered at the client machine.

#2- I can't seem to access the features of the Administration Pages. Page Not Found displays.

New Users: Most Likely Reasons Server Admin Pages Won’t Display:

1. The Office Tracker Server software isn’t running (check Task Manager Ctrl-Alt-Delete to see if the process “javaw.exe” is running.  If you don’t see one of these, choose “Office Tracker Server” from the “Start” menu and try again or if it’s installed as a service, choose Start/Control Panel/Administrative Tools/Services and Stop, then re-start the Office Tracker Server service.

2. IP address isn’t static.

On Windows 95/98 choose Run from the Start menu and type in “winipcfg”  and click “OK” to see your IP address.

On Windows NT/2000/XP, choose “Command Prompt” from the “Start/Programs/Accessories” menu and when the DOS window displays, type “ipconfig” then press the Enter key.

Your IP address should not be all zeros such as:  00.00.00.00, it should also not change from one startup to the next. If it does, it’s not “static” but is being assigned automatically by a DHCP Server and changes at random times. Check with your network administrator or the person who set up your network.

3. Proxy Server option is turned on in Internet Explorer. Choose “Internet Options” under the “Tools” menu (or other menu in older versions) in Internet Explorer, click “Connections” tab, then click “LAN Settings” button. If Proxy Server is on (checked) click on it to uncheck it.

4. You’re not entering the full path in your browser:   http://yourIPaddresshere:8001

5. Go to the “View Log” by pressing the “View Log” button and see if you are getting an error such as javalangnullpointer error in the log (you may need to scroll to see it). If you see this error, follow these steps:

1. Stop the Office Tracker Server by choosing “Stop Office Tracker Server” from the launcher in your Task Bar, or if it’s running as a Service, Stop the Office Tracker Server Service in your “Services” Control Panel.

2. Wait 2 mins. then restart the Office Tracker Server as you normally do.

6. You’ve upgraded improperly from 3.7.3 to 5.0.x. Repeat the upgrade but this time follow the instructions step by step.

7. Windows 2000 install problem. The OT Server may have been installed incorrectly under a login other than “Admin” or on another drive. Please call our tech support line and they can help you fix this.

Existing Users: If you have been using the Office Tracker Server for a while and are not getting an error message try these solutions:

You may need to do a “rebuild” on your server database. See the section in this guide on “Rebuild.”

Or

If you try a rebuild and it is unsuccessful you may need to restore a backup of the Office Tracker Server database. See the section in this manual on “Restoring a Backup.”

#3 Reason Names List Won’t Display

1. Most Likely:  If you created your own Office Tracker Server shortcut you may have this problem. To fix it, Stop the Office Tracker Server by choosing “Stop Office Tracker Server” from the launcher in your Task Bar, or if it’s running as a Service, Stop the Office Tracker Server Service in your “Services” Control Panel.

Now, start the Office Tracker Server from the Start/Programs/Office Tracker Server menu or from the Services Control Panel.

Refer to the Server documentation for how to create a shortcut properly. The best way is to copy the current Short Cut that is installed in the Start menu on the Office Tracker Server machine.

2. Possible – If you can, go to the “View Log” by pressing the “View Log” button and see if you are getting an error such as javalangnullpointer error in the log (you may need to scroll to see it). If you see this error, follow these steps:

1. Stop the Office Tracker Server by choosing “Stop Office Tracker Server” from the launcher in your Task Bar, or if it’s running as a Service, Stop the Office Tracker Server Service in your “Services” Control Panel.

3. Wait 2 mins. then restart the Office Tracker Server as you normally do.

#4 Office Tracker Registration Page Keeps Displaying on Server

If your demo period has expired you need to enter your serial number. You could also be experiencing a caching problem with your web browser. If so, try this:

1. To fix it, go to “Internet Options” under your “Tools” menu and press the “Delete Files” button. Click “OK” then click the “Refresh” button in your browser. 

2. If the registration page doesn’t go away, enter your serial number or “Demo” if you’re a demo user.  Press “Register” - if it doesn’t move on to the Admin page, repeat step 1.

3. If you still have a problem, restart the server machine, log on to the Admin page and then enter your serial number.

#5 Symptom: Server misbehaving in unusual ways. Clients getting disconnected or very slow.

Problem: The WebViewer Export Settings need to be set with the machine speed and memory in mind. With most 98 Systems this will be quite low, with NT systems, slightly higher and with 2000 or XP much better.

If you are exporting - every 15 mins. for every name for 4 full years --- this adds up to a lot of events.  This means thousands events are being "requested" pretty much constantly from the database (especially on a slower machine) while it may still be trying to process the last request. So you are taxing your server machine to the point of running out of system resources.

Solution:

Change the WebViewer settings. If you're running on Windows NT, try a maximum of every 1 hour for a period of  just 1 year at a time for a starting point unless you increase your machine speed. If you're running Windows 98, try every 2 hours for a period of 1 year.

It also depends on the number of events you typically create for each day and each name. These guidelines cover names lists that contain up to maybe 50 names.

#6- Server isn’t responding to my client users

Check to be certain the Office Tracker Server is running. Open your web browser and enter: http://serveripaddress:8001.  If you get a message stating  Page Not Found, it may have been shut down.  If so, you need to restart the Server.

If you can access the Admin page, click the View Log button and check for error messages or a message indicating the Server is rebuilding.

#7- One of my client users can't see the events they created.

Office Tracker uses a scheme where the identity is part of the event data record. If a user changes their identity, events may display differently. Check "File: Identity" to see what the current Identity is, then try choosing another Identity from the drop down menu in the Identity window. If the user created events under another identity you will either have to set up Sharing Privileges for that Identity and view the schedule with both names showing (group view) or re-create the events under the proper identity.

#8- My client users connected and the events went away.

This usually happens if someone moves the Office Tracker Server to another machine or directory and forgets to move the data files.

NOTE: If you do not have the “OTDatabase” folder in the “OTServer” directory, a new empty data file folder is automatically created. Since it is the master file directory, the clients are updated when they connect (meaning they are updated to a new "clear" status). To fix this problem, you need to Stop the Office Tracker Server, locate your most recent backup of the “OTDatabase” folder and put it back into the “OTServer” folder where it belongs, then restart the server.

#9- Client Users are Getting Error Messages

On occasion, a client's local data file "otclient.mdb" on Windows clients or "Schedule Data" on Macintosh clients, can become corrupt.  This can happen if the machine has a hard crash, etc.  If one of your client users is getting error messages or can’t get updates from other users, you may need to reset the client database. See #11 for instructions.

#10- Client Users Can’t Connect to Server or Can't "Hold" Their Connection

There are several conditions that can cause this problem.

If you have too many applications running on your server machine there may not be enough processing time for the Office Tracker Server.

If you are able to access the Office Tracker Server Admin pages with your browser but can not connect to the server with a client there is a possibility the Office Tracker Server was unable to initialize the client port (4300) on the server. To correct the problem, follow the steps below.

Stopping and Re-starting the Office Tracker Server

1. Stop the Office Tracker Server by choosing “Stop Office Tracker Server” from the launcher in your Task Bar, or if it’s running as a Service, Stop the Office Tracker Server Service in your “Services” Control Panel.

2. Wait for 3 minutes.

3. Restart the Office Tracker Server as you normally do.

4. Open your web browser and enter http://yourserveripaddress:8001, then go do the Names List. If the Registration window displays, enter your serial  number.

Test  your TCP/IP connection to the Office Tracker Server:

A program called "Ping" allows your computer to send a small packet to another computer with a request for a reply. You will need to know the IP address of the machine you want to test the connection to before you can use ping.

For a basic PING :

From the “Start” menu go to "Programs" and select “MS-DOS Prompt” or “Command Prompt.” This will open a DOS window.  Now type “ping  123.123.123.123” (Replace 123.123.123.123 with the IP address you want to check) and press enter. You will see some information displayed on the screen telling you how many packets were sent and how many were received and how long the transaction took in mili-seconds.

If you  see a message “Request timed out” this means you cannot make a connection to the IP address you entered.

If you see that a lot of the packages are lost, this can imply there is some type of network trouble.

Your IP Address May Not be Static

The Office Tracker Server must have a "static" IP address so client users can connect. To check your IP address on the server machine, follow these steps:

1.        Choose "run" from the "Start" menu.

2.        Type "winipcfg" (for Windows 95/98)

3.        Press Enter.

A window opens and displays the current IP address for the machine.  Make sure this is the same address you entered at the client machine.

For Windows NT users, either bring up the Command Prompt from the “Start/Programs” menu and enter ipconfig in the DOS window or select "Start>Settings>Control Panel"  then double-click the "Network" icon. Click the "Protocols" tab and then double-click your TCP/IP protocol to check your IP address for the machine.

#11 My clients aren’t behaving correctly, they can’t edit events or their schedule seems to “freeze.”

Re-setting the Office Tracker Server and Clients

There are some circumstances where you may need to do a re-set on your Office Tracker Server and clients. This usually occurs when files have been installed incorrectly, moved around during use, or when the server has been abruptly shut down and the data file corrupted.

To re-set the Office Tracker Windows clients you should follow these steps:

1. Open your web browser and go to the Office Tracker Server Admin pages. Press the Admin button, then press the "Rebuild" button. First, you will be asked if you'd like to make a back-up which you should do, then you can continue with the Rebuild. The Rebuild Successful page will display on completion. If not, the data file may be corrupt. You may need to follow the instructions for restoring a backup of your database file before you can continue. If you do restore a backup you will need to repeat this step again and be sure you get a successful rebuild.

2. On each client machine, Exit the Office Tracker application. Exit the Alarmer on Windows machines by right-clicking the Alarmer icon in the Task Bar and choosing Exit. Rename the file "otclient.mdb" in the Office Tracker folder to "otclient.mdbOLD."

3. Open the directory folder “reserve db” in the Office Tracker 4.0 client folder.  Make a copy of the file “Otclient.mdb” and put the copy into the main Office Tracker 4.0  directory at C: Program Files/Office Tracker 4.0.

4. Re-launch the client software, re-enter the serial number and choose "Connect" from the "Server" menu in the "Identity" window. Note: If the Identity window does not open automatically, choose "Identity" from the "File" menu.

5. Enter the Office Tracker Server IP address and click "OK".

6. Click "OK" in the Identity window.

The client should connect and begin retrieving events from the server. The local database file "otclient.mdb" will build from the server's master database file as the user moves from day to day.

#12 WebViewer Problem Where the Server Crashes Causing an Error

Note: This is a Windows NT Fix

The WebViewer uses Perl, a special programming language  that will leave itself  in memory if a user does not wait for the perl process to finish sending the browser the html message. The following steps will fix this by removing any perl.exe at a scheduled time.

Instructions on how to Automate the clean up process of Perl.exe from memory

1. Create a patch file with only this line in it:

e:\tools\kill.exe perl.exe

Name the file “ killperl.cmd”

Save it in the e:\tools folder.

2. Copy kill.exe file from the winnt resource kit into the e:\tools folder.

3. At the command prompt window, enter the following command exactly as shown.

C:\>at 22:00 /every:M,T,W,TH,F,S,SU "e:\tools\killperl.cmd"

4. Repeat the above command changing the time from 22:00 to the desired time for each scheduled time you would like to ensure the perl has been cleared from memory.

5. To confirm the results type c:\at and you’ll see a list of your scheduled times.

6. To delete a scheduled time line, type c:\at 2 /delete  (where 2 is the ID for the line that is shown when you type AT).

 

Reseting the Local Client Database File

If a client user is experiencing trouble it is often best to follow these steps to reset the client data file.

1. Exit from the Office Tracker software by choosing Exit from the File menu.

Windows Client Users:

a.  Use the right mouse button to click on the Alarmer icon (small clock icon in the lower right corner of your Task bar) and choose “Exit”.

b. Rename the client's local data file  ("otclient.mdb")  in the Office Tracker folder to “otclient.mdbOLD”.  Note: You won’t be able to rename it if you haven’t Exited from the Alarmer application.

c. Make a copy of the otclient.mdb file from the “reserve db” folder (right click on it and choose “copy”) then close the reserve db folder and right click and choose “paste” in the Office Tracker folder in the same location as the otclient.mdbOLD.  

Macintosh Client Users:

a. Quit the Office Tracker application. Rename the client’s local data file (“Schedule Data”) located in the Office Tracker folder to “Schedule Data OLD”.

2. Go back to the client machine and restart the Office Tracker from the “Start” menu, re-entering the serial number and Server IP address in the Identity window (‘File” menu).

This is like starting the client as a new connection and will create a new local schedule file on the client's machine using the server for data collection. It will take a few minutes at first for the client to get the updated events from the server but once the client has viewed the data, it will again be stored in the local file.

Office Tracker Client Tips

The following tips are useful in diagnosing and assisting with client trouble.

Windows 95 Potential Problem: Running the 4.0 or higher client on Windows 95 machines.

There can be a problem setting up the 4.0 or higher version of the Office Tracker client on Windows 95 machines if the wrong version of the MDAC file exists. If you get an error message about OLE you know you have this problem. Take the following steps to fix the client install on Windows 95.

1. Locate and download MDAC from the following web page: http://www.microsoft.com/msdownload/uda/mdac21/mdac_typ21.asp

2. Install MDAC.

3. Launch the Office Tracker client.

4. "Select Existing" button from the dialog that appears

5. Select the "Microsoft Jet OLE DB Provider" or the "Microsoft OLE DB Provider for ODBC Drivers" from the list

6. Press the next button.

7. Select the button "..." to the right of the data base name field.

8. Navigate to the Office Tracker folder - the default path is C:/Program

    Files/Office Tracker.

9. Select the file "otclient.mdb"

10. Press the "OK" button.

11. You should now see the registration screen for the client.

#1- Event notifications aren’t being created

Check the client’s notification preferences by choosing "Preferences" from the “Edit” menu on the Office Tracker client machine, then click the icon Events and be sure the “Auto-create Notifications” option is checked (on).

#2- Client can’t see their colleague’s events

Be sure the client has the necessary Sharing Privileges to view their colleague's schedule information. Also, be sure they have signed in under their correct Identity.

#3- Server seems slow

There may be more than one reason for this. Check the frequency of the WebViewer exports. If you are exporting “Every 15 mns.” You likely need to change this seeting to “Every hour” or “Every 3 hours.”

A large number of non-default Sharing Privileges can slow down server performance, especially when a new user connects for the first time and needs to retrieve all permission information concerning their name. Once all users have retrieved the initial  Sharing Privileges, server speed should increase.

Clients may see a slowdown if you have a large number of client users accessing one Office Tracker Server.  You might want to consider upgrading the server hardware to a faster machine.

Check how often the client users are “requesting” large group views.  For example, if several users have monthly group views saved with several names in them and they open and use the view regularly, the Office Tracker Server is receiving a very large data request each time they open and navigate with the view. In this instance, the best solution is to be sure the clients understand the purpose of creating group views and to recommend they limit access to large group views to an “as needed” basis only.

#4- When printing the monthly calendar the day in the calendar only shows the first character.

Choose Preferences from the "Edit" menu.  Click on the Schedule tab, then click on the font button (probably says “Arial”).  Select "Regular" for the style and set the font size to a smaller setting  like 8. If you need to reduce the font size smaller than 8 you can select the text field that displays the current font size and type in your new size.

Press the OK button when you have finished then press the "Apply" button to have your changes saved.  Press the OK button. Your monthly calendar view should be corrected.

#5- The Office Tracker client crashes and the next time you launch it does not communicate to the Office Tracker Server

Clients see a small unplugged icon in the upper right corner of the Office Tracker window and you know that the Office Tracker Server is running, you will need to do the following.

From the File menu in the Office Tracker Application select “Identity...” when this window opens press “Connect to Server.” Enter the IP address of the Office Tracker Server and press OK

#6- When I open a saved  schedule view it comes up with nothing in the window, no columns or names.

With the saved view open, set the View to "Daily," select “Set Column Widths...” from the View menu. In the "Set Column Width" window press the “Fill Client Area” button. This should fix the display. You should save the file now to save the new settings. If this does not work you will need to recreate the view and delete the damaged view from the Office Tracker folder.

#7- When in the Daily view the screen flickers like an old movie. (Windows client problem)

This can happen if you set the schedule view Preferences to display a time that Ends before the Start time. To fix it, choose “Preferences” from the “Edit” menu, press the “Schedule” tab and enter an Ending time that is later that the Starts time.

Upgrading and Moving the Server

How to Upgrade Office Tracker From 3.7.3 to 5.0.x

If you have already upgraded to a version of 4.0.x,  (4.0.1, 4.1.2, etc.) see instructions for upgrading from a 4.0 or 4.1 version to 5.0.

Important: You must be running the Office Tracker 3.7.4 Server or later version before you can upgrade to version 5.0.x. Instructions for upgrading to 3.7.4 are included below. Please do not attempt to upgrade an earlier version. To check the version of the server. open the "Admin" page and look at the bottom where it says "Version Number:"

If you did not get the latest version on CD ROM you can download the upgrades from the following link, after reading about changes, known bugs and how to upgrade: http://www.officetracker.com/html/upgrde40.html. This page also shows which version is the latest (at the top of the page)

Please do not skip steps. Be sure you have backups of all your Office Tracker files, stored on disk before you begin. Read through these instructions and read the list of changes and the list of known bugs before beginning the upgrade process.

First, download the Windows Server 3.7.4 update (unless you've done so)

Download the Windows Multi-User Version 5.0 here


If you are running version 3.7.3 or earlier begin here

1. Make sure all clients have synchronized their schedules to the server and instruct them to Exit the Office Tracker client software. Client users will not be able to use the Office Tracker software during this upgrade process. You may want to instruct your Office Tracker users to make printouts of any pertinent schedule information so they can work from paper during this time.

2. From the Office Tracker Server "Admin" page press the "Backup" button to back up your current Office Tracker Server data file ("OTDATA").

3. From the Admin page press the "Rebuild" button to rebuild the Office Tracker Server data file. Allow this process to complete and report back to you that the rebuild was successful.

4. Stop the Office Tracker Server then verify the jrew is not in memory in your Task Manager (press Control-Alt-Delete to view the Task Manager).

5. Download and install the 3.7.4 DLL update from the www.officetracker.com/html/upgrade40.html web site. You will need to unzip the archive "374DLL.ZIP". You will have two files.

6. Copy the file "otplib.dll" to the following directory: "C:/Windows/System" or "C:/WinNT/System32." You will be asked if you want to replace the one that is already there, reply Yes. Copy the file "OTPServ.zip" to the following directory : "c:/Program Files/OTServer/Jigsaw/Classes". You will be asked if you want to replace this file, reply Yes.

7. Launch the 3.7.4 Office Tracker Server from the Start menu or Start the Office Tracker Server services if it’s installed as a service.

8. Go to the Admin page and verify the version number is now 3.7.4

Note: You may need to empty your web browser cache before the new version information will display. Choose Internet Options from the Tools menu in MS IE 5.0 and press the “Delete Files” button.

 

If you ARE running version 3.7.4 (or just upgraded to it) begin here:

Please do not skip steps. Be sure you have backups of all you Office Tracker files, stored on disk before you begin. Read through these instructions and the pages covering changes and known bugs before beginning the upgrade process.

Important: You must be running the Office Tracker 3.7.4 Server version before you can upgrade to version 5.0. Please, do not attempt to upgrade an earlier version. See above for information on how to do this.

You will need to allow some time for the import of the 3.7.4 file to the new 5.0 version because of the new SQL database structure. Please be sure to do this upgrade only when you can have your server tied-up for about an hour without client access.

1. If you received the latest 5.0 version on CD ROM, locate the “OTSERVER.exe” on the disk. If you do not have the latest version, download it from the Milum web site at: http://www.officetracker.com/html/upgrade50.html. This page will have the most recent version available.

If you are downloading the OTSERVER50.zip, once you unzip it you will have one installer named "OTSERVER.exe" and one named "OTCLIENT.exe."

Don't run these installers yet, but continue on until instructed to run the installers.

2. Perform a "Rebuild" on the Office Tracker Server with the 3.7.4 version by going to the "Admin" page and pressing the "Rebuild" button one time only. This will create a file named "Otpdbbkp" in the current working directory, usually the OTServer directory. Let the rebuild complete until you see the “Rebuild Completed” page.

3. Make sure all clients have synchronized their schedules to the Office Tracker Server, they may want to print out necessary schedules so they can continue to work on paper, and enter any "penciled in" schedule information once the upgrade is complete.

4. Instruct the clients to Exit the Office Tracker client software. Client users will not be able to use the Office Tracker software during this upgrade process.

5. Make a backup copy of the "Otpdbbkp" file and move a copy of this backup to a safe place (another disk or at least another folder).

6. Stop the Office Tracker Server by pressing the Stop Server button on the Office Tracker Admin page. Then open the task manager by pressing (Control-Alt-Delete) and end the Task/Process "JREW"

7. Rename your current OTServer directory folder (in your Program Files) to "OTServer374" Note: To rename a directory you can right mouse click on the folder and choose "Rename" from the menu then type in the new name.

8. Install the Office Tracker 5.0 Server by running the installer "OTSERVER.exe" on the server machine.

9. Stop the Office Tracker Server by choosing "Stop Office Tracker Server" from the launcher icon in your Task Bar or by stopping the service if it's running as a service under Windows NT or 2000.

10. With the server stopped, move the file "Otpdbbkp" to the Import directory which is "Program

Files/OTServer/Jigsaw/Jigsaw/Www/Milum/Import/."

11. Move the "OTPSettings" file from C:/Program Files/OTServer374/Jigsaw/Jigsaw/www/Milum/ to the new directory: C:/Program Files/OTServer/Jigsaw/Jigsaw/www/Milum.

12. Start the Office Tracker Server from the launcher icon in your Task Bar or by starting the Office Tracker Server service if it's running as a service under Windows NT or 2000.

13. Launch your web browser and enter your log in information to access the Admin pages such as: http://yourIPaddress:8001.

The import process may take up to an hour or more depending on the size of your database files.

Important: Do NOT rename the server to a different name when you register the 5.0 serial number. It should display the same name you were using and this needs to stay the same. If you did rename the server you will need to press the Serial Number link and change it back to the old name.

14. Open the Office Tracker Admin page from your browser and check that the version now is 5.0. You should also check the Names List to verify the import worked. You should see all of your user's names and resource names as you did with version 3.7.4. If you have a long list of names it may take a few seconds for the whole list to display. If not, please contact Milum support at: support@officetracker.com

If you have a problem please contact Milum's technical support either by e-mail at support@officetracker.com or by telephone at 512-469-2967. Note: If you do not have a support package you may need to purchase support before you can talk with a representative.

You can now upgrade the clients to 5.0. Note: You can run 3.7.x and later clients with the 5.0 server. It may take a while to update the client's sharing privileges and event information from the server to the new database file. This is especially true if they open a view with many names in it. This will not happen every time, as once they get the information from the server they don't have to get it again until a change is made. Client users will see the messages "Gathering Events" or "Getting Permissions" in the lower left corner of their Office Tracker window.

 

Upgrading Clients from 3.7.x to Version 5.0

Important!: You must upgrade the Office Tracker Server to 5.0 before upgrading the Clients.

The Office Tracker 5.0 client uses a different data file format than the 3.7.x client. This means you will need to reconnect to the Office Tracker Server as you would if it was a new install.

1. The client application "Office Tracker" should not be running if you followed the instructions for upgrading the Office Tracker Server. You should also be sure to Exit the "Alarmer" application by right-clicking the Alarm icon in the Task Bar.

2. Run the Office Tracker client installer on each of the client computers (you'll need to move a copy of the installer to their machines first or place the installer in a shared directory that is accessible to all Office Tracker users) by double-clicking the "OTCLIENT.exe" application icon.

3. Start the Office Tracker client from the Start menu and enter your 5.0 serial number.

4. If the Identity window does not display, select Identity from the File menu.

5. Press the "Connect to Server"  button at the bottom of the Identity window and enter the IP address or Machine Name of the Office Tracker Server.

6. Press the OK button.

7. When the name of the Office Tracker Server appears in the "Server" area of the Identity window press the "OK" button to complete the connection.

Note: It may take a while to update your sharing privileges and event information from the server to your new database file. This is especially true if you open a view with many names in it. This will not happen every time, once you receive the information from the server you don't have to get it again until a change is made. You will see the messages "Gathering Events" or "Getting Permissions" in the lower left corner of your Office Tracker window.

8. You may need to choose "Open" from the "File" menu and open your saved schedule views. Once you open them, it is also recommended that you “Save As” and re-save them with the new 5.0 file format. You can leave your schedule views open when you Exit the Office Tracker client application so they will be "remembered" next time you launch the application.

 If you have a problem please contact Milum's technical support either by e-mail at support@officetracker.com or by telephone at 512-469-2967. Note: If you do not have a support package you may need to purchase support before you can talk with a representative.

 

Upgrading the Server from Version 4.0.x or later to version 5.0

(If you have been using a 4.0 demo this also applies to you)

1. Stop the Office Tracker Server by using the launcher in your Task Bar (version 4.0.x and later) or by stopping the Office Tracker Server Service if it’s running as a service under Windows NT, 2000 or XP.

2. Make a backup of your entire OTServer directory to another disk before upgrading

3. Press control-alt-delete and end the process javaw.exe if it is still running after you have stopped the Office Tracker Server.

4. Run the otserver.exe installer by double-clicking it and following the on-screen instructions.

5. Start the Office Tracker Server by selecting “Start Office Tracker Server” from the launcher in your Task Bar or by starting the Office Tracker Server service in your Services Control Panel.

Note: If you are doing an upgrade and choose a different drive this time, you will need to move your data. You will need to stop the Office Tracker Server, copy and paste your OTDatabase folder and OTPSettings file from the current installed drive to the appropriate locations on the new drive, and restart the Office Tracker Server. The location of the OTDatabase folder is: C:/Program Files/OTServer  and the location for the OTPSettings file is the following path: C:/Program Files/OTServer/Jigsaw/jigsaw/www/milum/. 

Upgrading the Clients

1. Exit the Office Tracker client application.

2. Run the OTCLIENT.EXE installer.

3. Start the Office Tracker 5.0 by selecting Office Tracker  from the Start menu or by double-clicking the shortcut on the desktop.

 

Moving the Office Tracker Server Software to a New Machine.

1. Log into the Office Tracker Admin page via your browser and press the Backup button to make a backup of the current data file.

2. Stop the Office Tracker Server software by using the launcher in your Task Bar or by stopping the Office Tracker Server service.

3. Make a backup copy of the entire OTServer folder. Store this copy on another disk in case of a problem so you can get back to your data.

4. Install the Office Tracker Server software on the new machine. Note: If you are installing your new server on Windows NT/2000/XP after installing you will need to stop the Office Tracker service on the new machine before continuing unless you cancelled the auto start option in the installer.

5. Make a new folder named OTServerData on the current Office Tracker server machine.

6. Locate and copy the latest backup file example "otdatafri.xml" or "otdata38437438.xml" in the OTP_Backups folder to the new folder OTServerData , locate and copy the "OTPSettings" files on your current server to the new folder OTServerData. The "OTP_Backups" folder will be in the following location. "Program Files/OTServer/Jigsaw/Jigsaw/www/Milum/OTP_Backups" The OTPSettings file will be located at "Program Files/OTServer/Jigsaw/Jigsaw/www/Milum."

7. Move a copy the folder OTServerData to the new server machine.

8. Copy the file OTPSetting from the folder OTServerData to OTServer/jigsaw/jigsaw/www/milum. Copy the file that ends with .xml from from the folder OTServerData to the following OTServer/jigsaw/jigsaw/www/milum/import.

9. You can log onto the Office Tracker Admin page after you start the Office Tracker Server to see when the server completes importing the data.

If you move the Office Tracker Server to a new machine and keep the same IP address you do not need to read any further. The Office Tracker client will connect to the new server automatically since the IP address is the same.

10. If the IP address of the newOffice Tracker Server machine is different, instruct all client users to do the following:

a. Choose "Preferences" from the Office Tracker Edit menu.

b. Select "Servers" from the tabs across the top of the Preferences window.

c. Click on the Server Name in the Server List area, then press the Delete button.

d. Click "Yes" when asked if you want to delete the Server from the list.

e. Click "Apply" and click "OK" to close the Preferences window.

f. Choose "Identity" from the "File" menu and press the “Connect to Server” button.

g. Enter the new server's IP address when prompted and click "OK" then "OK" again to log on.

 

How to Move the Office Tracker Server data from a Macintosh server to a Windows server:

Moving from one platform to another is a task that will likely take you a good part of a day. It is recommended that you pick a day where you will be able to work without a lot of interruption. It is also important for you to follow the instructions carefully and be sure you have current backups of all your Office Tracker Server files before beginning the process.

1. Back-up the Office Tracker Server folder on your Macintosh server before proceeding.

2. Locate the current Office Tracker Server's name. The name can be found in the Server Log Files or in the "Identify" window on one of the Office Tracker clients. Write this name down just as it appears, including capitalization.

3. Adjust the memory allocation on the Office Tracker Server. First Quit the server application, then from the desktop, select the Office Tracker Server icon and "Get Info" from the "File" menu. Set the minimum memory to a size that is at least double the size of the Office Tracker data file. For example, if the data file is 20MB, set the memory to 40MB.

4. Rebuild the Office Tracker Server's data file on the Macintosh server. (This can take 1-2 hours on large data files.) To rebuild the Office Tracker Server data file, hold down the Option key while restarting the Office Tracker Server application. Press the "OK" button when prompted.

5. When the rebuild is finished, select "Export..." from the "File" menu. (Make sure your users' lists are open before exporting)

6. Select the date range to export.

7. Select "Java Server" From the format drop down menu.

8. Press the "OK" button, You will be presented with a save dialog with the file name "OTPXData" already in the name field (Do not change the name.) Press the Save button. This Export can take up to 1 hour if the data file is large.

9. Prepare the Office Tracker Server on the Windows server by following the Install instructions as described in the section "Installation" in the Server Administrator's guide.

10. Once the Windows server is installed, start the server and log onto the Admin. web page and press the Admin. button. Detailed instructions are in the section "Getting Started With Office Tracker" in the Server Administrator's guide.

11. You should now see the Registration screen. Set the Server Name to the name you wrote down in step 2. Make sure the Name is exact. Enter your serial number in the space provided. Press the Register button when you have completed the changes.

12. Quit the Office Tracker Windows server. To quit the Windows server, go to the Admin. page and press the "Stop Server" button and press the "OK" buttons on the confirmation dialogs. Open the Task/Process manager and verify the Process/Task "javaw" is not running. If this process is running you will need to end the Task/Process "javaw"

13. Locate the file "OTPXData" on the Macintosh server. Move the "OTXData" file to the "Program Files/OTServer/Jigsaw/Jigsaw/www/milum/Import" directory on the Windows server. (Do not move the "OTPXData" to a Novell Server, this will damage the file.)

14. Start the Office Tracker Server on the Windows Server by choosing it from the "Start" menu. The "OTPXData" file will be automatically imported. This process can take up to an hour. You can tell the import is complete when you have very little drive access.

15. Log onto the Admin. page of the Office Tracker Server for Windows and verify your names appear in the Names List.

16. If you have been connected to the Macintosh Office Tracker Server, you will need to delete the clients local data file and make a fresh connection to the new server. The local data file on the Macintosh client is "Schedule Data". The Local data file on the Windows client is "!schedul.eda". You should also delete then recreate any saved views you created while connected to the Macitosh Server.

 

Using the Office Tracker Server with an ODBC Data Source

The Office Tracker Server ships pre-configured to use the 100% pure Java database “InstantDB” by Lutris www.lutris.com.  If you wish to use an ODBC data source for the database for the Office Tracker Server you will need to do the following.

We will be adding documentation later for using other database formats such as Oracle, Sybase, MS SQL Server and other databases.

Follow the instructions below to switch the Office Tracker Server to an ODBC data source.

1. Stop the Office Tracker Server.

 

2. Make a backup copy (to another disk) of your “OTDatabase”  folder in the OTServer directory and your “OTPSettings” file located in: Program Files/OTServer/jigsaw/jigsaw/www/milum.

3. Open the ODBC Data Source control panel. You can access this control panel from the Start menu at Start>Control Panel>ODBC Data Source. If you do not have the ODBC Data Source control panel installed you will need to locate the Installer on the Microsoft web site at www.Microsoft.com.

4. With the “ODBC” Control Panel open, press the “Add” button to create a new ODBC data source. This will display the "Create New Data Source" window.

5. Select "Microsoft Access Driver" from the list of available drivers and press the "Finish" button.

6. Type the Name "OTServer" in the Data Source name field. You can add a description to the Description field if you wish.

7. Press the "Create..." button, This will open the "New Database" dialog. Select the directory (Folder) you wish to save the database in by navigating to it in the Directories area on the right side of the dialog (Milum recommends the “OTServer” directory). Once you have selected the directory where you want to save the data file, type a name for the data file, example "OTServerData.mdb". Press the "OK" button to save your settings. You should see a dialog confirming the database creation.

8. Close the Windows for the ODBC Data Source by pressing "OK" on each one until the control panel is closed.

9. On the Machine with the Office Tracker Server installed locate and open the file "OTPSettings." This file should be located in the following path "C:\Program Files/OTServer/Jigsaw/Jigsaw/www/Milum".

10. You will need to change the following text in the settings file, We will be using the data source name "OTServer" we created earlier. Be careful the text must be exact!

Locate the section in the OTPSettings file with the following text:

jdbcurl=jdbc/:idb/=OT.prp

Change the string to the following text:

jdbcurl=jdbc:odbc/:OTServer

Locate the section in the OTPSettings file with the following text:

jdpcpropfile=InstantDB.prp

Change the string to the following text:

jdpcpropfile=MSSQL.prp

Locate the section in the OTPSetting file with the following text:

jdbcdriver=org.enhydra.instantdb.jdbc.idbDriver

Change the string to the following text:

jdbcdriver=sun.jdbc.odbc.JdbcOdbcDriver

11. Locate the backup file created earlier, this file should be located in the following path “c:\Program Files/OTServer/Jigsaw/Jigsaw/Www/Milum/OTP_Backups” The file you are looking for will be the most recently created file. You can set your view to “Detail” to see when the files where created.

12. Make a copy (Do Not Use The Original file) of the most recent back up file from the OTP_Backups directory to the “Import” directory at the following path “c:\Program Files/OTServer/Jigsaw/Jigsaw/Www/Milum/Import”

13. Launch the Office Tracker Server as you normally do. The backup file will be imported to the new ODBC data file and the Office Tracker Server will use the specified data file from now on. The Import may take some time depending on the size of the file you are importing. You can tell when the Server is finished as the drive indicator will return to normal. Usually takes from 10 to 120 mins.

14. Once the Import has completed you will need to log onto the Servers Admin pages to verify the data has been imported. You should go to the “Names List” and verify all your names are present, If your users list has been imported and all looks well, you should check the View Log from the Admin page to check for any error messages.

 

Office Tracker Palm Sync Setup

General Guidelines and Requirements:

• You cannot run the Office Tracker Server software (version 4.1 and later) on a machine with the Palm Synchronization software installed. If you are running the Office Tracker Server and Office Tracker client on one machine, you will not be able to synchronize that client with the Palm Pilot.

• Currently the OTPalm is a one-way sync – meaning events can be downloaded from Office Tracker to your Palm, but not uploaded from your Palm to Office Tracker. You cannot edit –OT events on your Palm and re-sync them.  This feature may be available in future versions.

• The range of events each client will receive when they do a palm sync depends on the settings you have created in the Office Tracker Server Palm Settings area.

• The OTPalm Sync software requires that the Network Hotsync manager is installed on your palm device.

• The Office Tracker Server uses port 14238 to sync to the palm pilots on your network. If you plan to allow internal syncs only you should not open this port. This port will need to be opened to sync from an Internet connection. Refer to your Information Systems department or the person who handles your routers.

 

Setting up the Office Tracker Server to Work with OTPalm Sync

Entering your OTPalm Sync Serial Number

1. Click the Palm Settings icon from the Office Tracker Server Admin page.

2. Enter the Palm serial number from the front of your CD ROM cover.

3. Click the “Update Settings” button and then click “OK” to accept your number.

Creating or Editing the Date Range for Palm Synchronization

The recommended settings for your Palm Sync is already entered by default. If you find that you need to change this time range so users get events further into the future, you can edit the settings by following the steps below.

1. Click the Palm icon in the Office Tracker Server Admin page.

2. Change the number of days for “Sync Backward” and “Sync Forward” to the number of days you would like to use.

3. Click the “Update Settings” button. Click “OK” when asked if you are sure you want to save changes.

4. Press the “Close” button to close the Palm settings window.

Setting Up the Palm Sync Software

The OTPalm software lets you synchronize events created on the Office Tracker scheduling system to you palm device.  The OTPalm Sync software requires that the Network Hotsync manager is installed on your palm device.  Once this software is installed, you may download your events from the Office Tracker Server to your palm device from your Office Tracker client computer.  The following outlines what is required to set up your palm and client computer to sync with the Office Tracker system.

1. Installing the Network Hotsync Manager on your Palm Device

First determine whether or not your Palm device has the Network Hotsync manager software.

1. Tap the Hotsync icon in the main applications area.

2. Tap the Menu icon to show the Options menu.

3. If the Network Hotsync manager is present, LANSync Prefs will appear in the menu list.

If the Network Hotsync manager is present, perform a local hotsync first before attempting to connect to the Office Tracker Server. 

If the Network Hotsync manager is not present, you must complete the following steps to install the Network Hotsync manager on your palm device.

1. Download the manager from the palm website: www.palm.com/support/downloads/netsync.html

2. Unzip the file into a local directory (such as C:\Temp).  You should see the file Netsync.PRC in the local directory. 

3. Run the Palm Desktop (must be version 3.0 or greater) and click on the Install icon. 

4. In the Install dialog, click Add and locate the file Netsync.PRC.

5. Select the file Netsync.PRC for installation. 

6. Connect your palm to your computer with the hotsync cable and do a local hot sync.  This will install the Network Hotsync manager on to your palm device.

7. Verify the installation worked properly by following steps 1-3 above.

2. Setting up your Palm to connect to the Office Tracker Server

1. Tap the Hotsync icon in the main applications menu.

2. Tap the menus icon to bring up the Options menu.

3. Select Primary PC Setup.

4. Enter “!!” for the Primary PC Name.

To enter “!!” first tap the keyboard icon “abc”, tap the “Shift” key on the keyboard, then tap the exclamation point two times.

 

5. Enter the Office Tracker Server IP address for the Primary PC Address.

6. Enter 0.0.0.0 for the Subnet Mask, or leave it empty.

7. Tap OK.

8. Tap the menus icon again to bring up the Options menu.

9. Tap LanSync Prefs.

10. Select LanSync and tap OK.

3. Setting up your local client machine for Palm Sync to the Office Tracker Server

1. Run the Palm Desktop software

2. Make sure the Hotsync Manager is running, it should show up in the taskbar.

3. In the Palm Desktop, select the Hotsync/Setup menu item.

4. Click on the Network tab.

5. If your username is checked, uncheck it.

6. Click OK.

7. Right-click the Hotsync Manager Icon in the taskbar.

8. If the Network item is not checked, click on it to activate it.

9. If the Local Serial or Local USB item is not checked, click on the appropriate item to activate it (depending on the type of hotsync cable you have).

4. Perform a Palm Sync to the Office Tracker Server

You are now set up to perform a Palm sync to Office Tracker.  Connect your palm device to the hotsync cable on your client computer and press the hotsync button.  You should see the Datebook updating and once the hotsync is complete, you should see your events from Office Tracker in your Datebook.  All Office Tracker events have “-OT” at the end of their name/description field.  Every time you sync with the Office Tracker server, your old OT events will be erased and the latest OT events will be added to your palm device for the time range set by the server administrator.

If the Office Tracker Server does not have the OTPalm Sync software configured it will time out after several seconds and your Palm unit will tell you that the connection could not be established. Contact your Office Tracker Server Administrator to let them know if you can’t connect.

Note: This is a one-way sync. You cannot edit –OT events on your palm and re-sync them. You must edit them from Office Tracker itself. 

5. Switching to and from Office Tracker Sync to Local Sync

To perform a local hotsync once you have done the setup described above, you must complete the following steps:

1. Tap on the Hotsync icon on your palm device.

2. Tap on the Menus icon to see the Options menu.

3. Select the LANSync Prefs item

4. Select Local Hotsync and click OK.

5. Once you have done the local hotsync, to switch back to Office Tracker Hotsync, perform steps 1-3 and then select LANSync and click OK.

6. Switching to and from Office Tracker Sync to regular Network Sync

To perform a network hotsync to your Palm Desktop once you have done the setup described above, you must complete the following steps:

1. Activate your Palm Desktop.

2. Select the Hotsync/Setup menu item.

3. Click on the Network tab.

4. Check your username.

5. Perform a local hotsync.

6. Once you wish to perform an Office Tracker palm sync in the future, you must complete the steps in paragraphs II and III, above.