[Koha] import question
Derek Dresser
Derek.Dresser at gouldacademy.org
Fri Jul 11 06:32:31 NZST 2003
Quoting Dan Weeks <Dan at bibliofiche.com>:
> FYI:
>
> Typicly 852a would hold a "homebranch" and 852b the "holdingbranch": this
is
> not always
> consistant but never-the-less defined as part of he 852 holding structure.
> Once you place
> a barcode on a book you need no acsession number (which is what I assume
you
> mean by "Item
> number"). The barcode IS the item number.
Thanks Dan,
actually, the itemnumber I am referring to is the koha items.itemnumber It
can't be NULL, nor can items.barcode. (I think) It seems like I could either
make the items.itemnumber just a sequence of unique numbers, or I could make
them the same as the barcode, but koha won't seem to let me map two koha
fields to the same MARC subfield. I could manually stick the data into the
"items" table in the database, but I'm hoping to figure out the "right" way
to do this during import so it will be useful for others.
Thanks,
Derek
>
> All 900 fields are "user defined" and not part of any marc definition. Many
> combinations
> have been used and accepted through the years but 852 is the defined area
for
> a holding.
> (A "holding" is specific to the individual item, as opposed the the Biblio
> which defines
> the title and author and publishing data. i.e. One "biblio" of a popular
> title could have
> many "holdings" in the library. This is also why the barcode of the book
> becomes the only
> "item" number you need.)
>
> Here is the LC definition of 852.
> http://www.loc.gov/marc/bibliographic/ecbdhold.html#mrcb852
>
> Dan
>
> ----- Original Message -----
> From: "Derek Dresser" <Derek.Dresser at gouldacademy.org>
> To: "paul POULAIN" <paul.poulain at free.fr>
> Sent: Thursday, July 10, 2003 11:31 AM
> Subject: Re: [Koha] import question
>
>
> > > >Paul ... any ideas?
> > > >
> > > >
> > > Of course yes :-)
> > > If you want import to put items into items table, you have to tell Koha
> > > where are hidden your items in your MARC datas...
> > > Let me explain :
> > > Koha supports any MARC flavour. And each MARC flavour hides items in a
> > > different place (for example in UNIMARC, it's 995. For NPL, that uses
> > > MARC21, it's 952)
> > > * Go to parameter section of Koha, MARC parameters tables.
> > > * Search for the field where items are hidden (for example 947)
> > > * Open subfields of field 947.
> > > * "map" each 947 subfield to a items.something field.
> > > * Put each subfield you've mapped to tab "items".
> > > * go back to main parameter page
> > > * run "checkmarc". If it reports no errors, you've win.
> > > * import again, using delete flag to empty your database during the
> > process.
> > >
> > > Hope This Helps
> >
> > Hi, I've got a few questions and some more info. First of all, my data
is
> > in MicroLIF format, which is apparently basically USMARC from what I
> > understand. I am using the MARC21 parameters at install time. I looked
> at
> > the MARC records in Winnebago, and it seems that
> > the "hidden" data is in the 852 field. However, it appears that the only
> > data in that field is the call number and bar code, while the MARC Check
> > requires that I map itemnumber, barcode, homebranch and holdingbranch at
a
> > minimum I think (and all within the 852 field).
> >
> > It seems like the import works fine for the biblios and biblioitems.
> Should
> > I just extract the barcode and call number afterwards and populate the
> items
> > table separately? If so, should I use the barcode number for the item
> > number, or just start with 1 and go up sequentially? How can I solve
this
> > problem so it will be the most useful for others in the long run? Does
it
> > make sense to have another import type "MicroLIF", or "Winnebago"?
Thanks
> > in advance for any ideas. I have included a small piece of my data
again,
> > in case it is useful.
> >
> > Thanks,
> > Derek
> >
> > 00623pam 2200181 a
> >
>
450000100130000000800410001302000150005405000210006908200140009010000350010424500860013926
> 00066002253000026002915040065003176500030003828520023004129610006004\35^^
> > 85023778 ^^851129s1986 nyu b 00010 eng ^^ ^_a0025003402^^0
> > ^_aAZ221^_b.A35 1986^^0 ^_a001.2^_219^^10^_aAdler, Mortimer
> > Jerome,^_d1902-^^12^_aA guidebook to le\arning :^_bfor a lifelong pursuit
> of
> > wisdom /^_cMortimer J. Adler.^^0 ^_aNew York :^_bMacmillan ;^_aLondon
> > :^_bCollier Macmillan,^_cc1986.^^ ^_axii, 163 p. ;^_c22 cm.^^ ^_a"Som\e
> > books that may be helpful to autodidacts": p. 161-163.^^ 0^_aLearning and
> > scholarship.^^1 ^_h001.2 Ad59g^_p10001^^WL^_t6^^^]00600pam 2200205 a
> >
>
45000010013000000080041000130200\022000540200022000760500024000980820017001221000020001392
>
450064001592500012002232600038002353000035002735040039003086500016003478520025003639610006
> 00388^^
> > 84028794 ^^841231s198\5 nyua b 00110 eng ^^ ^_a0716717174
> > (pbk.)^^ ^_a071671695X (hard)^^0 ^_aQA276.12^_b.M66 1985^^0
> > ^_a001.4/22^_219^^10^_aMoore, David S.^^10^_aStatistics :^_bconcepts \and
> > controversies /^_cDavid S. Moore.^^ ^_a2nd ed.^^0 ^_aNew York :^_bW.H.
> > Freeman,^_cc1985.^^ ^_axvii, 350 p. :^_bill. ;^_c24 cm.^^ ^_aIncludes
> > bibliographies and index.^^ 0^\_aStatistics.^^1 ^_h001.422
> > M782s^_p10002^^WL^_t6^^^]
> >
> > >
> > > Note : the main constraint is that all MARC subfields mapped to item
> > > field MUST be in the same field (you can't have a part of an item into
> > > 947 & 2nd part in 935). If you have, then the only solution is to
> > > "rewritte" your MARC data before importing. We have a problem with
> > > itemtypes, that is not in items in Koha but seems to have it's place in
> > > there, that's what we will speak during today IRC meeting.
> > >
> > > --
> > > Paul POULAIN
> > > Consultant indépendant en logiciels libres
> > > responsable francophone de koha (SIGB libre http://www.koha-fr.org)
> > >
> > >
> >
> >
> > --
> > Derek Dresser
> > http://network.gouldacademy.org/
> > Gould Academy
> > Bethel, ME 04217
> > (207)824-7700
> >
> > "Nothing endures but change"
> > --Heraclitus
> >
> >
> > -------------------------------------------------
> > This mail sent through IMP: http://horde.org/imp/
> >
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
>
--
Derek Dresser
http://network.gouldacademy.org/
Gould Academy
Bethel, ME 04217
(207)824-7700
"Nothing endures but change"
--Heraclitus
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
More information about the Koha
mailing list