[Bug 9712] New: Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Bug ID: 9712 Summary: Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt@gmail.com Reporter: kyle@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 --- Comment #1 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 15706 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15706&action=edit Bug 9712 - Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues This script can take existing issues and check to see of the due dates match up with the current issuing rules. If can optionally update the due dates based on the current issuing rules. Test Plan: 1) Set an issuing rule 2) Check out an item to a patron where that issuing rules applies 3) Modify the issuing rule's issue length 4) Run migration_tools/recalculate_due_dates.pl -t 5) You should see it list your issue has having a changed due date 6) run migration_tools/recalculate_due_dates.pl -c 7) You should see the due date updated in the database for this issue -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #15706|0 |1 is obsolete| | --- Comment #2 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 15707 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15707&action=edit Bug 9712 - Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues This script can take existing issues and check to see of the due dates match up with the current issuing rules. If can optionally update the due dates based on the current issuing rules. Test Plan: 1) Set an issuing rule 2) Check out an item to a patron where that issuing rules applies 3) Modify the issuing rule's issue length 4) Run migration_tools/recalculate_due_dates.pl -t 5) You should see it list your issue has having a changed due date 6) run migration_tools/recalculate_due_dates.pl -c 7) You should see the due date updated in the database for this issue -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #15707|0 |1 is obsolete| | --- Comment #3 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 15708 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15708&action=edit Bug 9712 - Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues This script can take existing issues and check to see of the due dates match up with the current issuing rules. If can optionally update the due dates based on the current issuing rules. Test Plan: 1) Set an issuing rule 2) Check out an item to a patron where that issuing rules applies 3) Modify the issuing rule's issue length 4) Run migration_tools/recalculate_due_dates.pl -t 5) You should see it list your issue has having a changed due date 6) run migration_tools/recalculate_due_dates.pl -c 7) You should see the due date updated in the database for this issue -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #15708|0 |1 is obsolete| | --- Comment #4 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 15709 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15709&action=edit Bug 9712 - Add command line script to recalculate existing due dates based on current issuing rules and retroactively update the issues This script can take existing issues and check to see of the due dates match up with the current issuing rules. If can optionally update the due dates based on the current issuing rules. Test Plan: 1) Set an issuing rule 2) Check out an item to a patron where that issuing rules applies 3) Modify the issuing rule's issue length 4) Run migration_tools/recalculate_due_dates.pl -t 5) You should see it list your issue has having a changed due date 6) run migration_tools/recalculate_due_dates.pl -c 7) You should see the due date updated in the database for this issue -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle.m.hall@gmail.com Assignee|gmcharlt@gmail.com |kyle.m.hall@gmail.com -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gmcharlt@gmail.com --- Comment #5 from Galen Charlton <gmcharlt@gmail.com> --- What is the use case you see for this? Particularly in a production situation, retroactively changing due dates on patrons seems a bit drastic (particularly if the loan period gets shortened). -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 --- Comment #6 from Kyle M Hall <kyle.m.hall@gmail.com> --- I agree, it is a drastic measure. This action has become necessary where bugs in Koha have caused loans to have an incorrect due date. Another good case is where a library has incorrectly set up circulation rules and needs to fix their due dates. Often in these cases, the correct due date has been stamped in the book, but the incorrect due date is set in Koha. (In reply to comment #5)
What is the use case you see for this? Particularly in a production situation, retroactively changing due dates on patrons seems a bit drastic (particularly if the loan period gets shortened).
-- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 --- Comment #7 from Galen Charlton <gmcharlt@gmail.com> --- (In reply to comment #6)
I agree, it is a drastic measure. This action has become necessary where bugs in Koha have caused loans to have an incorrect due date. Another good case is where a library has incorrectly set up circulation rules and needs to fix their due dates. Often in these cases, the correct due date has been stamped in the book, but the incorrect due date is set in Koha.
OK, that makes sense. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA CC| |m.de.rooy@rijksmuseum.nl --- Comment #8 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- misc/migration_tools/recalculate_due_dates.pl DUE DATE ALTERED ITEM NUMBER: 199709 BORROWER: 1 ITEM TYPE: EXH BORROWER CATEGORY: ST ISSUE DATE: 2013-09-23 12:25:00 OLD DATE DUE: 2013-09-30 23:59:00 NEW DATE DUE: 2013-09-30 23:59:36 *** TEST MODE, DATE DUE NOT UPDATED IN DATABASE *** UPDATED 1 OF 1 ISSUES Hey, I did not want to update (so it should not say it updated 1 issue). And what about the 36 seconds difference in due date? (I did not change any rule yet.) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9712 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |josef.moravec@gmail.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org