No subject
Sat Nov 27 22:32:00 NZDT 2010
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
>
--0016e65a01aa8afb830496d1f681
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
The table 'biblio_framework' has only the "code" of the f=
ramework.=A0<div>The actual definition is on tables 'marc_tag_structure=
' and 'marc_subfield_structure'.</div><div><br></div><div>For e=
xample, for 'BKS' framework there are 312 rows on 'marc_tag_str=
ucture' and 3532 rows on 'marc_subfield_structure',=A0</div>
<div>perhaps to much for copy/paste.</div><div><br></div><div>On those rows=
there are descriptions, that can be translated.</div><div>And one need to =
distinguish if the framework use authorities control or not.</div><div>
<br></div><div>I suggest you do a dump of the 3 tables.</div><div>From ther=
e you could extract all the inserts corresponding to particular framework, =
put all in a file and share it.</div><div><br></div><div>Bernardo</div>
<div><br><div class=3D"gmail_quote">On Tue, Dec 7, 2010 at 8:48 AM, Nicole =
Engard <span dir=3D"ltr"><<a href=3D"mailto:nengard at gmail.com">nengard at g=
mail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Looks like all your frameworks are in one table in the database.<br>
<br>
--<br>
-- Table structure for table `biblio_framework`<br>
--<br>
<br>
DROP TABLE IF EXISTS `biblio_framework`;<br>
CREATE TABLE `biblio_framework` (<br>
=A0`frameworkcode` varchar(4) NOT NULL default '',<br>
=A0`frameworktext` varchar(255) NOT NULL default '',<br>
=A0PRIMARY KEY =A0(`frameworkcode`)<br>
) ENGINE=3DInnoDB DEFAULT CHARSET=3Dutf8;<br>
<br>
<br>
You should export the framework in question and paste the mysql on the<br>
wiki (if we set up a page for these things).<br>
<br>
I'd instead repeat my desire for a more friendly framwork editor<br>
(something I don't have the skills to take on yet).<br>
<br>
Nicole<br>
<br>
2010/12/7 Elaine Bradtke <<a href=3D"mailto:eb at efdss.org">eb at efdss.org</=
a>>:<br>
<div><div></div><div class=3D"h5">> I'm about to put together some r=
ather specialized frameworks that may be<br>
> useful for other collections that have historical or archival sound<br=
>
> recordings in digital formats (we have both). Even basing it on the ex=
isting<br>
> one for audio cassettes and CDs is taking a bit of time. =A0It seems l=
ike it<br>
> would be a good idea to set up a repository of useful frameworks that =
we<br>
> could share.<br>
> From what I can tell, all the frameworks are in the same file, which m=
akes<br>
> sharing more difficult. =A0Someone may want to use my digital audio fr=
amework,<br>
> but they may have their own custom frameworks that they would need to =
keep.<br>
> =A0I wonder how it might be made easier to import and export individua=
l<br>
> frameworks without overwriting existing ones. I suppose one could =A0c=
ut and<br>
> paste the raw data, but it would be nice to have a more user friendly<=
br>
> method.<br>
> --<br>
> Elaine Bradtke<br>
> Data Wrangler<br>
> VWML<br>
> English Folk Dance and Song Society | <a href=3D"http://www.efdss.org"=
target=3D"_blank">http://www.efdss.org</a><br>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY<br>
> Tel=A0 =A0 +44 (0) 20 7485 2206 ext 36<br>
> ----------------------------------------------------------------------=
----<br>
> Registered Company No. 297142<br>
> Charity Registered in England and Wales No. 305999<br>
> ----------------------------------------------------------------------=
-----<br>
> "Writing about music is like dancing about architecture"<br>
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)<br>
><br>
><br>
</div></div>> _______________________________________________<br>
> Koha mailing list =A0<a href=3D"http://koha-community.org" target=3D"_=
blank">http://koha-community.org</a><br>
> <a href=3D"mailto:Koha at lists.katipo.co.nz">Koha at lists.katipo.co.nz</a>=
<br>
> <a href=3D"http://lists.katipo.co.nz/mailman/listinfo/koha" target=3D"=
_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
><br>
_______________________________________________<br>
Koha mailing list =A0<a href=3D"http://koha-community.org" target=3D"_blank=
">http://koha-community.org</a><br>
<a href=3D"mailto:Koha at lists.katipo.co.nz">Koha at lists.katipo.co.nz</a><br>
<a href=3D"http://lists.katipo.co.nz/mailman/listinfo/koha" target=3D"_blan=
k">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br></div>
--0016e65a01aa8afb830496d1f681--
More information about the Koha
mailing list