[Evergreen-general] Deleting shelving locations

[Diane Disbro]

Thank you for this discussion! I like Kathryn's idea since, yes, we do have
some confusing shelving locations that are no longer used.

Diane Disbro
Pronouns: she/her
Circulation Coordinator
Scenic Regional Library
*Temporary address change:*
912 S. Highway 47
Warrenton, Missouri 63383
636-456-3321
ddisbro at scenicregional.org



On Mon, Jan 25, 2021 at 8:53 AM Elaine Hardy <ehardy at georgialibraries.org>
wrote:

> 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
>>
> _______________________________________________
> 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/26dea40e/attachment-0001.html>