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 https://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
https://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.
