Data Validation

Data validation should be performed periodically if there have been hardware or networking issues. If you are unsure if you should use this tool please contact us. Data validation ensures that the database has all the correct data. There may be variances in the database if there have been networking or hardware issues.

Click Here to learn how to perform Data Validation

Data Validation Options

Patron Data

Validates patron data. If you have just imported patrons you can validate only that data by selecting the first option. The second option allow for a check of formatting for patron names addresses and company names. Recalculate balances updates all the patron balances according to the tickets they have bought and their payments. Finally you can ensure that the patron is recognized at the proper level for their donations. This option will recalculate the amount they have donated and ensure they have been acknowledged at the proper level.

Ticket Integrity

Verifies that all tickets for reserved seating events have been held and any tickets without a patron will be returned for sale.

Ticket Seat Codes

Verifies the seat codes for reserved seating performances. There are two sub selections dealing with seat codes. The first is to display any erroneous tickets on the theatre map for quick reference and visual representation of the problem. The second simply releases any seats which have a seat code error.

Mail List Count

This function updates the patron count of each mail list in the database.

GL Balances

Recalculates the totals of all GL accounts. This is performed for both monthly and yearly totals.

Tickets Without Order

Finds any tickets with zero as the order number and attempts to assign them a valid number.

Invalid Order #

Searches for orders with a order number of zero and assigns them a new number.

Reset Department

ONLY FOR OUTLET VERSION Resets all records in Theatre Manager allowing access from all outlets.

Reset Order(s)

Verifies that the flag used to ensure that a record is not simultaneously accessed by users is in the correct position. You may need to use this if a user prematurely exited the system.

Payment Transactions

Verifies the payment transactions for all donation receipts.

Price Codes

Removes price codes which are not connected to a play or a performance.

Sales Summary

Clears the Sales Summary reports and resets them allowing for summarization during the End of Day Process.

Performing Data Validation

Data Validation is performed using the Theatre Manager Data Validation Window. This window is accessed through the Data Base Utilities Window (Click Here to learn how to access the window) under the Database Utilities Menu at the bottom of the window.

Select the data you wish to validate
Single click the selection box to the left of each option to validate that option. Use the chart above or the descriptions beside each option to determine their function.
Click the OK Button to run the validation
If you do not wish to continue with the validations click Cancel . If you chose to continue with the validation the following window will open reminding you that the process may take some time.

Click Yes to continue

If you do not have sufficient time to run the validation click No to return to the Theatre Manager Database Validation Window to modify your chosen options.

The following window will open reminding you to ensure that you have made a backup of the database to prevent data loss.

Note: If you have not made a backup of your database do not continue past this point. If you do and a power interrupt occurs during the process you can easily restore the database without repairing.

Once you have a backup created click Yes to continue
The Working Progress Bar will open to show the progress of the validation.

When the verification has been completed you will return to the Database Utility Window.

Patron Data	Validates patron data. If you have just imported patrons you can validate only that data by selecting the first option. The second option allow for a check of formatting for patron names addresses and company names. Recalculate balances updates all the patron balances according to the tickets they have bought and their payments. Finally you can ensure that the patron is recognized at the proper level for their donations. This option will recalculate the amount they have donated and ensure they have been acknowledged at the proper level.
Ticket Integrity	Verifies that all tickets for reserved seating events have been held and any tickets without a patron will be returned for sale.
Ticket Seat Codes	Verifies the seat codes for reserved seating performances. There are two sub selections dealing with seat codes. The first is to display any erroneous tickets on the theatre map for quick reference and visual representation of the problem. The second simply releases any seats which have a seat code error.
Mail List Count	This function updates the patron count of each mail list in the database.
GL Balances	Recalculates the totals of all GL accounts. This is performed for both monthly and yearly totals.
Tickets Without Order	Finds any tickets with zero as the order number and attempts to assign them a valid number.
Invalid Order #	Searches for orders with a order number of zero and assigns them a new number.
Reset Department	ONLY FOR OUTLET VERSION Resets all records in Theatre Manager allowing access from all outlets.
Reset Order(s)	Verifies that the flag used to ensure that a record is not simultaneously accessed by users is in the correct position. You may need to use this if a user prematurely exited the system.
Payment Transactions	Verifies the payment transactions for all donation receipts.
Price Codes	Removes price codes which are not connected to a play or a performance.
Sales Summary	Clears the Sales Summary reports and resets them allowing for summarization during the End of Day Process.