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-r...@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-r...@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-r...@inlibro.com> wrote: >> >>> Hi Vinod, >>> >>> This table was replaced by circulation_rules. The structure is quite >>> different, as you'll notice. >>> >>> Caroline >>> >>> On 2022-08-02 01:34, vinod mishra wrote: >>> > Hello >>> > >>> > Can anyone help to know "issuingrules" table contents moved to which >>> 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-r...@inlibro.com <mailto: >>> caroline.cyr-la-r...@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-r...@inlibro.com <caroline.cyr-la-r...@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-r...@inlibro.com <caroline.cyr-la-r...@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