[Koha] MARC frameworks - sharing

[Olugbenga Adara]

Hello,



Check this page in the wiki which contains how to make a backup of a framework. 



http://wiki.koha-community.org/wiki/Mysqldump_Library



You could then import this dump into another instance of koha database.



I've used this to generate frameworks so I don't have to configure for every Koha install from scratch. 



Olugbenga Adara 

Mobile: 234-803-3220288

--- On Tue, 12/7/10, Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> wrote:

From: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
Subject: Re: [Koha] MARC frameworks - sharing
To: "Nicole Engard" <nengard at gmail.com>
Cc: "koha" <koha at lists.katipo.co.nz>
Date: Tuesday, December 7, 2010, 2:27 PM

The table 'biblio_framework' has only the "code" of the framework. The actual definition is on tables 'marc_tag_structure' and 'marc_subfield_structure'.
For example, for 'BKS' framework there are 312 rows on 'marc_tag_structure' and 3532 rows on 'marc_subfield_structure', 
perhaps to much for copy/paste.
On those rows there are descriptions, that can be translated.And one need to distinguish if the framework use authorities control or not.

I suggest you do a dump of the 3 tables.From there you could extract all the inserts corresponding to particular framework, put all in a file and share it.
Bernardo

On Tue, Dec 7, 2010 at 8:48 AM, Nicole Engard <nengard at gmail.com> wrote:

Looks like all your frameworks are in one table in the database.



--

-- Table structure for table `biblio_framework`

--



DROP TABLE IF EXISTS `biblio_framework`;

CREATE TABLE `biblio_framework` (

  `frameworkcode` varchar(4) NOT NULL default '',

  `frameworktext` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`frameworkcode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;





You should export the framework in question and paste the mysql on the

wiki (if we set up a page for these things).



I'd instead repeat my desire for a more friendly framwork editor

(something I don't have the skills to take on yet).



Nicole



2010/12/7 Elaine Bradtke <eb at efdss.org>:

> I'm about to put together some rather specialized frameworks that may be

> useful for other collections that have historical or archival sound

> recordings in digital formats (we have both). Even basing it on the existing

> one for audio cassettes and CDs is taking a bit of time.  It seems like it

> would be a good idea to set up a repository of useful frameworks that we

> could share.

> From what I can tell, all the frameworks are in the same file, which makes

> sharing more difficult.  Someone may want to use my digital audio framework,

> but they may have their own custom frameworks that they would need to keep.

>  I wonder how it might be made easier to import and export individual

> frameworks without overwriting existing ones. I suppose one could  cut and

> paste the raw data, but it would be nice to have a more user friendly

> method.

> --

> Elaine Bradtke

> Data Wrangler

> VWML

> English Folk Dance and Song Society | http://www.efdss.org

> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY

> Tel    +44 (0) 20 7485 2206 ext 36

> --------------------------------------------------------------------------

> Registered Company No. 297142

> Charity Registered in England and Wales No. 305999

> ---------------------------------------------------------------------------

> "Writing about music is like dancing about architecture"

> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

>

>

> _______________________________________________

> Koha mailing list  http://koha-community.org

> Koha at lists.katipo.co.nz

> http://lists.katipo.co.nz/mailman/listinfo/koha

>

>

_______________________________________________

Koha mailing list  http://koha-community.org

Koha at lists.katipo.co.nz

http://lists.katipo.co.nz/mailman/listinfo/koha




-----Inline Attachment Follows-----

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101207/a998eca1/attachment.htm