[Koha] Generating reports of values in 001

[glenda.claborne]

Thanks Katrin and Jared. We may have to upgrade. We are using WorldCat Local as our discovery service and I want to make sure all our records have OCLC numbers in them (we store these in the 001) so that when users click on the catalog link in WorldCat, they'll get through to the catalog record. OCLC's batchload process takes care of most of this but there are patches that we have not covered. That's why I want to run a report to see which records still have those non-OCLC numbers in them. Also, we've had the default Koha OSt control number identifier in the 003 (which is quite wrong) but I don't know how to refer to that tag in my SQL query.

Many thanks,
Glenda

-----Original Message-----
From: Fischer, Katrin [mailto:Katrin.Fischer at bsz-bw.de] 
Sent: Wednesday, June 19, 2013 3:53 PM
To: glenda.claborne; koha at lists.katipo.co.nz
Subject: RE: [Koha] Generating reports of values in 001

Hi Glenda,

we are using 001 (Control number) excessively, and the ExtractValue should work ok. What's the exact problem you have? Can you describe it a bit more? What kind of report do you need?

I notice that the report you link to is not using 001 but querying 035$a?

SELECT b.title, b.author, ExtractValue(m.marcxml, '//datafield[@tag="035"]/subfield[@code="a"]') AS 'OCLC Number' 
FROM biblio b
LEFT JOIN items i USING (biblionumber)
LEFT JOIN biblioitems m USING (biblionumber) WHERE i.wthdrawn > 0

Katrin


> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz [mailto:koha- 
> bounces at lists.katipo.co.nz] On Behalf Of glenda.claborne
> Sent: Wednesday, June 19, 2013 2:30 PM
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Generating reports of values in 001
> 
> Hello, there have been previous posts on this issue but no 
> satisfactory answers yet. I have posted the following query in Nicole 
> Engard's ByWater Solutions website and she has referred me to this 
> group in case the SQL queries <http://wiki.koha- 
> community.org/wiki/SQL_Reports_Library#Withdrawn_Titles_Li
> st_to_Send_to_OCLC>  she pointed me to don't work:
> 
> 
> 
> "I still can't find a good way to generate a report of the values 
> stored in the 001 tag, either from Koha's report wizard or creating 
> SQL queries using
> "ExtractValue(marcxml,'//controlfield[@tag="001"]') AS OCLC Control Number".
> And there's no easy way to map a Koha field to 001 and/or 003 to be 
> able to run reports that include these control fields. I would 
> appreciate some help."
> 
> 
> 
> Is this a data issue? Why don't the ExtractValue function work? 
> There's data in the 'marcxml' or 'marc' fields when I simply select them in a query?
> 
> 
> 
> Many, many thanks for any help.
> 
> 
> 
> Glenda B. Claborne
> 
> Library Director
> 
> The American University of Iraq, Sulaimani (AUIS)
> 
> +964 (0)53-330-1011, ext.1218
> 
> Skype: glenda.claborne
> 
> 
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
> http://lists.katipo.co.nz/mailman/listinfo/koha
>