August 2020 - Koha-bugs - lists.koha-community.org

[Bug 21901] New: Improve performance for serial registration
by bugzilla-daemon＠bugs.koha-community.org 03 Mar '21

03 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21901 Bug ID: 21901 Summary: Improve performance for serial registration Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: frank.hansen(a)ub.lu.se QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Because two indexes are missing, the SQL searches in C4::Serials perform very slow. Since theres no indexes for subscription.biblionumber and serial.subscriptionid, the SQL server will do a full table scans on both tables, which takes a very long time, especially if you have 100,000 subscriptions and approximately one million series registered. To improve response time, at least two indexes are required. I will therefore suggest these two indexes to be built: alter table serial add index idx_serial_subscriptionid using btree (subscriptionid); alter table subscription add index idx_subscription_biblionumber (biblionumber); It's also strange that the subscriptionid in serial is a varchar(100). In subscriptions table, subscriptionid is an int. I think subscriptionid in serial should be an int for safe and for best performance. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 47

[Bug 19458] New: Self-check module highlighting
by bugzilla-daemon＠bugs.koha-community.org 02 Mar '21

02 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19458 Bug ID: 19458 Summary: Self-check module highlighting 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 Work to be done 1. Identify new checkouts and renewals 2. Pass this data to the template 3. Have template apply a special class to those checkouts 4. Apply CSS to style these checkouts -- You are receiving this mail because: You are watching all bug changes.

1 21

[Bug 24973] New: Allow to localize and translate system preferences with new yaml based installer
by bugzilla-daemon＠bugs.koha-community.org 02 Mar '21

02 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24973 Bug ID: 24973 Summary: Allow to localize and translate system preferences with new yaml based installer Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Blocks: 24972 In the de-DE installer a sysprefs.sql file is used to make some changes to the system preferences for a smoother installation experience. The file can be found here: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/my… It's a mix of: - Translating prefs content (HTML prefs, they might go away to news sometime) - Localization settings (date format, currency format, time format) - Translating pref options (borrower titles and relationships) It would be great if there was a way to keep this kind of modifications when switching to the new yaml based installer files. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24972 [Bug 24972] Remove de-DE installer data -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 64

[Bug 16784] New: Export suggestions from OPAC as CSV
by bugzilla-daemon＠bugs.koha-community.org 02 Mar '21

02 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16784 Bug ID: 16784 Summary: Export suggestions from OPAC as CSV Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: vimal0212(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Dear Developers, We would like to see export feature (csv format) book suggestions for approval in staff client. In many libraries, Director of the institution want to see the list of suggested books by library users before placing order. He/she would suggest to remove books from list. This feature is useful to get the list of books for approval via OPAC and send to concerned authority before finalization. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 22

[Bug 24972] New: Remove de-DE installer data
by bugzilla-daemon＠bugs.koha-community.org 02 Mar '21

02 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24972 Bug ID: 24972 Summary: Remove de-DE installer data Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: bgkriegel(a)gmail.com, gmcharlt(a)gmail.com, testopia(a)bugs.koha-community.org Depends on: 24871 +++ This bug was initially created as a clone of Bug #24897 +++ Now we can translate all installer data, then the de-DE directory is no longer needed. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24871 [Bug 24871] Add new *-installer-*.po translation files -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 24

[Bug 23390] New: Add placeholder syntax for column names
by bugzilla-daemon＠bugs.koha-community.org 01 Mar '21

01 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23390 Bug ID: 23390 Summary: Add placeholder syntax for column names 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: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Bug 23206 added more bactch operations for report results. The use of these is limited by the column names which is not ideal for translations. We should add a way to transpose column names for these functions. I suggest [[column|alias]] -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 31

[Bug 17092] New: Generate debian/ control with version numbers from PerlDependencies.pm
by bugzilla-daemon＠bugs.koha-community.org 01 Mar '21

01 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17092 Bug ID: 17092 Summary: Generate debian/control with version numbers from PerlDependencies.pm Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: mirko(a)abunchofthings.net QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net Proof of concept. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 9

[Bug 19735] New: Move Perl deps definitions into a cpanfile
by bugzilla-daemon＠bugs.koha-community.org 01 Mar '21

01 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19735 Bug ID: 19735 Summary: Move Perl deps definitions into a cpanfile Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: julian.maurice(a)biblibre.com Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org cpanfile is a format for describing CPAN dependencies for Perl applications. It is more concise - thus easier to read and maintain - than C4::Installer::PerlDependencies, and allows to describe requirements more accurately (using version ranges or features for instance). Additionally it can be read by tools such as cpanm or carton for an easy way to install dependencies on non-Debian-based systems. For more information on cpanfile, see http://search.cpan.org/~miyagawa/Module-CPANfile-1.1002/lib/cpanfile.pod -- You are receiving this mail because: You are watching all bug changes.

1 79

[Bug 24997] New: Test to ensure mappings.yaml is in the correct order
by bugzilla-daemon＠bugs.koha-community.org 01 Mar '21

01 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24997 Bug ID: 24997 Summary: Test to ensure mappings.yaml is in the correct order Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org With the script introduced by bug 23204, we have the mappings.yaml that is generated using the data in DB. When the yaml file is modified, we must ensure that the script will generate exactly the same contain. A test needs to be written. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 16547] New: Can't place item level hold directly from search results screen
by bugzilla-daemon＠bugs.koha-community.org 01 Mar '21

01 Mar '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16547 Bug ID: 16547 Summary: Can't place item level hold directly from search results screen Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com If you search for an item that brings up a list of results, checking the check box and clicking the 'Place Hold' button allows you to place a hold -- but after you've selected the patron, you can only place biblio level holds -- the section of the 'Confirm Holds' page which usually shows to allow item level holds is not displayed. This is most easily demonstrated on the bywater demo machine [usernam and password are both koha]. Search for Harry Potter: http://intranet.bywatersolutions.com/cgi-bin/koha/catalogue/search.pl?q=har… Click the check-box for the first search result ( Harry Potter and the Chamber of Secrets [videorecording] ... ) Click the 'Place hold' button, which will take you to the 'Confirm hold' screen (http://intranet.bywatersolutions.com/cgi-bin/koha/reserve/request.pl?biblio…) Enter card number 55. This takes you to a second 'Confirm hold' screen, showing a hold for 'Harry Potter and the Chamber of Secrets' for patron Bilbo Baggins (55)... no item information is viewable. (http://intranet.bywatersolutions.com/cgi-bin/koha/reserve/request.pl?biblio…) By contrast, If I start at http://intranet.bywatersolutions.com/cgi-bin/koha/catalogue/search.pl?q=har…, and click in to the first result page to see the details: http://intranet.bywatersolutions.com/cgi-bin/koha/catalogue/detail.pl?bibli… Then click 'place hold' from the details screen, I am taken to http://intranet.bywatersolutions.com/cgi-bin/koha/reserve/request.pl?biblio… Entering card number 55 at that point takes me to http://intranet.bywatersolutions.com/cgi-bin/koha/reserve/request.pl?biblio… ... but this time item level information *is* available, and an item level hold can be placed. Steps to replicate on your system: 1/ Search for an item with more than one search result 2/ Select an item, click 'Place hold' 3/ Enter a patron card number 4/ Note that item level holds are not available. 5/ Run the search again 6/ Click the title to see the detail page on the same bib. 7/ Enter the same patron card number 8/ Items now show on the page, and an item level hold can be placed. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 33