<div dir="ltr">Heat added!<div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><font face="arial black, sans-serif">Diane Disbro</font></div><div dir="ltr"><div>Pronouns: she/her</div><div>Circulation Coordinator</div><div>Scenic Regional Library</div><div>251 Union Plaza Drive</div><div>Union, MO 63084</div><div>(636) 583-0652 ext 110</div><div><span style="font-family:Raleway"><font color="#000000"><a href="mailto:ddisbro@scenicregional.org" target="_blank">ddisbro@scenicregional.org</a></font></span></div><div><span style="font-family:Raleway"><font color="#000000"><br></font></span></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Oct 21, 2022 at 10:23 AM Rogan Hamby via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">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: <div><br></div><div><a href="https://bugs.launchpad.net/evergreen/+bug/1917092" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1917092</a><br></div><div><br></div><div>I think it deserves more heat added to it and one of the other bugs complicating it was resolved in August.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Oct 21, 2022 at 11:16 AM Murphy, Benjamin via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal">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. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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?<u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Benjamin Murphy<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">NC Cardinal Program Manager<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">State Library of North Carolina<u></u><u></u></span></p>
<p class="MsoNormal"><u><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"><a href="mailto:benjamin.murphy@ncdcr.gov" target="_blank"><span style="color:rgb(5,99,193)">benjamin.murphy@ncdcr.gov</span></a>
</span></u><span style="font-size:10pt;font-family:Arial,sans-serif;color:black"> |
<a href="https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal" target="_blank"><span style="color:rgb(5,99,193)">https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Raleigh, North Carolina 27699-4600<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-top:6pt"><span style="font-size:10pt;font-family:Arial,sans-serif">The State Library is part of the NC Department of Natural & Cultural Resources.<u></u><u></u></span></p>
<p class="MsoNormal"><i><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><span style="font-size:10pt;font-family:Arial,sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</div></blockquote></div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote></div>