Re: [Koha] Batch imports of MARC records for e-books and 099 fields for regular books
Thank you so much for the help. I had a little bumpy patch figuring out MarcEdit (I haven't had to really look at cataloging record structure in detail since library school). It finally worked when I added: 952$o Electronic Book and 942$c EBOOKS in addition to the fields Tajoli suggested. It could be that one of those was unnecessary, but since it finally looked right, I was disinclined to do more testing at that point. It's now almost exactly right. There's just one little thing left. Each book I added has an empty parentheses at the end of the Availability section of the display. I'm told this is the # of copies available. I looked at some of our records for ebooks that were migrated from Voyager, and also looked at some other Koha libraries that had ebooks, but I was unable to figure out what field controlled the contents of those parenthesis. Either the parenthesis should have the numeral 1 in them, or they shouldn't appear at all for e-book records. So can someone either tell me what MARC field/subfield controls the contents of those parenthesis, or else how to suppress the parentheses entirely when displaying ebooks in search results. Example of search results with empty parentheses: <http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-search.pl?q=gale+virtual> or <http://bit.ly/5i7itX> [If you send your reply to the list, please cc: <stacy.pober@manhattan.edu> as I am on digest.] Advance thanks, Stacy On Tue, Dec 8, 2009 at 5:27 AM, tajoli <tajoli@cilea.it> wrote:
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
-- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.pober@manhattan.edu
Hi,
There's just one little thing left. Each book I added has an empty parentheses at the end of the Availability section of the display. I'm told this is the # of copies available. [...] so can someone either tell me what MARC field/subfield controls the contents of those parenthesis, or
I'm not sure because I don't how LEK config display. I think the field is 952. Check the difference between http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=20... and http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=21...
or else how to suppress the parentheses entirely when displaying ebooks in search results.
You can't do it, because you don't have access to command-line of your installation. Bye Zeno Tajoli
Hi,
Check the difference between http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=20... and http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=21...
Yes, the first one was migrated from our Voyager records, the second one was imported by me after some tweaking in MarcEdit. There are four 952 subfields in the migrated record that are not in the one I uploaded. Here they are with their contents: $2 z $a MAN $b MAN $r 2008-05-10 subfields $a and $b are branchcodes, according to the documentation (and the contents look appropriate for that, though I think only one 'branch' is defined now. According to the official Koha version's manual, <http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration> Data Migration – Koha Item Fields: "Source of classification or shelving scheme Koha tag: 952$2 "Classification scheme that defines filing rules used for sorting call numbers. If no classification scheme is entered, the system will use the value entered in the Cataloging preference "DefaultClassificationSource" "Date last seen * Koha tag: 952$r "The last date that the item was last seen in the library (checked in / checked out / inventoried)." I can put in a test record with those fields and see if that makes a difference, but I would be surprised if it changed anything. I did test by adding a $t (copy number) subfield of: $t 1 but that didn't change the empty parentheses issue. I am wondering if the contents of the parenthesis for number of copies is a value derived from another field entirely. I did find another library that had their e-books correctly indicating 1 or 2 copies and that's where I got the idea of using a 952$t. However, there are other differences throughout their records, and I don't know if the 952 is the specific subfield that is making the difference in their records.. Is there some documentation available for official Koha that shows where each data element is pulled from the MARC record for each element of the public catalog (i.e. not staff view) display? In case the above question isn't clear, I'm looking for which field/subfield is used to derive each element of the OPAC view of the record, particularly where the summary is given of the records (i.e. in the initial display of search results when multiple items are displayed.) One thing I've noticed in our catalog is that some of the fields that display in the MARC view do not display in the Expanded MARC view. In the MARC view, I can see the 942 (if present) and 952 fields. In the Expanded MARC view, I cannot. I tend to assume that kind of discrepancy is a bug, but I thought I should mention it here first in case it is a feature. Expanded MARC view: <http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=200959> [Click on "MARC view" tag for plain text MARC display - I don't think I can provide a direct link to the plain text MARC version. ] Stacy On Mon, Dec 14, 2009 at 3:32 PM, tajoli <tajoli@cilea.it> wrote:
Hi,
There's just one little thing left. Each book I added has an empty parentheses at the end of the Availability section of the display. I'm told this is the # of copies available. [...] so can someone either tell me what MARC field/subfield controls the contents of those parenthesis, or
I'm not sure because I don't how LEK config display. I think the field is 952.
Check the difference between http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=20... and http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=21...
or else how to suppress the parentheses entirely when displaying ebooks in search results.
You can't do it, because you don't have access to command-line of your installation.
Bye Zeno Tajoli
-- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.pober@manhattan.edu
2009/12/15 Stacy Pober <stacy.pober@manhattan.edu>:
Hi,
Check the difference between http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=20... and http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=21...
Yes, the first one was migrated from our Voyager records, the second one was imported by me after some tweaking in MarcEdit.
There are four 952 subfields in the migrated record that are not in the one I uploaded. Here they are with their contents:
$2 z $a MAN $b MAN $r 2008-05-10
subfields $a and $b are branchcodes, according to the documentation (and the contents look appropriate for that, though I think only one 'branch' is defined now.
According to the official Koha version's manual, <http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration> Data Migration – Koha Item Fields:
"Source of classification or shelving scheme Koha tag: 952$2
"Classification scheme that defines filing rules used for sorting call numbers. If no classification scheme is entered, the system will use the value entered in the Cataloging preference "DefaultClassificationSource"
"Date last seen * Koha tag: 952$r
"The last date that the item was last seen in the library (checked in / checked out / inventoried)."
I can put in a test record with those fields and see if that makes a difference, but I would be surprised if it changed anything. I did test by adding a $t (copy number) subfield of: $t 1 but that didn't change the empty parentheses issue.
I am wondering if the contents of the parenthesis for number of copies is a value derived from another field entirely.
I suspect it is because the item has no home or holding branch, can you do me a favour, just edit one, and set a homebranch and an holdingbranch, then check if it is doing a count. (952a and 952b) I know it doesn't really make sense for EBOOKS but maybe the branch could be EBOOKS :) It tries to count how many items are available at each branch. Chris
Chris, Thanks so much! You're right, the $a and $ b fields control the parentheses contents. Putting a branch code in them fixed the problem. Is there some documentation that shows what MARC field/subfield is used to produce each element of the the patron view of an item record in a search result and the same for a detailed item record? Also useful to know would be which of the item record elements are mapped directly from a MARC subfield and which are derived (calculated) from data in a subfield. If that's in some Koha documentation, then it would be useful to have. I couldn't find it in either the official Koha or LibLime Enterprise Koha documents, and I did try looking for it before posting to the list. Thanks again. You folks are SO helpful. Stacy On Mon, Dec 14, 2009 at 6:29 PM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
2009/12/15 Stacy Pober <stacy.pober@manhattan.edu>:
Hi,
Check the difference between http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=20... and http://man.waldo.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=21...
Yes, the first one was migrated from our Voyager records, the second one was imported by me after some tweaking in MarcEdit.
There are four 952 subfields in the migrated record that are not in the one I uploaded. Here they are with their contents:
$2 z $a MAN $b MAN $r 2008-05-10
subfields $a and $b are branchcodes, according to the documentation (and the contents look appropriate for that, though I think only one 'branch' is defined now.
According to the official Koha version's manual, <http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration> Data Migration – Koha Item Fields:
"Source of classification or shelving scheme Koha tag: 952$2
"Classification scheme that defines filing rules used for sorting call numbers. If no classification scheme is entered, the system will use the value entered in the Cataloging preference "DefaultClassificationSource"
"Date last seen * Koha tag: 952$r
"The last date that the item was last seen in the library (checked in / checked out / inventoried)."
I can put in a test record with those fields and see if that makes a difference, but I would be surprised if it changed anything. I did test by adding a $t (copy number) subfield of: $t 1 but that didn't change the empty parentheses issue.
I am wondering if the contents of the parenthesis for number of copies is a value derived from another field entirely.
I suspect it is because the item has no home or holding branch, can you do me a favour, just edit one, and set a homebranch and an holdingbranch, then check if it is doing a count.
(952a and 952b) I know it doesn't really make sense for EBOOKS but maybe the branch could be EBOOKS :) It tries to count how many items are available at each branch.
Chris
-- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.pober@manhattan.edu
2009/12/16 Stacy Pober <stacy.pober@manhattan.edu>:
Chris,
Thanks so much!
You're right, the $a and $ b fields control the parentheses contents.
Putting a branch code in them fixed the problem.
Is there some documentation that shows what MARC field/subfield is used to produce each element of the the patron view of an item record in a search result and the same for a detailed item record?
Also useful to know would be which of the item record elements are mapped directly from a MARC subfield and which are derived (calculated) from data in a subfield. If that's in some Koha documentation, then it would be useful to have. I couldn't find it in either the official Koha or LibLime Enterprise Koha documents, and I did try looking for it before posting to the list.
Hi Stacy It depends if you are using the XSLT display or not. If you are using the XSLT display, then you can control what shows by editing the XSL stylesheets. With the normal display it isn't document except with comments inside the code. Maybe Nicole could write that up :) (*running away and hiding now*) Chris
Nicole needs some training in XSL before she can write that ;) but I'm up for anyone else writing it and me putting it in the manual with the appropriate crediting information :) Nicole 2009/12/15 Chris Cormack <chris@bigballofwax.co.nz>:
2009/12/16 Stacy Pober <stacy.pober@manhattan.edu>:
Chris,
Thanks so much!
You're right, the $a and $ b fields control the parentheses contents.
Putting a branch code in them fixed the problem.
Is there some documentation that shows what MARC field/subfield is used to produce each element of the the patron view of an item record in a search result and the same for a detailed item record?
Also useful to know would be which of the item record elements are mapped directly from a MARC subfield and which are derived (calculated) from data in a subfield. If that's in some Koha documentation, then it would be useful to have. I couldn't find it in either the official Koha or LibLime Enterprise Koha documents, and I did try looking for it before posting to the list.
Hi Stacy
It depends if you are using the XSLT display or not. If you are using the XSLT display, then you can control what shows by editing the XSL stylesheets. With the normal display it isn't document except with comments inside the code.
Maybe Nicole could write that up :) (*running away and hiding now*)
Chris _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Chris Cormack -
Nicole Engard -
Stacy Pober -
tajoli