[Koha] Altering the frameworkcode of existing records
Michael Kuhn
mik at adminkuhn.ch
Fri Aug 16 03:12:31 NZST 2019
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
More information about the Koha
mailing list