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@gmail.com> Date: 16/08/2019 14:12 (GMT+03:00) To: Alvaro Cornejo <cornejo.alvaro@gmail.com>, koha@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@gmail.com> Date: 15/08/2019 16:42 (GMT+03:00) To: muirunyeri <muirunyeri@gmail.com> Cc: Carlos Lopez <clopez@dml.vic.edu.au>, koha@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@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@dml.vic.edu.au> Date: 15/08/2019 02:02 (GMT+03:00) To: muirunyeri <muirunyeri@gmail.com>, koha@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@dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of muirunyeri Sent: Thursday, 15 August 2019 5:56 AM To: koha@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@gmail.com> Date: 14/08/2019 22:54 (GMT+03:00) To: katrin.fischer.83@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@web.de> Date: 06/08/2019 19:14 (GMT+03:00) To: koha@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha