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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Galen Charlton Sent: Tuesday, August 28, 2012 12:59 PM To: koha@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha