[Evergreen-general] Purging deleted shelving locations

[Diane Disbro]

Heat added!

Diane Disbro
Pronouns: she/her
Circulation Coordinator
Scenic Regional Library
251 Union Plaza Drive
Union, MO 63084
(636) 583-0652 ext  110
ddisbro at scenicregional.org



On Fri, Oct 21, 2022 at 10:23 AM Rogan Hamby via Evergreen-general <
evergreen-general at list.evergreen-ils.org> wrote:

> 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
>>
> _______________________________________________
> 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/5eb8bf89/attachment.htm>