Heat added! Diane Disbro Pronouns: she/her Circulation Coordinator Scenic Regional Library 251 Union Plaza Drive Union, MO 63084 (636) 583-0652 ext 110 ddis...@scenicregional.org
On Fri, Oct 21, 2022 at 10:23 AM Rogan Hamby via Evergreen-general < evergreen-general@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@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.mur...@ncdcr.gov <benjamin.mur...@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@list.evergreen-ils.org >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> > _______________________________________________ > Evergreen-general mailing list > Evergreen-general@list.evergreen-ils.org > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general