- Koha - lists.katipo.co.nz

SQL Reports Reminder
by Nicole Engard 13 Aug '09

13 Aug '09

Hi all, I know we're all super busy getting ready for the feature freeze, but I just wanted to drop a line to remind everyone that at the bottom of this page: http://wiki.koha.org/doku.php?id=sql_library we have some requests for reports from the experts :) If you know how to solve someone's problem feel free to edit the page and put your query on the wiki to help out our fellow Koha users. Thanks, Nicole Koha Doc Manager

1 0

Paying fines with manual credit
by Agnes Rivers-Moore 13 Aug '09

13 Aug '09

2 1

Need help with reports
by Scott Zollars 13 Aug '09

13 Aug '09

I need help constructing the following reports in SQL. I am still not fluent in that. I need a list of interlibrary loan materials checked out to other libraries by the month and by the day for our ILL record keeping. Also I need a report that lists all cataloging records with NULL in the source of acquisition field in the item records within a specific date range. Thanks, Scotty Zollars Director of Library Services Labette Community College 200 S. 14th Parsons, KS 67357 620-820-1168 620-421-1469 FAX Four things you can't recover: The stone after the throw, the word after it's said, the occasion after it's missed and the time after it's gone.

2 2

Re: [Koha] koha and library homepage integration
by BWS Johnson 12 Aug '09

12 Aug '09

Salvete! >Of course! Sorry Owen for forgetting to mention you - we got heaps of >value from your blog - thank you too. :-) Owen is so smart (how smart is he?) that even a moron like me can understand what he's trying to get you to do since he explains everything so clearly. Cheers, Brooke

1 0

koha and library homepage integration
by Erik Lewis 12 Aug '09

12 Aug '09

I'm trying to see how far I can integrate my library website with the koha opac. Has there been any work with integrating a cms with the koha opac? Any good examples I should checkout where the catalog and the library homepage are blended really nicely?

4 4

creating a report for patrons without an email that have items overdue
by Melanie Hedgespeth 12 Aug '09

12 Aug '09

Can anyone tell me how to "combine" the following reports? We want to create a report that gives us a list of patrons who do not have email accounts and have items overdue. (information from http://wiki.koha.org/doku.php?id=sql_library) Sharon Moreland Circulation Overdue materials SELECT borrowers.surname, borrowers.firstname, borrowers.cardnumber, issues.date_due, (TO_DAYS(curdate())-TO_DAYS(date_due)) AS 'days overdue', items.itemcallnumber, items.barcode, biblio.title, biblio.author FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= '28' AND homebranch = 'LIBRARY' ORDER BY issues.date_due asc, borrowers.surname ASC Complete Sharon Moreland Patron Missing e-mails SELECT cardnumber, surname, firstname, branchcode, debarred, dateexpiry FROM borrowers WHERE ' ' IN (email) Melanie <http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/917121931 39?ref=s>

2 1

Error when returning and checking out books
by ed c 12 Aug '09

12 Aug '09

Hello all, On my Koha install I am receiving errors when I check in a book. The error when I have it set to debug mode I am sent to an error page that reads: Koha error The following fatal error has occurred: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 226. Apache Server version: Apache/2.2.8 (Ubuntu) Server built: Mar 10 2009 18:09:05 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux cassidy 2.6.24-23-server #1 SMP Wed Apr 1 22:22:14 UTC 2009 i686 Perl 5.008008 In production mode, I get a Web site that says: "production mode - trapped fatal error" The return and or check out actually does go through but obviously I can't have library staff seeing this error every time they check in or out a book. I don't remember seeing these earlier, but I am not sure. However, nothing has changed recently that could have caused this. I did try temporarily copying the latest ItemCirculationAlertPreference.pm from the git repository, but that didn't do anything but change the line number in the error. Any ideas? Edward Edward

2 4

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