[Koha] To batch change the returns / check-in

Thu Apr 16 11:29:21 NZST 2020

Thanks very much for adding that Alvaro! Sorry I completely forgot to
add DB backup in my response, got too deep into all the caveats and
considerations!

Regards,

Alex

On 16/04/20 11:20 am, Alvaro Cornejo wrote:
> Hi José
>
> Before running the UPDATE query I´ll recommend you to do a validation
> of the update by converting it to a SELECT statement
>
> So 
>
> UPDATE issues SET date_due="2020-04-29 23:59:00",
> lastreneweddate="2020-04-15 15:01:00" WHERE date_due > '2020-03-17'; 
>
> Will become:
>
> SELECT date_due, lastreneweddate FROM  issues WHERE date_due >
> '2020-03-17';  
>
> This will find all the same reccods that will be updated in your
> initial query.
>
> BTW a table/DB backup before touching the database is a good idea.
>
> Regards
>
> Alvaro 
>
> |----------------------------------------------------------------------------------------|
> */7/* Switch off as you go / Apaga lo que no usas /  Débranchez au fur
> et à mesure.
>  *q *Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le mer. 15 avr. 2020 à 17:40, Alex Buckley
> <alexbuckley at catalyst.net.nz <mailto:alexbuckley at catalyst.net.nz>> a
> écrit :
>
>     Hi Jose,
>
>     Yes you're right at present in all versions of Koha 18.11 currently
>     available the only way to bulk extend due dates of existing issues
>     is in
>     the database.
>
>     A couple of suggestions I have for your query are:
>
>       * Currently your query only changes the date_due of issues due
>     on one
>         day 17 March 2020. If you're goal is to extend all issues that
>     have
>         been due on 17 March till today's date (i.e. issues due on 17
>     March,
>         18 March, 19 March and so on) then what you could do instead is:
>
>     UPDATE issues SET date_due="2020-04-29 23:59:00",
>     lastreneweddate="2020-04-15 15:01:00" WHERE date_due > '2020-03-17';
>
>     This will extend the due date to 29 April 2020 for any item that has
>     been due between 17 March and today.
>
>       * Also you will not need to specify the database name koha_biblio
>         because to get into the Koha database shell you'll be
>     specifying the
>         database name, like so:
>
>     /sudo koha-mysql koha_biblio/
>
>
>     *How this would affect anything else:*
>
>     Any overdue issues due before 17 March will *not* be extended with the
>     above amended query. Therefore you should consider doing the
>     following:
>
>       * * Stop overdue notices being generated*
>
>     You can do this one of two ways:
>
>     - If you want all notices (overdue, advance, hold and password reset
>     notices) to stop being sent during the lockdown you can run:
>
>     sudo koha-email-disable <instancename>
>
>     This stops notices being sent but they are still generated. Therefore
>     when the lockdown is over you will need to:
>
>     - Delete notices in the message_queue database table which have a
>     time_queued value of during the lockdown, otherwise all overdue
>     notices
>     generated during the lockdown will be sent
>
>     - Re-enable email
>
>     sudo koha-email-enable <instancename>
>
>
>     OR
>
>     - Comment out overdue_notices.pl <http://overdue_notices.pl> in
>     the /etc/cron.daily/koha-common file
>
>     This will stop overdue notices being generated at all during the
>     lockdown.
>
>
>       * *Stop overdue fines accruing during the lockdown for those
>     overdues
>         due before 17 March 2020*
>
>     - Set finesMode system preference to  /'Calculate (but only for
>     mailing
>     to the administrator)'/
>
>     /
>     /
>
>       * *Stop patrons being charged the replacement cost of
>     items*/**/*(only
>         applies if you are using the **
>         **DefaultLongOverdueChargeValue system preference)*/
>         /
>
>     Remove the value from the DefaultLongOverdueChargeValue system
>     preference.
>
>
>     Just to let you know soon (probably around 24th April ) Koha 18.11.16
>     will be available to upgrade to and that has the wonderful feature of
>     allowing you to bulk extend due dates in the Koha staff client as this
>     excellent blog post by my colleague Aleisha Amohia outlines:
>     https://www.catalyst.net.nz/blog/koha-let-people-read-longer
>
>     Please let me know if you have any questions at all!
>
>     Many thanks,
>
>     Alex
>
>     -- 
>     Alex Buckley
>     Koha Developer
>
>     Catalyst IT - Expert Open Source Solutions
>     DDI: +64 4 803 2378 | Mob: +64 22 429 6157 | www.catalyst.net.nz
>     <http://www.catalyst.net.nz>
>
>
>     CONFIDENTIALITY NOTICE: This email is intended for the named
>     recipients only. It may contain privileged, confidential or
>     copyright information. If you are not the named recipient, any
>     use, reliance upon, disclosure or copying of this email or its
>     attachments is unauthorised. If you have received this email in
>     error, please reply via email or call +64 4 499 2267.
>
>     _______________________________________________
>
>     Koha mailing list  http://koha-community.org
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Alex Buckley
Koha Developer

Catalyst IT - Expert Open Source Solutions
DDI: +64 4 803 2378 | Mob: +64 22 429 6157 | www.catalyst.net.nz

CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.