[Evergreen-general] Purging deleted shelving locations

[Murphy, Benjamin]

After a successful shelving location consolidation project a few years ago, we've found ourselves in a scenario where 85% of our shelving location are flagged as deleted, but they still show up in the Shelving Locations Editor interface. We'd like to properly purge these shelving locations from the database, but before doing so we'll need to update a bunch of legacy data like deleted items, old circulations, acquisition line items etc. Based on our consolidation project we have a map of old shelving location to new shelving location, and we can find which tables reference asset.copy_location so that we know what data to update to the new identifiers, but we're also aware of other places where shelving locations can show up like item templates and reports.

Have any of you taken on a project to actually purge shelving location entries from the asset.copy_location table? If so, do you have any words of advice for things to look out for or address in the process other than strictly updating an ID from one value to another in a database table?

Benjamin Murphy
NC Cardinal Program Manager
State Library of North Carolina
benjamin.murphy at ncdcr.gov<mailto:benjamin.murphy at ncdcr.gov>  | https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal
109 East Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
The State Library is part of the NC Department of Natural & Cultural Resources.
Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20221021/f8737f54/attachment-0001.htm>