Do it in Perl, using C4::Biblio. That's the way to do it imho.
El mar., 6 de jun. de 2017 10:19 AM, Michael Kuhn <m...@adminkuhn.ch> escribió: > Hi > > We are working with Debian 8 and a package installation of Koha > 16.11.04. The database is filled with bibliographic records which are > connected to tables "issues" and "biblioitems", also they are linked to > authority data. > > We want to edit the content of MARC field 300 which may look like: > > <datafield tag="300" ind1=" " ind2=" "> > <subfield code="a">1 map : col. ; 34 x 47 cm</subfield> > <subfield code="c">9 pictures</subfield> > </datafield> > > to (for example): > > <datafield tag="300" ind1=" " ind2=" "> > <subfield code="a">NEW CONTENT FOR THIS RECORD</subfield> > </datafield> > > It seems not possible to do this using Koha menu "Tools > MARC > modification templates" since the new content of MARC field 300 is > different for every records and I would have to create many thousands of > template actions. > > Thus I have tried the following: > > 1. I have unloaded the content of field "marcxml" for every record in > table "biblioitems" and cut off everything except the tags and content > for MARC field 300. I have then created an SQL statement replacing this > content with the new content for the affected record: > > UPDATE biblioitems SET marcxml = REPLACE( marcxml, '<datafield tag="300" > ind1=" " ind2=" ">\n <subfield code="a">1 map :</subfield>\n > <subfield code="b">col. ;</subfield>\n <subfield code="c">34 x 47 cm. > fold. to 25 x 10 cm.</subfield>', '<datafield tag="300" ind1=" " ind2=" > ">\n <subfield code="a">NEW CONTENT FOR THIS RECORD</subfield>') > WHERE ExtractValue(biblioitems.marcxml,'//controlfield[@tag="001"]') = > 5451649; > > 2. Like this the content for MARC field 300 in field "marcxml" was > correctly changed and I can immediately see the desired result in the > Koha OPAC and staff client. No reindexing was needed. > > 3. But the content of tag <leader> in field "marcxml" has NOT changed > (so it still shows the old number of characters of the record). I don't > know if this is a problem or how it could be easily solved. > > My question: Is this the way to go or does anyone have another idea how > to accomplish this task? Maybe this is even described in some > documentation? > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
