Replace all existing call numbers with LoC
Hi, I'm working on a restructuring of a small arts non-profit library. The library currently uses an esoteric, confusing custom catalog numbering system devised by a staff member who is no longer here. We'd like to switch all our records over to LoC cataloging. We currently are using Koha 3.18.05.100 - I'm curious if it's possible to replace all our records with LoC records, in bulk, rather than editing each individually. Thanks!
Daniel, I think for LoC, you can only do one direct import at a time unless you order records through their record distribution service (which costs $). Please correct me if I am wrong. If you used OCLC, you could perhaps put together a file of LC records and do a mass import (setting holdings data before import). Otherwise, assuming LC has catalogued every item you have, you will need to do one search at a time - probably with the Z39.50 search tool. Thoughts on this from anyone else? Thanks, Jesse On 23-Mar-16 3:45 PM, Daniel Glendening wrote:
Hi,
I'm working on a restructuring of a small arts non-profit library. The library currently uses an esoteric, confusing custom catalog numbering system devised by a staff member who is no longer here.
We'd like to switch all our records over to LoC cataloging. We currently are using Koha 3.18.05.100 - I'm curious if it's possible to replace all our records with LoC records, in bulk, rather than editing each individually.
Thanks!
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center Ph: (202)-677-3967 x104 jlambertson@sqcc.org عالم الانجازات ينحاز دوماً مع المتفائلين
Thanks Jesse, That's not what I hoped to hear, but what I expected. In editing the entry, via the "Replace Record via Z39.50," I'm able to retrieve Library of Congress info, and call numbers, but when I save, the call number remains unchanged, still displaying the old number. If I change that number in the "edit item," it will be correct. I'm probably approaching this problem from the wrong direction, as I'm very new to Koha, but shouldn't the MARC biblio info be in sync with item info? Hopefully this makes some sense... Thanks, Daniel On 3/23/16, Jesse A Lambertson <jlambertson@sqcc.org> wrote:
Daniel,
I think for LoC, you can only do one direct import at a time unless you order records through their record distribution service (which costs $).
Please correct me if I am wrong.
If you used OCLC, you could perhaps put together a file of LC records and do a mass import (setting holdings data before import). Otherwise, assuming LC has catalogued every item you have, you will need to do one search at a time - probably with the Z39.50 search tool.
Thoughts on this from anyone else?
Thanks,
Jesse
On 23-Mar-16 3:45 PM, Daniel Glendening wrote:
Hi,
I'm working on a restructuring of a small arts non-profit library. The library currently uses an esoteric, confusing custom catalog numbering system devised by a staff member who is no longer here.
We'd like to switch all our records over to LoC cataloging. We currently are using Koha 3.18.05.100 - I'm curious if it's possible to replace all our records with LoC records, in bulk, rather than editing each individually.
Thanks!
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center Ph: (202)-677-3967 x104 jlambertson@sqcc.org عالم الانجازات ينحاز دوماً مع المتفائلين
-- *Daniel J Glendening* www.danieljglendening.com www.gwcinvestigators.com @dglendening <https://twitter.com/#%21/dglendening>
Thanks Jesse, That's not what I hoped to hear, but what I expected. In editing the entry, via the "Replace Record via Z39.50," I'm able to retrieve Library of Congress info, and call numbers, but when I save, the call number remains unchanged, still displaying the old number. If I change that number in the "edit item," it will be correct. I'm probably approaching this problem from the wrong direction, as I'm very new to Koha, but shouldn't the MARC biblio info be in sync with item info? Hopefully this makes some sense... Thanks, Daniel
At 08:46 PM 3/23/2016 +0000, Daniel Glendening wrote:
Thanks Jesse,
That's not what I hoped to hear, but what I expected.
In editing the entry, via the "Replace Record via Z39.50," I'm able to retrieve Library of Congress info, and call numbers,
What "call number" are you looking at? There's maybe a bit of confusion here. LoC will supply an 001 (control number) which together with 003 (control number identifier) *must* be unique e.g. (001)16644410 + (003)DLC is (100$a)Cowan's (245$a)"The Welland ship canal..." LoC also supply an 010 "LC control number" 36013568. If it were a more recent publication they might supply an 040 ISBN (10 or 13 digit)... plus a Dewey, plus... LoC *only* supply the generic bibliographic data for a generic copy of your book. The Koha "call number" is associated with *your* item (particular copy of the generic) on *your* shelf; it appears under "Item" (para 'o') and is generated by Koha when you add an item. There is some latitude in Koha over how it's generated, and you can always "hand edit" it (in fact, there are times that you should do so.)
but when I save, the call number remains unchanged, still displaying the old number.
That is normal -- your LoC import has only (potentially) changed the biblio data, *not* the item data.
If I change that number in the "edit item," it will be correct. I'm probably approaching this problem from the wrong direction, as I'm very new to Koha, but shouldn't the MARC biblio info be in sync with item info?
This is where there is some confusion: the generic / all library / biblio description "contains" your items, all of which are individual books defined by you (with Koha's assistance) including (952$o)(your library's) call number... Best -- Paul
Hopefully this makes some sense...
Thanks, Daniel
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>
Hi, Daniel-- Although it's common for others systems to be able to copy LC call number information from a bib record 050 or 090 field for display, even pull or copy from those bib fields into item records, Koha doesn't do that, and the displayed call number is from the item record (stored in a 952 field, subfield o, i.e., letter "o"). This is also the field that is searched on in call number searches, so be sure it's formatted correctly for searching, sorting, etc. I'm not familiar with replacing records via Z39.50 (we use OCLC & export records), so I'm not sure if there's a way to overlay the call number in the item record via that process--perhaps someone else can let you know! I hope this helps! Cheerio, h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
Hi Daniel, when creating new items the itemcallnumber system preference can be used to suggest a call number from the bibliographic record that can be changed/overwritten by the library. There is currently no other relationship between the callnumber information in the record and the item that I can think of and no automatism to automatically update it after the item has been saved. Hope this helps, Katrin Am 23.03.2016 um 22:38 schrieb Hernandez, Heather:
Hi, Daniel--
Although it's common for others systems to be able to copy LC call number information from a bib record 050 or 090 field for display, even pull or copy from those bib fields into item records, Koha doesn't do that, and the displayed call number is from the item record (stored in a 952 field, subfield o, i.e., letter "o"). This is also the field that is searched on in call number searches, so be sure it's formatted correctly for searching, sorting, etc. I'm not familiar with replacing records via Z39.50 (we use OCLC & export records), so I'm not sure if there's a way to overlay the call number in the item record via that process--perhaps someone else can let you know!
I hope this helps! Cheerio, h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hernandez, Heather <heather_hernandez@...> writes:
Hi, Daniel--
Although it's common for others systems to be able to copy LC call number information from a bib record 050 or 090 field for display, even pull or copy from those bib fields into item records, Koha doesn't do that, and the displayed call number is from the item record (stored in a 952 field, subfield o, i.e., letter "o"). This is also the field that is searched on in call number searches, so be sure it's formatted correctly for searching, sorting, etc. I'm not familiar with replacing records via Z39.50 (we use OCLC & export records), so I'm not sure if there's a way to overlay the call number in the item record via that process--perhaps someone else can let you know!
I hope this helps! Cheerio, h2
Hi, Thanks -- this is making a little more sense now I think, re biblio versus individual item. So, the 952 fields won't automatically populate -- so if I'd like to use LoC shelving call letter system, I should just copy/paste that into the item record's 952 o field? Thanks for your help!
Hi, Daniel-- I would definitely play with the itemcallnumber system preference that Katrin suggested--it may really save you some keystrokes! When working in OCLC, I do copy the 050 or 090 subfields a & b into a 952 subfield o, e.g. this: 050 _4 VM381 ǂb .R682 1997 Is copied and pasted into this: VM381 R682 1997 So that our 952 field in OCLC for this item is this: ǂ2 lcc ǂa SFMARITIME ǂb SFMARITIME ǂc STACKS ǂy BOOK ǂo VM381 R682 1997 ǂp 189951 ǂe NPSGIFT ǂx Donor, Kilk Estate via Assn 20140605 Cheerio! h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
Also consider MarcEdit and its capability to generate call numbers: https://www.youtube.com/watch?v=W_9bl0b2COo -- once you have call numbers, use MarcEdit's conditional find and replace to move these from the 050 to the 952$o. Koha is the only ILS that is integrated with MarcEdit and you can seamlessly import records into the MarcEdit editor, change them (generate a call numbers and copy these to the 952$o) and save the records back into Koha. Consider http://marcedit.reeset.net/tutorials for information on integration with Koha. I hope this helps, Sebastian -- Sebastian Hierl, Ph.D. Drue Heinz Librarian, Arthur & Janet C. Ross Library American Academy in Rome Via Angelo Masina 5 00153 Rome Italy T: +39 06 5846 417 F: +39 06 5810 788 On Wed, Mar 23, 2016 at 11:05 PM, Hernandez, Heather < heather_hernandez@nps.gov> wrote:
Hi, Daniel--
I would definitely play with the itemcallnumber system preference that Katrin suggested--it may really save you some keystrokes!
When working in OCLC, I do copy the 050 or 090 subfields a & b into a 952 subfield o, e.g. this: 050 _4 VM381 ǂb .R682 1997
Is copied and pasted into this: VM381 R682 1997
So that our 952 field in OCLC for this item is this: ǂ2 lcc ǂa SFMARITIME ǂb SFMARITIME ǂc STACKS ǂy BOOK ǂo VM381 R682 1997 ǂp 189951 ǂe NPSGIFT ǂx Donor, Kilk Estate via Assn 20140605
Cheerio! h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123 415-561-7032, heather_hernandez@nps.gov http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Sebastian Hierl <s.hierl@...> writes:
Also consider MarcEdit and its capability to generate call numbers: https://www.youtube.com/watch?v=W_9bl0b2COo -- once you have call numbers, use MarcEdit's conditional find and replace to move these from the 050 to the 952$o. Koha is the only ILS that is integrated with MarcEdit and you can seamlessly import records into the MarcEdit editor, change them (generate a call numbers and copy these to the 952$o) and save the records back into Koha.
I've started to look to MarcEdit but haven't gotten very far. I'm running into a problem in setting up ILS Integration in MarcEdit. The program keep crashing when I apply ILS data, with the message: "System.UnhandledExceptionEventArgs" My only thought is maybe I'm not using the appropriate url in the "Host Name" field -- using the url that I use to access and login to Koha.
At 07:45 PM 3/23/2016 +0000, Daniel Glendening wrote:
Hi,
I'm working on a restructuring of a small arts non-profit library. The library currently uses an esoteric, confusing custom catalog numbering system devised by a staff member who is no longer here.
We'd like to switch all our records over to LoC cataloging. We currently are using Koha 3.18.05.100 - I'm curious if it's possible to replace all our records with LoC records, in bulk, rather than editing each individually.
Having gone through the same sort of "exercise" for about 13,000 records five or six years ago, the short answer is "no", it's not possible. (The long answer is that it might be possible to write a script to try and batch import via Z3950, but this would assume many things -- that there are no typos in your existing titles, authors (confusion over authorities), ISBNs, publishers, edition numbers, publication dates, etc; and that LoC actually have all your records which is probably true for 99% of US first and numbered/revised edition publications, but watch out for differences in ISBNs between hardbacks and trade paperbacks, and be very aware that later imprints are "spotty" at best; LoC is also helpful for a few / some "foreign" titles.) We "imported" from spreadsheets via MarcEdit and in hindsight got a lot of "success" and some blatant deficiencies which we're still correcting. The bottom line is that we are still "re-cataloguing", with LoC, LAC, BL, BNF, whatever Z3950 records, (and of course with the "Mark 1 eyeball" method) many books that have been on our shelves for twenty or more years. Your mileage might vary... Wishing you luck -- Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>
participants (7)
-
Daniel -
Daniel Glendening -
Hernandez, Heather -
Jesse A Lambertson -
Katrin Fischer -
Paul A -
Sebastian Hierl