Hie, "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). Le 18/01/2013 18:36, Paul a écrit :
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.
Only about 90% of 'items' have any xml attached to them. Within those that do have an xml entry, only the following subfields appear:
<subfield code="f"> entries < 1% <subfield code="i"> entries ~ 20% <subfield code="k"> entries ~ 1.5% <subfield code="x"> entries ~ 95%
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.
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.
Also, if there is any way to "rebuild" more_subfields_xml -- it's way too big a problem to manage manually.
Many thanks - Paul
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:
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim"> xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" <?xml version="1.0" encoding="UTF-8"?> <collection </collection> <datafield tag="999" ind1=" " ind2=" "> </datafield> <leader> a </leader> <record> </record>
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Fridolyn SOMERS Biblibre - Pôle Support fridolyn.somers@biblibre.com <mailto:fridolyn.somers@biblibre.com>