this page has been moved to https://support.goalexandria.com/knowledge-base/clean-up-your-data/ |
Have you exceeded—or are you close to exceeding—your patron and item record limits? Do your reports look cluttered? Is it sometimes hard to find things in your catalog? If so, it's probably time to clean up your data! Doing so will free up space and make your collection easier to manage and search.
You can check your record limit in Alexandria by clicking on the question mark icon in the top right corner, then selecting "About Alexandria." |
Before running any utilities, run a report to see what information will be changed. If you are removing patrons and items, their history and statistics will be lost. (Although, don't worry—removing a copy does not alter the title lifetime usage and last use date.) |
Library Cleanup 
- Weed out items in your library. See what needs to go by running a Weeding List report. Then you can choose the appropriate utility to get rid of the items you want to remove.
- Genrefy. Have you considered organizing your library by genre to make it easier for your patrons to find books? Read about it on our blog.
- Also see our blog post on Tidying Up Your Library!
Item Cleanup 
- Remove lost, discarded, or archived items. Check out the Remove Copies tab of our End of Year Procedures for easy instructions on how to do this. But if you want to save these items, be sure to do an export first!
- Consolidate multiple copies under one title using the Move Copies To This Title function in Items Management.
- Use Temporary Items for things like periodicals, so they don't clutter your long-term catalog.
- Remove titles without copies if you aren't using them. Run the Titles with No Copies report to see what title records you have that don't have copies. These might be e-resources, or they might be titles you are no longer using.
How do you tell how many items or patrons you have per site? A quick way is to go to Sites and run the Actions menu > Site Record Counts report. Note that you will need to add the count of your titles with no copies to the number of copies in order to get a true item count. |
Patron Cleanup 
- Weed out your Transferred patrons. Run a Patron Information report and select by Patrons with a Status of Transferred. Review the PDF to make sure you want to remove everyone who shows up on that list. Then you can run the Remove Patrons utility and select for those with the status you wish to remove.
- Weed out your Inactive patrons. Run an Inactive Patrons report to make sure you want to remove everyone who shows up on that list. Then you can run the Remove Patrons utility and select for those with the status you wish to remove.
- Weed out your Graduated patrons. Run a Patron Information report and select by Patrons in Grade Graduated (or whatever your Last Grade is). Review the PDF to make sure you want to remove everyone who shows up on that list. Then you can run the Remove Patrons utility and select for those with the Grade you wish to remove.
Is this a lot to manage? Consider using a SIS integration service such as GG4L or Clever. |
Catalog (Data) Cleanup 
- Use autofill to keep your data clean.
- Clean up your terms and fields using Authority Control.
- Spring Cleaning—Authority Control (Mediums and Genres)
- Labor of Love—Cleaning up Your Subject Tags
- Pay special attention to your Series terms and make sure they are standardized.
- Cataloging Series and Serials (Best Practices and Series tabs)
- Run the Fix Series utility to add series to the correct tag.
- Run the Change Series Volume utility to make volume numbers consistent, so they sort properly.
- Consider using a data cleanup service like Mitinet. You don't have to do it all yourself! Some Mitinet services, such as AnalyzeMARC and EnhanceMARC, are now fully integrated with Alexandria and require no imports and exports.
System Cleanup 
- Policies. The statistics you can obtain in Alexandria are largely based on Policies. Review your policies to ensure you are collecting relevant data.
- Security. Can your patrons place holds? Can your library staff run utilities to mass remove data? Take a look at your Security groups and the permissions given to each group. Run the Operator Summary report to see what users have access to your system!
- Sites. Did your library information change? Go to Sites Management to double check the library contact information, as well as the Researcher Notice, which displays in patron modules. (And don't forget to update your Bulletin Boards!)
- Reports. It's easy to forget what is running in the background. Review your Saved Reports so you can turn off or remove any unnecessary operations, and use your Letters preferences to update your messaging.
- Documentation. Do you keep notes on your library management and data operations? (Hidden Bulletin Boards are a great place for this!) Take the time to update your policies and procedures... for your own sake as well as for your coworkers and successors!
- More. Take a look at Beginning-of-Year Procedures and End-of-Year Procedures for other cleanup and preparation in your system!