- Koha - lists.katipo.co.nz

(no subject)
by erlanda_simonyan＠flib.sci.am 17 Mar '20

17 Mar '20

Dear all , We can also refine your search as a phrase when looking for a title, subject,author and want to add additional search for a Publisher, Corporote name as a column on 'Refine Your Search'. How can we do it? We use koha 18.11.02 Thanks, Erlanda

1 0

Installation problem in Debian vps
by seatry1999 17 Mar '20

17 Mar '20

Hi guys, I have an installation problem in * Debian GNU/Linux 10* vps. So, I have followed the instructions in https://wiki.koha-community.org/wiki/Koha_on_Debian. After entering *$ sudo apt-get install koha-common*, there are a lot of errors about BDB::mysql, mostly about XXXXX table doesnt found. Here is a clip of the error: Upgrading database schema for testlibrary DBD::mysql::db do failed: Table 'koha_testlibrary.systempreferences' doesn't exist [for Statement " SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 114. What can I do to eliminate the error and install and configure Koha in my vps? Thanks for your attention -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 3

Kohathon 2020 Online Conference Schedule Available
by David Nind 15 Mar '20

15 Mar '20

It seems this message didn't make it to the main Koha mailing list, so reposting. >From Lisette Scheer <president(a)koha-us.org> Date: 14 March 2020 The Koha-US Conference Committee is pleased to announced the schedule for next month’s online conference Kohathon is now available at http://koha-us.org/kohathon-2020/. The conference will be live streamed from 8 am Eastern time April 23rd until 11 pm Eastern time. The conference is free and open to all. Recordings will be made available after the conference. If you have any questions, please e-mail us at info(a)koha-us.org Thank you! Lisette Scheer Koha-US 2020 President

1 0

Sending message to Users using Send List Options in lists Menu!
by Kuppu Swamy 15 Mar '20

15 Mar '20

Dear Sir, I am providing regular keyword search services to my users by using " KOHA search the Catalogue Option" and stored the search results in separate files in Lists menu.I have a problem of disseminating this information by sending E-Mail to the respective students/faculty of our University I have encountered with an error message while Sending message to Users using Send List Options in lists Menu. The respective screen shots are enclosed for your reference,help and advice. With regards S.Kuppuswamy, *Librarian* *Jain University - International Institute for Aerospace Engineering & Management ,Bangalore,INDIA* *E-Mail :kuppu.iiaem@gmail.com <kuppu.iiaem(a)gmail.com>*

2 2

Re: [Koha] [KOHA] SQL CIRCULATION REPORT- how to SUM
by rogan.hamby＠gmail.com 14 Mar '20

14 Mar '20

Hi James, The query I posted worked with my quick test. Could you post your query as it is now? On Sat, Mar 14, 2020 at 9:52 AM muiru james <muirunyeri(a)gmail.com> wrote: > Hi Rogan and All, > > I cant thank you enough for the tremendous effort you have put towards > helping me solve my problem. > > You do indeed understand well what I need. > > The UNION ALL is working well by adding a new row below the last class > group. However the SUM function is returning a 0 (zero). It seems its not > adding up the numbers. > > Please dont give up but help me find out the last remaining bit. We are > almost there. > > Most appreciated > > James > > > > > > On Thu, Mar 12, 2020 at 2:57 PM <rogan.hamby(a)gmail.com> wrote: > >> Hi James, >> >> If I'm understanding correctly you want an additional row giving a sum of >> all the numbers in addition to the per class one? The simplest way it >> occurs to me to do that is with a UNION ALL statement. I've taken some >> filters out for brevity but this illustrates the approach: >> >> SELECT CONCAT(SUBSTRING(itemcallnumber,1,1), '00') AS "CLASS", >> count(statistics.type) AS 'NUMBER' >> FROM borrowers >> LEFT JOIN statistics ON >> (statistics.borrowernumber=borrowers.borrowernumber) >> LEFT JOIN items ON (items.itemnumber = statistics.itemnumber) >> LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = >> items.biblioitemnumber) >> WHERE statistics.type IN ('issue', 'renew') >> GROUP BY SUBSTRING(itemcallnumber,1,1) >> UNION ALL >> SELECT "All Classes" AS "CLASS", SUM(statistics.type) AS 'NUMBER' >> FROM borrowers >> LEFT JOIN statistics ON >> (statistics.borrowernumber=borrowers.borrowernumber) >> LEFT JOIN items ON (items.itemnumber = statistics.itemnumber) >> LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = >> items.biblioitemnumber) >> WHERE statistics.type IN ('issue', 'renew') >> >> Basically with UNION ALL you can create other queries that don't have to >> be tied to the data of the previous queries so long as the columns line >> up. >> >> >> >> On Thu, Mar 12, 2020 at 3:04 AM muiru james <muirunyeri(a)gmail.com> wrote: >> >>> Hi Rogan and Team, >>> >>> I really appreciate your assistance towards my problem. The query does >>> indeed work to answer my need. Another query was also pushed to me towards >>> the same. >>> >>> I'm now looking for a way to SUM my answer to get the total number of >>> books issued. Any suggestions would be most welcome for any of the 2 >>> queries. The other SQL query is as below: - >>> >>> SELECT CONCAT(SUBSTRING(itemcallnumber,1,1), '00') AS "CLASS", >>> count(statistics.type) AS 'NUMBER' >>> FROM borrowers >>> LEFT JOIN statistics ON >>> (statistics.borrowernumber=borrowers.borrowernumber) >>> LEFT JOIN items ON (items.itemnumber = statistics.itemnumber) >>> LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = >>> items.biblioitemnumber) >>> WHERE statistics.type IN ('issue', 'renew') >>> AND date(statistics.datetime) BETWEEN <<Date BETWEEN >>> (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> >>> AND statistics.itemtype = 'BK' >>> GROUP BY SUBSTRING(itemcallnumber,1,1) >>> ORDER BY items.itemcallnumber ASC >>> >>> N.B My desire is to SUM the NUMBER column as TOTAL. >>> >>> Please assist team >>> >>> Warm Regards. >>> JAMES >>> >>> On Fri, Mar 6, 2020 at 7:10 PM <rogan.hamby(a)gmail.com> wrote: >>> >>>> Hi James, >>>> >>>> One simple way to handle it is with a case statement. The >>>> following example has a static between filter for the dates but it >>>> illustrates this approach. You can also do some cleaning to make sure there >>>> aren't spaces in front and it assumes that all of your DDC numbers in fact >>>> start with a digit. >>>> >>>> SELECT >>>> COUNT(*), >>>> CASE >>>> WHEN LEFT(it.itemcallnumber,1) = '0' THEN '000s' >>>> WHEN LEFT(it.itemcallnumber,1) = '1' THEN '100s' >>>> WHEN LEFT(it.itemcallnumber,1) = '2' THEN '200s' >>>> WHEN LEFT(it.itemcallnumber,1) = '3' THEN '300s' >>>> WHEN LEFT(it.itemcallnumber,1) = '4' THEN '400s' >>>> WHEN LEFT(it.itemcallnumber,1) = '5' THEN '500s' >>>> WHEN LEFT(it.itemcallnumber,1) = '6' THEN '600s' >>>> WHEN LEFT(it.itemcallnumber,1) = '7' THEN '700s' >>>> WHEN LEFT(it.itemcallnumber,1) = '8' THEN '800s' >>>> WHEN LEFT(it.itemcallnumber,1) = '9' THEN '900s' >>>> ELSE 'OTHER' >>>> END >>>> from (SELECT * FROM issues UNION ALL SELECT * FROM old_issues) i >>>> JOIN items it ON it.itemnumber = i.itemnumber >>>> WHERE DATE(i.timestamp) BETWEEN '2020-02-01' AND '2020-02-29' >>>> GROUP BY 2 ORDER BY 2; >>>> >>>> >>>> >>>> On Thu, Mar 5, 2020 at 11:06 AM muiru james <muirunyeri(a)gmail.com> >>>> wrote: >>>> >>>>> Dear All, >>>>> >>>>> My library uses DDC scheme of classification and we are looking for a >>>>> report that will count items checked out allowing us to select day(s) >>>>> of >>>>> issue, select itemtype and group the statistics by DDC 10 broad >>>>> classes. >>>>> >>>>> *EXAMPLE* >>>>> >>>>> IN a date range say 1st-31st March 2020. >>>>> >>>>> *DDC Class | NO. of books issued* >>>>> 000 - 12 >>>>> 100 - 26 >>>>> 200 - 157 >>>>> . >>>>> . >>>>> . >>>>> 900 - 230 >>>>> >>>>> The report can generate statistics for a day, month, quarter, e.t.c. >>>>> >>>>> Any assistance however close will be greatly appreciated. >>>>> >>>>> Thank you as you prepare to help >>>>> >>>>> James >>>>> _______________________________________________ >>>>> >>>>> Koha mailing list http://koha-community.org >>>>> Koha(a)lists.katipo.co.nz >>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>>>> >>>>

1 0

Thermal barcode printer
by Yatheesh lis 14 Mar '20

14 Mar '20

Hi Can anyone suggest Thermal barcode printer suitable for small library i.e 15,000 books Based on quality and easy to use. -- Y.Yatheesh Babu Hyderabad India

3 2

Call for news: March 2020 Koha Newsletter
by Koha Newsletter 14 Mar '20

14 Mar '20

I'm collecting news for the March newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

String Freeze Notice
by Joy Nelson 13 Mar '20

13 Mar '20

Greetings! Just a quick note that string freeze will go into effect on 3/15/2020 for the maintenance branches. Maintenance releases scheduled for the 24th. -- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

1 0

temporarily suspend fines
by Margo Duncan 13 Mar '20

13 Mar '20

Good morning, Our spring break has been extended and we would like to temporarily suspend fines or automatically extend due dates in Koha, instead of individually adjusting accounts. Is there a way to do this globally? We have a lot of circulation rules. Thanks in advance, Margo Margo Duncan, MLS Electronic Resources & Collection Development Librarian Robert R. Muntz Library The University of Texas at Tyler 903.566.7174 | mduncan(a)uttyler.edu<mailto:mduncan@uttyler.edu>

2 1

Re: [Koha] multiple Koha zebra problem
by dcook＠prosentient.com.au 13 Mar '20

13 Mar '20

Hi George, I’m glad that my email helped! It does feel strange, but that’s the way SysV scripts work. Think about it like a shebang at the top of a script. While it starts with a #, it is still parsed by computers as more than just a comment. David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595 From: George Mikuchadze <gmikuchadze(a)gmail.com> Sent: Friday, 13 March 2020 4:11 PM To: dcook(a)prosentient.com.au Subject: Re: [Koha] multiple Koha zebra problem Many thanks for your reply, I updated this line (very strange because the line is a comment in the script) and it started without any problem! George Mikuchadze On Fri, Mar 13, 2020 at 3:26 AM <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > wrote: Hi George, I notice that you didn't answer Katrin's questions. Answering those questions is really important, or we can't really help you very well. Now, it sounds to me like you've installed Koha from either a "git clone" or a tarball, and that you're running multiple Koha instances from multiple Koha codebases, which may or may not be running the same version. I'm guessing that you copied "misc/bin/koha-zebra-ctl.sh" to /etc/init.d/koha-zebra-daemon, /etc/init.d/koha1-zebra-daemon, etc. However, it sounds like you haven't updated the following line within that file: # Provides: koha-zebra-daemon You'll need to update that to match the filename. That's why you're getting that error. I think Ubuntu 14.04 used upstart as an init system while Ubuntu 16.04 should be using systemd. Systemd can be pretty strict when it comes to interpreting SysV style scripts like "misc/bin/koha-zebra-ctl.sh", so that's probably where the difference lies. Now, if you're only running 1 version of Koha (ie 3.22.21), I'd highly recommend that you don't use git/tarball installations, and instead switch to using Debian packages. It will make your life much easier (and it'll make it easier for you to get support from the Koha Community). Cheers, David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595 -----Original Message----- Date: Thu, 12 Mar 2020 12:11:08 +0400 From: George Mikuchadze <gmikuchadze(a)gmail.com <mailto:gmikuchadze@gmail.com> > To: koha(a)lists.katipo.co.nz <mailto:koha@lists.katipo.co.nz> , katrin.fischer.83(a)web.de <mailto:katrin.fischer.83@web.de> , Irakli Garibashvili <igar(a)hotmail.com <mailto:igar@hotmail.com> > Subject: [Koha] multiple Koha zebra problem Message-ID: <CAJR6aCBHjT3XBNtvb_Unejw+5cUO9QU7JwfDatskrxPBEWDEnw(a)mail.gmail.com <mailto:CAJR6aCBHjT3XBNtvb_Unejw%2B5cUO9QU7JwfDatskrxPBEWDEnw@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" Dear Katrin, Many thanks for Your reply. The problem is the following: We use multiple koha-s (with the same number of zebra daemons), now we want to install koha v3.22.21 on ubuntu 16.04. When I activate koha-zebra-daemon for the second instance of koha (koha1), I get the error: ---------------------------------------------------------------------------------------------------------------------- $ sudo update-rc.d koha1-zebra-daemon defaults insserv: script koha1-zebra-daemon: service koha-zebra-daemon already provided! insserv: exiting now! update-rc.d: error: insserv rejected the script header ----------------------------------------------------------------------------------------------------------------------- Here is the content of koha1-zebra-daemon: ............................................................................................................... .............the same as for instance of koha, koha2, koha3....................... USER=koha GROUP=koha DBNAME=koha1 NAME=koha-zebra-ctl.$DBNAME LOGDIR=/var/log/koha1 ERRLOG=$LOGDIR/koha-zebradaemon.err STDOUT=$LOGDIR/koha-zebradaemon.log OUTPUT=$LOGDIR/koha-zebradaemon-output.log KOHA_CONF=/etc/koha1/koha-conf.xml RUNDIR=/var/run/koha1/zebradb LOCKDIR=/var/lock/koha1/zebradb # you may need to change this depending on where zebrasrv is installed ZEBRASRV=/usr/bin/zebrasrv ZEBRAOPTIONS="-v none,fatal,warn" .................................................................................................... .............the same as for instance of koha, koha2, koha3........... The main strange is the following: it (the same version of koha and zebra) works without any problem on Ubuntu 14.04! Thanks in advance George Mikuchadze

1 0