Hi Katrin and Magnus

After the mentioned changes everything works as expected. Thanks again for your help!

(And as suggested by Katrin I have set system preference "CurrencyFormat" to a format with decimal dot).

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch



Am 08.01.24 um 10:53 schrieb Michael Kuhn:
Hi Katrin and Magnus

Many thanks for your answers!

It is not possible to change the value to "0.00" via Koha menu "Administration > Defining circulation and fine rules for all libraries" - even wehn savin "0.00" it will still show "0,00".

We have eight rules there - all of them show value "0,00" in column "Overdue fines cap (amount)". But in table "circulation_rules" I found the following:

MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE rule_name="overduefinescap";
+-----+------------+--------------+----------+-----------------+------------+
| id  | branchcode | categorycode | itemtype | rule_name    | rule_value
+-----+------------+--------------+----------+-----------------+------------+
|   4 | NULL       | NULL         | NULL     | overduefinescap |       |
|  34 | NULL       | NULL         | BUCH     | overduefinescap | 0.00  |
|  67 | NULL       | NULL         | CD       | overduefinescap | 0.00  |
|  94 | NULL       | NULL         | ZSS      | overduefinescap | 0.00  |
| 136 | NULL       | PT           | BUCH     | overduefinescap |       |
| 170 | NULL       | HB           | BUCH     | overduefinescap | 0.00  |
| 182 | NULL       | NULL         | KONV     | overduefinescap |       |
| 214 | NULL       | NULL         | DVD      | overduefinescap |       |
+-----+------------+--------------+----------+-----------------+------------+
8 rows in set (0,000 sec)

So I changed just the values actually containing "0,00" as follows:

MariaDB [koha_bibliothek]> UPDATE circulation_rules SET rule_value = '0.00' WHERE rule_value = '0,00';

Thus table "circulation_rules" now shows:

MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE rule_name="overduefinescap";
+-----+------------+--------------+----------+-----------------+------------+
| id  | branchcode | categorycode | itemtype | rule_name    | rule_value |
+-----+------------+--------------+----------+-----------------+------------+
|   4 | NULL       | NULL         | NULL     | overduefinescap |       |
|  34 | NULL       | NULL         | BUCH     | overduefinescap | 0.00  |
|  67 | NULL       | NULL         | CD       | overduefinescap | 0.00  |
|  94 | NULL       | NULL         | ZSS      | overduefinescap | 0.00  |
| 136 | NULL       | PT           | BUCH     | overduefinescap |       |
| 170 | NULL       | HB           | BUCH     | overduefinescap | 0.00  |
| 182 | NULL       | NULL         | KONV     | overduefinescap |       |
| 214 | NULL       | NULL         | DVD      | overduefinescap |       |
+-----+------------+--------------+----------+-----------------+------------+
8 rows in set (0,000 sec)

However, even after restarting Koha ( memcached apache2 koha-common ) Koha menu "Administration > Defining circulation and fine rules for all libraries" still shows the value "0,00" in column "Overdue fines cap (amount)" for all eight rules as before.

I will now wait and see what happens after the next run of "/etc/cron.daily/koha-common".

Best wishes: Michael


_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to