- Koha - lists.katipo.co.nz

subscription delete
by Nalisha Tamang 05 Sep '19

05 Sep '19

Dear all, Please help me to delete the serial subscription, i tried to delete the subscription but it didn't work, it is still there. Thanks with regards Nalisha Tamang Rai

2 1

Top 10 Circulating Books
by Ma. Victoria H. Silva-Manuel 04 Sep '19

04 Sep '19

HI. I got the SQL report below to generate the top 10 circulating books from koha-community. SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode FROM statistics sJOIN items i ON (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 10 How can we add date range and branch filter? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Time-based Circulation Statistics
by Admire Mutsikiwa 04 Sep '19

04 Sep '19

Hi We are interested in generating circulation statistics grouping then by hour of day so that we can establish the busiest times for circulation activities. I will appreciate any pointers on coming with such a SQL report. Kind Regards, Admire Mutsikiwa

3 2

Re: [Koha] Koha calculating but not showing overdue fines
by muirunyeri 04 Sep '19

04 Sep '19

Hi, I thank you Katrin for your advise on my problem. Koha was installed online following the installation procedure availed in kohageek blog. How or where do I set the holdingbranch? Kindly give me more guidance on this please. Thanks for your forbearance. Regards. Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 01/09/2019 21:36 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha calculating but not showing overdue fines Hi, just in case: you should also set the holdingbranch of your items. if the fine is calculated on return, but not appearing overnight on the patron account, the next thing you need to check is that the fines.pl cronjob is scheduled and running. How to do that depends a bit on how you installed Koha. Hope this helps, Katrin On 25.08.19 07:24, muiru james wrote: > Hi, > > My system is now calculating overdue fines after setting the homelibrary > field but its only after checking in the overdue item that you can see the > amount of fine. On the patrons account, its only showing the user as having > overdue items but not showing what amount of fine has accrued. What can I > do for the amount accrued to be shown even while the item is still checked > out? > > Someone please help > > Thank you > > Best Regards > > On Wed, 21 Aug 2019 10:59 muirunyeri <muirunyeri(a)gmail.com wrote: > >> Hi, >> >> While Koha is now calculating fines, its only possible to see the fine >> after item checkin. Its only showing a user as having overdue items but no >> amount of fine accrued before checkin. What can be done to show on the >> screen the amount accrued even while the item is still checked out? >> >> Best Regards >> >> >> >> Sent from my Samsung Galaxy smartphone. >> -------- Original message -------- >> From: muirunyeri <muirunyeri(a)gmail.com> >> Date: 16/08/2019 14:12 (GMT+03:00) >> To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, koha(a)lists.katipo.co.nz >> Subject: Re: [Koha] Koha Not calculating and charging overdue fines >> >> Hi, >> >> Thanks Alvaro. The code worked and now overdue is calculating >> >> Best regards >> >> >> >> Sent from my Samsung Galaxy smartphone. >> -------- Original message -------- >> From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> >> Date: 15/08/2019 16:42 (GMT+03:00) >> To: muirunyeri <muirunyeri(a)gmail.com> >> Cc: Carlos Lopez <clopez(a)dml.vic.edu.au>, koha(a)lists.katipo.co.nz >> Subject: Re: [Koha] Koha Not calculating and charging overdue fines >> >> Hi Muirunyeri >> >> You can access mysql and run a command like: >> >> >> UPDATE `items` SET `homebranch` = `YourHomeBranchID' [WHERE homebranch is NULL]; >> >> As you will be editing your database directly, you should backup your >> system before. >> >> Regards, >> >> Alvaro >> >> >> |-----------------------------------------------------------------------------------------------------------------| >> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >> celular y Nextel >> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS >> y GPRS online >> Visitenos en www.perusms.com >> >> >> Le jeu. 15 août 2019 à 01:54, muirunyeri <muirunyeri(a)gmail.com> a écrit : >> >>> Hi Carlos, >>> I ran the report which returns a single column with item numbers. It >>> indeed confirms all items are without home branch. However, no batch >>> editing option. >>> Any assistance to solve this is highly appreciated. >>> Thanks >>> >>> Sent from my Samsung Galaxy smartphone.-------- Original message >>> --------From: Carlos Lopez <clopez(a)dml.vic.edu.au> Date: 15/08/2019 >>> 02:02 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com>, >>> koha(a)lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re: Koha Not >>> calculating and charging overdue fines >>> Hi Muirunyeri >>> If the homebranch field is empty, you could run a report from this query: >>> SELECT itemnumber >>> FROM items >>> WHERE homebranch is NULL >>> >>> You should even get a little "Batch modify" button at the top of your >>> results. >>> >>> With kind regards from the Dalton McCaughey Library Team >>> >>> Carlos Lopez >>> >>> Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 >>> Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | >>> library.dmlibrary.org.au >>> >>> -----Original Message----- >>> From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of muirunyeri >>> Sent: Thursday, 15 August 2019 5:56 AM >>> To: koha(a)lists.katipo.co.nz >>> Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines >>> >>> >>> >>> >>> >>> Sent from my Samsung Galaxy smartphone.-------- Original message >>> --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 >>> (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha >>> Not calculating and charging overdue fines >>> Hi, >>> >>> I have around 44,000 items that were imported from excel. The homebranch >>> field is blank and this might be the cause if the non-calculating overdue >>> fines. How can i edit items to fill this field (batch)? The homebranch >>> field is not available on the items form. If its hidden, how can I unhide >>> it? >>> >>> You could also give me an SQL code if it'll get the >> >>> Sent from my Samsung Galaxy smartphone. >>> >>> >>> -------- Original message -------- >>> From: Katrin Fischer <katrin.fischer.83(a)web.de> >>> >>> Date: 06/08/2019 19:14 (GMT+03:00) >>> To: koha(a)lists.katipo.co.nz >>> Subject: Re: [Koha] Koha Not calculating and charging >>> overdue fines >>> >>> >>> >>> >>> Hi all, >>> >>> >>> >>> I think what Caroline described would work well for a dev (git) >>> or >>> >>> standard (tarball) installation, while things with the packages >>> work a >>> >>> little differently like Michael describes. So it might depend on >>> your >>> >>> installation type on what you should do. >>> >>> >>> >>> For package installations the fines.pl should be scheduled by >>> default to >>> >>> run daily. >>> >>> >>> >>> Have you checked everything else that might prevent fines from >>> calculating? >>> >>> >>> >>> - finesmode systempreference? >>> >>> - Holidays in the calendar? >>> >>> - Circulation rules correct? For example sometimes it's easy to >>> miss >>> >>> that rules for 'all libraries' might have been overwritten by >>> branch >>> >>> specific ones. >>> >>> >>> >>> Hope this helps, >>> >>> >>> >>> Katrin >>> >>> >>> >>> On 06.08.19 17:07, Michael Kuhn wrote: >>> >>> > Hi >>> >>> > >>> >>> > >> I think this' where my solution lies however the >>> cron -l command >>> >>> > >> replies no cron command for my user account. I >>> have 2 accounts >>> >>> > >> showing i.e. the admin account and the >>> koha_instance account. >>> >>> > >> >>> >>> > >> I hope i was supposed to run it thru the main >>> account coz thats where >>> >>> > >> I log in. >>> >>> > >> >>> >>> > >> Or what might I be doing wrong? I believe the cron >>> list should have >>> >>> > >> something. Please advise. >>> >>> > >>> >>> > I'm not sure if this is of any help, but in the Koha 19.05 >>> standard >>> >>> > the script "fines.pl" is executed in file >>> >>> > "/etc/cron.daily/koha-common" as follows: >>> >>> > >>> >>> > koha-foreach --chdir --enabled >>> /usr/share/koha/bin/cronjobs/fines.pl >>> >>> > >>> >>> > Thus not in any user controlled crontab. Also the path is >>> not >>> >>> > "misc/cronjobs/fines.pl". >>> >>> > >>> >>> > Best wishes: Michael >>> >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> >>> Koha(a)lists.katipo.co.nz >>> >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> >>> >>> >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> -- >>> >>> Click here to report this message as spam: >>> https://console.mailguard.com.au/ras/1WjDFG6Rrm/6w1jxU3YIDrNJIQQ56V7oe/0.4 >>> >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Data export not working
by Elaine Bradtke 03 Sep '19

03 Sep '19

Koha 19.05 At first Koha seemed to export fewer records than expected, but now I'm not getting any. My latest test was a list of 100 bib numbers resulting in 67 bib records - the missing ones were all from the end of the list. That was at 1:53 pm local time. The next test of 50 resulted in 0 bib records downloaded (0 KB) that was at 2:27pm Then I tried a range of bib numbers (61082-61395). Still no bib records (0KB) this was at 2:33pm. I tried accession dates at 3:04 pm with the same result. What could be wrong, where do we look? The records are there when I search for them, but I can't seem to export them. I hate to be such a bother, but what should have been a simple operation has become a multi-day headache, and I don't know how to fix it. Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

2 2

September 2019 koha-US meeting dates
by Jason Robb 03 Sep '19

03 Sep '19

*koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, September 4th at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+board+mee…> ) Where: https://kslib.zoom.us/j/450230564 Agenda: https://docs.google.com/document/d/10oIqPtT8TrQQD2M_SqY9RjV3CJqdl5YAomCTGva… *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Thursday, September 19th at 3:15 pm MDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Where: Pueblo, CO *This will be an in-person meeting at the koha-US conference. The meeting will also be streamed live for those who are unable to attend -- watch for more info and a link closer to the event.* *General meetings* put an emphasis on Koha -- bugs, issues, development ideas, workflows -- bring your problems and questions so we can discuss! These meetings also include major organizational decisions and reports from various committees. Meetings are held via Zoom video conferencing. A microphone and camera are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Reports - Check-in
by Aliki 03 Sep '19

03 Sep '19

Hello everybody! I would like to run a report in which I could trace all the books/barcodes that haven't been checked-in, in a specific period. Is there any query that I could use to get the non checked-in books/barcodes, except the checked-out ones? -- Aliki Pavlidou

2 1

Circulation by Call Number
by Ma. Victoria H. Silva-Manuel 03 Sep '19

03 Sep '19

How do I add title in the SQL report below to generate circulation statistics by call number? SELECT count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS > 'Call Number', (items.barcode) AS 'Accession 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 date(statistics.datetime) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> > AND <<and (yyyy-mm-dd)|date>> > AND statistics.branch = <<Branch|branches>> > AND items.location = <<Location|loc>> > AND statistics.itemtype = <<Item > type|itemtypes>> > GROUP BY items.itemcallnumber > ORDER BY items.itemcallnumber ASC > I tried adding biblio.title in many places but it always ending up in error. I'm not a programmer that is why I'm struggling with this. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 2

Unable to Access Koha # Critical
by SATISH 03 Sep '19

03 Sep '19

Hi, With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57 I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was running successfully and only during weekend (sunday), system was not accessed. but, when I tried to access Koha for Checkout and Checkin today, I am facing problem It is very critical for me to get this fixed, as it is a busy day for users and for me. Kindly help to fix this error. I am looking forward to hearing from you. #Critical Problem #Priority 1 So for I tried to know the status of MySQL: (as 'root' user) 1) mysql login ------------------------ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2) Mysql Status --------------------------- service mysql start start: Job failed to start 3) System Log Verification ---------------------------- tail -f syslog Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Linux version 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016 (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39) Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] KERNEL supported cpus: Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Intel GenuineIntel Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] AMD AuthenticAMD Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] NSC Geode by NSC Sep 3 11:07:42 gechlibrary bluetoothd[786]: Bl 4) PID ps aux | grep mysqld root 3603 0.0 0.0 4688 832 pts/2 S+ 11:19 0:00 grep --color=auto mysqld 5) MySQL log ----------------- /var/log/mysql/error.log is empty 6) MySQL Status ------------------------------ # mysqld status 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting as process 4036 ... 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled. 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8 190903 11:30:48 InnoDB: Using Linux native AIO mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30) 190903 11:30:48 InnoDB: Error: unable to create temporary file; errno: 30 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error. 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mysqld: Too many arguments (first extra is 'status'). Use --verbose --help to get a list of available options 190903 11:30:48 [ERROR] Aborting 190903 11:30:48 [Note] mysqld: Shutdown complete -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish(a)gmail.com College Website: www.gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library

3 4

Issue with email configuration_not able to send email to patron
by Library biet 03 Sep '19

03 Sep '19

Hi, This is Shashikiran M working as Asst Librarian, I installed KOHA live DVD on my new system and then it was updated to KOHA 19.05 at that time i'm able to send email to patron, after that I took backup from my old system and restored into the new system (PC) after restoring the database into the new system I'm not able to send email to Patron. Can you please help me out. Thanks and regards Shashikiran M Asst Librarian BIET

2 1