[Koha] Koha Not calculating and charging overdue fines

muirunyeri muirunyeri at gmail.com
Wed Aug 21 19:59:07 NZST 2019


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 at gmail.com> Date: 16/08/2019  14:12  (GMT+03:00) To: Alvaro Cornejo <cornejo.alvaro at gmail.com>, koha at 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 at gmail.com> Date: 15/08/2019  16:42  (GMT+03:00) To: muirunyeri <muirunyeri at gmail.com> Cc: Carlos Lopez <clopez at dml.vic.edu.au>, koha at 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 at 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 at dml.vic.edu.au> Date: 15/08/2019  02:02  (GMT+03:00) To: muirunyeri <muirunyeri at gmail.com>, koha at 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 at dml.vic.edu.au | library.dmlibrary.org.au 



-----Original Message-----

From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of muirunyeri

Sent: Thursday, 15 August 2019 5:56 AM

To: koha at 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 at gmail.com> Date: 14/08/2019  22:54  (GMT+03:00) To: katrin.fischer.83 at 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 at web.de>

          

          Date: 06/08/2019 19:14 (GMT+03:00) 

          To: koha at 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 at lists.katipo.co.nz



        https://lists.katipo.co.nz/mailman/listinfo/koha



      

    

  

_______________________________________________

Koha mailing list  http://koha-community.org

Koha at 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 at lists.katipo.co.nz

https://lists.katipo.co.nz/mailman/listinfo/koha




More information about the Koha mailing list