[Evergreen-catalogers] Changing a shelf locations

Wed May 29 14:42:34 EDT 2013

If there is anything at all unique in the records that could be used to select them, and somebody could do the changes at the database level... it is fairly easy and could save a lot of work.  Pretty similar to the already mentioned report->excel->load workflow, but I'll throw this method out there anyway.

Using call number ranges, we just split our monolithic "Children's Room" and "Young Adult" locations into a bunch of new separate shelving locations.  Also split videos, new books, and large print collections into separate fiction/nonfiction locations.

The code for doing one call number range looked like this...

UPDATE asset.copy SET location ='268' WHERE id IN (SELECT copy.id FROM asset.copy AS copy JOIN asset.copy_location AS copylocation ON (copy.location = copylocation.id) JOIN asset.call_number AS callnum ON (copy.call_number = callnum.id)
WHERE callnum.label_sortkey BETWEEN 'DVD 0' AND 'DVD 999.9999' AND copylocation.name IN ('NONFICTION') AND copy.location ='168' AND copy.circ_lib IN ('4'));

That was for videos that were actually located and interfiled with nonfiction books.  They were moved to "Adult Videos Nonfiction".
At the other library, they were located in "Videos"... moving them to the "Adult Videos Nonfiction" at that library worked much the same way.

For each batch of call numbers to be moved, just need the id & name of the current location, the id of the library, and the id of the location to change them to.

Some of that SQL is actually superfluous/redundant, it was done that way for repeatability (a few selections required more complex criteria) and readability.  There were about 90 of those statements, to move about 75K items within two libraries.

Anyhow, if they can be selected electronically, it'd take all of a few minutes to move them all.  But if there isn't... yes, you're probably stuck scanning barcodes.

--------------------------------
Jeremiah Miller - 541-917-7597
Sysadmin - Albany Public Library
Albany, OR
--------------------------------

-----Original Message-----
From: evergreen-catalogers-bounces at list.evergreen-ils.org [mailto:evergreen-catalogers-bounces at list.evergreen-ils.org] On Behalf Of Sarah Childs
Sent: Tuesday, May 28, 2013 2:28 PM
To: Evergreen Community Catalogers
Subject: Re: [Evergreen-catalogers] Changing a shelf locations

Oh, yeah. That's a messy kind of situation. Just pulling them and
scanning them might be the easiest thing, if they're already grouped on
the shelf.  When you said they didn't have a shelving location, I
thought you meant they were in the system with no shelving location in
the item record, so it would be easy to run a report for that, but if
you meant they have the same shelving location as other "regular" size
books, that's much more of a hassle.

---
Sarah Childs
Technical Services Department Head
Hussey-Mayfield Memorial Public Library
250 North Fifth Street
Zionsville, IN 46077
317-873-3149 x13330
sarahc at zionsville.lib.in.us

On 2013-05-28 17:13, John Mundy wrote:
> Well, it's size related. Most of them were created years ago (well
> before I
> was here) with very minimal cataloging so I'm not even sure if all of
> them
> even have measurements in their records.
>
> John
> -----Original Message-----
> From: "Elizabeth B. Thomsen" <et at noblenet.org>
> To: evergreen-catalogers at list.evergreen-ils.org
> Date: Tue, 28 May 2013 16:03:56 -0400
> Subject: Re: [Evergreen-catalogers] Changing a shelf locations
>
>
> Before you scan them all, is there any other way to identify them, for
> example, a call number prefix or circ modifier, etc.?  If you can do a
> search and get them into a report, you can open the results in Excel
> and
> just copy and paste the barcodes into a text file to upload.
>
> Depending on how many you have and how findable they are, that may be
> faster than scanning them all.
>
>
> On 5/23/2013 4:07 PM, John Mundy wrote:
>> My apologies for any duplication.
>> If you have a large collection of items is there any easy way in
>> Evergreen to import that list of items and change all of their shelf
>> locations to the same thing?
>> One of our branches has a large collection of Oversize books that are
>> not cataloged as having their own shelf location. I can create a new
>> shelf location for them easily, but I don't know offhand any quick
>> way
>> to change items shelf locations.
>> Thank you,
>> John
>> Director
>> Perry County Public Library
>> 812-547-2661
>> fax 812-547-3038
>> jmundy at tcpclibrary.org <mailto:jmundy at tcpclibrary.org>
>> http://www.tcpclibrary.org/ [http://www.tcpclibrary.org/]
> <http://www.tcpclibrary.org/ [http://www.tcpclibrary.org/]>
>>
>>
>> _______________________________________________
>> Evergreen-catalogers mailing list
>> Evergreen-catalogers at list.evergreen-ils.org
>>
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
> [http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers]
>>
>
>
> --
> Elizabeth Thomsen, Member Services Manager
> NOBLE: North of Boston Library Exchange
> 26 Cherry Hill Drive
> Danvers MA 01923
> E-mail: et at noblenet.org
>
> _______________________________________________
> Evergreen-catalogers mailing list
> Evergreen-catalogers at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
> [http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers]
> _______________________________________________
> Evergreen-catalogers mailing list
> Evergreen-catalogers at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
_______________________________________________
Evergreen-catalogers mailing list
Evergreen-catalogers at list.evergreen-ils.org
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers

DISCLAIMER: This e-mail may be a public record of the City of Albany and may be subject to the State of Oregon Retention Schedule and may be subject to public disclosure under the Oregon Public Records Law. This e-mail, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please send a reply e-mail to let the sender know of the error and destroy all copies of the original message.