- Koha - lists.katipo.co.nz

[KOHA] ALL TRANSACTIONS DELETE
by muirunyeri 06 Sep '19

06 Sep '19

Hello, A training was conducted using a real koha database with real patrons. Witjin afew days the library wants to use the system to replace the manual one. Is there a way to erase all the transactions so that the koha instance would be new for that rollout? Kindly advise Warm regards Sent from my Samsung Galaxy smartphone.

2 1

Deleted biblio still appearing in search results staff interface
by Elaine Bradtke 05 Sep '19

05 Sep '19

We're running 19:05.02 The problem is with Biblio 13267 A selection of some less known folk songs, vol. 2 <http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionum…> and related name authority record 1493 Winn, Cyril In the staff interface, if Winn, Cyril is used as a search term, the results include A selection of some less known folk songs, vol. 2 <http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionum…> - biblio 13267. It shouldn't be there, it's been deleted. When the title is clicked on, the answer is: The record you requested does not exist (13267). In the OPAC (https://catalogue.efdss.org) when we search on the title, A selection of some less known folk songs, vol. 2 <http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionum…> or the name Winn, Cyril, or the biblio number the answer that comes up is: Internal Server Error We've run a zebra index and it didn't make any difference. Any ideas on what's causing the problem? Where we should look? I just did a couple batch edits and uploads, but this particular record was not in either of those batches. 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

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