Hi Elaine,
It is possible to query MARC control fields in reports. I have done it
in the past to find badly coded records.
The command to query MARC control fields is a bit tricky, but once you
understand it, it's easy to adapt to your needs.
For example, the query is to show the publication date is
SELECT
biblionumber,
SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),8,4)
AS "Publication date"
FROM biblio_metadata
- SUBSTRING means you're getting just a part of the string of characters
that is in 008, specifically, we start at the 8th character and we get 4
characters. This is tricky to remember because it's not the same as the
positions we're used to. The publication date is usually 008/07-10. But
here, you have to add 1, so it's 8-11. (It has to do with starting to
count at 0 or at 1; positions start at 0 but character count starts at 1).
- EXTRACTVALUE is used to search for specific MARC fields, in this case,
we will look in the metadata field for the 008 MARC field
So you can play with this query keeping in mind that you have to add 1
to the 008 position.
SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),16,3) for
publication place (008/15-17)
SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),36,3) for
language (008/35-37)
etc.
Reference:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
I hope this helps!
Caroline
On 20-04-14 13 h 58, Elaine Bradtke wrote:
An unknown number of biblios in our catalogue have bad 008 fields. I'd
like to be able to fix them, but how do I find them?
Two things I've noticed about the bad 008s, some lack a date, some have
invalid codes in various positions.
I'd like to produce a list of biblionumbers of records that are missing
dates, or have invalid codes. Or possibly two lists one for dates, one for
invalid codes. Is it possible to do this with a report? It's beyond my
minimal skills in that area.
Elaine Bradtke
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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit
Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>
INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
<http://www.inLibro.com>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
