[Koha] Matching authority records with tag 001

Tue Sep 20 20:23:58 NZST 2022

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  \\$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