February 2018 - Koha-bugs - lists.koha-community.org

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|19467 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19467 [Bug 19467] Display location and itemtype description on lost items report -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Bug 9573 depends on bug 20236, which changed state. Bug 20236 Summary: Show descriptions instead of codes for locations and item types on item lost report result list https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20236 What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 20236] New: Show descriptions instead of codes for locations and item types on item lost report result list
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20236 Bug ID: 20236 Summary: Show descriptions instead of codes for locations and item types on item lost report result list Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Blocks: 9573 When using the item lost report, the codes for locations and item types are shown instead of the correct descriptions. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 [Bug 9573] Ability to download items lost report -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 --- Comment #66 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- I realized (while testing) that I did the original sign-off here. But as we have a second sign-off I hope the RM will be happy to have me QA as well. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 --- Comment #65 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 71895 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71895&action=ed… Bug 9573: (QA follow-up) Add missing include back Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #71880|0 |1 is obsolete| | --- Comment #64 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 71894 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71894&action=ed… Bug 9573: Add missing KOHA_VERSION in js paths Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #71879|0 |1 is obsolete| | --- Comment #63 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 71893 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71893&action=ed… Bug 9573: Add missing use statement Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> Signed-off-by: Séverine QUEUNE <severine.queune(a)bulac.fr> Signed-off-by: Séverine QUEUNE <severine.queune(a)bulac.fr> Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #71878|0 |1 is obsolete| | --- Comment #62 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 71892 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71892&action=ed… Bug 9573: (follow-up) Lost items report - add KohaTable to itemlost Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> Signed-off-by: Séverine QUEUNE <severine.queune(a)bulac.fr> Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9573] Ability to download items lost report
by bugzilla-daemon＠bugs.koha-community.org 17 Feb '18

17 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9573 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #71877|0 |1 is obsolete| | --- Comment #61 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 71891 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71891&action=ed… Bug 9573: Lost items report - Add the CSV export ability Finally we add the ability to export the list of lost items. The items will be export in CSV format using a CSV profile defined. Test plan: 0/ Apply all the patches from this patch set 1/ Define a CSV profile (type=SQL, Usage=Export lost items in report) Try something like that to get the same columns as the default table: Title=biblio.title |Author=biblio.author |Lost status=items.itemlost |Lost on=items.itemlost_on |Barcode=items.barcode |Call number=items.itemcallnumber |Date last seen=items.datelastseen |Price=items.price |Rep. price=items.replacementprice |Library=items.homebranch |item type=items.itype |Current location=items.holdingbranch |Location=items.location |Not for loan status=items.notforloan |Notes=items.itemnotes 2/ Use the filters and select items to export 3/ Export the list of items you want and make sure the CSV is correctly formatted and contains the items you selected QA Notes: - I think we should add default CSV profiles for the different "usage", but I would consider it as a separate enhancement since none of them is defined yet - Most of the code to export CSV is no reusable. We should make Koha::Exporter::Record support CSV export for type=SQL (it only supports MARC type so far). Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> Signed-off-by: Séverine QUEUNE <severine.queune(a)bulac.fr> Signed-off-by: Katrin Fischer <katrin.fischer.83(a)web.de> -- You are receiving this mail because: You are watching all bug changes.

1 0