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

[Doug Dearden]

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>
  
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="c">BK</subfield>
  </datafield> 

-----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

Hi,

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 
biblioitems.marcxml.

Regards,

Galen
-- 
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 & 
http://evergreen-ils.org


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