<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<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 <kcoleman@jeffcolib.org> 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">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 target="_blank" href="mailto:kcoleman@jeffcolib.org" rel="noopener">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 target="_blank" href="mailto:rhamby@equinoxinitiative.org" rel="noopener">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 target="_blank" href="mailto:kcoleman@jeffcolib.org" rel="noopener">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 target="_blank" href="mailto:kcoleman@jeffcolib.org" rel="noopener">kcoleman@jeffcolib.org</a>
</div>
<div>
<br>
</div>
<div>
<div style="color: #000000; 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 target="_blank" style="color: #181818; text-decoration: none;" href="https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=reading_link&utm_source=email_signature" rel="noopener">Currently Reading</a>
</div>
<div style="color: #000000; 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 target="_blank" href="https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=cover&utm_source=email_signature" rel="noopener"><img width="50" style="margin: 10px 0px 5px;" src="https://www.goodreads.com/user/email_signature_cover/5960108" alt="Book Cover"></a>
</div>
<div style="color: #000000; 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 target="_blank" style="border: 0px none; text-decoration: none;" href="https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature" rel="noopener"><img height="16" width="16" style="vertical-align: middle; margin-right: 2px;" src="https://s.gr-assets.com/assets/icons/goodreads_icon_32x32-6c9373254f526f7fdf2980162991a2b3.png" alt="Goodreads Logo"> </a>
<a target="_blank" style="color: #aaaaaa; 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">Get your own email signature</a>
</div>
<br>
<br>
<img height="52" width="288" src="https://docs.google.com/uc?export=download&id=0B9TS4tJXQ3d3UkpzRGVsWm5rZTQ&revid=0B9TS4tJXQ3d3V2RnZFBpZUZyTHQyblpZdGM3bjlrdTVSdVhRPQ">
<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 target="_blank" href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a target="_blank" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a target="_blank" href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a target="_blank" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a target="_blank" href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a target="_blank" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>
<a target="_blank" href="mailto:Evergreen-general@list.evergreen-ils.org" rel="noopener">Evergreen-general@list.evergreen-ils.org</a>
<br>
<a target="_blank" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noopener">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>
<br>
</blockquote>
</div>_______________________________________________
<br>Evergreen-general mailing list
<br>Evergreen-general@list.evergreen-ils.org
<br>http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
<br>
</blockquote>
<div>
<br>
</div>
<div class="io-ox-signature">
<div class="default-style">
Please wash hands after reading.
</div>
</div>
</body>
</html>