[Koha] Batch record modification

[Indranil Das Gupta]

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
>