942 c searching and generating reports
The problem: I need to batch edit a group of biblios, but first I have to find them and extract a list of their biblio numbers. All the biblios in question have a common trait: their 942$c is Components They also do not have item records But I can't seem to create a report that will do this (my grasp of the whole report function is rather feeble). Any advice? Now for the inevitable weirdness: I know there are over 70 biblios with Components in the 942$c field. I created a report that lists all the biblionumbers and itemtypes. The only Components that report produced were ones that had been manually entered. Not the 70+ that came in via a bulk import. If I search for the items individually by title, etc. they are there and appear to be normal records. If I try to limit an advance search to Components, it draws a blank. Which makes me think there's something fishy going on somewhere. But where to look? Thanks for any help! Elaine
* Elaine Bradtke (eb@efdss.org) wrote:
The problem: I need to batch edit a group of biblios, but first I have to find them and extract a list of their biblio numbers. All the biblios in question have a common trait: their 942$c is Components They also do not have item records
But I can't seem to create a report that will do this (my grasp of the whole report function is rather feeble). Any advice?
Now for the inevitable weirdness:
I know there are over 70 biblios with Components in the 942$c field.
I created a report that lists all the biblionumbers and itemtypes. The only Components that report produced were ones that had been manually entered. Not the 70+ that came in via a bulk import. If I search for the items individually by title, etc. they are there and appear to be normal records. If I try to limit an advance search to Components, it draws a blank. Which makes me think there's something fishy going on somewhere. But where to look?
Hi Elaine I bet the ones imported just have the data in the marcxml field, so in order to find them you would use some sql like SELECT biblionumber FROM (SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems) as comptable WHERE comp="Components"; Try that and see if you get at least 70 biblionumbers back One caveat, your mysql server needs to be running at least 5.1.5 for this query to work (most modern installs will be) Hope this helps Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
Nope, that didn't work. How about something that will give me the biblio number and the contents of the associated 942$c? I can sort those in a spreadsheet and it might also give me a clue as to what's going on. Elaine On Thu, Dec 15, 2011 at 12:58 AM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
* Elaine Bradtke (eb@efdss.org) wrote:
The problem: I need to batch edit a group of biblios, but first I have to find them and extract a list of their biblio numbers. All the biblios in question have a common trait: their 942$c is Components They also do not have item records
But I can't seem to create a report that will do this (my grasp of the whole report function is rather feeble). Any advice?
Now for the inevitable weirdness:
I know there are over 70 biblios with Components in the 942$c field.
I created a report that lists all the biblionumbers and itemtypes. The only Components that report produced were ones that had been manually entered. Not the 70+ that came in via a bulk import. If I search for the items individually by title, etc. they are there and appear to be normal records. If I try to limit an advance search to Components, it draws a blank. Which makes me think there's something fishy going on somewhere. But where to look?
Hi Elaine
I bet the ones imported just have the data in the marcxml field, so in order to find them you would use some sql like
SELECT biblionumber FROM (SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems) as comptable WHERE comp="Components";
Try that and see if you get at least 70 biblionumbers back
One caveat, your mysql server needs to be running at least 5.1.5 for this query to work (most modern installs will be)
Hope this helps
Chris
-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
-- 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 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- 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 (2)
-
Chris Cormack -
Elaine Bradtke