May 2023 - Koha-bugs - lists.koha-community.org

[Bug 33635] New: CSV export display broken diacritics in Excel
by bugzilla-daemon＠bugs.koha-community.org 14 Mar '25

14 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33635 Bug ID: 33635 Summary: CSV export display broken diacritics in Excel Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: clemens.tubach(a)kit.edu, gmcharlt(a)gmail.com, michaela.sieber(a)kit.edu This has been a re-occurring support issue: When using one of Koha's many CSV download options, the exported CSV file doesn't open as UTF-8 in Excel, resulting in broken diacritics. LibreOffice doesn't show the issue. The only way to fix it right now is not to open the file directly, but to use the import functionality in Excel as it lets you pick the encoding and separators. This means a lot of extra steps and clicks, which make the CSV export functionalities in Koha hard to use. It turns out that Excel will import the CSV correctly, if we convert the encoding of the exported CSV file from UTF-8 to UTF-8-BOM. Problematic CSV exports include: * Exporting a basket summary page as CSV * Using CSV profile based exports in general, including: lists, basket, lost items report * ... Can we 'fix' the encoding to use BOM? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 23

[Bug 22531] New: Allow for multiple requests to partners and display partners in audit log
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '25

13 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22531 Bug ID: 22531 Summary: Allow for multiple requests to partners and display partners in audit log 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: andrew.isherwood(a)ptfs-europe.com Target Milestone: --- Currently, when an ILL request is sent to partners it is not possible to send to further partners, should the first partner not be able to fulfil the request. A better approach would be to allow the "Place request with partners" option to be selected even when this action has already taken place. This will allow the user to try multiple partners subsequently. As such, we should log which partners a request has been sent to and this information should be displayed in the "Display request log" functionality added in Bug 20750 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 54

[Bug 27444] New: Allow reports to use the calendar to count open/closed days based on the calendar
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '25

13 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27444 Bug ID: 27444 Summary: Allow reports to use the calendar to count open/closed days based on the calendar Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org When writing reports related to fines or overdue notices, one runs into difficulties based on how Koha holidays are stored. There's no good way for SQL to calculate out how many days within a given span were open days. So if you're using the calendar to calculate when to send overdue notices at 10 open days past the due date, there's no way to get SQL to tell you which items should have gotten an overdue notice today. This becomes more of an issue as we use the patron emailer more, since the patron emailer relies upon a report. If one wanted to use the patron emailer to send a fourth overdue notice, one would not be able to calculate when to send that notice using the Koha calendar. I'm not sure what the solution is here. Maybe some syntax one could use in a report to ask Koha to generate a value? So you could say something like: WHERE timestampdiff(days,date_due,curdate()) = <<opendays:date_due,curdate()>> ? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 29566] New: Convert bundle contents modal to a notice
by bugzilla-daemon＠bugs.koha-community.org 12 Mar '25

12 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29566 Bug ID: 29566 Summary: Convert bundle contents modal to a notice Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com We add a simple way to display and print a contents list for bundle items in bug 28854. It would be useful to allow librarians to customise how this list displays and prints; We can achieve that by converting the contents to a notice list other print slips. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 21383] New: Sorting on ILL request table is inaccurate
by bugzilla-daemon＠bugs.koha-community.org 12 Mar '25

12 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21383 Bug ID: 21383 Summary: Sorting on ILL request table is inaccurate 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: andrew.isherwood(a)ptfs-europe.com In the ILL requests table, values containing numbers are sorted incorrectly. For example, AUB-1, AUB-10, AUB-11, AUB-20, AUB-21 etc. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 8

[Bug 21889] New: Include Staff Client entered Purchase Suggestions with System Preference maxopensuggestions
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '25

11 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21889 Bug ID: 21889 Summary: Include Staff Client entered Purchase Suggestions with System Preference maxopensuggestions Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kelly(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Currently only Purchase Suggestions made by patrons through the OPAC are the only suggestions counted in the system preference MaxOpenSuggestions. It would be nice if this system preference also connected to the staff client, so a purchase suggestion done on the patrons account by staff alerted the staff that the patron already had the maximum number of purchase suggestion allowed. At this time, even if a patron has maxed out the number of open purchase suggestions on the OPAC, a staff member can still enter more purchase suggestions for that patron through the staff client without knowledge of the maxopensuggestions being reached. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 11

[Bug 17173] New: Quick edit a subfield in frameworks
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '25

11 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17173 Bug ID: 17173 Summary: Quick edit a subfield in frameworks Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: System Administration Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com There are too many click to jump to the edit form of a specific subfield. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 24846] New: It would be helpful to have a bulk edit of due dates tool
by bugzilla-daemon＠bugs.koha-community.org 10 Mar '25

10 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24846 Bug ID: 24846 Summary: It would be helpful to have a bulk edit of due dates tool Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com With events sometimes leading to unforeseen branch closures (think Coronavirus as an example), it would be helpful to have a tool that would allow librarians to update due dates in bulk based on branch and current due date of the material. We envisage this tool as a simple form whereby the user can filter checkouts by a due date window and branch and then either set a fixed new due date for all such items or roll the due date on by X days. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 52

[Bug 21827] New: koha-mysql does not recognize non-standard port
by bugzilla-daemon＠bugs.koha-community.org 10 Mar '25

10 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21827 Bug ID: 21827 Summary: koha-mysql does not recognize non-standard port Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: gmcharlt(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net The koha-mysql script provided with the Debian package currently does not check the <port> element in koha-conf.xml. Consequently, if one uses a non-standard port number for MySQL, koha-mysql cannot connect to the database even though Koha itself can. Teaching koha-mysql how to pass --port to the mysql command would fix it. I note that if/when the patches for bug 11974 make it in, it would be useful to also teach koha-mysql how to pass --socket. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 23141] New: The Debian scripts do not use the myql portnumber
by bugzilla-daemon＠bugs.koha-community.org 10 Mar '25

10 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23141 Bug ID: 23141 Summary: The Debian scripts do not use the myql portnumber Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: andreas.jonsson(a)kreablo.se QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net Target Milestone: --- The scripts koha-mysql, koha-mysqldump, and koha-create and possibly others do not use the configured mysql portnumber configured in koha-conf.xml. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 38