Note: It is advised that an Integrity Check should only be run if suggested by a HandiSoft Support Consultant.
If you want to run a database integrity check to check the stability of your Time+Billing database, read the instructions below carefully.
This should be run on the server, as this is generally the quickest machine.
This will take a number of hours to perform and is not quick.
Ensure a suitable backup has been made before completing this process.
All users must close out of all HandiSoft programs during the duration of the Integrity Check.
You may prefer to run this over a weekend on a machine that can be left running.
Raise a new case online and request a date-specific password to complete this process.
Clients using ODB
Read through the steps here: Time+Billing Data Integrity Test ODB PDF
At step 4, use this Time+Billing Data Integrity Test excel sheet for a list of reports you should run. Record the outcomes of each report as shown in the excel.
At step 7, the ‘Fix duplicate jobs’ and the ‘Transfer WIP to Open Job’ will take a while to complete. The Fix and Adjust will take a number of hours to complete. This can be left running.
Clients using SQL
Read through the steps here: Time+Billing Data Integrity Test SQL PDF
At step 2, use this Time+Billing Data Integrity Test excel sheet for a list of reports you should run. Record the outcomes of each report as shown on the excel.
At step 8, the ‘Fix duplicate jobs’ and the ‘Transfer WIP to Open Job’ will take a while to complete. As the Fix and Adjust will take a number of hours to complete. This can be left running.