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

[Joy Nelson]

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/>