[Koha-devel] MARC Framework Editor

[paul POULAIN]

Rachel Hamilton-Williams a écrit :
> Hi,
>   
Hi Rach,
> Paul were you having another crack at the MARC Framework editor as well 
> at the moment? or someone else?
>   
not me (and in fact, if you look at gitstats, you'll see I don't commit 
a lot those months...)

> Having just spent an hour or 2 working with it and giving up because 
> it's just tooo much clicking to delete all the fields you don't need, 
> we'll resort to a "programmer" method.
>
> However, it would be useful to be able to do 2 things
>
> 1/. Create a new framework based on either a "blank" or preferably, with 
> only the fields that are mandatory for Koha to work, so that you just 
> add in any fields you want, (usually about 20) rather than deleting all 
> the ones you don't (about 900!)
>   
A suggestion here : DELETE FROM marc_subfield_structure WHERE tab=-1 AND 
kohafield='' AND frameworkcode='WHATEVER_YOU_WANT'
should delete all unused subfields in a given framework.
then DELETE FROM marc_tag_structure WHERE (SELECT count(*) FROM 
marc_subfield_structure WHERE 
marc_subfield_structure.tag=marc_tag_structure.field)=0
UPDATE marc_subfield_structure SET tab=-1 WHERE frameworkcode='WHATEVER'
will "hide" every fields, you can then have the few you need reappear, 
and do the previous DELETE to clean things.

Note : previous SQL untested, it's basically the idea.

Once this is done, you can export marc_subfield_structure and 
marc_tag_structure, and get a SQL file quite interesting to have a 
simple cataloguing framework.
In UNIMARC, when you install Koha, you have the choice between 2 UNIMARC 
flavours : "complete MARC frameworks" or "public library MARC framework" 
(with much less fields !)

We did them with the previous commands.

It was boring to do the 1st time, but now, it's done !!!

-- 
Paul POULAIN
http://www.biblibre.com
Expert en Logiciels Libres pour l'info-doc
Tel : (33) 4 91 81 35 08