Version 5 of Timesheets requires major updates to the database files. Once
upgraded you will not be able to use any new Timesheets 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.
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 an older version to version 5
1) download the DB conversion software from https://www.cybermatrix.com/download/tsdbisam2edb.zip.
2) unzip this file into your old data folder. For Timesheets Standard the
data will be stored in the user Documents\CyberMatrix\Timesheets folder. E.g. C:\Users\Administrator\Documents\CyberMatrix\Timesheets.
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 4 to
version 5. 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 v5 and import the CSV files into
v5.
Part of the data updates in V4 include the Date field in the EmployeeTime
table changed to WorkDate and the Date field in the Invoices table changed to
InvoiceDate. If you have created new reports using these fields you will have
to modify them to use the new names.
Steps to upgrade data from version 4 to version 5
In the Data Manager of v4, 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/tsedb2unicode.zip.
2) unzip this file into your old data folder. By default the data will be
stored in the Public Documents\CyberMatrix\Timesheets folder. E.g. C:\Users\Public\Documents\CyberMatrix\Timesheets.
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 Timesheets installer to install v5.
Upgrading to a newer version of Timesheets V5
The easiest way to upgrade Timesheets 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.
