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

[Bug 16219] New: Runreport.pl should allow sql paramters to be passed on the command line.
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16219 Bug ID: 16219 Summary: Runreport.pl should allow sql paramters to be passed on the command line. Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Runreport.pl has a major limitation in that it is not capable of running reports that use sql parameters: Runreport will run this: SELECT p.surname, p.firstname, p.email, p.cardnumber, h.waitingdate AS 'hold date', i.barcode, b.title FROM reserves h LEFT JOIN borrowers p USING (borrowernumber) LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE h.waitingdate IS NOT NULL AND h.branchcode='ABC' but if your report looks like this: SELECT p.surname, p.firstname, p.email, p.cardnumber, h.waitingdate AS 'hold date', i.barcode, b.title FROM reserves h LEFT JOIN borrowers p USING (borrowernumber) LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE h.waitingdate IS NOT NULL AND h.branchcode=<<Waiting at|branches>> We should be able to supply a --sql_params argument one or more times to provide the sql parameters. runreport.pl --to="someone(a)someplace.com" --subject="Patrons with Holds Waiting at Library" --format=csv --sql_params="ABC" 1 -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 17140] New: Incorrect rounding in total fines calculations, part 2
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17140 Bug ID: 17140 Summary: Incorrect rounding in total fines calculations, part 2 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: larit(a)student.uef.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Bug 15741 fixes some rounding issues but not all, for example trying to paying a fine of 1.14 still does not work (also 1.39). To replicate bug: 1. Go to patron's fines tab, make sure there are no outstanding payments. 2. Via "Create manual invoice" tab, create one fine of 1.14 3. Go to Pay fines tab 4. Click "Pay amount" and confirm. 5. Observe error message "You must pay a value less than or equal to 1.14." 6. Go to Pay fines tab 7. Click "Pay selected" and confirm 8. Observe error message "You must pay a value less than or equal to 1.14." -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 77

[Bug 18344] New: Allow overdue fines cap at replacement price, and cap by amount to work together
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18344 Bug ID: 18344 Summary: Allow overdue fines cap at replacement price, and cap by amount to work together 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: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com There is no reason that a library shouldn't be able to use the monetary fines cap and the replacement price cap at the same time. The code is written in such a way that they already work harmoniously. We have librarians who wish to use both so they can set a high cap of $10.00 but also use the replacement price cap so that a $20.00 book would only get a fine of $10.00, but a $5.00 paperback will only get a fine of $5.00 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 28

[Bug 17171] New: Add a syspref to allow currently issued items to be issued to a new patron without staff confirmation
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17171 Bug ID: 17171 Summary: Add a syspref to allow currently issued items to be issued to a new patron without staff confirmation 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: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Work to be done: 1) Add new system preference AutoReturnCheckedOutItemForNewCheckout ( or something more terse ) 2) Add new system preference AutoReturnCheckedOutItemForNewCheckoutForgiveFine 3) Modify circulation.pl to accept these new parameters and report what happened (yellow box) instead of prompting for confirmation -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 42

[Bug 17530] New: Don't show 'article request' link when no article requests are permitted
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17530 Bug ID: 17530 Summary: Don't show 'article request' link when no article requests are permitted Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Don't show the article request link on records where there is no article request possible. At the moment the article request link shows on all records, no matter if the circulation conditions allow for an article request or not. We should not show the link when an article request is in general not possible. -- You are receiving this mail because: You are watching all bug changes.

1 83

[Bug 17282] New: Ability to create charts for SQL reports
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17282 Bug ID: 17282 Summary: Ability to create charts for SQL reports Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: gmcharlt(a)gmail.com Reporter: alex.arnaud(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Add a form under report's result that allow to configure and draw a chart (pie, bar, line and combination). -- You are receiving this mail because: You are watching all bug changes.

1 96

[Bug 18071] New: Extend script update_authorities.pl
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '20

12 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18071 Bug ID: 18071 Summary: Extend script update_authorities.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Authority data support Assignee: gmcharlt(a)gmail.com Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 17382] New: Elasticsearch - provide a method to identify records not indexed
by bugzilla-daemon＠bugs.koha-community.org 10 Nov '20

10 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17382 Bug ID: 17382 Summary: Elasticsearch - provide a method to identify records not indexed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org While testing I ran across an error in rebuilding where a bad dateaccessioned ('0002-00-05') caused a record to fail indexing It owuld be nice to provide this inofrmation to the user - either via a table or a cronjob/email report - something to allow the library to correct problematic records. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 18193] New: Elasticsearch - adding new records from Z39.50 results in ' internal server error'
by bugzilla-daemon＠bugs.koha-community.org 10 Nov '20

10 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18193 Bug ID: 18193 Summary: Elasticsearch - adding new records from Z39.50 results in 'internal server error' Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org To recreate: 1 - Go to cataloging 2 - Select 'New from Z39/50' 3 - Search, find a record, import 4 - Save the record 5 - Error! Checking the logs you should see a dump of the record in xml - Koha chokes trying to access it as a MARC::Record In C4/Search.pm: 2492 If we are using elasticsearch, it'll already be a MARC::Record and this 2493 function needs a new name. 2494 2495 =cut 2496 2497 sub new_record_from_zebra { 2498 2499 my $server = shift; 2500 my $raw_data = shift; 2501 # Set the default indexing modes 2502 my $search_engine = C4::Context->preference("SearchEngine"); 2503 if ($search_engine eq 'Elasticsearch') { 2504 return $raw_data; 2505 } However, that doesn't seem to be the case, we are still getting marc XML, adding "&& 0" to the if and nullifying that section (or removing it) seems to solve the issue -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 16728] New: Display Issued with entry (MARC21 777) to staff and OPAC normal view
by bugzilla-daemon＠bugs.koha-community.org 09 Nov '20

09 Nov '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16728 Bug ID: 16728 Summary: Display Issued with entry (MARC21 777) to staff and OPAC normal view Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt(a)gmail.com Reporter: eb(a)efdss.org QA Contact: testopia(a)bugs.koha-community.org The 777 field is not one of the fields currently displayed in staff or OPAC normal view. It is visible in the MARC view, but this does not enable the link (via subfield w) to the related record. The subfields are identical to 773 (which does display in the normal view). The main difference being the automatic text generated by the indicators. http://www.loc.gov/marc/bibliographic/concise/bd777.html This is a very important field for music libraries. -- You are receiving this mail because: You are watching all bug changes.

1 17