Koha calculating but not showing overdue fines
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@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@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
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@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@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
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
muiru james