<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hie,<br>
<br>
"items.more_subfields_xml" is the column used to store subfields of
item field (952 in MARC21) that are NOT linked with a column of
items data table (ie 952$a => items.homebranch).<br>
<br>
<div class="moz-cite-prefix">Le 18/01/2013 18:36, Paul a écrit :<br>
</div>
<blockquote cite="mid:5.2.1.1.2.20130118111825.10770d20@stormy.ca"
type="cite">I have recently done some "house-keeping" looking for
consistency in the MySQL db (5.5.24 in 3.8.5), and while some
tidying up has been straight-forward I am having problems with
more_subfields_xml in items.
<br>
<br>
Only about 90% of 'items' have any xml attached to them. Within
those that do have an xml entry, only the following subfields
appear:
<br>
<br>
<subfield code="f"> entries < 1%
<br>
<subfield code="i"> entries ~ 20%
<br>
<subfield code="k"> entries ~ 1.5%
<br>
<subfield code="x"> entries ~ 95%
<br>
<br>
and they are mostly filled with random values from 2xx, 6xx and
9xx, although the 'code="x"' values appear to be valid from the
952$x. code="f" contains values from 952$v; code="i" has some
952$i valid entries but mostly 650$a,x,y,z; code="k" has random
authors, titles, etc - and I can't find where we might use 952$k
in our frameworks.
<br>
<br>
Can someone please tell me how these blobs are mapped/created and
used by koha? Our odd-ball results/entries don't appear to be
having much, if any, influence on cataloguing and search
functions.
<br>
<br>
Also, if there is any way to "rebuild" more_subfields_xml -- it's
way too big a problem to manage manually.
<br>
<br>
Many thanks - Paul
<br>
<br>
P.S. For completeness, after de-duping all the entries obtained
from " SELECT more_subfields_xml FROM items; " (249,636 text
lines), the only data left (apart from the subfields above) are
"empty containers" using:
<br>
<br>
xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>
<br>
xmlns=<a class="moz-txt-link-rfc2396E" href="http://www.loc.gov/MARC21/slim">"http://www.loc.gov/MARC21/slim"</a>>
<br>
xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://www.loc.gov/MARC21/slimhttp://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd">"http://www.loc.gov/MARC21/slim
http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"</a>
<br>
<?xml version="1.0" encoding="UTF-8"?>
<br>
<collection
<br>
</collection>
<br>
<datafield tag="999" ind1=" " ind2=" ">
<br>
</datafield>
<br>
<leader> a </leader>
<br>
<record>
<br>
</record>
<br>
<br>
_______________________________________________
<br>
Koha-devel mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
<br>
website : <a class="moz-txt-link-freetext" href="http://www.koha-community.org/">http://www.koha-community.org/</a>
<br>
git : <a class="moz-txt-link-freetext" href="http://git.koha-community.org/">http://git.koha-community.org/</a>
<br>
bugs : <a class="moz-txt-link-freetext" href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a>
<br>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Fridolyn SOMERS<br>
Biblibre - Pôle Support<br>
<a href="mailto:fridolyn.somers@biblibre.com">fridolyn.somers@biblibre.com</a></div>
</body>
</html>