Summer Reader - Database Maintenance
Rating: Unrated | Last Updated: Thu, Oct 13, 2011 at 7:21 AM
You don't have any programs currently running and you want to delete all data from all programs and all the patrons
In most cases, this will remove 99% of the patron records if you do this for all of your programs. There are times when a patron has been deleted from a program but has not been deleted from the db so they are not attached to a program. These patrons will still be in the db. Go to 'System Maintenance-->Patron Information' and click on the "Delete All Unregistered Patrons" button. This will remove the rest unregistered of the patrons from the db. Click on the "Go" button to perform a blank search to make sure all records have been deleted.
In this scenario all patrons will register as new sign ups.
You have 1 or more programs currently running but you want to delete all data from all other programs and all those programs' patrons
In most cases, this will remove 99% of the patron records that you want removed if you do this for the programs for which patrons are to be removed. There are times when a patron has been deleted from a program but has not been deleted from the db so they are not attached to a program. These patrons will still be in the db. Go to 'System Maintenance-->Patron Information' and click on the "Delete All Unregistered Patrons" button. This will remove the rest of the unregistered patrons from the db. Click on the "List All Unregistered Patrons" button to perform a search to make sure there are not any unregistered patrons left. There will still be patrons in the db for the programs where you did not delete the patron record.
In this scenario all patrons will register as new sign ups unless they happen to be registered in one of the programs that is currently running. If they are in a program currently running and want to sign up for another program they would need to use the "Signed Up Before" button on the registration page. To ensure that this feature is available go to System Settings and set the 'Signed Up Before' Feature to Yes. If this option is not made available then only staff will be able to register them unless they register as a new individual with a different library card or user name.
You want to keep the patron information in the db and re-use one or more of your programs
There are two ways to accomplish this:
If you plan on using this scenario then it is a good idea to enable Email via Email Setup. Be sure to enable the "Login Info Email Enable” and make the "Email” field a required field in the program’s registration setup as well. This will allow users to use the "Forgot Your Login Info” button so they can receive an email from the application with their login information – rather than calling the library for this information or the user could choose to register with a new user name or library card.
You want to keep the patron information in the db and create a new program for this year
There are no attachments for this article.
There are no comments for this article. Be the first to post a comment.
What is new in Summer Reader 2013?
Viewed 19997 times since Tue, Feb 5, 2013
Summer Reader Language/Text Troubleshooting
Viewed 755 times since Wed, Jan 23, 2013
How do I Add a New Header in Summer Reader?
Viewed 1801 times since Mon, Dec 19, 2011
Summer Reader Evanced Style Templates Archive
Viewed 2531 times since Fri, Jan 18, 2013
Viewed 1735 times since Wed, Sep 28, 2011
Viewed 1342 times since Wed, Sep 28, 2011
How to Select Multiple Recipients for an Email in Summer Reader
Viewed 395 times since Tue, Aug 13, 2013
Hosted Customer Sites Security Protocol
Viewed 1130 times since Wed, Sep 28, 2011
How to export and import a program’s style sheet in Summer Reader
Viewed 1052 times since Mon, Nov 21, 2011
Can one Summer Reading Program Support Multiple Goals?
Viewed 1035 times since Thu, Oct 6, 2011