The following options are available for each workgroup in the Workgroup Database Operations section. With the exception of the Export Tables option, each of these options may result in permanent data loss and should only be used under the guidance of NetResults Technical Support or Professional Services:

To access the Workgroup Database Operations for a particular workgroup:

1. Login to the Workgroup Management System
2. Click on the Workgroup Database Tools icon to the left of the workgroup name on the Workgroup Management System Home Page.

   Optionally, you can get to the Workgroup Database Operations page by clicking on the Admin icon, selecting the option Manage Workgroup Database Operations, then clicking on the Continue button.

3. Select the radio button to the left of the option you wish to use (each is described in detail below), then click on the Continue button

Export Tables
Allows you to export all of the tables within the database in the form of comma separate text files (CSV). This is useful to create a snapshot of the database at any point in time, or to generate data in a format usable by third party utilities. The export operation exports the entire contents of the database to comma separate text files (CSV). The files are written to a subdirectory named Importer\ProblemTracker\Export\Data below the workgroup's installation directory. By default, the workgroup's installation directory can be found at C:\Inetpub\wwwroot\ProblemTracker\workgroup where workgroup is the name of the workgroup. Thus, if using the default installation directory the exported files can be found at C:\Inetpub\wwwroot\ProblemTracker\workgroup\Importer\ProblemTracker\Export\Data One file is generated for each table.

Initialize Tables
This operation creates the necessary database tables and populates the database with the initial data. This operation is typically run after using the Add Workgroup operation to add a SQL Server database rather than from this page.

Create Tables
This operation creates the necessary database tables without initializing them (empty tables). This function is typically used after performing a Migrate operation rather than from this page.

Delete Tables
This operation completely deletes all data (records, configuration settings, etc.) and tables from the database. This operation should not be used without the supervision of NetResults Technical Support.

Import Tables
Allows you to import an entire database in the form of comma separated text files (CSV). Due to data integrity issues spanning multiple tables, this feature should not be used without the supervision of NetResults Technical Support or Professional Services. Doing so will most likely result in a non-functional database (even though it may appear to work for a while) and is a violation of your license agreement if done without the supervision of NetResults Technical support or Professional Services.

Upgrade Data Only
This operation upgrades the database from a previous version of ProblemTracker to the current version. This operation will only upgrade the database. To upgrade the workgroup files, choose the relevant upgrade option in the WMS Admin section (by clicking on the Admin icon in the button bar of WMS).

Upgrade Users Only
This operation upgrades the user accounts in the workgroup to the latest version of ProblemTracker and adds them to the WMS User database. This operation will only upgrade the user accounts. If you need to upgrade the entire workgroup (the web pages, database, etc.), please go to the WMS Admin section and choose the relevant upgrade option (by clicking on the Admin icon in the button bar of WMS).