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

Doug Dearden dearden at sarsf.org
Wed Aug 29 08:27:54 NZST 2012

Hi Galen,

I ran the sql command against my test DB to delete the 852 tag limiting it to one record.  It takes out the 852 datafield but leaves behind some blank space - example below.  Is this going to matter?  - Thanks, Doug

  <datafield tag="700" ind1=" " ind2=" ">
    <subfield code="a">Hymes, Dell, editor.</subfield>
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="c">BK</subfield>

-----Original Message-----
From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Galen Charlton
Sent: Tuesday, August 28, 2012 12:59 PM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed


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 & 

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz

More information about the Koha mailing list