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-d...) - 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...) - 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-r...) 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@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@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
Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose@inlibro.com https://www.inLibro.com