Purging Patron Data

Purging patron data is preformed using a mail list. When you attempt to purge the patron data you will be asked to select mail list(s) to which the patrons you would like to purge are associated. Only patrons which have no ticket history, donation history, outstanding transactions, payments or balances, and not marked "Do not DELETE" will be purged. If you are required to delete patrons with any of the above data refer to deleting a patron.

1. Open the Database Utilities Window

   Click Here to learn how to access the window.

   

2. Select the F_Client file with the description "patron data"

   To select single click on the file. The Delete Patrons in Mail List Window will open.

   

3. Enter the mail list(s) which contains associations to the patrons you wish to purge

   Click Here to learn how to create a mail list.

   Note: Only patrons which have no ticket history, donation history, outstanding transactions, payments or balances, and not marked "Do not DELETE" will be purged.

4. Click OK

   The folllowing confirmation window will open.

   

5. Click Yes to continue with the purge

   If you wish to double check who's in the mail list before purging or you no longer wish to purge click No .

   The following warning window will open.

   

6. Click Yes to continue with the purge of the patron information

   If you wish to double check who's in the mail list before purging or you no longer wish to purge click No .

   The following window will appear showing the progress of the purge. Depending on the size of your mail lists and the number of empty patrons this window may appear very briefly.

   

   Once the empty patrons have been purge a window will appear showing the results of the purge.

   

7. Click Ok

   You will return to the Database utility window where the # Records and Space(Kb) columns in the table will be updated to show the current information.