[Bug 9300] New: filtering export.pl by accession date does not work
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Bug ID: 9300 Summary: filtering export.pl by accession date does not work Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: gmcharlt@gmail.com Reporter: steven_jeffery@fmi.com When using the MARC export tool at /tools/export.pl you have the option to filter the records by accession date. This feature is not currently functioning. Instead of filtering, it simply grabs all records regardless of accession date. <oleonard>: I think I'm reproducing your bug SJeffery, given how long this export download is taking <oleonard>: Yup, got all records. <oleonard>: SJeffery: master -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 --- Comment #1 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 18045 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=18045&action=edit dates in the marc aren't in the date range either This is still an issue. I ran the export for Jan 1 2013 to today and I got results like this one: mysql> select datecreated from biblio where biblionumber=753; +-------------+ | datecreated | +-------------+ | 2012-09-21 | +-------------+ Which is obviously not right. The MARC is attached in the image -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Jesse Weaver <jweaver@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED CC| |jweaver@bywatersolutions.co | |m Assignee|gmcharlt@gmail.com |jweaver@bywatersolutions.co | |m -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 --- Comment #2 from Jesse Weaver <jweaver@bywatersolutions.com> --- Created attachment 18631 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=18631&action=edit Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 --- Comment #3 from Jesse Weaver <jweaver@bywatersolutions.com> --- Created attachment 18632 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=18632&action=edit Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Jesse Weaver <jweaver@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #18631|0 |1 is obsolete| | Attachment #18631|Bug 9300 - filtering |Bug 9300 - filtering description|export.pl by accession date |export.pl by accession date |does not work Small typo in |does not work Small typo in |query construction, fixed. |query construction, fixed. |To test: 1) Try filtering a |To test: 1) Try filtering a |MARC export using "Start |MARC export using "Start |date" 2) Notice the lack of |date" 2) Notice the lack of |filtering 3) Apply patch 4) |filtering 3) Apply patch 4) |Try export again, records |Try export again, records |are filtered by |are filtered by -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off CC| |paul.poulain@biblibre.com --- Comment #4 from Paul Poulain <paul.poulain@biblibre.com> --- Patch tested with a sandbox, by Cedric Vita <cedric.vita@dracenie.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #18632|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 --- Comment #5 from Paul Poulain <paul.poulain@biblibre.com> --- Created attachment 18698 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=18698&action=edit Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned Signed-off-by: Cedric Vita <cedric.vita@dracenie.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |jonathan.druart@biblibre.co | |m Patch complexity|--- |Trivial patch QA Contact| |jonathan.druart@biblibre.co | |m --- Comment #6 from Jonathan Druart <jonathan.druart@biblibre.com> --- Typo fix. Marked as Passed QA. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #18698|0 |1 is obsolete| | --- Comment #7 from Jonathan Druart <jonathan.druart@biblibre.com> --- Created attachment 18731 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=18731&action=edit Bug 9300 - filtering export.pl by accession date does not work Small typo in query construction, fixed. To test: 1) Try filtering a MARC export using "Start date" 2) Notice the lack of filtering 3) Apply patch 4) Try export again, records are filtered by dateaccessioned Signed-off-by: Cedric Vita <cedric.vita@dracenie.com> Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |gmcharlt@gmail.com --- Comment #8 from Galen Charlton <gmcharlt@gmail.com> --- Pushed to master. Thanks, Jesse! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |Pushed to Stable CC| |tomascohen@gmail.com --- Comment #9 from Tomás Cohen Arazi <tomascohen@gmail.com> --- This patch has been pushed to 3.12.x, will be in 3.12.1. Thanks Jesee! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9300 Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bgkriegel@gmail.com --- Comment #10 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- Pushed to 3.10.x, will be in 3.10.7 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org