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;
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.
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
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
