<div dir="ltr">Thank you for this discussion! I like Kathryn's idea since, yes, we do have some confusing shelving locations that are no longer used.<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><b><i>Temporary address change:</i></b></div><div><span style="font-family:Raleway"><font color="#000000">912 S. Highway 47</font></span></div><div><font color="#000000"><span style="font-family:Raleway">Warrenton, Missouri 63383</span><br></font></div><div><span style="font-family:Raleway"><font color="#000000">636-456-3321</font></span></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 Mon, Jan 25, 2021 at 8:53 AM Elaine Hardy <<a href="mailto:ehardy@georgialibraries.org">ehardy@georgialibraries.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"><div class="gmail_default" style="font-family:tahoma,sans-serif">Keep in mind that there is a bug that allows for a shelving location with undeleted items to be deleted -- <a href="https://bugs.launchpad.net/evergreen/+bug/1910546" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1910546</a></div><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><br><div dir="ltr" style="margin-left:0pt"><table style="border:medium none;border-collapse:collapse"><colgroup><col width="94"><col width="530"></colgroup><tbody><tr style="height:0pt"><td style="vertical-align:top;padding:5pt;text-align:right"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh5.googleusercontent.com/bpjlHkZIWY-VYFVLNA9ro5_6N4c7AxtzAPQhhzTKXaM1luxXME10aRo56LngwgoMXQ-OptUpmewQo8ljPZNpd7H2nZx09Xns4m_RVJ6D7NoWhha3cHDFxXExYWy2c7E0qfs3M5WC" style="margin-left: 0px; margin-top: 0px;" width="75" height="75"></span></span></p></td><td style="vertical-align:top;padding:5pt;text-align:left"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><font size="1"><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">J. Elaine Hardy</span><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">,</span><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">PINES and Collaborative Projects Manager</span></font></p><hr style="margin-left:0px;margin-right:auto"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><font size="1"><span style="font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"></span><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Georgia Public Library Service</span></font></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><font size="1"><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341</span></font></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><font size="1"><span style="font-family:Verdana;color:rgb(30,67,155);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 235-7128</span><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> | <a href="mailto:ehardy@georgialibraries.org" target="_blank">ehardy@georgialibraries.org</a></span></font></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><font size="1"><span style="font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 548-4241 | Cell<br></span></font></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><a href="https://www.facebook.com/georgialibraries" style="text-decoration:none" target="_blank"><span style="font-size:9pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh4.googleusercontent.com/wjWdJl8zhUVb20FdmA0VXc4J9O5c0fKk1TTRabfYTrAZPyt8gtuVsgSIP_gPDaSD0mpvMRmzVxbpurZbyAzV1VrEHAKJUAZkUeSVH-CLb0KFkL6pHU_v09gN6QRKIRtUq1iR-Zbn" style="margin-left: 0px; margin-top: 0px;" width="36" height="36"></span></span></a><span style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> </span><a href="https://www.twitter.com/georgialibs" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh6.googleusercontent.com/9dDBepVWGW2bIMC615q1KfmBTkk04sQENYf3r3X4IP5eYttphc5NQh1IZ4vsfVKxNeDquYf251jJKz3GP8Gs0LSo5nPIlC1gZsTcmFlhGRuaM0RSbHJXxpqqwAVJgjcKud5Jzgop" style="margin-left: 0px; margin-top: 0px;" width="35" height="35"></span></span></a><a href="https://www.instagram.com/georgialibraries/" style="text-decoration:none" target="_blank"><span style="font-size:11pt;font-family:Arial;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:37px;height:37px"><img src="https://lh3.googleusercontent.com/qC0XM1vBNxEXGw_lKy9Mi0CItlEXSk42qcHTINcYfBgysbcUifEX39mTV0CvllVyEzZUU7Di1U3uQ4N5hKG7244DAaWAfZIxP3HldZONwuBMo1KdTdPe_5SUXG44S8MQvRFkWJcj" style="margin-left: 0px; margin-top: 0px;" width="37" height="37"></span></span></a></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><font size="1"><a href="http://georgialibraries.org/subscription" style="text-decoration:none" target="_blank"><span style="font-family:Verdana;color:rgb(17,85,204);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-family:Verdana;color:rgb(0,0,0);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> </span></font><span style="font-size:10pt;font-family:Verdana;color:rgb(67,67,67);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><font size="1">for stories of Georgia libraries making an impact in our communities</font>.</span></p></td></tr></tbody></table></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 25, 2021 at 9:38 AM swills <a href="http://beyond-print.com" target="_blank">beyond-print.com</a> <<a href="mailto:swills@beyond-print.com" target="_blank">swills@beyond-print.com</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"><u></u>
<div>
<div>
Just FYI
</div>
<div>
<br>Some of my libraries had enough trouble tolerating "zStacks" in the list and I ended up moving all the items in "zStacks" to another location. if a location is empty, i.e. no items point at a location, the location can be deleted.
</div>
<div>
<br>
</div>
<div>
Using SQL:
</div>
<div>
select id,name from asset.copy_location where name IN ('zStacks','NewLoc');
</div>
<div>
reveals: 1234 => zStacks
</div>
<div>
5678 => NewLoc
<br>
<br>UPDATE asset.copy set location = 5678 where location = 1234;
</div>
<div>
<br>
</div>
<div>
This Move all copies, deleted or otherwise from the ZStacks location to a new location so that zStacks it can be retired by deleting it as local admin.
<br>
<br>The items with deleted =>true will not show in searches but can still be reported on in their new location.
</div>
<div>
<br>
</div>
<div>
Steve Wills.
</div>
<div>
Supporting the Maine Balsam Consortium
</div>
<blockquote type="cite">
<div>
On January 25, 2021 9:21 AM Kate Coleman <<a href="mailto:kcoleman@jeffcolib.org" target="_blank">kcoleman@jeffcolib.org</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div dir="ltr">
Thanks again Rogan, and I really like that suggestion Kathyrn. Thanks for the tip!
<br>
</div>
<br>
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">
On Mon, Jan 25, 2021 at 8:18 AM Rogan Hamby <
<a href="mailto:rhamby@equinoxinitiative.org" target="_blank">rhamby@equinoxinitiative.org</a>> wrote:
<br>
</div>
<blockquote>
<div dir="ltr">
Yep. You can even select whether a shelving location is "deleted" since it's just a boolean flag.
<br clear="all">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir="ltr"><span style="font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><br></span></p>
<p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir="ltr"><br></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">
On Mon, Jan 25, 2021 at 9:10 AM Kate Coleman <
<a href="mailto:kcoleman@jeffcolib.org" rel="noopener" target="_blank">kcoleman@jeffcolib.org</a>> wrote:
<br>
</div>
<blockquote>
<div dir="ltr">
Perfect! Thanks Rogan. So in a scenario like I mentioned, that old shelving location will still be a visible option to choose when filtering on Shelving Locations in a report?
<br>
</div>
<br>
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">
On Mon, Jan 25, 2021 at 8:06 AM Rogan Hamby <
<a href="mailto:rhamby@equinoxinitiative.org" rel="noopener" target="_blank">rhamby@equinoxinitiative.org</a>> wrote:
<br>
</div>
<blockquote>
<div dir="ltr">
Hi Kate,
<div>
<br>
</div>
<div>
This is another instance where "DELETE" actually means "update the database entry to set a deleted flag but keep it there" just as with many other things in Evergreen so using the delete option doesn't actually delete the copy location. It will prevent it from being used for new copies but old entires like deleted copies, circs, etc... will still reference it.
</div>
<div>
<br clear="all">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir="ltr"><br></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">
On Mon, Jan 25, 2021 at 8:59 AM Kate Coleman <
<a href="mailto:kcoleman@jeffcolib.org" rel="noopener" target="_blank">kcoleman@jeffcolib.org</a>> wrote:
<br>
</div>
<blockquote>
<div dir="ltr">
Are there any negative impacts on statistics if a shelving location is deleted? If I'm doing a circ report and that location is no longer available, are those historical circs moved to the current shelving location?
<br clear="all">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<br>
<br>Kate Coleman, MLIS
<br>
</div>
<div>
Technical Services Manager, Jefferson County Library
<br>
</div>
<div>
Missouri Evergreen Consortium
<br>
</div>
<div>
5678 State Rd. PP
<br>High Ridge, MO 63049
<br>636-677-8689
<br>Fax: 636--677-1769
<br>
<a href="mailto:kcoleman@jeffcolib.org" rel="noopener" target="_blank">kcoleman@jeffcolib.org</a>
</div>
<div>
<br>
</div>
<div>
<div style="color:rgb(0,0,0);font-family:Georgia,"Times New Roman",serif;font-size:10px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<a style="color:rgb(24,24,24);text-decoration:none" href="https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=reading_link&utm_source=email_signature" rel="noopener" target="_blank">Currently Reading</a>
</div>
<div style="color:rgb(0,0,0);font-family:Georgia,"Times New Roman",serif;font-size:10px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<a href="https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=cover&utm_source=email_signature" rel="noopener" target="_blank"><img style="margin: 10px 0px 5px;" src="https://www.goodreads.com/user/email_signature_cover/5960108" alt="Book Cover" width="50"></a>
</div>
<div style="color:rgb(0,0,0);font-family:Georgia,"Times New Roman",serif;font-size:10px;font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;margin-top:5px">
<a style="border:0px none;text-decoration:none" href="https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature" rel="noopener" target="_blank"><img style="vertical-align: middle; margin-right: 2px;" src="https://s.gr-assets.com/assets/icons/goodreads_icon_32x32-6c9373254f526f7fdf2980162991a2b3.png" alt="Goodreads Logo" width="16" height="16"> </a>
<a style="color:rgb(170,170,170);text-decoration:none;vertical-align:middle" href="https://www.goodreads.com/user/email_signature_instructions?utm_medium=gyo_link&utm_source=email_signature" rel="noopener" target="_blank">Get your own email signature</a>
</div>
<br>
<br>
<img src="https://docs.google.com/uc?export=download&id=0B9TS4tJXQ3d3UkpzRGVsWm5rZTQ&revid=0B9TS4tJXQ3d3V2RnZFBpZUZyTHQyblpZdGM3bjlrdTVSdVhRPQ" width="288" height="52">
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener" target="_blank">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener" target="_blank">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener" target="_blank">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener" target="_blank">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</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" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
<div>
<br>
</div>
<div>
<div>
Please wash hands after reading.
</div>
</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>
</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>