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