Anyone please On Wed, 21 Aug 2019 10:59 muirunyeri <[email protected] 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 <[email protected]> > Date: 16/08/2019 14:12 (GMT+03:00) > To: Alvaro Cornejo <[email protected]>, [email protected] > 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 <[email protected]> > Date: 15/08/2019 16:42 (GMT+03:00) > To: muirunyeri <[email protected]> > Cc: Carlos Lopez <[email protected]>, [email protected] > 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 <[email protected]> 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 <[email protected]> Date: 15/08/2019 >> 02:02 (GMT+03:00) To: muirunyeri <[email protected]>, >> [email protected] 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 | [email protected] | >> library.dmlibrary.org.au >> >> -----Original Message----- >> From: Koha <[email protected]> On Behalf Of muirunyeri >> Sent: Thursday, 15 August 2019 5:56 AM >> To: [email protected] >> Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines >> >> >> >> >> >> Sent from my Samsung Galaxy smartphone.-------- Original message >> --------From: muirunyeri <[email protected]> Date: 14/08/2019 22:54 >> (GMT+03:00) To: [email protected] 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 <[email protected]> >> >> Date: 06/08/2019 19:14 (GMT+03:00) >> To: [email protected] >> 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 >> >> [email protected] >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> 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 >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
