- Koha - lists.katipo.co.nz

Re: [Koha] SQL Report Help
by Nicole Engard 12 Aug '09

12 Aug '09

Thanks!!!! This is just right :) On Wed, Aug 12, 2009 at 8:36 AM, Bernardo Gonzalez Kriegel < gonzalez(a)famaf.unc.edu.ar> wrote: > SELECT > borrowers.cardnumber,borrowers.surname,borrowers.firstname,issues.date_due,items.barcode,biblio.title,biblio.author > FROM borrowers LEFT JOIN issues ON > (issues.borrowernumber=borrowers.borrowernumber) LEFT JOIN items ON > (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON > (biblio.biblionumber=items.biblionumber) WHERE issues.date_due = > DATE_ADD(curdate(), INTERVAL 1 DAY) ORDER BY borrowers.surname asc; >

1 0

SQL Report Help
by Nicole Engard 12 Aug '09

12 Aug '09

I'm trying to write a report that shows all patrons who have items due tomorrow. I'm probably missing one step in this report, I don't get an error, but I also don't get any results - ideas? SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,issues.due_date,items.barcode,biblio.title,biblio.author FROM borrowers LEFT JOIN issues on (issues.borrowernumber=borrowers.borrowernumber) LEFT JOIN on items (issues.itemnumber=items.itemnumber) LEFT JOIN on biblio (biblio.biblionumber=items.biblionumber) WHERE issues.date_due = DATE_ADD(curdate()+1 DAYS) ORDER BY borrowers.surname asc

3 2

problem with serials
by Robert Lyon 12 Aug '09

12 Aug '09

Hi I'm trying to upgrade a koha 2 to koha 3 and i've gone through the basic steps and got most things working - but I'm having a problem with the serials part. I notice from bits of the code that it uses a new table called serialitems but I notice that table for me is blank. Is there a script i'm meant to run to fix this up? or some step I've missed out? Bob

1 0

Interesting public lists?
by Daniel G 11 Aug '09

11 Aug '09

Hi, We're a new Koha library, and our reference librarian is looking for ideas about public lists to add to the opac. If your library, or a library you know, has good examples, would you please reply with a link to the opac? Many thanks, Daniel -- View this message in context: http://www.nabble.com/Interesting-public-lists--tp24922514p24922514.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Is SQL in reports limited to a SELECT statement?
by Daniel G 11 Aug '09

11 Aug '09

Hi, I'm working on creating a report to parse data from biblioitems.marcxml. My SELECT statement is long and repetitive and could benefit from the use of variables. Do all reports created from SQL have to have only one statement, a SELECT statement? Thanks in advance for any tips, tricks, or kludges, or for confirming what I suspect is the awful truth. Daniel -- View this message in context: http://www.nabble.com/Is-SQL-in-reports-limited-to-a-SELECT-statement--tp24… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Items add error
by Liny Varghese 11 Aug '09

11 Aug '09

Dear all, I have installed koha 3.00.02 on Ubuntu server 8.10. I can login into koha, imported records using bulkmarcimport.pl, and search also possible. When adding a new record using default framework the biblio is added, but Koha 952 fields(items data) are not dding and the following error message appears. The following fatal error has occurred: Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 92. at What could be the problem? The same problem exists in Debian lenny installation also. Is this any error related to Perl ? any help is apreciated Liny Varghese -- Information Scientist Cochin University of Science & Technology Kerala, S.India Ph: 91-0484-2575715 www.cusat.ac.in

3 7

Queries on Modification Log and fines
by Akin Adigun 11 Aug '09

11 Aug '09

hi, I am using koha 3.01 on suse 11.0 and nozebra configuration. kindly assist with queries on Modification log for patrons. Also queries on fines. a. The patron that cancel, writeoff or make payment for fines b. The queries for all patrons with fines in the library c. The patron with fines over the noissuescharge amount in the library Akin Adigun (MCP) Akinomatics Tel: +2348035565348, +2348029219271

1 0

Request to the community
by Krishnan M 11 Aug '09

11 Aug '09

(Perhaps someone with more mileage in the Koha world should champion this....) I would like to request that we (as a community) take some positive steps to advance Koha in the light of recent (heated) discussion about changes to Koha possibly not making it back into core in good time for use by the largest possible number of users. Personally, i am convinced we will all be better off if we ensure a vibrant culture of contribution. Let's think about and put in place mechanisms that help this. The business end of the discussion, first: For example, 1) Let's create a process for everyone developing specific features by themselves to publish outlines of the same (using an RFC format, for example).. This can include vendor development sponsored by customers. 2) The process may allow for conceivable time offsets/delays, and certain other provisions for protecting the interests of the customers, including confidentiality, competitive considerations, etc. 3) As part of this process, participants can include commitments to contribute upto (or not less than) a particular portion of such additions 4) The process will include tracking that will self-report over a period of time how participants are keeping up (planned vs. actual), or even for the community to "report" on what they think is happening 5) While it may be inadvisable or infeasible to "throw the licensing book at" people, the important news always makes it out sooner or later...especially within the community Let's be careful to avoid even the slightest hint of "policing". We want this to be a friendly exchange. *BOLD* I am willing to bet anything that participants will benefit many times more than what they "put in" *BOLD* Now, onto other 'softer' aspects: Let's stop casting aspersions and bashing people/vendors, etc. on the list. The negative energy does no good. i like to adopt a simple philosophy to contributing to open source: There's nothing to lose (and conversely, nothing to gain...this latter might need some explanation, but later...). All of us have our own reasons for doing what we do, and no one needs sit 'in judgement' over others. Also, all feedback is welcome, so long as we use it constructively: When someone says 'Koha is good', i feel nice. When someone says 'Koha is not upto scratch', i feel even better: here's an opportunity to learn from them what exactly is it about Koha that can be improved to change that opinion in substance! Koha would not be what it is without the participation of every one that was ever involved, one way or another, and i mean that in the widest possible sense. Best regards, krishnan Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com

4 4

Koha error
by Liny Varghese 11 Aug '09

11 Aug '09

Dear all I am getting the following error Koha error The following fatal error has occurred: Can't call method "append_fields" on an undefined value at /usr/local/share/perl/5.10.0/MARC/File/SAX.pm line 92. Apache Server version: Apache/2.2.9 (Ubuntu) Server built: Jul 10 2009 18:41:33 Koha 3.00.00.107 Koha DB 3.0000107 MySQL mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2 OS Linux smslibrary 2.6.27-14-server #1 SMP Fri Jul 24 23:04:35 UTC 2009 i686 GNU/Linux Perl 5.010000 liny

1 0

Help with Query on Modification lof for patrons and fines
by Akin Adigun 10 Aug '09

10 Aug '09

Hello, I am using koha 3.0.1 on suse 11.0 with nozebra configuration Pls I need queries on modification log for patrons and queries on patron that have fine againt there record and having fine above the nochage amount thanks Akin Adigun (MCP) Akinomatics Tel: +2348035565348, +2348029219271

2 1