[Koha] Koha 16.05 - Change MARC framework globally on batch of records?

[Joy Nelson]

Craig-
The 'bad' records reported would indicate corrupted marc records.
ModBiblio will return 1 on success and 0 for no success.  The goodcount is
incremented when ModBiblio is successful with an update and the badcount is
updated when not successful.

Thanks
-Joy

On Tue, Mar 21, 2017 at 3:25 PM, Craig Butosi <craig.butosi at rcmusic.ca>
wrote:

> Hi everyone,
>
> Thanks to everyone who replied. This is exactly what I was looking for.
> I've tested <UPDATE biblio SET frameworkcode="XX" WHERE biblionumber = 'X';
> > , opened the record, saw the framework had changed, then saved it, so the
> query seems to work fine on at least one record. Thanks Michael.
>
> > or use the touch_all_biblios.pl script
>
> Joy, are there any major risks involved in running this (very useful!)
> script? (There's always a risk, I know.) Looking at the output, the script
> reports:
>
> Good: X, Bad: Y (of Z) in T seconds
> Accuracy:  N%
> Average time per record: T seconds
>
> What would constitute a record going 'bad', say?
>
> All best,
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> THE ROYAL CONSERVATORY
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
> -----Original Message-----
> From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Joy
> Nelson
> Sent: March-21-17 8:18 AM
> To: mik at adminkuhn.ch
> Cc: Koha
> Subject: Re: [Koha] Koha 16.05 - Change MARC framework globally on batch
> of records?
>
> You can update the biblio table with the new framework, but any
> differences between the old and new frameworks will not be represented in
> the bibliographic record until you save that record in Koha (or use the
> touch_all_biblios.pl script)
>
> joy
>
> On Tue, Mar 21, 2017 at 12:51 PM, Michael Kuhn <mik at adminkuhn.ch> wrote:
>
> > Hi Craig
> >
> > Katrin wrote:
> >
> > it looks like the framework is stored in frameworkcode in the table
> >> biblio. It should be possible to change it with SQL as I think it
> >> doesn't get mapped to a MARC field at the moment.
> >>
> >
> > Such an SQL statement would look like
> >
> > UPDATE biblio SET frameworkcode="XX"
> >
> > where XX is a frameworkcode that must exist in table "biblio_framework".
> > Since the above statement would change the framework of ALL records to
> "XX"
> > it may be necessary to use some WHERE clause like
> >
> > UPDATE biblio SET frameworkcode="XX" WHERE biblionumber > 100000
> >
> > or maybe
> >
> > UPDATE biblio SET frameworkcode="XX" WHERE frameworkcode NOT IN ("XX",
> > "FA")
> >
> > Before applying such a change I would recommend to backup the
> > database, of course.
> >
> > 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 mik at adminkuhn.ch · W
> > www.adminkuhn.ch _______________________________________________
> > Koha mailing list  http://koha-community.org Koha at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> Note: This email message and any attachments are intended only for the use
> of the individual to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under
> applicable law. If the recipient of this email is not the intended
> recipient (or the employee or agent responsible for delivering the email to
> the intended recipient), you are hereby notified that any review,
> dissemination, distribution or copying or other use of this message is
> strictly prohibited. If you have received this communication in error,
> please notify the sender immediately by return email and delete this
> message and attachments from your system, thank you.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at 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/>