[Koha] Koha Not calculating and charging overdue fines

Alvaro Cornejo cornejo.alvaro at gmail.com
Fri Aug 16 01:42:16 NZST 2019


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 results I need.
>
>
> Warm regards.
>
>
>
>
>
>
> Sent from my Samsung Galaxy smartphone.-------- Original message
> --------From: Katrin Fischer <katrin.fischer.83 at web.de> Date: 14/08/2019
> 22:35  (GMT+03:00)
> Date:14/08/2019  22:35  (GMT+03:00) To: muirunyeri <muirunyeri at 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 at web.de>
>         Date: 12/08/2019 08:54 (GMT+03:00)
>         To: muirunyeri <muirunyeri at 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 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