Paul and Andres (I think) wrote:
The other idea is Build a full record with as many 035 tags as copies of that book we have. Again bulkmarcimport should take into account this and build the biblio and biblioitems needed.
We want to know what is the proper way to build our records in order to get this reality fully represented in the koha database.
Yes, that's the proper way if you speak of biblio & items. in this case, the 035 subfields MUST be mapped to item tab (10) and don't map a 035 subfield in another tab (except for ignore).
I am confused. In other threads it has been recommended to put copies and other holdings information in 852 tags or to create 952 user tags. The 035 tag is for SYSTEM CONTROL NUMBER. Is this a better alternative? Do you then create your own (non-MARC) subfields? I am especially interested because I am trying to load our Koha DB and have used 952 tags for holding information. Now I show duplicate entries for all item information in the intranet pages but the items show up correctly in the opac screens. Looking at the db, the correct items entries are present for each biblio. The problem seems to be in the marc_subfield_table table when there are multiple tag entries for the 952 tags where there should be only one. Also, I get errors when I run "rebuildnommarc.pl" complaining of null data in the tagorder field. Your comments would be appreciated. Dana
Dana Huff said:
I am confused. In other threads it has been recommended to put copies and other holdings information in 852 tags or to create 952 user tags. The 035 tag is for SYSTEM CONTROL NUMBER. Is this a better alternative? Do you then create your own (non-MARC) subfields?
I agree, that was confusing. You are quite right, the holdings information (all of the information specific to each copy of a title, such as barcode, date aquired, etc) goes into a holdings tag. 852 is very common in MARC21, though you can define your own holdings tag, as long as the tag number starts with "9" (like "952"). This tag gets repeated in the MARC record -- once for each copy owned.
I am especially interested because I am trying to load our Koha DB and have used 952 tags for holding information. Now I show duplicate entries for all item information in the intranet pages but the items show up correctly in the opac screens. Looking at the db, the correct items entries are present for each biblio. The problem seems to be in the marc_subfield_table table when there are multiple tag entries for the 952 tags where there should be only one.
You are allowed to have multiple 952 tags, of course (one for each copy). But I assume you are looking at _two_ 952 tags for each copy? Seems like someone else had this problem before. Does anyone remember that thread? What was the solution?
Also, I get errors when I run "rebuildnommarc.pl" complaining of null data in the tagorder field.
Could you go to bugs.koha.org and submit a bug report on this? Stephen -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
Stephen said:
You are allowed to have multiple 952 tags, of course (one for each copy). But I assume you are looking at _two_ 952 tags for each copy?
That is correct, _two_ 952 tags for all fields: barcode, price, homebranch, etc., for each copy. Thanks, Dana
Dana Huff a écrit :
Stephen said:
You are allowed to have multiple 952 tags, of course (one for each copy). But I assume you are looking at _two_ 952 tags for each copy?
That is correct, _two_ 952 tags for all fields: barcode, price, homebranch, etc., for each copy.
Koha CAN NOT handle that. You must rewrite your datas before importing them into Koha. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Paul, This is the problem. When I create my Marc data, I create ONE 952 tag for each copy of the book. Each 952 tag has 'homebranch', 'holdingbranch', 'barcode', and 'price'. So for example, in a text representation of the Marc record (copying from MarcEdit which I am using to convert my text to marc format) where I have 2 copies of the book: =LDR 00000nam 2200000Ia 45e0 =008 040921s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a848267353 =082 \\$a226.5$bMOR =100 \\$aMORRIS, Leon =245 \\$aJesús es el Cristo: Estudios sobre la Teología de Juan =260 \\$aBarcelona, ES$bEditorial Clie$2003 =300 \\$fES =440 \\$aColección Teologica Contemporanea =952 \\$bSEF$dSEF$pI0494007682$r18 =952 \\$bSEF$dSEF$pI0494007690$r18 When I use bulkmarcimport.pl to import the data into Koha, I get what appear to be correct insertions into the 'biblio', 'biblioitems', and 'items' tables. For this example, I would have two 'items' rows linked to the 'biblio' and 'biblioitems' records. BUT, the mapping in the 'marc_subfield_table' doubles each associated entry in the 'items' table. To illustrate: mysql> SELECT `biblionumber`,`title`,`author` FROM biblio WHERE biblionumber = 3; +--------------+--------------------------------------------------------+--------------+ | biblionumber | title | author | +--------------+--------------------------------------------------------+--------------+ | 3 | Jes·s es el Cristo: Estudios sobre la TeologÝa de Juan | MORRIS, Leon | +--------------+--------------------------------------------------------+--------------+ 1 row in set (0.00 sec) mysql> SELECT biblionumber,homebranch,holdingbranch,barcode,price FROM items WHERE biblionumber = 3; +--------------+------------+---------------+-------------+-------+ | biblionumber | homebranch | holdingbranch | barcode | price | +--------------+------------+---------------+-------------+-------+ | 3 | SEF | SEF | I0494007682 | 18.00 | | 3 | SEF | SEF | I0494007690 | 18.00 | +--------------+------------+---------------+-------------+-------+ 2 rows in set (0.00 sec) mysql> SELECT `bibid`, `tag`, `tagorder`, `subfieldcode`, `subfieldorder`, `subfieldvalue`, `valuebloblink` FROM `marc_subfield_table` WHERE `bibid` = 389; +-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+ | bibid | tag | tagorder | subfieldcode | subfieldorder | subfieldvalue | valuebloblink | +-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+ | 389 | 260 | 7 | a | 1 | Barcelona, ES | NULL | | 389 | 245 | 6 | a | 1 | Jes·s es el Cristo: Estudios sobre la TeologÝa de Juan | NULL | | 389 | 100 | 5 | a | 1 | MORRIS, Leon | NULL | | 389 | 090 | 4 | c | 1 | 3 | NULL | | 389 | 090 | 4 | d | 2 | 3 | NULL | | 389 | 082 | 3 | b | 2 | MOR | NULL | | 389 | 082 | 3 | a | 1 | 226.5 | NULL | | 389 | 020 | 2 | a | 1 | 848267353 | NULL | | 389 | 952 | 9 | b | 1 | SEF | NULL | | 389 | 952 | 9 | d | 2 | SEF | NULL | | 389 | 952 | 9 | p | 3 | I0494007682 | NULL | | 389 | 952 | 9 | r | 4 | 18 | NULL | | 389 | 952 | 10 | b | 1 | SEF | NULL | | 389 | 952 | 10 | d | 2 | SEF | NULL | | 389 | 952 | 10 | p | 3 | I0494007690 | NULL | | 389 | 952 | 10 | r | 4 | 18 | NULL | | 389 | 008 | 1 | | 1 | 040921s9999 xx 000 0 und d | NULL | | 389 | 952 | 12 | b | 1 | SEF | NULL | | 389 | 952 | 12 | d | 2 | SEF | NULL | | 389 | 952 | 12 | p | 3 | I0494007682 | NULL | | 389 | 952 | 12 | r | 4 | 18 | NULL | | 389 | 952 | 12 | u | 5 | 3 | NULL | | 389 | 952 | 13 | b | 1 | SEF | NULL | | 389 | 952 | 13 | d | 2 | SEF | NULL | | 389 | 952 | 13 | p | 3 | I0494007690 | NULL | | 389 | 952 | 13 | r | 4 | 18 | NULL | | 389 | 952 | 13 | u | 5 | 4 | NULL | | 389 | 260 | 7 | b | 2 | Editorial Clie | NULL | | 389 | 260 | 7 | c | 3 | 2003 | NULL | | 389 | 300 | 8 | f | 1 | ES | NULL | | 389 | 440 | 9 | a | 1 | Colecci¾n Teologica Contemporanea | NULL | +-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+ 31 rows in set (0.00 sec) mysql> This can't be happening to everyone so I must have some configuration problem. Could I be missing some PERL library? But, I get no errors when running bulkmarcimport.pl. I hope this additional information helps to clarify my problem. Thanks, Dana ----- Original Message ----- From: Paul POULAIN To: Dana Huff Cc: koha@lists.katipo.co.nz Sent: Thursday, 23 September 2004 10:43 AM Subject: Re: [Koha] Double _items_ tags, Was: More questions for migrating to koha Dana Huff a écrit :
Stephen said:
You are allowed to have multiple 952 tags, of course (one for each copy). But I assume you are looking at _two_ 952 tags for each copy?
That is correct, _two_ 952 tags for all fields: barcode, price, homebranch, etc., for each copy.
Koha CAN NOT handle that. You must rewrite your datas before importing them into Koha. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Dana Huff a écrit :
Paul, This is the problem. When I create my Marc data, I create ONE 952 tag for each copy of the book. Each 952 tag has 'homebranch', 'holdingbranch', 'barcode', and 'price'. So for example, in a text representation of the Marc record (copying from MarcEdit which I am using to convert my text to marc format) where I have 2 copies of the book:
I'm 80% sure this is due to your koha mappings. Check twice that : * ALL subfields in 952 field are either in 10 (item) or -1 (ignore) tab. * NO subfield outside 952 are in 10 (item) tab. This can be checked with Links Koha-Marc DB, using items tab. If there is something outside 952. (I bet EUR1 that the 1st 952$ not being -1 is NOT in a 10 but a 1-9 ;-) ) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Paul said:
I'm 80% sure this is due to your koha mappings. Check twice that : * ALL subfields in 952 field are either in 10 (item) or -1 (ignore) tab.
I checked very carefully 3 and 4 times: both in Koha parameters and in MySQL and all 952 fields are either 10 or -1.
* NO subfield outside 952 are in 10 (item) tab. This can be checked with Links Koha-Marc DB, using items tab. If there is something outside 952.
The 'items' table only maps to 952 tags and furthermore, there is no other mapping of a 952 field to any other Koha table but 'items'. (I bet EUR1 that the 1st 952$ not being -1 is NOT in a 10 but a 1-9 ;-) ) I hate to take your money, Paul, but I cannot find a problem in this area. I wish I could! Dana
Paul, I found the problem. I will discuss it with you offline. Dana ----- Original Message ----- From: Paul POULAIN To: Dana Huff Cc: koha@lists.katipo.co.nz Sent: Thursday, 23 September 2004 12:05 PM Subject: Re: [Koha] Double _items_ tags, Was: More questions for migrating to koha Dana Huff a écrit :
Paul, This is the problem. When I create my Marc data, I create ONE 952 tag for each copy of the book. Each 952 tag has 'homebranch', 'holdingbranch', 'barcode', and 'price'. So for example, in a text representation of the Marc record (copying from MarcEdit which I am using to convert my text to marc format) where I have 2 copies of the book:
I'm 80% sure this is due to your koha mappings. Check twice that : * ALL subfields in 952 field are either in 10 (item) or -1 (ignore) tab. * NO subfield outside 952 are in 10 (item) tab. This can be checked with Links Koha-Marc DB, using items tab. If there is something outside 952. (I bet EUR1 that the 1st 952$ not being -1 is NOT in a 10 but a 1-9 ;-) ) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (3)
-
Dana Huff -
Paul POULAIN -
Stephen Hedges