Knowledgebase : Deleting & Purging
Clearing Test Data From time@work and expense@work - Sep 24, 2009 - 6:57:14 AM
There may be situations where you need to clear all transaction data from a time@work or expense@work database.

Typically this occurs in situations where you need to remove test data from the system prior to go live or perhaps where you wish to create an empty test version of a live database.

A SQL Server Script which removes all transaction data is available for download at the bottom of this article.

This Script will erase all Transaction Data (but not Reference Data) in the system and should only be used by someone comfortable with Executing SQL Scripts. Additionally a backup of the database should be taken prior to running the Script.

Knowledgebase : Deleting & Purging
Purge Status Records - Apr 5, 2007 - 10:38:10 PM
The Purge Status Records Function in expense@work and time@work can be used to delete unwanted Forms and Timesheets from the system.

Status records track the progress of Timesheets and Expense Forms. They remain in the Status table until deleted by this function.



You should run this whenever you want to reduce the number of records in the Status table for performance reasons or if you want to delete unused forms and timesheets so they are no longer visible.