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 [email protected] On Mon, Jan 25, 2021 at 8:53 AM Elaine Hardy <[email protected]> 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 | [email protected] > > (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 < > [email protected]> 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 <[email protected]> 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 < >> [email protected]> 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 < [email protected]> >> 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 < >> [email protected]> 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 < [email protected]> >> 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 >> [email protected] >> >> 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 >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> >> _______________________________________________ >> Evergreen-general mailing list >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> >> _______________________________________________ >> Evergreen-general mailing list >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> >> _______________________________________________ >> Evergreen-general mailing list >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> >> _______________________________________________ >> Evergreen-general mailing list >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> >> >> Please wash hands after reading. >> _______________________________________________ >> Evergreen-general mailing list >> [email protected] >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> > _______________________________________________ > Evergreen-general mailing list > [email protected] > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
