[Evergreen-general] Purging deleted shelving locations

[Rogan Hamby]

Unfortunately to actually purge the shelving locations something would have
to be done in the data base to resolve where they are linked to (off the
top of my head) both items and circulations.  The best thing would be to
update the editor to either hide or filter them, which there is a bug here
for:

https://bugs.launchpad.net/evergreen/+bug/1917092

I think it deserves more heat added to it and one of the other bugs
complicating it was resolved in August.

On Fri, Oct 21, 2022 at 11:16 AM Murphy, Benjamin via Evergreen-general <
evergreen-general at list.evergreen-ils.org> wrote:

> 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 <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.*
>
>
>
>
> _______________________________________________
> Evergreen-general mailing list
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20221021/b18736e9/attachment.htm>