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

[Bug 21560] New: report ODS export optimization
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '19

26 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21560 Bug ID: 21560 Summary: report ODS export optimization Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org SQL reports can be exported with CSV, TSV of ODS format. When report has thousands of rows, using ODS format is around 10 times longer than other formats. It also loads CPU and RAM a lot. The longest call is expandTable(). I found that the call on OpenOffice-OODoc lib can be optimized. Based on https://grep.metacpan.org/search?qci=&q=expandTable&qft=&qd=OpenOffice-OODo… -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 49

[Bug 22246] New: Elasticsearch indexing needs a maximum length for __sort fields
by bugzilla-daemon＠bugs.koha-community.org 25 Mar '19

25 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22246 Bug ID: 22246 Summary: Elasticsearch indexing needs a maximum length for __sort fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: ere.maijala(a)helsinki.fi Target Milestone: --- Currently there's no limit to the length of *__sort fields. If such field is created from item information or something else that can be repeated a lot, the field may become too long. Such field is e.g. local-classification, which is by default created from 952o. If there are hundreds or thousands of items, the field may become longer than what Elasticsearch accepts. Also consider making it a non-sortable field by default. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 21735] New: Update Sys Pref : MarkLostItemsAsReturned
by bugzilla-daemon＠bugs.koha-community.org 22 Mar '19

22 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21735 Bug ID: 21735 Summary: Update Sys Pref : MarkLostItemsAsReturned Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Documentation Assignee: koha-bugs(a)lists.koha-community.org Reporter: kelly(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org This system preference changed in Koha version 17.11.07 in which the library has more options than just Mark/Don't Mark. We will need some documentation on this in the manual. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 19980] New: Omnibus: Update single-column templates to use Bootstrap grid
by bugzilla-daemon＠bugs.koha-community.org 22 Mar '19

22 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19980 Bug ID: 19980 Summary: Omnibus: Update single-column templates to use Bootstrap grid Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: dcook(a)prosentient.com.au, josef.moravec(a)gmail.com, misilot(a)fit.edu, nengard(a)gmail.com, testopia(a)bugs.koha-community.org Blocks: 14546 Templates in the staff client which are a single column can be easily converted from using YUI grids to using Bootstrap grids. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14546 [Bug 14546] Make staff client templates responsive -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 22048] New: Use set_password instead of update_password in the codebase
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22048 Bug ID: 22048 Summary: Use set_password instead of update_password in the codebase Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- update_password has been deprecated and will be removed by bug 21992. We need to switch all the uses in the codebase into using set_password. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 32

[Bug 21834] New: Display illrequests.orderid in the table of ILL requests
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21834 Bug ID: 21834 Summary: Display illrequests.orderid in the table of ILL requests Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: ILL Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no illrequests.orderid is used to store ILL requets IDs that originate outside of Koha. For some ILL systems, this ID is very important and often used to identify requests. It would be good if this was displayed in the main table of ILL requests, and if the column was sortable. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 20574] New: Acquisitions Views
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20574 Bug ID: 20574 Summary: Acquisitions Views Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: kyle(a)bywatersolutions.com Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org 1 - Add a dropdown branch filter to the aqui-home page 2 - Add custom js to your system t preselect the filter based on signed in library -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 21300] New: Restriction of ILS-DI webservice to 1st and 2d level by default
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21300 Bug ID: 21300 Summary: Restriction of ILS-DI webservice to 1st and 2d level by default Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: anne-claire.bernaudin(a)univ-rennes1.fr QA Contact: testopia(a)bugs.koha-community.org The Koha wiki describes a way of restricting access to ILS-DI through an Apache configuration : https://wiki.koha-community.org/wiki/APIs_and_protocols_supported_by_Koha#I… "ILS-DI ILS-DI is self-documenting, so in an installation where it is enabled, you can get some information about it at the URL: http://koha-opac.example.org/cgi-bin/koha/ilsdi.pl Because ILS-DI gives access to all your data (items, patrons...), it should be restricted by allowing IP in the admin interface and/or by disabling services via the server. For Apache, these rules can be added to restrict public access only to the first and second levels of ILS-DI: <IfModule mod_rewrite.c> # Rewrite Rules RewriteEngine On # Restricted ILS-DI Access RewriteCond %{QUERY_STRING} !(^($|(\??|(.*&))service=(Describe|GetAvailability|GetRecords|GetAuthorityRecords))) RewriteRule ^/cgi-bin/koha/ilsdi\.pl$ - [R=403,L] </IfModule> Because an IP can be easily spoofed, the second way is recommanded." This would be great to have this restriction setup by default when installing Koha, and to have the possibility to open level 3 and 4 of ILS-DI only if needed. This would be more compliant with GDPR (see bug 18081). Thanks Anne-Claire -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 18212] New: Move SQL code from aqplan.pl administrative script into a C4 perl module
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18212 Bug ID: 18212 Summary: Move SQL code from aqplan.pl administrative script into a C4 perl module Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: alexbuckley(a)catalyst.net.nz Reporter: alexbuckley(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org This bug report requires the removal of SQL code out of the administrative script aqplan.pl and placed into a perl module in C4 directory. Instead of placing the SQL code directly into a subroutine in a C4 module the database query will be re-written as a DBIx query. -- You are receiving this mail because: You are watching all bug changes.

1 36

[Bug 19330] New: Selenium test for Tool module functionality
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '19

21 Mar '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19330 Bug ID: 19330 Summary: Selenium test for Tool module functionality Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: alexbuckley(a)catalyst.net.nz Reporter: alexbuckley(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org The test for this bug report will test the following functionality: * Create patron list * Create patron club template * Create patron club * Create notice * Create overdue notice and status trigger * Create patron card batch * Create patron card text layout * Create patron card template * Set holidays with calendar * Create CSV profile * View logs * Create news item * Add new quote -- You are receiving this mail because: You are watching all bug changes.

1 4