[Koha] Altering the frameworkcode of existing records

[Michael Kuhn]

Hi

Sorry for creating noise!

As I saw my question was answered in thread 
https://lists.katipo.co.nz/public/koha/2017-March/047557.html - 
partially even by myself...

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



Am 15.08.19 um 17:00 schrieb Michael Kuhn:
> Hi
> 
> This is Koha 18.11.
> 
> In our library we exported the standard framework, re-imported it as 
> "RVSK". Then it was edited and more than 2'600 records were added. Only 
> recently it turned out the new framework "RVSK" was edited far too much, 
> only leaving 17 MARC tags but missing many fields, among them mandatory 
> fields like MARC 003, 005, 040$c or 952. Unfortunately all the missing 
> fields were not just hidden but deleted. It would be a lot of manual 
> work to find out and re-create the missing fields.
> 
> Thus we thought it would be easier to again export the standard 
> framework and re-import it under a new name like "ABC". Then move the 
> 2'600 records from framework "RVSK" to "ABC", delete the mutilated 
> framework "RVSK" and carefully edit the new framework "ABC".
> 
> I think the following SQL command could do this:
> 
> UPDATE biblio
> SET frameworkcode="ABC"
> WHERE frameworkcode="RVSK"
> 
> Has anyone done this before? Will this work or would this cause new 
> problems?
> 
> Best wishes: Michael