<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff background="">
<DIV><FONT face=Courier size=2>Paul,<BR><BR>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:<BR><BR>=LDR 00000nam 2200000Ia 45e0<BR>=008
040921s9999\\\\xx\\\\\\\\\\\\000\0\und\d<BR>=020
\\$a848267353<BR>=082 \\$a226.5$bMOR<BR>=100 \\$aMORRIS,
Leon<BR>=245 \\$aJesús es el Cristo: Estudios sobre la Teologí­a de
Juan <BR>=260 \\$aBarcelona, ES$bEditorial Clie$2003<BR>=300
\\$fES<BR>=440 \\$aColección Teologica Contemporanea<BR>=952
\\$bSEF$dSEF$pI0494007682$r18<BR>=952
\\$bSEF$dSEF$pI0494007690$r18<BR><BR>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.<BR><BR>To illustrate:<BR><BR>mysql> SELECT
`biblionumber`,`title`,`author` FROM biblio WHERE biblionumber =
3;<BR>+--------------+--------------------------------------------------------+--------------+<BR>|
biblionumber |
title
| author
|<BR>+--------------+--------------------------------------------------------+--------------+<BR>|
3 | Jes·s es el Cristo: Estudios sobre la TeologÝa de Juan | MORRIS, Leon
|<BR>+--------------+--------------------------------------------------------+--------------+<BR>1
row in set (0.00 sec)<BR><BR>mysql> SELECT
biblionumber,homebranch,holdingbranch,barcode,price FROM items WHERE
biblionumber =
3;<BR>+--------------+------------+---------------+-------------+-------+<BR>|
biblionumber | homebranch | holdingbranch | barcode |
price
|<BR>+--------------+------------+---------------+-------------+-------+<BR>|
3 | SEF |
SEF | I0494007682 |
18.00 |<BR>| 3
| SEF |
SEF | I0494007690 |
18.00
|<BR>+--------------+------------+---------------+-------------+-------+<BR>2
rows in set (0.00 sec)<BR><BR>mysql> SELECT `bibid`, `tag`, `tagorder`,
`subfieldcode`, `subfieldorder`, `subfieldvalue`, `valuebloblink` FROM
`marc_subfield_table` WHERE `bibid` =
389;<BR>+-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+<BR>|
bibid | tag | tagorder | subfieldcode | subfieldorder |
subfieldvalue
| valuebloblink
|<BR>+-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+<BR>|
389 | 260 | 7 |
a
| 1 |
Barcelona,
ES
| NULL |<BR>|
389 | 245 | 6 |
a
| 1 |
Jes·s es el Cristo: Estudios sobre la TeologÝa de Juan
| NULL |<BR>|
389 | 100 | 5 |
a
| 1 |
MORRIS,
Leon
| NULL |<BR>|
389 | 090 | 4 |
c
| 1 |
3
| NULL |<BR>|
389 | 090 | 4 |
d
| 2 |
3
| NULL |<BR>|
389 | 082 | 3 |
b
| 2 |
MOR
| NULL |<BR>|
389 | 082 | 3 |
a
| 1 |
226.5
| NULL |<BR>|
389 | 020 | 2 |
a
| 1 |
848267353
| NULL |<BR>|
389 | 952 | 9 |
b
| 1 |
SEF
| NULL |<BR>|
389 | 952 | 9 |
d
| 2 |
SEF
| NULL |<BR>|
389 | 952 | 9 |
p
| 3 |
I0494007682
| NULL |<BR>|
389 | 952 | 9 |
r
| 4 |
18
| NULL |<BR>|
389 | 952 | 10 |
b
| 1 |
SEF
| NULL |<BR>|
389 | 952 | 10 |
d
| 2 |
SEF
| NULL |<BR>|
389 | 952 | 10 |
p
| 3 |
I0494007690
| NULL |<BR>|
389 | 952 | 10 |
r
| 4 |
18
| NULL |<BR>|
389 | 008 | 1
|
| 1 |
040921s9999 xx 000 0 und
d
| NULL |<BR>|
389 | 952 | 12 |
b
| 1 |
SEF
| NULL |<BR>|
389 | 952 | 12 |
d
| 2 |
SEF
| NULL |<BR>|
389 | 952 | 12 |
p
| 3 |
I0494007682
| NULL |<BR>|
389 | 952 | 12 |
r
| 4 |
18
| NULL |<BR>|
389 | 952 | 12 |
u
| 5 |
3
| NULL |<BR>|
389 | 952 | 13 |
b
| 1 |
SEF
| NULL |<BR>|
389 | 952 | 13 |
d
| 2 |
SEF
| NULL |<BR>|
389 | 952 | 13 |
p
| 3 |
I0494007690
| NULL |<BR>|
389 | 952 | 13 |
r
| 4 |
18
| NULL |<BR>|
389 | 952 | 13 |
u
| 5 |
4
| NULL |<BR>|
389 | 260 | 7 |
b
| 2 |
Editorial
Clie
| NULL |<BR>|
389 | 260 | 7 |
c
| 3 |
2003
| NULL |<BR>|
389 | 300 | 8 |
f
| 1 |
ES
| NULL |<BR>|
389 | 440 | 9 |
a
| 1 |
Colecci¾n Teologica
Contemporanea
| NULL
|<BR>+-------+-----+----------+--------------+---------------+--------------------------------------------------------+---------------+<BR>31
rows in set (0.00 sec)<BR><BR>mysql></FONT></DIV>
<DIV><FONT face=Courier size=2></FONT> </DIV>
<DIV><FONT face=Courier size=2>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.</FONT></DIV>
<DIV><FONT face=Courier size=2>I hope this additional information helps to
clarify my problem.</FONT></DIV>
<DIV><FONT face=Courier size=2></FONT> </DIV>
<DIV><FONT face=Courier size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Courier size=2>Dana</FONT></DIV>
<DIV><FONT face=Courier size=2><BR>----- Original Message ----- <BR>From: Paul
POULAIN <BR>To: Dana Huff <BR>Cc: koha@lists.katipo.co.nz <BR>Sent: Thursday, 23
September 2004 10:43 AM<BR>Subject: Re: [Koha] Double _items_ tags, Was: More
questions for migrating to koha<BR><BR><BR>Dana Huff a écrit :<BR><BR>>
Stephen said:<BR>><BR>>> You are allowed to have multiple 952 tags, of
course (one for each <BR>>> copy).<BR>>> But I assume you are
looking at _two_ 952 tags for each copy?<BR>><BR>> That is correct, _two_
952 tags for all fields: barcode, price, <BR>> homebranch, etc., for each
copy.<BR><BR>Koha CAN NOT handle that. You must rewrite your datas before
importing <BR>them into Koha.<BR><BR>-- <BR>Paul POULAIN<BR>Consultant
indépendant en logiciels libres<BR>responsable francophone de koha (SIGB libre
http://www.koha-fr.org)</FONT></DIV></BODY></HTML>