Page tree

Getting Started


Save as PDF

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.


Library Cleanup

Improve your physical space along with the digital space!


Item Cleanup

Improve statistics and reports, and stay within your item record limits.


Patron Cleanup

Improve statistics and reports, and stay within your patron record limits.


Catalog Cleanup

Improve search results, sorting, and catalog details for your patrons.



System Cleanup

Improve database management, security, and your sanity.


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 


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.


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 patronsRun 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 Clever.

Catalog (Data) Cleanup 


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!