Pardon the mess! The Support Center is undergoing construction.  


Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.


Warning

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 
Anchor
LibraryCleanup
LibraryCleanup


Item Cleanup 
Anchor
ItemCleanup
ItemCleanup
  • 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. 


Info

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 
Anchor
PatronCleanup
PatronCleanup
  • 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.
Tip

Is this a lot to manage? Consider using a SIS integration service such as GG4L or Clever.

Catalog (Data) Cleanup 
Anchor
CatalogCleanup
CatalogCleanup


System Cleanup 
Anchor
SystemCleanup
SystemCleanup
  • 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!