[Koha] issuingrules from 19.11 to 20.05

[Katrin Fischer]

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 at 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 at 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 at 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 at 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 at inLibro.com <mailto:
>>>> caroline.cyr-la-rose at inLibro.com>
>>>>
>>>> INLiBRO | Document Technologies Specialists | www.inLibro.com
>>>> <http://www.inLibro.com>
>>>> _______________________________________________
>>>>
>>>> Koha mailing list  http://koha-community.org
>>>> Koha at 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 at inLibro.com <caroline.cyr-la-rose at 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 at inLibro.com <caroline.cyr-la-rose at inLibro.com>
>> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha