Modifying biblio data with SQL
Hi all, We wish to make some minor tweaks to biblio data that was imported originally using bulkmarcimport.pl. I understand where the data resides in the biblio,biblioitems,items table trio and can do the fix with some SQL. My question regards the other place the data is stored, i.e. in the marcxml field in the bibioitems table. Should I make the same changes to the marcxml data that I make in the table trio? If so, why? tia rickw -- _________________________________ Rick Welykochy || Praxis Services Politics is the business of getting power and privilege without possessing merit. -- PJ O'Rourke
Rick - you may want to take a look at sync_items_in_marc_bib.pl which will update your marc blob and marcxml - from your items table. Read through that and that should give you an idea. Cheers, Brendan On Mon, Apr 26, 2010 at 11:06 AM, Rick Welykochy <rick@praxis.com.au> wrote:
Hi all,
We wish to make some minor tweaks to biblio data that was imported originally using bulkmarcimport.pl.
I understand where the data resides in the biblio,biblioitems,items table trio and can do the fix with some SQL.
My question regards the other place the data is stored, i.e. in the marcxml field in the bibioitems table.
Should I make the same changes to the marcxml data that I make in the table trio?
If so, why?
tia rickw
-- _________________________________ Rick Welykochy || Praxis Services
Politics is the business of getting power and privilege without possessing merit. -- PJ O'Rourke _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
-- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO, Director of Innovation Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: West Haven, CT Phone # (888) 900-8944 http://bywatersolutions.com info@bywatersolutions.com See us at ALA : BOOTH # 817
My understanding is that the marcxml column is actually authoritative. The table trio is more for quick work that doesn't need / can't wait for the MARC data to be parsed. Also I think the zebra index is build from either marc or marcxml column depending on an option to rebuild_zebra.pl. On Tue, 2010-04-27 at 04:06 +1000, Rick Welykochy wrote:
Hi all,
We wish to make some minor tweaks to biblio data that was imported originally using bulkmarcimport.pl.
I understand where the data resides in the biblio,biblioitems,items table trio and can do the fix with some SQL.
My question regards the other place the data is stored, i.e. in the marcxml field in the bibioitems table.
Should I make the same changes to the marcxml data that I make in the table trio?
If so, why?
tia rickw
-- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
participants (3)
-
Brendan Gallagher -
Michael Hafen -
Rick Welykochy