Database Updates for Existing Timesheets Users


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. The steps to upgrade your 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
http://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
http://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.


Timesheets Video Demo

Timesheets Help

Latest Testimonials

Adam Killick, SysAdmin and Main Programmer, Bawtree Software

CyberMatrix Timesheets has worked very well for us here at Bawtree Software. It is a very reliable piece of software; as well, easy to use.

Ken Maglothin, COO, Hotsy Equipment Company

...your program is well thought out, very intuitive, easy to us, and very scalable. It is exactly what we were looking for.

Steven

I like the program, and am very impressed with the speed of your response to my inquiries. Thank you for the great customer service, it is rare these days.

Richard Piecuch, MES Vision

I wanted to thank you for the quick turnaround...I also wanted to let you know that your tool is working our great for our solution. Great job.

Kathy Palmer, Director of Event Services, The Student & Youth Travel Association

It allows us to produce reports for our client showing how many hours we worked on each of their initiative. It helped us to secure funding for another staff person based on tracked hours.