marc VS marcxml field in koha's biblioitems table
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
Hi, On Thu, Jun 18, 2015 at 10:20 AM, Andreas Roussos <arouss1980@gmail.com> wrote:
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.
It is possible for rebuild_zebra.pl to be run in a mode where it uses the marc column rather than the marcxml column when indexing bibs, so to avoid the possibility of discrepancies in indexing, you should update the marc column after making changes to the MARCXML. To do this, use the misc/maintenance/touch_all_biblios.pl command-line utility. Regards, Galen -- Galen Charlton Infrastructure and Added Services Manager Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
Le 18/06/2015 16:32, Galen Charlton a écrit :
Hi,
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. It is possible for rebuild_zebra.pl to be run in a mode where it uses
On Thu, Jun 18, 2015 at 10:20 AM, Andreas Roussos <arouss1980@gmail.com> wrote: the marc column rather than the marcxml column when indexing bibs, so to avoid the possibility of discrepancies in indexing, you should update the marc column after making changes to the MARCXML. Outside from this reason, I think the biblioitems.marc field can/could/should be removed.
-- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries
Hi, On Fri, Jun 19, 2015 at 3:41 AM, Paul Poulain <paul.poulain@biblibre.com> wrote:
Outside from this reason, I think the biblioitems.marc field can/could/should be removed.
I agree; it is now fully redundant and has been for a while. There's an existing bug for this that I've given a gentle nudge to: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10455 Regards, Galen -- Galen Charlton Infrastructure and Added Services Manager Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (3)
-
Andreas Roussos -
Galen Charlton -
Paul Poulain