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)