[Koha] Upgrade Problems

2014-05-01 Thread Joel Ewy
Greetings, I administer a Koha server for a small church library (and am going to set it up for another), and I'm only called in to work on it a few times a year, when there are problems. It was first set up in 2007 and has been upgraded a couple times since then. Each time has been a struggle t

Re: [Koha] Looking for help with a report

2014-05-01 Thread Steven Nickerson
Thank you Nick, That's close...at least it gets me my list in the pull-down but none of them return results, I think because the itype field in items contains the "code" and not the "description", right? I actually prefer the description be what shows up in the pull-down, but then how do I d

Re: [Koha] Looking for help with a report

2014-05-01 Thread Nick Clemens
Hi Steve, This works for me: SELECT itemnumber, barcode, itemcallnumber FROM items WHERE itype=<> You can find more info about the runtime paramters on the wiki too: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters -Nick On Thu, May 1, 2014 at 4:33 PM, Steven Nickers

[Koha] Looking for help with a report

2014-05-01 Thread Steven Nickerson
Is there someone who can provide the SQL for me for a report that simply lists the itemnumber, barcode, and itemcallnumber for all items of a given Item Type. I'd like the report to prompt (with a pull-down) the list of all Item Types I have so that I can select it to report on. I think this sho

[Koha] Instructions to upgrade 3.10 to 3.10.13

2014-05-01 Thread ISM KIS
Our head librarian asked me to upgrade Koha from 3.10.2 to 3.10.13 Server is running Debian. We are not using git. Where do I find instruction on how exactly this minor upgrade can be done? Rudy Wuthrich Kodaikanal International School ___ Koha mailin