Hi Vinod, if you recreate the issuingrules table it should have no consequence on updates, unless Koha was to re-add a table with the same name in the future, which is not likely to happen. It will of course have no functionality/no effect on circulation. As always you should make a backup before any updates. Hope this helps, Katrin On 09.09.22 16:27, vinod mishra wrote:
Hello I have already updated koha to 20.05, now for some reason i wish to create issuingrule table again with similar data as it was before upgrade. May i know what will be the impact in current operation or if again i upgrade to next version from 20.05 ?
Thanks
On Wed, 17 Aug, 2022, 20:02 Caroline Cyr La Rose, < caroline.cyr-la-rose@inlibro.com> wrote:
Hi,
Sorry, this is completely outside my knowledge. Hopefully, someone else on the list will answer...
Caroline On 2022-08-17 09:53, vinod mishra wrote:
Hello
I am sorry this may not be related to Koha but since I am helpless need suggestions on how to replace the highlighted codings with the new *"circulation_rules"*
if (commandStatus) { query = "select * from *issuingrules* where categorycode='*' or categorycode=? and branchcode='*' or branchcode=? "; ptst = conn.prepareStatement(query); ptst.setString(1, Borrower.categorycode); ptst.setString(2, Borrower.branchcode);
for (rs = ptst.executeQuery(); rs.next(); status = true) { *IssuingRules.renewalsallowed* = rs.getInt("*renewalsallowed*"); *IssuingRules.maxissueqty* = rs.getInt("*maxissueqty*"); *IssuingRules.issuelength* = rs.getInt("*issuelength*"); *IssuingRules.firstremind* = rs.getInt("*firstremind*"); }
With Regards,
Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 Scopus ID: 57223138343
*"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*
On Wed, Aug 3, 2022 at 6:35 PM Caroline Cyr La Rose < caroline.cyr-la-rose@inlibro.com> wrote:
Hi Vinod,
If you look at the existing rules in circulation_rules, you'll notice the rule name is in the rule_name column and the value is in rule_value.
If you need to insert via SQL, you can do something like
INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value) VALUES ("BRANCHCODE", "CATEGORYCODE", "ITEMTYPE", "issuelength", "21");
I would suggest doing it via the administration interface (Administration
Circulation and fines rules) however, just because there are so many different rules. I'm not sure what the consequences are if only a few rules are filled in.
Regards,
Caroline On 2022-08-03 01:17, vinod mishra wrote:
Hello Rose
Actualy i wish to incorporate new codes/columns in place of following in existing RFID middleware:
issuelength maxissueqty renewalsallowed
Can anyone help which new columns / code can be substituted for?
On Tue, 2 Aug, 2022, 19:42 Caroline Cyr La Rose, < caroline.cyr-la-rose@inlibro.com> wrote:
Hi Vinod,
This table was replaced by circulation_rules. The structure is quite different, as you'll notice.
Caroline
Hello
Can anyone help to know "issuingrules" table contents moved to which
On 2022-08-02 01:34, vinod mishra wrote: table
from Version 20.05? as it was there up to 19.11 and what tables columns could be used in place of issuingrules if similar does not exist?
With Regards,
Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL:http://vinod.itshelp.co.in/ ORCID ID:http://orcid.org/0000-0003-4666-7874 Scopus ID: 57223138343
*"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi* _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager
Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose@inLibro.com <mailto: caroline.cyr-la-rose@inLibro.com>
INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com> _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Caroline Cyr La Rose, M.S.I. Bibliothécaire | Responsable de produit
Tél. : 1-833-465-4276, poste 221 Caroline.Cyr-La-Rose@inLibro.com <caroline.cyr-la-rose@inLibro.com> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
-- Caroline Cyr La Rose, M.S.I. Bibliothécaire | Responsable de produit
Tél. : 1-833-465-4276, poste 221 Caroline.Cyr-La-Rose@inLibro.com <caroline.cyr-la-rose@inLibro.com> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha