Despite our best efforts, sometimes we end up creating blank records in our files! These scripts will search for blank records and display them in a list for you to preview and then delete if desired.
These scripts are listed under Common Tasks > General tidy-up
A different find request is used for each file, as listed below, but the general process is the same. The script finds blank records. You can edit some so they're not blank, if appropriate, and you will generally want to delete the remaining ones.
File | Find Blank Records script searches for: |
Contacts | Records that are blank in First Name, Last Name AND Company Name |
Ensembles | Records that are blank in Ensemble Name |
Exams | Records that are blank in Exam Session OR Exam Subject |
Excursions | Records that are blank in Excursion Name |
Loans & Hire | Records that are blank in Category 2 OR First Name |
Resources | Records that are blank in Category 2 AND in Ref No |
Student Accounts | Records that are blank in Amount |
Students | Records that are blank in First Name AND Last Name |
Tuition | Records that are blank in Lesson Type
|
To delete the found set, select Records from the menu at the top of the screen, then Delete Found Set.
You can also OMIT records before deleting the found set, if there are some you want to keep. Select the record, then select Records > Omit Record. The record will be removed from the found set. If you then go on to Delete Found Set, the omitted ones will not be deleted.