Batch imports of MARC records for e-books and 099 fields for regular books
I've been experimenting with batch importing vendor-supplied MARC records for some of the electronic books we have. The e-books upload fine, and look okay with one big exception: In a search result screen, these item records show up with "Availability: No items available:" If you click on the title, the full record does show the working URL to the book, but that "no items available" message will discourage users from clicking on it. Example of record: <http://wxman.sandbox.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=211416> or shorter link: <http://bit.ly/7YOcdA> I found that if I changed three fields in the holdings: Koha Item Type: Electronic book Collection code: Ebooks Shelving Location: EBOOKS then the e-book correctly shows up as EBOOK in the summary display. However, the prospect of manually editing over 3000 holdings records is too hideous to contemplate. Is thers some shortcut to change all of an incoming batch of MARC-21 records to have the same holdings information? If so, could someone here kindly guide me through it? Before uploading the MARC file for the first 200+ records, I used a text editor that could handle large files and prepended our EZproxy string onto the book's URL using a macro. That went smoothly. If there is no shortcut or tool in Koha for changing holdings on a large batch of records at once, is there some workaround using an external tool that would let me edit the information into the records before uploading them? 099 issues: We have a number of e-books that were cataloged in Voyager, the system we used before Koha. The Voyager produced records MARC 099 field information that listed them as e-books, and they don't have the "availability message" problem. I would have liked to see whether adding an 099 field with identical information to the incoming records would fix this, but these records do not have 099's provided by the vendor, since that field is used for a Local Free-Text Call Number. When I open the editor in Koha, I see no way to add this field to an existing record. We have editable 099 fields for records if they were migrated from our old catalog and already contained an 099 field. However, when we upload records without 099 fields from other sources, we see no way to add the field.. The apparent lack of a method to add 099 fields to imported MARC records has proved to be a significant problem for our Cataloger. That issue affects not just e-books but also many other types of items. Ideally, I'd like to have an actual link to the e-book, or at least to the book's Koha record in the summary results field of the opac. But right now, I'll settle for some way to change "no items available" to "EBOOK" without hand-editing thousands of records. And if anyone can tell me how to add an 099 field to an item that isn't imported with one, I'd be most grateful to learn that. We are using 3.01.00.037 with LibLime Enterprise Koha build: 4.0100000. And yes, I do know LEK isn't real open source Koha, but there isn't a LEK user's list which I can join. The support list LibLime set up for bug reports has booted me and some other subscribers off because, I was told, they wanted to limit participation on that list as there was getting to be to much traffic. They also refuse to give us access to the LEK Bugzilla tracking, even on a read-only basis... but that's another story. I'm on digest, so please cc: me on any answers sent to the list. Advance thanks. -- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.pober@manhattan.edu
Stacy Pober a écrit :
then the e-book correctly shows up as EBOOK in the summary display.
However, the prospect of manually editing over 3000 holdings records is too hideous to contemplate.
Koha 3.2 has/will have a bulk item edition tool: you select your barcodes/itemnumber, you define what changes you want to do, and it's done on all your items-collection (information useless to LEK users probably, sorry) For the rest of your problem: couldn't marcedit be usefull to update your marcrecords before importing them ? HTH -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
Dear Stacy, On Tue, 8 Dec 2009 04:51:42 -0500, Stacy Pober <stacy.pober@manhattan.edu> wrote:
Is thers some shortcut to change all of an incoming batch of MARC-21 records to have the same holdings information? If so, could someone here kindly guide me through it?
yes, it possible. You need to manipolate your vendor file and insert, for every record a tag 952. The structure of 952 id http://wiki.koha.org/doku.php?id=en:documentation:marc21holdings_holdings_da... Koha Item Type: Electronic book -> 952$y Collection code: Ebooks -> 952$8 Shelving Location: EBOOKS -> 952$c
Before uploading the MARC file for the first 200+ records, I used a text editor that could handle large files and prepended our EZproxy string onto the book's URL using a macro. That went smoothly. If there is no shortcut or tool in Koha for changing holdings on a large batch of records at once, is there some workaround using an external tool that would let me edit the information into the records before uploading them?
If you need to insert the exact same value in every 952, you can use a text editor. You can use also MarcEdit, and advanced MARC editor. To more advanced manipulation you need to write a specific script. Attention that the structure of 952 that I write you is the default structure of Koha 3.0.x/3.1.x LEK could be different.
And if anyone can tell me how to add an 099 field to an item that isn't imported with one, I'd be most grateful to learn that. We are using 3.01.00.037 with LibLime Enterprise Koha build: 4.0100000.
You need to setup the field 099 as you lke in you cataloguing framework. But I don't know if LEK allows you to do it. In Koha: Home › Administration › MARC Frameworks > (select the framework and read the help). http://koha.org/documentation/manual/3.0/administration/catalog-administrati...
And yes, I do know LEK isn't real open source Koha, but there isn't a LEK user's list which I can join. The support list LibLime set up for bug reports has booted me and some other subscribers off because, I was told, they wanted to limit participation on that list as there was getting to be to much traffic.
I think is quite strange, you have paid to have support to LibLime. Bye
participants (3)
-
Paul Poulain -
Stacy Pober -
tajoli