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 results I need. Warm regards. Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Katrin Fischer <katrin.fischer.83@web.de> Date: 14/08/2019 22:35 (GMT+03:00) Date:14/08/2019 22:35 (GMT+03:00) To: muirunyeri <muirunyeri@gmail.com> Cc: Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, can you please post to the list? I will answer there! Thanks, Katrin On 14.08.19 19:43, muirunyeri wrote: Hi, Thanks for assisting on my query. I have around 44,000 items. Kindly help me with more info on how to use the batch item editing. I cannot see the field containing home library in the form when using the batch item modification tool. There is however permanent location and current location both holding the name of my library. This two fields are however set and I need the home library field. If its hidden, how can I unhide it? You could also give me the SQL code if it'll get the results I need. Thanks alot. Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83@web.de> Date: 12/08/2019 08:54 (GMT+03:00) To: muirunyeri <muirunyeri@gmail.com> Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, yes, this is most likely the problem. You need to make sure that in all your items Home library (homebranch) and current location (holdingbranch) are set for Koha to work correctly. Depending on the amount of items you have, there could be different ways to fix this: batch item editing, exporting/reimporting (matching items) or SQL. Make sure you have not hidden those fields from the add item form or have set proper defaults set to prevent the problem in the future. Hope this helps, Katrin On 07.08.19 13:11, muirunyeri wrote: Hi all, The sys prefs are all well set, the calendar and the fine rules. I however observed a very sinister issue which might be causing the overdue fine not calculating. After searching for a book, in normal view under the home library it is blank. This is in like all the books. Could it be the cause? I only have one library under libraries and the fines and circulation polices for all branches are cloned to this library. Regards 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