<!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>
<DIV><FONT face=Arial size=2>Paul,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks for the prompt response! That is what I had
assumed and so I am puzzled as to why I am getting errors in rebuildnonmarc.pl.
We used the 952 "user" tag because that was already defined in our
db.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Here is a sample of the error:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New" size=2>DBD::mysql::st execute failed: Column
'tagorder' cannot be null at c:\usr\koha200\intranet\modules/C4/Biblio.pm line
385.<BR>ERROR ==> insert into marc_subfield_table
(bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue)
values (387,952,, ,b,1,SEF)<BR>DBD::mysql::st execute failed: Column
'tagorder' cannot be null at c:\usr\koha200\intranet\modules/C4/Biblio.pm line
932.<BR>ERROR ==> insert into marc_word (bibid, tag, tagorder, subfieldid,
subfieldorder, word, sndx_word) values
(387,952,,b,1,SEF,soundex(SEF))<BR></FONT> </DIV>
<DIV><FONT face=Arial size=2>Also, every "952" linked field, ie. every 'items'
table field shows up twice but only on "intranet" pages. When we look at biblios
from OPAC pages, they appear correctly. When we try to edit the 'items' data,
things really get messed up. The changes appear to 'take' but then aren't
there when you do a search, for example, on bar code.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm scratching my head for ideas here. We
are running Koha 2.0.0. Win32. We loaded everything into a clean db,
a copy of blank200 with the marc_subfield_structure and marc_tag_structure
tables built from the sql script provided with the installation. I can't see
anything amiss in the table structure.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Again, thanks in advance for any help.</FONT></DIV>
<DIV><FONT face=Arial size=2>Dana</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=paul.poulain@free.fr href="mailto:paul.poulain@free.fr">Paul
POULAIN</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=dana@sefovan.org
href="mailto:dana@sefovan.org">Dana Huff</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=koha@lists.katipo.co.nz
href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, 22 September 2004 10:14
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Koha] Re: More questions
for migrating to koha</DIV>
<DIV><BR></DIV>Dana Huff a écrit :<BR><BR>> Paul and Andres (I think)
wrote:<BR>> <BR>> >> The other idea is Build a full record
with as many 035 tags as copies<BR>> >> of that book we have.
Again bulkmarcimport should take into account<BR>> >> this and build
the biblio and biblioitems needed.<BR>> >><BR>> >> We want
to know what is the proper way to build our records in order<BR>> >>
to get this reality fully represented in the koha database.<BR>>
><BR>> ><BR>> > Yes, that's the proper way if you speak of
biblio & items.<BR>> > in this case, the 035 subfields MUST be
mapped to item tab (10) and<BR>> > don't map a 035 subfield in another
tab (except for ignore).<BR>> I am confused. In other threads it has been
recommended to put copies <BR>> and other holdings information in 852 tags
or to create 952 user tags. <BR>> The 035 tag is for SYSTEM CONTROL NUMBER.
Is this a better <BR>> alternative? Do you then create your own (non-MARC)
subfields?<BR>> I am especially interested because I am trying to
load our Koha DB <BR>> and have used 952 tags for holding information. Now
I show duplicate <BR>> entries for all item information in the intranet
pages but the items <BR>> show up correctly in the opac screens. Looking at
the db, the correct <BR>> items entries are present for each biblio. The
problem seems to be in <BR>> the marc_subfield_table table when there are
multiple tag entries for <BR>> the 952 tags where there should be only one.
Also, I get errors when I <BR>> run "rebuildnommarc.pl" complaining of null
data in the tagorder field.<BR>> <BR>> Your comments would be
appreciated.<BR>> <BR>> Dana<BR><BR>If I understand correctly your
question, then I've a nice answer for you <BR>: you can put your items
information WHERE YOU WANT : 035, 952, 852. <BR>For french UNIMARC it's
995.<BR>That's the beauty of Koha ;-)<BR>The only rules are :<BR>* put all
your items fields to the same TAG<BR>* in this TAG put only items
informations<BR>* use the koha <-> MARC relation to "map" MARC to the
item table.<BR><BR>All the rest is done magically ;-)<BR><BR>-- <BR>Paul
POULAIN<BR>Consultant indépendant en logiciels libres<BR>responsable
francophone de koha (SIGB libre <A
href="http://www.koha-fr.org">http://www.koha-fr.org</A>)<BR><BR></BLOCKQUOTE></BODY></HTML>