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)
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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
From there you could extract all the inserts corresponding to particular
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. framework, put all in a file and share it. Bernardo On Tue, Dec 7, 2010 at 8:48 AM, Nicole Engard <nengard@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
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
2010/12/7 Elaine Bradtke <eb@efdss.org>: 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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@gmail.com> wrote: From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Subject: Re: [Koha] MARC frameworks - sharing To: "Nicole Engard" <nengard@gmail.com> Cc: "koha" <koha@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@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@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@lists.katipo.co.nz
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -----Inline Attachment Follows----- _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Elaine, Huge "Thank you!" This is a wonderful Christmas gift to us (and it does feel like it is especially for us) since we have loads of "historical or archival sound recordings in digital formats" I'd also like to second the motion for a "more user friendly method" to import and export individual frameworks. Linda On 1:59 PM, Elaine Bradtke wrote:
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
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. 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)
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
My 2 eurocents for a "more user friendly method" to import and export individual frameworks and frameworks editor. sb
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. I'll send a progress report. But it isn't a high priority at the moment, maybe sometime in January. Meanwhile, if anyone who has a specific interest in historic or archival sound recordings could contact me off list so we could collaborate on what fields would be most useful, I'd appreciate it. Elaine On Tue, Dec 7, 2010 at 1:58 PM, Linda Culberson <lculber@mdah.state.ms.us>wrote:
Elaine, Huge "Thank you!" This is a wonderful Christmas gift to us (and it does feel like it is especially for us) since we have loads of "historical or archival sound recordings in digital formats"
I'd also like to second the motion for a "more user friendly method" to import and export individual frameworks. Linda
On 1:59 PM, Elaine Bradtke wrote:
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)
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
-- 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)
2010/12/7 Elaine Bradtke <eb@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.
Linda Culberson wrote:
I'd also like to second the motion for a "more user friendly method" to import and export individual frameworks.
I've created http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5478 based on this thread because I didn't find the idea as an enhancement request before. I've labelled it "seeking cosponsors". Is anyone willing to sponsor it? Leave a comment, then when you have some, you can change it to "seeking developer" and choose. Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
participants (8)
-
Bernardo Gonzalez Kriegel -
Elaine Bradtke -
Linda Culberson -
MJ Ray -
Nicole Engard -
Olugbenga Adara -
Senthil Anand -
Stefano Bargioni