Very interesting and helpful update, thank you Doug! MP
-----Original Message----- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Doug Dearden Sent: Tuesday, September 18, 2012 6:04 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Hi all, No issues here, just following up in case someone is looking at this thread in the future. I updated the database using the sql statement below, and it deleted most of the 852 datafields. I thought all was well but a week or so later found a record that still had some 852 datafields in it. Upon investigation I found a number of records - around 400, and all of them had multiple 852 datafields - at least two per record. I did some experimentation and the sql statement below only works on those records where there is a single 852 datafield. I tried some variations and found that if I ran this one it would remove the first 852 datafield: update biblioitems set marcxml = UpdateXML(marcxml, '//datafield[@tag="852"][1]', ''); I did a backup, ran the sql statement above several times until it returned 0 records changed (17 in fact, as I had one record with 16 852 datafields). Each time it ran it stripped off the leading 852 datafield. I then ran this one to check for any leftovers: SELECT ExtractValue (marcxml ,'//datafield[@tag="852"]/*') FROM biblioitems WHERE marcxml RLIKE '<datafield tag="852"'; It returned zero results. Ran touch_all_biblios.pl Zebra indexes rebuilt that night as part of our regular cron job. All looks good. - Doug -----Original Message----- From: Galen Charlton [mailto:g...@esilibrary.com] Sent: Tuesday, August 28, 2012 3:42 PM To: Doug Dearden Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Hi, No, whitespace between datafield elements is irrelevant as far as Koha's parsing of the MARCXML records is concerned. Regards, Galen On 08/28/2012 04:27 PM, Doug Dearden wrote: > 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-boun...@lists.katipo.co.nz > [mailto:koha-boun...@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: g...@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
