[Koha] Batch record modification

[Caroline Cyr La Rose]

Hello Igor,

As far as I know as well, Koha's batch modification doesn't allow 
changes to control fields. I usually use MarcEdit to do this kind of change.

- Export records to be modified 
(https://koha-community.org/manual/latest/en/html/cataloging.html#exporting-data)

- Make the change in MarcEdit (here's an article I wrote on how to 
change 008/15-17, it's in French, but I'm sure Google Translate or 
another translation tool can translate it for you: 
https://inlibro.com/knowledge-base/modification-en-lot-des-zones-de-controle-avec-marcedit-1-lieu-de-publication-008-15-17/)

- Reimport the modified records into Koha, matching on the biblionumber 
(999$c in MARC21 or I think 001? in UNIMARC?) and specify to replace the 
existing record with the incoming record when there is a match 
(https://koha-community.org/manual/latest/en/html/cataloging.html#importing-records)

Regards,

Caroline

On 2024-06-18 04:43, Indranil Das Gupta wrote:
> Hi
>
> IIRC, Koha's batch modification tool does not work with the MARC21 control
> fields (i.e. 000 - 009).
>
> However, since you only wish to switch the value of a single position in
> the leader, you may be able to do it.
>
> For example, to update the 17th position of LDR (Encoding level) to "2"
> (full level, material not examined) for biblionumber 1 you could do this:
>
> UPDATE biblio_metadata
> SET metadata = UpdateXML(metadata, '//leader', CONCAT('<leader>',
> SUBSTRING(ExtractValue(metadata, '//leader'), 1, 17), '2',
> SUBSTRING(ExtractValue(metadata, '//leader'), 19, 6), '</leader>'))
> WHERE biblionumber = 1;
>
>
> cheers
> -idg
>
> --
> Indranil Das Gupta
> L2C2 Technologies
>
> Phone : +91-98300-20971
> WWW  : http://www.l2c2.co.in
> Blog    : http://blog.l2c2.co.in
> IRC     : indradg on irc://irc.freenode.net
> Twitter : indradg
>
>
> On Tue, Jun 18, 2024 at 12:25 PM Сычев Игорь Алексеевич <ias at tpu.ru> wrote:
>
>> Hello!
>>
>> I have a list of records that need to change the value "2" to "1" in the
>> 8th position of the leader.
>> How do I make a batch modification at the leader position?
>>
>> Good Luck!
>>
>> Igor A. Sychev
>> Tomsk Polytechnic University
>> https://lib.tpu.ru
>>
>>
>> _______________________________________________
>>
>> 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

Caroline Cyr-La-Rose, M.L.I.S. (she/her)
Librarian | Product Manager

1-833-INLIBRO (465-4276), ext. 221
caroline.cyr-la-rose at inlibro.com
https://www.inLibro.com