[Koha] Matching authority records with tag 001

Fri Sep 30 00:50:13 NZDT 2022

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>