Manage sample data

You can access the Manage Sample Data page in the application in two ways:

  • Directly from the System Admin menu under the Workspaces subsection
  • From the link at the bottom of the System Information widget on the Product Admin home page

From this page you can manage or delete sample data that comes pre-installed with the application.

Refer to the help documentation for more details about this functionality.

When can't you automatically delete Sample Data?

 Sample Data cannot be deleted, if:

  • the names of the users or workspaces have changed
  • your application has been upgraded at least once to a newer version
  • your installed version is earlier than 6.5

If any of the above situations apply please follow the instructions below.
 

Manually delete sample data

Delete Sample Products, Programs, and Portfolios

First, delete all the sample workspaces on your system, via the system administration > workspaces subsection:

  • View/Edit Products
  • View/Edit Programs
  • View/Edit Portfolios (SpiraPlan only)

Deactivate Sample Users

You can deactivate all sample users. Note that the system administrator (username "administrator" is not a sample user). To do so, edit each sample user, and set their "Active" flag to "No."

Delete sample users (on premise only)

On premise customers can permanently delete all sample users by running the SQL script below. Please note that this is a permanent operation that cannot be undone. We strongly recommend taking a database backup before running any SQL against your database, in case something goes wrong.

DELETE FROM TST_USER_PROFILE
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_COLLECTION_ENTRY
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CREATOR_USER_ID >= 2 AND CREATOR_USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CONTACT_USER_ID >= 2 AND CONTACT_USER_ID <= 13
GO
DELETE FROM TST_DATA_SYNC_USER_MAPPING
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_PROJECT_GROUP_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_PROJECT_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO

 

NOTE: If you are a cloud customer and want to delete sample users but cannot, please should open a support ticket with us and provide the URL of your Spira instance.