Hej, Lars! You can certainly export your frameworks! They live in the marc_subfield_structure and marc_tag_structure tables in the database, so you can dump them with something like mysqldump --opt -u koha -p koha marc_subfield_structure marc_tag_structure > danmarc2.sql (Assuming your databaseuser and your database are both called "koha", of course. ) That will give you all the frameworks, so you might have to edit danmarc2.sql by hand to get just the danmarc2 framework, unless you delete any existing framweorks before you enter the danmarc2 stuff. And if you can get your hands on the danmarc2 spec in some machine readable form it's probably much easier to transform that into SQL that you can import into the database, rather than typing it all in "by hand". That's what I did to get the NORMARC spec into Koha, anyway. Depending on how similar danmarc2 is to unimarc you may find you have to do some other changes too, to make your new framework work the way it should, for example in the display of results and record details. Good luck! ;-) Magnus libriotech.no 2010/8/6 Lars J. Helbo <lars@helbo.org>
Hi,
I keep getting funny ideas about what I would like to do :-)
Here in Denmark the public libraries are using a special MARC framework. It is called danMARC2. It has some similarities with Unimarc but is still a different kind of flavour. The official definition can be found here:
http://www.kat-format.dk/danMARC2/default.html
I could enter this framework with all tags and subfiels in Koha (Administration/MARC bibliographic framework). If it should be correct with all details, subfields etc. it would however take "some" time. This raises my question: Would it be possible to export such an empty framework and use it on another installation of Koha? Or would I have to start all over again each time? -- Lars J. Helbo Borgergade 44 DK-8450 Hammel
Tlf.: +45 8696 9315 lars.helbo@frijsendal.dk
www.frijsendal.dk
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Lars, you also need to dump/translate the table biblio_framework. The purpose of the frameworks is to show only the relevant fields and subfields (when cataloging) for each type of material. What are these, is something that depends on the needs of librarians. Bernardo 2010/8/7 Lars J. Helbo <lars@helbo.org>
Den 07-08-2010 00:06, Magnus Enger skrev:
That will give you all the frameworks, so you might have to edit danmarc2.sql by hand to get just the danmarc2 framework, unless you delete any existing framweorks before you enter the danmarc2 stuff.
Or I make an extra installation of koha for this purpose and edit the default MARC framework, so there is only one framework in the installation ?
-- Lars J. Helbo Borgergade 44 DK-8450 Hammel
Tlf.: +45 8696 9315 lars.helbo@frijsendal.dk
www.frijsendal.dk
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
As mentioned some time ago by Henri Laurent Damien: "All you have to do is a mysqldump Mydb marc_subfield_structure marc_tag_structure biblio_frameworks --where 'frameworkcode=Yourcode' --no-create-info And you get them as a text file. " This way you can isolate just that framework and all its components, take it and load it to other systems etc. I would be (pleasantly) surprised however if just changing the framework enabled full conformance with DanMarc. Keep us all informed of your success or "challenges". Ian On 07/08/2010 07:57, Lars J. Helbo wrote:
Den 07-08-2010 00:06, Magnus Enger skrev:
That will give you all the frameworks, so you might have to edit danmarc2.sql by hand to get just the danmarc2 framework, unless you delete any existing framweorks before you enter the danmarc2 stuff.
Or I make an extra installation of koha for this purpose and edit the default MARC framework, so there is only one framework in the installation ? -- Lars J. Helbo Borgergade 44 DK-8450 Hammel
Tlf.: +45 8696 9315 lars.helbo@frijsendal.dk
www.frijsendal.dk <http://www.frijsendal.dk>
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
Ian, Thanks for your SQL syntax to dump a specific marc framework. But how do you load it in the target database? Regards Olugbenga Adara Mobile: 234-803-3220288 --- On Sat, 8/7/10, Ian Bays <ian.bays@ptfs-europe.com> wrote: From: Ian Bays <ian.bays@ptfs-europe.com> Subject: Re: [Koha] Exporting MARC framework ? To: "Lars J. Helbo" <lars@helbo.org> Cc: "Koha-List" <koha@lists.katipo.co.nz> Date: Saturday, August 7, 2010, 7:32 PM As mentioned some time ago by Henri Laurent Damien: "All you have to do is a mysqldump Mydb marc_subfield_structure marc_tag_structure biblio_frameworks --where 'frameworkcode=Yourcode' --no-create-info And you get them as a text file. " This way you can isolate just that framework and all its components, take it and load it to other systems etc. I would be (pleasantly) surprised however if just changing the framework enabled full conformance with DanMarc. Keep us all informed of your success or "challenges". Ian On 07/08/2010 07:57, Lars J. Helbo wrote: Den 07-08-2010 00:06, Magnus Enger skrev: That will give you all the frameworks, so you might have to edit danmarc2.sql by hand to get just the danmarc2 framework, unless you delete any existing framweorks before you enter the danmarc2 stuff. Or I make an extra installation of koha for this purpose and edit the default MARC framework, so there is only one framework in the installation ? -- Lars J. Helbo Borgergade 44 DK-8450 Hammel Tlf.: +45 8696 9315 lars.helbo@frijsendal.dk www.frijsendal.dk _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com -----Inline Attachment Follows----- _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
2010/8/7 Ian Bays <ian.bays@ptfs-europe.com>
As mentioned some time ago by Henri Laurent Damien:
"All you have to do is a mysqldump Mydb marc_subfield_structure marc_tag_structure biblio_frameworks --where 'frameworkcode=Yourcode' --no-create-info And you get them as a text file. "
This way you can isolate just that framework and all its components, take it and load it to other systems etc.
Thanks for improving on my initial attempt, folks! I have taken the liberty of creating a page in the wiki where we can collect Tips & Tricks related to mysqldump, similar to SQL and jQuery: http://wiki.koha-community.org/wiki/Mysqldump_Library Koha FTW! Magnus
As mentioned some time ago by Henri Laurent Damien:
"All you have to do is a mysqldump Mydb
marc_subfield_structure
marc_tag_structure biblio_frameworks --where 'frameworkcode=Yourcode' --no-create-info And you get them as a text file. "
This way you can isolate just that framework and all its components, take it and load it to other systems etc.
Thanks for improving on my initial attempt, folks!
I have taken the liberty of creating a page in the wiki where we can collect Tips & Tricks related to mysqldump, similar to SQL and jQuery: http://wiki.koha-community.org/wiki/Mysqldump_Library
Thanks for creating the wikipage. However the syntax you provided did not work for me. I used mysqldump -uroot -p koha marc_subfield_structure marc_tag_structure biblio_framework --where="frameworkcode='yourframeworkcode'" --no-create-info > frameworkcode.sql I am running MySQL Server 5.1.37 on Ubuntu. I don't know whether the syntax is server version specific. Regards Olugbenga Adara
On 10 August 2010 21:16, Olugbenga Adara <gbengaadara@yahoo.com> wrote:
I have taken the liberty of creating a page in the wiki where we can collect Tips & Tricks related to mysqldump, similar to SQL and jQuery: http://wiki.koha-community.org/wiki/Mysqldump_Library
Thanks for creating the wikipage. However the syntax you provided did not work for me.
I used mysqldump -uroot -p koha marc_subfield_structure marc_tag_structure biblio_framework --where="frameworkcode='yourframeworkcode'" --no-create-info > frameworkcode.sql
Try --where without the =, as in: --where "frameworkcode='yourframeworkcode'" Did you substitute your actual framework code for "yourframeworkcode"? If that does not solve it: do you get an error message? Regards, Magnus libriotech.no
participants (5)
-
Bernardo Gonzalez Kriegel -
Ian Bays -
Lars J. Helbo -
Magnus Enger -
Olugbenga Adara