Or....depending on the collection size... you could export your records, modify them with a marc modifier tool (MarcEdit or other) and then reimport matching on the biblionumber 999$c.
-joy On Tue, Jun 6, 2017 at 9:33 PM, Tomas Cohen Arazi <tomasco...@gmail.com> wrote: > 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 > -- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
