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

[Bug 18129] New: Adding staging user to staged batches, for better filtering
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18129 Bug ID: 18129 Summary: Adding staging user to staged batches, for better filtering Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: stefan.berndtsson(a)ub.gu.se QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl When multiple users use "Stage MARC for import" as a daily cataloging tool, it would be helpful if the uploading user could be stored with the staged batch. This would make it possible (perhaps via a SysPref) to filter the staged list to that particular user. We have tools that create the upload files based on today's date, so distinguishing this based on file name is not really doable. Having to add a comment each time also isn't too practical, and you can't filter on either of those anyway. Also, showing imported batches in the list can be a bit overwhelming after a while, and deletion of them are multiple steps, which makes the cataloging flow longer. What I propose is the following enhancement: 1. Add currently logged in username as a field in the import_batches table. 2. When uploading, write that username in that field. 3. Have a SysPref that can be set to filter the staged list (both the tool and the acquisition selector from staged) by that same username. 4. Have a SysPref that can be set to filter so that "Imported" and "Cleaned" are hidden. 5. For the batch list, have the option of "Show all batches" when the filters in 3 and 4 are active. -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 18176] New: aqbookesellers.listprice and aqbookesellers.invoiceprice need to be renamed for currencies
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18176 Bug ID: 18176 Summary: aqbookesellers.listprice and aqbookesellers.invoiceprice need to be renamed for currencies 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: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The columns aqbookesellers.listprice and aqbookesellers.invoiceprice have FK constraints on the 'currencies' table, and they are actually documented as currencies. So, they need to be renamed. listprice is used the rigth way in aqorders. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 18188] New: Working title
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18188 Bug ID: 18188 Summary: Working title Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing 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 6

[Bug 18210] New: Allow API to update/ merge bibliographic records & not just replace
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18210 Bug ID: 18210 Summary: Allow API to update/ merge bibliographic records & not just replace Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: bibliwho(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl The Koha API allows for existing records to be replaced/ overlaid wholesale with data provided. It would be great to have the option of updating records as well, i.e., changing only data/ fields that are included in a source file while preserving all data/ fields not in the source file. This would require a means of identifying fields that are protected from overlay on import. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 17230] New: borrowers table should be better normalized
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17230 Bug ID: 17230 Summary: borrowers table should be better normalized Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org I've always been bothered by the fact that we have 3 separate sets of contact information in the borrowers table: streetnumber streettype address address2 city state zipcode country email phone B_streetnumber B_streettype B_address B_address2 B_city B_state B_zipcode B_country B_email B_phone altstreetnumber altstreettype altaddress altaddress2 altcity altstate altzipcode altcountry altemail altphone These should be moved to a contacts table, which contains a 'contact_type' field corresponding to 'primary', 'B_' or 'alt' (although these also desperately need to be renamed), as well as a link to the borrower and a timestamp. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 18218] New: Contact information (borrower, branch, acquisitions), should be centralized into a single table
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18218 Bug ID: 18218 Summary: Contact information (borrower, branch, acquisitions), should be centralized into a single table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The borrowers table contains three sets of contact information -- primary (streetnumber, streettype, address, etc... no prefix), secondary (B_streetnumber, B_streettype, etc) and alternate (altcontactaddress1, altcontactaddress2, etc.)... there are also the emailpro and phonepro fields. These should be moved into a 'contacts' table. I think that it would be reasonable to re-factor the aqcontacts table so that generic contact information was in the contacts table, as well as pulling branch contact information into contacts as well. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 18261] New: Select item type not available when staff overrides hold policy
by bugzilla-daemon＠bugs.koha-community.org 12 Jan '20

12 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18261 Bug ID: 18261 Summary: Select item type not available when staff overrides hold policy Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: andreas.hedstrom.mace(a)sub.su.se QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com With AllowHoldItemTypeSelection set to Allow, it is possible to select an item type to fill the hold. But when staff overrides a circulation policy, the ”Request specific item type” dropdown on the place hold page only lists ”Any item type”, even if there are several items with various item types attached to the bibliographic record. We believe this to be a bug. To reproduce: Set AllowHoldItemTypeSelection to Allow. Set AllowHoldPolicyOverride to Allow. Create/choose a circulation rule for a patron category of your choice, allow holds and set On shelf holds allowed to ”If all unavailable”. Find or create a bibliographic record with two or more items, with two or more item types. Check out one item. Place a hold using the patron category for which you specified the circulation rule above. This should result in a staff override as this behaviour should not be allowed by the circulation policy. Try to request a specific item type, and confirm that choosing an item type is not available, the only option being ”Any item type”. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 18454] New: Holds to pull timestamp
by bugzilla-daemon＠bugs.koha-community.org 11 Jan '20

11 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18454 Bug ID: 18454 Summary: Holds to pull timestamp 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: black23(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Add timestamp if hold to pull is set. We can use it for sorting by time. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 18446] New: Test to ensure a system preference in .pref file also exists in sysprefs.sql
by bugzilla-daemon＠bugs.koha-community.org 11 Jan '20

11 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18446 Bug ID: 18446 Summary: Test to ensure a system preference in .pref file also exists in sysprefs.sql 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: lari.taskula(a)jns.fi QA Contact: gmcharlt(a)gmail.com Extend t/db_dependent/check_sysprefs.t to read preferences from .pref files in order to check that they are also defined in installer/data/mysql/sysprefs.sql. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 18513] New: Add test to detect errors in sysprefs.sql
by bugzilla-daemon＠bugs.koha-community.org 11 Jan '20

11 Jan '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18513 Bug ID: 18513 Summary: Add test to detect errors in sysprefs.sql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt(a)gmail.com Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org I would be nice to have a test to detect errors in sysprefs.sql (and maybe more like userflags.sql, userpermissions.sql...) -- You are receiving this mail because: You are watching all bug changes.

1 2