[Koha] marc VS marcxml field in koha's biblioitems table

Andreas Roussos arouss1980 at gmail.com
Fri Jun 19 02:20:12 NZST 2015


Hi there,

We use koha 3.02.02.00, and I've recently had to make a number of
corrections to our records using
SQL statements that basically did a search & replace in the 'marcxml' field
of the 'biblioitems' table.
An example of such a query is as follows:

UPDATE biblioitems SET marcxml = REPLACE( marcxml, '<datafield tag="610"
ind1="0" ind2=" ">\n    <subfield code="a">Text A</subfield>', '<datafield
tag="610" ind1="0" ind2=" ">\n    <subfield code="a">Text B</subfield>' ) ;

This worked as expected and I can see the changes I've made when browsing
through book records in koha's OPAC.

My question is: do I also need to edit the contents of the 'marc' field?
According to the man page of C4::Biblio (
http://perldoc.koha-community.org/C4/Biblio.html): "In the 3.0 version of
Koha, the authoritative record-level information is in
biblioitems.marcxml". So, it looks like I should be OK with editing the
marcxml data only, but wanted to double-check with someone from this
mailing list who knows more about koha than I do.

Thanks in advance for your help.

Kind regards,
Andreas


More information about the Koha mailing list