Database Updates for Existing Project Clock Users

Version 10 of Project Clock requires major updates to the database files. Once upgraded you will not be able to use any new Project Clock data with older versions. Therefore, it is strongly recommended you backup your existing data before installing.

For enterprise editions, you can examine the SQL scripts for your database server to determine which modifications to make. In the program folder you will find a script for the recent updates to MySQL and MS SQL.

The steps to upgrade your non-Enterprise data are outlined below. However, the updates cannot be performed if anyone else is using the program. Before running this version, ensure no one else is running the application on your network. Check to make sure the Project Clock Icon is no longer in the system tray. Data from Project Clock version 4 or below cannot be used with version 10. If you are using Project Clock version 4 or below, you will need to send your data to us for conversion.

The steps below are quite tedious for the average user. Because of this we are happy to upgrade your data for you. Just backup the data in the old version's Data Manager, send us the backup file and we'll do the rest.

Steps to upgrade data from version 4 through 8 to version 10

1) download the DB conversion software from http://www.cybermatrix.com/download/pcdbisam2edb.zip.

2) unzip this file into your old data folder. For Project Clock Standard the data will be stored in the user Documents\CyberMatrix\ProjClock folder. E.g. C:\Users\Administrator\Documents\CyberMatrix\ProjClock.

3) run DBISAM2EDB.exe (for multi-user installs you should run this file from one of the client machines so a network database path is stored instead of a local path).

4) click the Upgrade Database button.

5) when the update is finished close down the conversion software.

6) install the software

Then complete the steps listed below to upgrade data from version 9 to version 10. You do not have to export the table to CSV as this will have already been done.

Alternatively you could just start over fresh and export any old data you want to keep in CSV format. Then upgrade to v10 and import the CSV files into v10.

Steps to upgrade data from version 9 to version 10

In the Data Manager of v9 export every table containing data you want to keep to CSV format. Use the default name supplied, do not change the filename. Export these files into the data folder.

1) download the DB Unicode conversion software from
http://www.cybermatrix.com/download/pcedb2unicode.zip.

2) unzip this file into your old data folder. By default the data will be stored in the user Documents\CyberMatrix\ProjClock folder. E.g. C:\Users\Administrator\Documents\CyberMatrix\ProjClock.

3) run EDB2Unicode.exe (for multi-user installs you should run this file from one of the client machines so a network database path is stored instead of a local path).

4) click the Upgrade Database button.

5) when the update is finished close down the conversion software.

6) run the Project Clock installer to install v10.

Upgrading to a newer version of Project Clock V10

The easiest way to upgrade Project Clock and continue using your old data is to simply install over the old version. Be sure to backup your data first as a precaution. If you want to use your old data in a new folder, you have two choices. You will either have to copy over your entire old data folder to the new folder and then point the software to use this new folder, or install data in a new folder and then copy over the database files.


Project Clock Video Demo

Project Clock Help

Latest Testimonials

Jeff Erickson, Director, Navigant Consulting

Thanks for a great product! I have been using it since Version 3.0.

Frances Wheeler, Wheeler Design

I do love this program simple and straight forward to use!

Derk Jan Bellink, Consultant BMD ERP Software, Austria

I have been using the program for years now and it is definitely a great help since punching in and out is really just a few clicks. Especially helpful when I am on site at a customer's office, billing my time away, and in between other customers phone me, so I have to interrupt billing to the "main" customer and register time for those who call instead...

Claire Thirlwall, Thirlwall Associates Ltd.

I've used Project Clock Pro by CyberMatrix for years for time recording. Very inexpensive and lots of easy reports.

Mary Seiger, Landmark Engineering

Perfect! We really appreciate it. This is a wonderful program and you are great to work with-so quick, efficient and friendly.