Testing Data Integrity


Table of Contents   Previous Page  Next Page    

The Data Integrity checker is designed to help point out what may be errors in records. Note that it only looks for things that might be errors -- it is up to you to decide whether an actual problem has been found.

For example, if you enter a membership record with the same first and last name as an existing record, you will receive a message stating that a duplicate record is potentially being created; but, you are allowed to ignore this message and create the record.  Many times this is necessary simply because two people may have the same name. If the Data Integrity checker finds that duplicate record, you would know that it is not a problem.

Running Data Integrity Tests

1Choose Tools > Database Tools > Run Data Tests.
2On the Data Integrity window, select either Membership or Group data to test. The list of Available Tests will change based on the type of data being tested.

 Note: The relationships test for Membership records actually includes four tests. The following types of relationship requirements are checked:

Records that must be related to at least one other membership record
Records that must be related to at least one other group record
Records that must be related to both a group and a membership record
Records that must be related to at least one group or membership record
3Select the tests that should run.
4Click Test Now. Each record found to match one of the selected tests will appear in the Test Results list at the bottom of the window. The Test column will show the number of the test that a given record failed.

 Note: If no records meet the criteria for a given test, an entry will appear in the list stating "No Data Found"

5You can choose to Open or Delete any records that appear in the Test Results list by clicking the appropriate icon. If a record is deleted, it is permanently removed from the database just like deleting it from the membership or group list window.