[Koha] Double _items_ tags, Was: More questions for migrating to koha
Dana Huff
dana at sefovan.org
Thu Sep 23 21:50:18 NZST 2004
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 at 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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20040923/91d579a6/attachment-0001.html
More information about the Koha
mailing list