[Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed

Galen Charlton gmc at esilibrary.com
Wed Aug 29 06:59:29 NZST 2012


On 08/28/2012 02:56 PM, Galen Charlton wrote:
> Unless you had changed your MARC frameworks to use the 852 field for
> item data rather than the 952, if the 852s are from your previous
> system, I'd suggest that you actually *delete* them.  A bib export from
> Koha will include the item data in 952 fields if you need them for
> record interchange or union catalog purposes, and getting rid of the
> legacy 852s avoids the risk of confusing staff about the state of an
> item record.

And you can delete the 852 fields in two steps (or three, counting the 
backup you should make first :) ).  First, run the following SQL update:

update biblioitems set marcxml = UpdateXML(marcxml, 
'//datafield[@tag="852"]', '');

Then run touch_all_biblios.pl, which will (in addition to signalling 
that the bibs should be reindexed) synchronize biblioitems.marc with 


Galen Charlton
Director of Support and Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at 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 & 

More information about the Koha mailing list