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.vis...@divaantwerp.be www.divaantwerp.be -----Oorspronkelijk bericht----- Van: Koha <koha-boun...@lists.katipo.co.nz> Namens Nick Clemens Verzonden: donderdag 29 september 2022 13:50 CC: koha@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.vis...@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.vis...@divaantwerp.be www.divaantwerp.be > > > -----Oorspronkelijk bericht----- > Van: Katrin Fischer <katrin.fischer...@web.de> > Verzonden: maandag 19 september 2022 21:49 > Aan: Giacomo Visini <giacomo.vis...@divaantwerp.be>; > koha@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-boun...@lists.katipo.co.nz> Namens Katrin Fischer > > Verzonden: zondag 18 september 2022 18:35 > > Aan: koha@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.vis...@divaantwerp.be www.divaantwerp.be > >> > >> -----Oorspronkelijk bericht----- > >> Van: Koha <koha-boun...@lists.katipo.co.nz> Namens Caroline Cyr La > >> Rose > >> Verzonden: woensdag 14 september 2022 14:52 > >> Aan: koha@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.vis...@divaantwerp.be<mailto:giacomo.vis...@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@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-r...@inlibro.com > >> <mailto:caroline.cyr-la-r...@inlibro.com> > >> > >> INLiBRO | Document Technologies Specialists | www.inLibro.com > >> <http://www.inLibro.com> > >> _______________________________________________ > >> > >> Koha mailing list http://koha-community.org > >> Koha@lists.katipo.co.nz > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > >> _______________________________________________ > >> > >> Koha mailing list http://koha-community.org > >> Koha@lists.katipo.co.nz > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > > > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org Koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
