January 2017 - Koha-bugs - lists.koha-community.org

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Needs Signoff --- Comment #64 from Josef Moravec <josef.moravec(a)gmail.com> --- Rebased on master, added another followup. Asking for new sign off - too many followups and conflicts with new work pushed to master. Also note, that the test plan should be amended. New test plan: 1) Apply the patches 2) Go to Tools › CSV export profiles and create a profile of type "SQL for basket export in acquisition" example: biblionumber=biblio.biblionumber|auteur=biblio.author|titre=biblio.title|date=biblioitems.copyrightdate|editeur=biblioitems.publishercode|isbn=biblioitems.isbn|quantite=aqorders.quantity|prix=aqorders.rrp|panier=aqorders.basketno 3) In acquisition module, create a new basket and add an order to the basket 4) On basket detail page, there should be the split button labelled "Export to CSV" 5) Try to use the button and export CSV with your CSV profile you defined in step 2 6) Validate the CSV file. 7) Repeat 4-6 with a closed basket. a) close the basket b) View the basket c) validate that there is an export button d) test it with an export 8) prove t/db_dependent/Acquisition/GetBasketAsCSV.t t/db_dependent/Koha/CsvProfiles.t -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 --- Comment #63 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58992 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58992&action=ed… Bug 8612: Fix test due to bug 13726 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58079|0 |1 is obsolete| | --- Comment #62 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58991 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58991&action=ed… Bug 8612: QA follow-up - distinguish between late issues and basket export csv profiles -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58078|0 |1 is obsolete| | --- Comment #61 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58990 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58990&action=ed… Bug 8612: Add tests for GetBasketAsCSV -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58077|0 |1 is obsolete| | --- Comment #60 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58989 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58989&action=ed… Bug 8612: QA followup - Make export button split button, unify button labels -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58076|0 |1 is obsolete| | --- Comment #59 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58988 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58988&action=ed… Bug 8612 - Followup - use Koha::CsvProfile[s] module (see bug 15451) Signed-off-by: Josef Moravec <josef.moravec(a)gmail.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58075|0 |1 is obsolete| | --- Comment #58 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58987 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58987&action=ed… Bug 8612 - Clean basket.pl getting rid of subroutines with sql query and use GetBasketAsCSV instead GetBasketAsCSV now has a new argument the profile_csv_id, when this param is defined, it loads the profile_content, searches the value of the predefined fields and assembles the data to create the output of the csv file. Signed-off-by: Josef Moravec <josef.moravec(a)gmail.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58074|0 |1 is obsolete| | --- Comment #57 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58986 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58986&action=ed… Bug 8612 - Cleans basket.tt by using TT blocks Signed-off-by: Josef Moravec <josef.moravec(a)gmail.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8612] CSV export profile to have custom fields in export csv basket
by bugzilla-daemon＠bugs.koha-community.org 14 Jan '17

14 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8612 Josef Moravec <josef.moravec(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58073|0 |1 is obsolete| | --- Comment #56 from Josef Moravec <josef.moravec(a)gmail.com> --- Created attachment 58985 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58985&action=ed… Bug 8612 - System preference to have custom fields in export csv basket This patch allows the user use a CSV export profile to create the fields to export the basket as CSV in a basket page. To test: 1) Apply the patch; 2) Create a CSV export profile - type sql - Home › Tools › CSV export profiles ex: biblionumber=biblio.biblionumber|auteur=biblio.author|titre=biblio.title|date=biblioitems.copyrightdate|editeur=biblioitems.publishercode|isbn=biblioitems.isbn|quantite=aqorders.quantity|prix=aqorders.rrp|panier=aqorders.basketno 3) Create a new basket and add an order to the basket 4) Validate: the text "Select CSV profile:" and a dropdown in the basket view 5) In the new dropdown, select the CSV export profile created 6) Validate the CSV file. 7) Do the same validation with a closed basket. a) close the basket b) View the basket c) validate that there is a dropdown d) test it with an export Signed-off-by: Josef Moravec <josef.moravec(a)gmail.com> Works as expected for me Signed-off-by: Josef Moravec <josef.moravec(a)gmail.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 5594] Option to configure default sort order for items on bib records
by bugzilla-daemon＠bugs.koha-community.org 13 Jan '17

13 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5594 Marjorie Barry-Vila <marjorie.barry-vila(a)ccsr.qc.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila(a)ccsr.qc | |.ca -- You are receiving this mail because: You are watching all bug changes.

1 0