[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