[Koha] Import holdings as a separate file to MARC bib. records

Thu Jun 6 08:43:27 NZST 2013

We use 001 for this number too.

On Wed, Jun 5, 2013 at 1:48 PM, Fischer, Katrin <Katrin.Fischer at bsz-bw.de>wrote:

> Hi Iming,
>
> I think maybe use 001 in the bibliographic record for your matching? 001
> is indexed as "Control-number" and we use it for matching regularly.
>
> Katrin
>
>
> > -----Original Message-----
> > From: koha-bounces at lists.katipo.co.nz [mailto:koha-
> > bounces at lists.katipo.co.nz] On Behalf Of Iming Chan
> > Sent: Wednesday, June 05, 2013 2:18 PM
> > To: koha at lists.katipo.co.nz
> > Subject: Re: [Koha] Import holdings as a separate file to MARC bib.
> records
> >
> > Hi Katrin,
> >
> > Thank you for your help.
> >
> > Now my next question is: Each holding (item) record from our old system
> has
> > a unique number that links to the bibliographic record.  I am just unsure
> > which MARC tag in Koha that is ideal to store such number that I hope
> can be
> > used for matching purpose?
> >
> > Iming
> >
> >
> >
> >
> > Fischer, Katrin wrote
> > > Hi Iming,
> > >
> > > the matching process uses Zebra to find the right match. 997$c has to
> > > be indexed for this to work and the index name needs to be added to
> > > your matching rule configuration.
> > >
> > > Also I think you need to have all subfields for an item in one single
> > > 952 field in order for the items to be imported correctly.
> > >
> > > Hope this helps,
> > >
> > > Katrin
> > >
> > >> -----Original Message-----
> > >> From:
> >
> > > koha-bounces at .co
> >
> > >  [mailto:koha-
> > >>
> >
> > > bounces at .co
> >
> > > ] On Behalf Of Iming Chan
> > >> Sent: Wednesday, June 05, 2013 9:36 AM
> > >> To:
> >
> > > koha at .co
> >
> > >> Subject: [Koha] Import holdings as a separate file to MARC bib.
> > >> records
> > >>
> > >> Dear all,
> > >>
> > >> I have successfully migrated MARC bib. records from our old system to
> > >> Koha 3.12.  The old system can only export holdings (items) in csv
> > >> format, which I have successfully converted to MARC with Koha 952
> > >> tags (using MarcEdit).
> > >> A few examples below:
> > >>
> > >> =LDR  00292nam a2200145Ia 45e0
> > >> =008  130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> > >> =952  \\$2ddc
> > >> =952  \\$aCPL
> > >> =952  \\$bCPL
> > >> =952  \\$g7.95
> > >> =952  \\$o423.1 MACQ
> > >> =952  \\$p30094000001781
> > >> =952  \\$tIn Manager's Office
> > >> =952  \\$yBK
> > >> =997  \\$c26
> > >>
> > >> =LDR  00278nam a2200145Ia 45e0
> > >> =008  130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> > >> =952  \\$2ddc
> > >> =952  \\$71
> > >> =952  \\$aMPL
> > >> =952  \\$bMPL
> > >> =952  \\$g72.50
> > >> =952  \\$oLS 025.32 ANG
> > >> =952  \\$p30094000002920
> > >> =952  \\$yBK
> > >> =997  \\$c51
> > >>
> > >> =LDR  00278nam a2200145Ia 45e0
> > >> =008  130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> > >> =952  \\$2ddc
> > >> =952  \\$aMPL
> > >> =952  \\$bMPL
> > >> =952  \\$g0.00
> > >> =952  \\$oPER 051 REA
> > >> =952  \\$p10000032
> > >> =952  \\$t1999 Sept.
> > >> =952  \\$yBK
> > >> =997  \\$c78
> > >>
> > >> =LDR  00277nam a2200145Ia 45e0
> > >> =008  130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> > >> =952  \\$2ddc
> > >> =952  \\$aMPL
> > >> =952  \\$bMPL
> > >> =952  \\$g0.00
> > >> =952  \\$oPER 051 REA
> > >> =952  \\$p10000033
> > >> =952  \\$t1999 Oct.
> > >> =952  \\$yBK
> > >> =997  \\$c78
> > >>
> > >> Our old system Control Number is stored on 997$c tag and this number
> > >> is also found in each of our holdings record.  So it is logical to
> > >> match holdings to bibliographic records using 997$c tag (instead of
> > >> the ISBN 020$a or ISSN 022$a).  So I have setup a new matching rule
> > >> using 997$c in our Koha system.
> > >> However, after I imported the holdings MARC file to the reservoir
> > >> using the Staged MARC Import function, it informed me that no matches
> > >> were found (when I have selected 997$c as the match point)!
> > >>
> > >> Have I missed something?  Your assistance will be greatly appreciated.
> > >>
> > >> Iming
> > >>
> > >>
> > >>
> > >> -----
> > >>
> > >> Iming Chan
> > >> Translib Information Service
> > >> Melbourne, Australia
> > >> --
> > >> View this message in context:
> > >> http://koha.1045719.n5.nabble.com/Import-
> > >> holdings-as-a-separate-file-to-MARC-bib-records-tp5757122.html
> > >> Sent from the Koha-general mailing list archive at Nabble.com.
> > >> _______________________________________________
> > >> Koha mailing list  http://koha-community.org
> >
> > > Koha at .co
> >
> > >> http://lists.katipo.co.nz/mailman/listinfo/koha
> > >>
> > >
> > > _______________________________________________
> > > Koha mailing list  http://koha-community.org
> >
> > > Koha at .co
> >
> > > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> >
> >
> >
> > -----
> >
> > Iming Chan
> > Translib Information Service
> > Melbourne, Australia
> > --
> > View this message in context: http://koha.1045719.n5.nabble.com/Import-
> > holdings-as-a-separate-file-to-MARC-bib-records-tp5757122p5757174.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > _______________________________________________
> > Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)