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 &#39;biblio_framework&#39; has only the &quot;code&quot; of the f=
ramework.=A0<div>The actual definition is on tables &#39;marc_tag_structure=
&#39; and &#39;marc_subfield_structure&#39;.</div><div><br></div><div>For e=
xample, for &#39;BKS&#39; framework there are 312 rows on &#39;marc_tag_str=
ucture&#39; and 3532 rows on &#39;marc_subfield_structure&#39;,=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">&lt;<a href=3D"mailto:nengard at gmail.com">nengard at g=
mail.com</a>&gt;</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 &#39;&#39;,<br>
 =A0`frameworktext` varchar(255) NOT NULL default &#39;&#39;,<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&#39;d instead repeat my desire for a more friendly framwork editor<br>
(something I don&#39;t have the skills to take on yet).<br>
<br>
Nicole<br>
<br>
2010/12/7 Elaine Bradtke &lt;<a href=3D"mailto:eb at efdss.org">eb at efdss.org</=
a>&gt;:<br>
<div><div></div><div class=3D"h5">&gt; I&#39;m about to put together some r=
ather specialized frameworks that may be<br>
&gt; useful for other collections that have historical or archival sound<br=
>
&gt; recordings in digital formats (we have both). Even basing it on the ex=
isting<br>
&gt; one for audio cassettes and CDs is taking a bit of time. =A0It seems l=
ike it<br>
&gt; would be a good idea to set up a repository of useful frameworks that =
we<br>
&gt; could share.<br>
&gt; From what I can tell, all the frameworks are in the same file, which m=
akes<br>
&gt; sharing more difficult. =A0Someone may want to use my digital audio fr=
amework,<br>
&gt; but they may have their own custom frameworks that they would need to =
keep.<br>
&gt; =A0I wonder how it might be made easier to import and export individua=
l<br>
&gt; frameworks without overwriting existing ones. I suppose one could =A0c=
ut and<br>
&gt; paste the raw data, but it would be nice to have a more user friendly<=
br>
&gt; method.<br>
&gt; --<br>
&gt; Elaine Bradtke<br>
&gt; Data Wrangler<br>
&gt; VWML<br>
&gt; English Folk Dance and Song Society | <a href=3D"http://www.efdss.org"=
 target=3D"_blank">http://www.efdss.org</a><br>
&gt; Cecil Sharp House, 2 Regent&#39;s Park Road, London NW1 7AY<br>
&gt; Tel=A0 =A0 +44 (0) 20 7485 2206 ext 36<br>
&gt; ----------------------------------------------------------------------=
----<br>
&gt; Registered Company No. 297142<br>
&gt; Charity Registered in England and Wales No. 305999<br>
&gt; ----------------------------------------------------------------------=
-----<br>
&gt; &quot;Writing about music is like dancing about architecture&quot;<br>
&gt; --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)<br>
&gt;<br>
&gt;<br>
</div></div>&gt; _______________________________________________<br>
&gt; Koha mailing list =A0<a href=3D"http://koha-community.org" target=3D"_=
blank">http://koha-community.org</a><br>
&gt; <a href=3D"mailto:Koha at lists.katipo.co.nz">Koha at lists.katipo.co.nz</a>=
<br>
&gt; <a href=3D"http://lists.katipo.co.nz/mailman/listinfo/koha" target=3D"=
_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
&gt;<br>
&gt;<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