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)