[Evergreen-general] Deleting shelving locations

Elaine Hardy ehardy at georgialibraries.org
Mon Jan 25 09:52:45 EST 2021


Keep in mind that there is a bug that allows for a shelving location with
undeleted items to be deleted --
https://bugs.launchpad.net/evergreen/+bug/1910546

J. Elaine Hardy, PINES and Collaborative Projects Manager
------------------------------

Georgia Public Library Service

2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341

(404) 235-7128 | ehardy at georgialibraries.org

(404) 548-4241 | Cell

<https://www.facebook.com/georgialibraries>
<https://www.twitter.com/georgialibs>
<https://www.instagram.com/georgialibraries/>

Join our email list <http://georgialibraries.org/subscription> for stories
of Georgia libraries making an impact in our communities.


On Mon, Jan 25, 2021 at 9:38 AM swills beyond-print.com <
swills at beyond-print.com> wrote:

> Just FYI
>
> 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.
>
> Using SQL:
> select id,name from asset.copy_location where name IN
> ('zStacks','NewLoc');
> reveals: 1234 => zStacks
>              5678 => NewLoc
>
> UPDATE asset.copy set location = 5678 where location = 1234;
>
> 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.
>
> The items with deleted =>true will not show in searches but can still be
> reported on in their new location.
>
> Steve Wills.
> Supporting the Maine Balsam Consortium
>
> On January 25, 2021 9:21 AM Kate Coleman <kcoleman at jeffcolib.org> wrote:
>
>
> Thanks again Rogan, and I really like that suggestion Kathyrn. Thanks for
> the tip!
>
> On Mon, Jan 25, 2021 at 8:18 AM Rogan Hamby < rhamby at equinoxinitiative.org>
> wrote:
>
> Yep.  You can even select whether a shelving location is "deleted" since
> it's just a boolean flag.
>
>
>
>
> On Mon, Jan 25, 2021 at 9:10 AM Kate Coleman < kcoleman at jeffcolib.org>
> wrote:
>
> 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?
>
> On Mon, Jan 25, 2021 at 8:06 AM Rogan Hamby < rhamby at equinoxinitiative.org>
> wrote:
>
> Hi Kate,
>
> 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.
>
>
>
> On Mon, Jan 25, 2021 at 8:59 AM Kate Coleman < kcoleman at jeffcolib.org>
> wrote:
>
> 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?
>
>
> Kate Coleman, MLIS
> Technical Services Manager, Jefferson County Library
> Missouri Evergreen Consortium
> 5678 State Rd. PP
> High Ridge, MO 63049
> 636-677-8689
> Fax: 636--677-1769
> kcoleman at jeffcolib.org
>
> Currently Reading
> <https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=reading_link&utm_source=email_signature>
> [image: Book Cover]
> <https://www.goodreads.com/user/email_signature_destination/5960108?utm_medium=cover&utm_source=email_signature>
> [image: Goodreads Logo]
> <https://www.goodreads.com/?utm_medium=gr_logo&utm_source=email_signature> Get
> your own email signature
> <https://www.goodreads.com/user/email_signature_instructions?utm_medium=gyo_link&utm_source=email_signature>
>
>
>
> _______________________________________________
> 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
>
> _______________________________________________
> 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
>
> _______________________________________________
> Evergreen-general mailing list
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
>
> Please wash hands after reading.
> _______________________________________________
> 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/20210125/7ae3e9a2/attachment-0001.html>


More information about the Evergreen-general mailing list