[Bug 36201] New: Add -days_old and -months_old arguments for misc/export_records.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Bug ID: 36201 Summary: Add -days_old and -months_old arguments for misc/export_records.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: alexbuckley@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl It would be nice if libraries could use misc/export_records.pl as a cronjob to run on the first day of every month to export all new biblio records added in the last month: by using new -days_old=31 or -months_old=1 arguments for the export_records.pl script to limit on the biblio.datecreated. A use case for this would be those libraries which need to keep a union catalogue up to date with their local Koha catalogue. By providing the union catalogue provider with a MARC file of all biblio additions in the last month. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Change sponsored?|--- |Sponsored -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 --- Comment #1 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Created attachment 162575 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=162575&action=edit Bug 36201: Add -days_old and -months_old arguments to misc/export_records.pl Limit exported records based on the biblio.datecreated using the -days_old and -months_old arguments. Test plan: 1. Remove all biblios in your Koha catalogue, then create 10 bibliographic records - in the Koha database set 6 of the biblios to have a biblio.datecreated 50 days ago 2. Apply patches and restart services 3. In koha-shell run the following command: perl misc/export_records.pl --months_old=1 --format=marc --record-type=bibs --filename=/tmp/test.mrc 4. Check the /tmp/test.mrc and confirm it has 4 biblios in it 5. In the koha-shell run the following command: perl misc/export_records.pl --days_old=31 --format=marc --record-type=bibs --filename=/tmp/test2.mrc 6. Check the /tmp/test2.mrc and confirm it also has 4 biblios in it 7. In the koha-shell run the following command: perl misc/export_records.pl --days_old=52 --format=marc --record-type=bibs --filename=/tmp/test3.mrc 8. Check the /tmp/test3.mrc and confirm it has 10 biblios in it 9. In the koha-shell run the following command: perl misc/export_records.pl --format=marc --record-type=bibs --filename=/tmp/all.mrc 10. Check the /tmp/all.mrc and confirm it also has 10 biblios in it 11. Try running the export_records.pl script with a variety of other arguments and confirm it works as expected Sponsored-By: Department of Corrections, New Zealand -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |alexbuckley@catalyst.net.nz |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff --- Comment #2 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Ready to test -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Baptiste <baptiste.bayche@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Patch doesn't apply CC| |baptiste.bayche@inlibro.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36201 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |RESOLVED Resolution|--- |DUPLICATE --- Comment #3 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Since we have upstreamed the ability to run export_records.pl off a SQL report in bug 36770 ( https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36770 ) this bug report is redundant, because you could just add these conditionals as a SQL WHERE clause in your SQL report. *** This bug has been marked as a duplicate of bug 36770 *** This bug has been marked as a duplicate of bug 36770 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org