Help needed finding info in non-indexed fields
If I had understood at the outset that 561 was not searchable by mere mortals, I wouldn't have put important information in there. Live and learn. Now I'm trying to extract it, and put it somewhere else, specifically, in the item record, subfield 8. Before I do that, I need to know how to find the biblios with information in the 561 fields, and if possible, search by specific information in this field, so I can split them up into 'collections' Any help, in as plain, ordinary language as possible, would be most welcome. Unfortunately my IT guru is up to his eyeballs in his day job, and I need to fix this problem before it gets any bigger. Thanks! -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Can't you just add the 561 to your indexes and rebuild? Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner@liblime.com -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Elaine Bradtke Sent: Monday, April 11, 2011 9:07 AM To: koha Subject: [Koha] Help needed finding info in non-indexed fields If I had understood at the outset that 561 was not searchable by mere mortals, I wouldn't have put important information in there. Live and learn. Now I'm trying to extract it, and put it somewhere else, specifically, in the item record, subfield 8. Before I do that, I need to know how to find the biblios with information in the 561 fields, and if possible, search by specific information in this field, so I can split them up into 'collections' Any help, in as plain, ordinary language as possible, would be most welcome. Unfortunately my IT guru is up to his eyeballs in his day job, and I need to fix this problem before it gets any bigger. Thanks! -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 -------------------------------------------------------------------------- - "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
You can extract them using SELECT biblionumber, ExtractValue(`marcxml`,'//datafield[@tag="561"]/*') FROM `biblioitems` WHERE ExtractValue(`marcxml`,'count(//datafield[@tag="561"])>0') but only if you are using Mysql 5.1. You can use more restrictive conditions in the WHERE clause, of course. With Mysql 5.0 or lower, you can find biblios with 561 using SELECT `biblioitemnumber` FROM `biblioitems` WHERE `marcxml` LIKE '%tag="561"%' Stefano On Apr 11, 2011, at 15:07 , Elaine Bradtke wrote:
... I need to know how to find the biblios with information in the 561 fields, and if possible, search by specific information in this field
On Mon, Apr 11, 2011 at 10:07 AM, Elaine Bradtke <eb@efdss.org> wrote:
If I had understood at the outset that 561 was not searchable by mere mortals, I wouldn't have put important information in there. Live and learn. Now I'm trying to extract it, and put it somewhere else, specifically, in the item record, subfield 8. Before I do that, I need to know how to find the biblios with information in the 561 fields, and if possible, search by specific information in this field, so I can split them up into 'collections'
Any help, in as plain, ordinary language as possible, would be most welcome. Unfortunately my IT guru is up to his eyeballs in his day job, and I need to fix this problem before it gets any bigger. Thanks!
In '/etc/koha/zebradb/marc_defs/marc21/biblios/record.abs' add something like melm 561$a Ownership-Custodial-History and to '/etc/koha/zebradb/biblios/etc/bib1.att', something like: att 8040 Ownership-Custodial-History Then rebuild your indexes. To+
Thank you for the hints, I think I'd better wait until my IT wizard has a few minutes to look this over. Indexing the field may be the best way to cope with this particular problem. . . .so much to learn! Elaine On Mon, Apr 11, 2011 at 2:34 PM, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
On Mon, Apr 11, 2011 at 10:07 AM, Elaine Bradtke <eb@efdss.org> wrote:
If I had understood at the outset that 561 was not searchable by mere mortals, I wouldn't have put important information in there. Live and learn. Now I'm trying to extract it, and put it somewhere else, specifically, in the item record, subfield 8. Before I do that, I need to know how to find the biblios with information in the 561 fields, and if possible, search by specific information in this field, so I can split them up into 'collections'
Any help, in as plain, ordinary language as possible, would be most welcome. Unfortunately my IT guru is up to his eyeballs in his day job, and I need to fix this problem before it gets any bigger. Thanks!
In '/etc/koha/zebradb/marc_defs/marc21/biblios/record.abs' add something like melm 561$a Ownership-Custodial-History
and to '/etc/koha/zebradb/biblios/etc/bib1.att', something like:
att 8040 Ownership-Custodial-History
Then rebuild your indexes. To+
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
participants (4)
-
Elaine Bradtke -
Stefano Bargioni -
Tomas Cohen Arazi -
Wagner, Jane