CS Time/TNA Documents

username password

Fixing data corruption

    If you are using the TopSpeed version of CS Time and you get error messages coming up on screen about possible data corruption in a file then you need to take action.  This document will take you through the steps for fixing data corruption.

    See the Data Corruption document for more information on what data corruptioin is and how to prevent it.



    Do a backup before you start

    It is always a good idea to make a backup of your CS Time data before you start fixing data corruption.  Close all open CS Time modules and use the CS Time Backup Module to create a backup.

    Freshening the files

    The first thing to do is to freshen your data files as this may resolve the problem.  When you are freshening a file, CS Time creates a new data file and attempts to copy the data from the original file into the new one.

    To freshen your files versions prior to CS Time (TNA6 and older), open the Configuration Module. Click on File, File Manager.

    If you ar running CS Time, click on your Windows Start menu, All Programs, CS Time and then File Maintenance.

    Fixing Data Corruption - 1.png

    Click on the Tag All button to select all the data files and then click on the Freshen button.  You may receive an "Unable to upgrade" error message on one or two files (e.g. Log) during the process - click on the Retry button to continue.

    Please note: this process may take some time to complete and you may not be able to do anything else on your computer while CS Time is busy freshening your files.

    Important: Do not interrupt this process!

    Using TPSFix

    If freshening the data files did not help, you can use the TPSFix utility that can be found in the CS Time application folder.

    Before you start make sure you know where the CS Time data is located. You can find this information in the User Module when you click on Help and About. The data is located in the path shown next to Reading From.

    Double-check that all the CS Time modules are closed and inform network users to no use CS Time until further notice.

    If CS Time generated an error message, the message will usually indicate which file is corrupt e.g. "Possible data corruption in file ... attempting to access a record from the DAILYHOU file". You can then use this as a starting point – depending on how far the corruption has spread, you may need to run checks on the other entire major files as well.

    Alternatively, start with fixing the main files (clockings.tps, dailyhou.tps, errors.tps, warnings.tps, weeklyho.tps). Once those are done then move on to all other files that contain data – (card, classifi, criteria, employee, leave, movedail).

    1. Run the tpsfix.exe program (usually found in the CS Time application folder).




    1. Under the Source (file to recover) heading, next to the label Filename, click on Browse.   A windows explorer window will open.  Navigate to the CS Time data folder and double-click the file you want to test / fix e.g. clocking.tps.  A destination file with a TPR extension will now automatically be visible.  Click on the Next button.


    1. You can specify an example file if you have previously attempted to fix the file without success. See the section: Creating an example file at the bottom of this document.
      Untick the Header option and click on Start.

    2. TPSFix will now scan your selected file for errors.

      1. If no problems are found you will be prompted to select whether to continue to extract the data to the result file or not.


        Click on No.  Read on from point 5.

      2. Any errors found will be shown during the scanning process. 


    TPSFix will automatically start extracting data if any serious errors were found.


    1. When TPSFix shows a Finished message click on OK to close TPSFix.  To test and scan other files repeat the process from point 1.

    2. Now you need to rename and build the fixed files.  Open your CS Time data folder in Windows explorer and rename the original *.TPS and the fixed *.TPR files.  For example: if the clocking.tps file was fixed, rename the clocking.tps file to clocking.tp1 and then rename clocking.TPR to clocking.tps.  Do this for all the repaired files.

    3. Open the File Manager/Maintenace (see the section on Freshening the files above). Select the files that were fixed and click on the Build button. 

    Fixing Data Corruption - 1.png

    CS Time will now build the keys used for sorting your data.  When this process is complete you can close the File Maintenance Module and re-open the CS Time Server module.

    Creating an example file

    If a file is so badly corrupted that TPSFix cannot recover the data run TPSFix again using an example file.  An example file can be created as follows:

    1. Rename the corrupt file e.g. rename clocking.tps to clocking.org.
    2. Open the File Maintenance Module
    3. Select the file you want to recreate and click on Info.  Normally this will create a new empty data file. 
    4. Now change the extension of the newly created file to TPE e.g. rename clocking.tps to clocking.tpe.
    5. Change the extension of your original data file back to TPS e.g. rename clocking.org to clocking.tps.
    6. Run tpsfix again, but this time select the clocking.tpe file you have created as the example file in point 3 above.


    Permalink:  http://tinyurl.com/6u6oobt

    Page last modified 09:32, 28 Jul 2014 by Admin CS Time/TNA Documents > Advanced > Fixing data corruption


    You must login to post a comment.
    Attach file


    Powered by MindTouch Core