[Koha] Matching authority records with tag 001
Giacomo Visini
Giacomo.VISINI at divaantwerp.be
Tue Oct 11 03:33:02 NZDT 2022
Hi everybody of the Koha community,
First of all, thank you for all the help.
I can tell you that the suggestion of Nick Clemens finally did the trick. We asked to reindex our database and it worked! It was this bug all along: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23053
Below the matching rule that did the trick:
Matching rule code: 001 LOCAL
Description: 001 Local-Number
Match threshold: 1000
Record type: Authority record
Match points
Search index: Local-Number
Score: 1000
Matchpoint components
Tag: 001
Subfields: (empty)
Offset: 0
Length: 0
Normalization rule: (none)
Maybe this can be of help for some people out there.
All the best,
Giacomo
Giacomo Visini I Library assistant
DIVA, Antwerp Home of Diamonds
Visiting adress library (temporary): Kaasstraat 13, B-2000 Antwerpen
Postal adress: Kaasstraat 13, B-2000 Antwerpen
T + 32 3 360 52 41 M + 32 485 66 49 98
giacomo.visini at divaantwerp.be www.divaantwerp.be
-----Oorspronkelijk bericht-----
Van: Koha <koha-bounces at lists.katipo.co.nz> Namens Nick Clemens
Verzonden: donderdag 29 september 2022 13:50
CC: koha at lists.katipo.co.nz
Onderwerp: Re: [Koha] Matching authority records with tag 001
You may wish to reindex and try again, depending on whether you have indexed your authorities since this bug:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23053
On Tue, Sep 20, 2022 at 4:24 AM Giacomo Visini < Giacomo.VISINI at divaantwerp.be> wrote:
> Hi Katrin,
>
> Thank you for your time.
>
> I exported the authority records with the 'export data' tool. Using
> MarcEdit's 'export tab delimited records' I converted the mrc-file to xlsx.
> Using OpenRefine I reconciled the 1XX tags and added 024 tags with
> ID's etc. I exported that again into a xlsx-file. Using MarcEdit again
> I converted that file to mrk and then to mrc.
>
> I can confirm that the 001 tags are a match. (below copy/paste from
> the actual mrc-files)
>
> This is the original record :
> =LDR 00220 a2200109 4500
> =001 85809
> =003 OSt
> =005 20170526155948.0
> =008 170526||\aca||aabn\\\\\\\\\\\|\a|a\\\\\d
> =040 \\$aOSt$cOSt
> =150 \\$a10de eeuw
> =942 \\$aTOPIC_TERM
>
> This is the record I like to match to it:
> =LDR 00362 a22a010013300
> =001 85809
> =003 OSt
> =005 20170526155948.0
> =008 170526||\aca||aabn\\\\\\\\\\\|\a|a\\\\\d
> =024 7\$1https://www.wikidata.org/wiki/Q8052$2wikidata$aQ8052
> =024 7\$1http://vocab.getty.edu/aat/300404502$2gettyaat$a300404502
> =040 <http://vocab.getty.edu/aat/300404502$2gettyaat$a300404502=040>
> \\$aOSt$cOSt
> =150 \\$a10de eeuw
> =942 \\$aTOPIC_TERM
>
> Doing this comparison, I've noticed the LDR has changed. Could this be
> the problem?
>
> All the best,
>
> Giacomo Visini I Library assistant
> DIVA, Antwerp Home of Diamonds
> Visiting adress library (temporary): Kaasstraat 13, B-2000 Antwerpen
> Postal adress: Kaasstraat 13, B-2000 Antwerpen T + 32 3 360 52 41 M +
> 32 485 66 49 98 giacomo.visini at divaantwerp.be www.divaantwerp.be
>
>
> -----Oorspronkelijk bericht-----
> Van: Katrin Fischer <katrin.fischer.83 at web.de>
> Verzonden: maandag 19 september 2022 21:49
> Aan: Giacomo Visini <Giacomo.VISINI at divaantwerp.be>;
> koha at lists.katipo.co.nz
> Onderwerp: Re: [Koha] Matching authority records with tag 001
>
> Hi Giacomo,
>
> did you export the records from Koha for batch editing? Can you
> confirm manually that the 001 of the records still match?
>
> Hope this helps,
>
> Katrin
>
> On 19.09.22 09:29, Giacomo Visini wrote:
> > Hi Katrin,
> >
> > Thank you for reaching out. We are using Zebra.
> >
> > Marcel de Rooy suggested changing the search index from 'Local-number'
> to 'Local-Number', but again, it just won't work.
> >
> > All the best,
> >
> > Giacomo Visini I Library assistant
> > DIVA, Antwerp Home of Diamonds
> > Visiting adress library (temporary): Kaasstraat 13, B-2000 Antwerpen
> > Postal adress: Kaasstraat 13, B-2000 Antwerpen T + 32 3 360 52 41 M
> > +
> > 32 485 66 49 98
> >
> >
> > -----Oorspronkelijk bericht-----
> > Van: Koha <koha-bounces at lists.katipo.co.nz> Namens Katrin Fischer
> > Verzonden: zondag 18 september 2022 18:35
> > Aan: koha at lists.katipo.co.nz
> > Onderwerp: Re: [Koha] Matching authority records with tag 001
> >
> > Hi Giacomo,
> >
> > are you using Elasticsearch or Zebra?
> >
> > Katrin
> >
> > On 14.09.22 15:57, Giacomo Visini wrote:
> >> Hi Caroline,
> >>
> >> Thank you very much for the suggestion! I've run every possibility
> using 'Local-number' as the search index, tweaking the threshold,
> score and length again, but I still can't get the records to match.
> Very weird. Maybe the problem lies somewhere else?
> >>
> >> Best regards,
> >>
> >> Giacomo Visini I Library assistant
> >> DIVA, Antwerp Home of Diamonds
> >> Visiting adress library (temporary): Kaasstraat 13, B-2000
> >> Antwerpen Postal adress: Kaasstraat 13, B-2000 Antwerpen T + 32 3
> >> 360 52 41 M +
> >> 32 485 66 49 98 giacomo.visini at divaantwerp.be www.divaantwerp.be
> >>
> >> -----Oorspronkelijk bericht-----
> >> Van: Koha <koha-bounces at lists.katipo.co.nz> Namens Caroline Cyr La
> >> Rose
> >> Verzonden: woensdag 14 september 2022 14:52
> >> Aan: koha at lists.katipo.co.nz
> >> Onderwerp: Re: [Koha] Matching authority records with tag 001
> >>
> >> Hi Giacomo,
> >>
> >> Can you try with the search index "Local-number" instead? I looked
> >> at
> the Zebra indexing files and this seems to be the index for 001 in
> authorities. "Control-number" would be for 001 in bibliographic records.
> >>
> >> I hope it helps,
> >>
> >> Caroline
> >>
> >> On 2022-09-14 05:23, Giacomo Visini wrote:
> >>> Hello colleague's,
> >>>
> >>> We are trying to import a bunch of authority records with updated
> fields, but I can't find the right way to match them with existing
> authority records. The only tag which is workable in our case should
> be 001. We have followed the manual meticulously, but it just doesn't work.
> >>>
> >>> Matching rules used below:
> >>>
> >>> Matching rule code: CNUMBER
> >>> Description: 001
> >>> Match threshold: 100
> >>>
> >>> 1. Search index: Control-number
> >>> 2. Score: 101
> >>> 1. Tag: 001
> >>> 2. Subfields: [blank]
> >>> 3. Offset: 0
> >>> 4. Length: 0
> >>> 5. Normalization rule: [none]
> >>>
> >>> Looking at past messages, we've tried changing the match threshold
> >>> to
> '1000' and the score to '1000'. Also, since this matching rule uses a
> control field, we've tried changing the length to '5' (correct in our
> case), but to no avail. We've even tried changing the subfield to 'a'
> and '@', but this doesn't seem to change anything.
> >>>
> >>> Anyone who encountered the same problem, but found a solution? Any
> suggestions?
> >>>
> >>> We are using 21.11.06 with Zebra
> >>>
> >>> Thanks in advance.
> >>>
> >>> Giacomo Visini I Library assistant DIVA, Antwerp Home of Diamonds
> >>> Visiting adress library (temporary): Kaasstraat 13, B-2000
> >>> Antwerpen Postal adress: Kaasstraat 13, B-2000 Antwerpen T + 32 3
> >>> 360 52 41 M
> >>> +
> >>> 32 485 66 49 98
> >>> giacomo.visini at divaantwerp.be<mailto:giacomo.visini at divaantwerp.be
> >>> > www.divaantwerp.be<http://www.divaantwerp.be/>
> >>> Follow us on Facebook<https://www.facebook.com/diva.antwerp> I
> >>> Linkedin<https://www.linkedin.com/company/438781> I
> >>> Instagram<https://www.instagram.com/divaantwerp/>
> >>> _______________________________________________
> >>>
> >>> Koha mailing listhttp://koha-community.org Koha at lists.katipo.co.nz
> >>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> >> Caroline Cyr La Rose, M.L.I.S.
> >> Librarian | Product Manager
> >>
> >> Phone: 1-833-465-4276, ext. 221
> >> Caroline.Cyr-La-Rose at inLibro.com
> >> <mailto:caroline.cyr-la-rose at inLibro.com>
> >>
> >> INLiBRO | Document Technologies Specialists | www.inLibro.com
> >> <http://www.inLibro.com>
> >> _______________________________________________
> >>
> >> Koha mailing list http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >> _______________________________________________
> >>
> >> Koha mailing list http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > _______________________________________________
> >
> > Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
--
Nick Clemens
ByWater Solutions
bywatersolutions.com
Phone: (888) 900-8944
Pronouns: (he/him/his)
Timezone: Eastern
Follow us:
<https://www.facebook.com/ByWaterSolutions/>
<https://www.instagram.com/bywatersolutions/>
<https://www.youtube.com/user/bywatersolutions>
<https://twitter.com/ByWaterSolution>
_______________________________________________
Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list