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
