Re: [Koha] Report help

2012-04-03 Thread Nicole Engard
From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html leader6 = a (and one of the leader7 values below) leader7 = a leader7 = c leader7 = d leader7 = m leader6 = t On Tue, Apr 3, 2012 at 7:43 PM, Chris Cormack ch...@bigballofwax.co.nz

Re: [Koha] Report help

2012-04-03 Thread Chris Cormack
On 4 April 2012 15:19, Nicole Engard neng...@gmail.com wrote: From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html    leader6 = a (and one of the leader7 values below)        leader7 = a        leader7 = c        leader7 = d        leader7 = m    leader6 = t Something

[Koha] Report help

2012-03-12 Thread Nicole Engard
I'm looking to alter this report http://wiki.koha-community.org/wiki/SQL_Reports_Library#Total_Collection_Size_by_Date to give me the count of items that were in the collection on that date - that means checking the deleted items to see what was added and deleted on the date that's entered and

Re: [Koha] report help - total amount writeoff

2011-10-19 Thread Wagner, Jane
...@lists.katipo.co.nz] *On Behalf Of *Peel Lisa *Sent:* Wednesday, October 19, 2011 3:08 PM *To:* 'koha@lists.katipo.co.nz' *Subject:* [Koha] report help - total amount writeoff Hello Report help again I am afraid! Could anyone supply me with the SQL for a report which will show me the amount of fines

[Koha] Report help needed

2011-09-18 Thread Sue McMillan
Hello everyone, I need a report that shows the average age of our item collections at specific branches. I've looked at the pre-made sql reports on the Koha-Community pages but nothing there is useful for this report and I've also tried to make my own with no success. I would be grateful

Re: [Koha] Report Help

2011-08-24 Thread Nicole Engard
Thanks a bunch! This appears to work. I'll post this to the wiki in your name so that you get credit for the work and so that others can benefit from this. Nicole 2011/8/17 Msgr. Marion J. Makarewicz marmak3...@att.net: SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode,

Re: [Koha] Report Help - Extracting XML

2011-07-29 Thread Nicole Engard
Message- From: Nicole Engard [mailto:neng...@gmail.com] Sent: Thursday, July 28, 2011 5:02 PM To: Grobani, Daniel Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report Help - Extracting XML Okay - this: select count(statistics.datetime) as circs, CONCAT('a href=\/cgi-bin/koha/catalogue

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
Daniel, That part I knew :) it was getting it in to the query (the joining) I was having trouble with :) Nicole On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani dgrob...@samuelmerritt.edu wrote: Nicole, This should give you the 520a: extractValue(biblioitems.marcxml,

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
ON (biblioitems.biblioitemnumber = items.biblioitemnumber)? Daniel -Original Message- From: Nicole Engard [mailto:neng...@gmail.com] Sent: Thursday, July 28, 2011 4:36 AM To: Grobani, Daniel Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report Help - Extracting XML Daniel, That part I knew

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Daniel Grobani
Try this (I also did some light cleanup): SELECT COUNT(statistics.datetime) AS circs, CONCAT(' \/cgi- ',biblio.title,' ') AS Title, CONCAT(' \http://mycatalogv/cgi-

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
Okay - this: select count(statistics.datetime) as circs, CONCAT('a href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a') AS Title, CONCAT('a

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Grobani, Daniel
stick. Daniel -Original Message- From: Nicole Engard [mailto:neng...@gmail.com] Sent: Thursday, July 28, 2011 5:02 PM To: Grobani, Daniel Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report Help - Extracting XML Okay - this: select count(statistics.datetime) as circs, CONCAT('a href

[Koha] Report Help - Extracting XML

2011-07-27 Thread Nicole Engard
Hello all, I need some report assistance. I want to add the summary (520a) to this report: select count(statistics.datetime) as circs, CONCAT('a href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a') AS Title, CONCAT('a

Re: [Koha] Report Help - Extracting XML

2011-07-27 Thread Daniel Grobani
Nicole, This should give you the 520a: extractValue(biblioitems.marcxml, collection/record/datafield[@tag='520'][1]/subfield[@code='a']) Of course, you'll have to do a join on biblioitems. - Cheers, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel

[Koha] Report Help

2011-07-01 Thread Nicole Engard
Hi all, I wrote this report to get all subject headings in a Koha system that start with key phrases: SELECT lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag=610]/subfield[@code=a]') AS lcsh FROM biblioitems) AS subjects WHERE lcsh LIKE College% OR lcsh LIKE Seminary% GROUP

Re: [Koha] Report Help

2011-07-01 Thread Chris Nighswonger
Hi Nicole, On Fri, Jul 1, 2011 at 9:33 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I wrote this report to get all subject headings in a Koha system that start with key phrases: SELECT lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag=610]/subfield[@code=a]')

Re: [Koha] Report Help

2011-07-01 Thread Ian Walls
Unfortunately, that's just the way that ExtractValue works. From the manual: If multiple matches are found, the content of the first child text node of each matching element is returned (in the order matched) as a single, space-delimited string. Since MARC doesn't give us any means of

Re: [Koha] Report Help

2011-07-01 Thread Chris Nighswonger
On Fri, Jul 1, 2011 at 9:52 AM, Ian Walls ian.wa...@bywatersolutions.comwrote: Unfortunately, that's just the way that ExtractValue works. From the manual: If multiple matches are found, the content of the first child text node of each matching element is returned (in the order matched) as

Re: [Koha] Report Help

2011-07-01 Thread Frédéric Demians
I wrote this report to get all subject headings in a Koha system that start with key phrases: You can get your headings with a Perl script. You can also export all your biblio records in ISO2709 and then combine various standard Linux commands to extract and select your headings. For

Re: [Koha] Report Help

2011-07-01 Thread Chris Nighswonger
On Fri, Jul 1, 2011 at 10:19 AM, Nicole Engard neng...@gmail.com wrote: On Fri, Jul 1, 2011 at 10:09 AM, Chris Nighswonger cnighswon...@foundations.edu wrote: The sad thing is if it was comma or otherwise delimited we could do some splitting foo. But spaces will inevitably appear in the

Re: [Koha] Report help

2011-05-25 Thread Church, Beverly
Is this run at the MySQL level or in the reports module? * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 4:23 PM, Nicole Engard neng...@gmail.com wrote:

Re: [Koha] Report help

2011-05-25 Thread Ian Walls
MySQL 5.1 or greater is required. The queries should work either from the reports module, or directly on the MySQL command line. -Ian 2011/5/25 Church, Beverly bchu...@liblime.com Is this run at the MySQL level or in the reports module? * * * * Beverly Church LibLime Project Manager

Re: [Koha] Report help

2011-05-25 Thread Daniel Grobani
Bev, I wrote that gnarly marcxml-parsing query you offered below because at the time, LLEK was running on a pre-5.1 version of MySQL and I couldn't use the simpler ExtractValue(). I just ran cait's query that Nicole offered from the SQL Reports Library against our LLEK report server and it

<    1   2