[Koha] MARC frameworks - sharing

[Senthil Anand]

2010/12/7 Elaine Bradtke <eb at efdss.org>
>
> Well, it looks like I'm not the only one.  My IT guru and I are going to experiment a bit, both on the editing and import and export of MARC frameworks. I got fed up with the process of deleting lots of individual fields so I'm looking at editing outside of Koha.

Hello,

I use the following method to edit a new framework using SQL
statements before fine tuning them from the browser. For the new
framework TEST after creating the framework and viewing the subfields
at least once in the browser,

1. Hide all the fields from showing up in the browser. For the hidden
value look at the Koha help file for the marc framework editing page.

update marc_subfield_structure set hidden = 5 where frameworkcode like 'TEST';

2. Now enable the fields you are interested in using the following
SQL: For the 100a tag

update marc_subfield_structure set hidden = 0 where tagfield = 100 and
tagsubfield like 'a' and frameworkcode like 'TEST'

Repeat the sql with the different values of tagfield and tag subfield.
Now the only tags which have to be taken care of are some authority
tags.

You can also enable the tags you want to be visible individually from
the browser if you want.

The above procedure seems to work for me but I am not sure if there
are any unxepected side effects. Proceed with caution.