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

[Bug 18441] New: add primary, foreign keys to statistics table
by bugzilla-daemon＠bugs.koha-community.org 11 Sep '23

11 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18441 Bug ID: 18441 Summary: add primary, foreign keys to statistics table 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: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com I think that the primary key would be useful for Bug 9717 'localuse recorded for holds/transfers' -- we could record 'localuse' when the item is checked in, and then update the statistics record to 'holdcaptured' or 'transferred' if the check-in captures a hold or completes a branch transfer. The statistics table is *very* slow to join borrowers or items against, because borrowernumber and itemnumber are not indexed. It also caused a 12 hour run of updatedatabase on site that had a large statistics table, when running the upgrade that fixed bug 14598 (itemtype is not set on statistics by C4::Circulation::AddReturn). This occurred on the 16.06.00.039 update. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 18265] New: Followup to Buuug 17196. deletedbiblio_metadata is not used. biblioitemnumber was forgot.
by bugzilla-daemon＠bugs.koha-community.org 11 Sep '23

11 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18265 Bug ID: 18265 Summary: Followup to Buuug 17196. deletedbiblio_metadata is not used. biblioitemnumber was forgot. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: olli-antti.kivilahti(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Exhibit 1: The MARCXML is lost when the biblio is deleted because the values in biblio_metadata-table from biblioitems-table are never moved to deletedbiblio_metadata-table. Previously the marcxml was preserved in the oldbiblioitems-table This is a challenge for gathering statistics For example item has been ordered, received, and removed from collection during the statistics period Information in marcxml is needed to accurately categorize the item Exhibit 2: [15:22:38] <kivilahtio> also. In Koha there once was a great idea that one biblio-entry can have multiple biblioitems [15:22:45] <kivilahtio> and the marcxml was tied to the biblioitems-table [15:23:11] <kivilahtio> this is a nice idea, but nobdy really cared for it and now biblionumber and biblioitemnumber are used interchangeably [15:23:22] <kivilahtio> except when they get out of sync during a data migration [15:23:41] <kivilahtio> then things start to work really interestingly [15:23:47] <kivilahtio> but the point is [15:23:57] <kivilahtio> biblio_metadata has a biblionumber-column [15:24:15] <kivilahtio> shouldn't it have a biblioitemnumber-column, just for old time's sake? In the biblioitems-table we had marcxml. primary keyed with biblioitemnumber. Now the marcxml is moved to biblio_metadata and the foreign key reference was simplified to biblionumber. This makes the existing FRBR-bug worse. -- You are receiving this mail because: You are watching all bug changes.

1 27

[Bug 16327] New: Running build_oai_sets.pl with embed items option should consider every item in a biblio
by bugzilla-daemon＠bugs.koha-community.org 11 Sep '23

11 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16327 Bug ID: 16327 Summary: Running build_oai_sets.pl with embed items option should consider every item in a biblio Change sponsored?: --- Product: Koha Version: 3.22 Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: pjamorim91(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org After configuring a mapping for an oai set which uses item fields, the build_oai_sets.pl must be run with the -i flag, to embed item data in a biblio. The bug is that it's only considering the first item (by itemnumber) of the biblio, not all the items in it. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 18483] New: Customised help: Enhance staff client with news based, easily editable help system
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18483 Bug ID: 18483 Summary: Customised help: Enhance staff client with news based, easily editable help system Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Koha's staff client has a file based help system with an edit function for customising. However, the edited files have to be saved and restored with each release. Otherwise they are overwritten. As an enhancement or alternative, the existing news system can be used to implement a complementing help system. Similar to the news, the text can be created for all branches or for individual branches. Help is context sensitive (based on the existing help system), and it can be created / edited directly from the help page (based on a user permission). The display can be managed with a system preference (Bug 18472: Add system preference CustomOnlineHelpStaff to hide / select custom online help system). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 41

[Bug 18436] New: Add home library to the SIP2 patron info response 64
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18436 Bug ID: 18436 Summary: Add home library to the SIP2 patron info response 64 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: george(a)shoutbomb.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Koha's SIP2 server should provide additional patron related info, in this case the patron's home library. This will be a new segment and should be the key not the name. The following is an example from another ILS SIP2 response with the segment AQ providing the home library info. SIP2:response:: 64 00020170412 183400000000000001000000000000AOzzz|AA21391999999999|AEWALKER JONNY|AQpcl|BZ0050|CA0020|CB0250|BLY|CQY|BHUSD|CC10.|BD12655 S KOHA AVE, HELLO, AZ, 99999|BF111-222-3333|DJWALKER MOLLY|PB19950808|PCres|PE20190412 235900|PS20190412 235900|ZYres|AY2AZB936 Thanks... George -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 18406] New: Linking items
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18406 Bug ID: 18406 Summary: Linking items Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: p.imperatori(a)aarome.org QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Created attachment 61990 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=61990&action=ed… Host plus secondary records Hi, i don't know if this issue has been treated previously (doesn't look like). When a record has an item linked to an host item, both in Staff mode and in OPAC is visible in the item to which record is linked to, but this is not true the other way around, in the "mother" record you don't see in the items if there are records linked to that specific item(s)(The only option is the "show analytics" feature). I think it woold be helpfull to have this. Thanks Paolo Imperatori -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 18386] New: Renew message in Default messaging preferences
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18386 Bug ID: 18386 Summary: Renew message in Default messaging preferences Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: vimal0212(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com When renew a book user would like to get an SMS notification which contains when is the next due date. In default messaging preferences no option for the message to send after renewal. It's nice messaging preference for Renew in Administration > Patron categories > Default messaging preferences -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 18371] New: XSLT transformation fails if UNIMARC 100$a is hidden
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18371 Bug ID: 18371 Summary: XSLT transformation fails if UNIMARC 100$a is hidden Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: synapse.ova(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org In UNIMARC XSLT trasformation on page opac-detail.pl fails with software error Unsupported UNIMARC character encoding [] for XML output for UNIMARC; 100$a -> at /usr/share/perl5/MARC/File/XML.pm line 568. Error occurs if subfield 100$a is made invisible in OPAC. It appears, that after filtering (rows 92-100), record is passed to XSLT processing (rows 152-163), and it already lacks field 100$a (it was filtered before). SetUTF8Flag (row 147) does not add filtered 100$a. So right now turning 100$a OPAC visibility off leads to error when user accesses opac-detail.pl. There is no problems with opac-MARCdetail.pl and opac-ISBDdetail.pl — subfield is hidden correctly. Quick fix for those, who have this problem is to make 100$a fully visible. -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 18348] New: SHOW_BCODE should be a column of the borrowers table
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18348 Bug ID: 18348 Summary: SHOW_BCODE should be a column of the borrowers table Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org The SHOW_BCODE is a hidden feature, not translatable and does not exist for all languages. It sounds like it should be a column of the borrowers table -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 18345] New: Add a more ES based query builder
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '23

10 Sep '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18345 Bug ID: 18345 Summary: Add a more ES based query builder 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 Currently we user a 'query_string' type of query for all ES searches. ES provides a more robust query interface with boolean must/shuld/must_not options. This patchset will pull code from bug 14567 to allow for building queries on this interface -- You are receiving this mail because: You are watching all bug changes.

1 9