[Bug 43457] New: Make sure authorised_value only includes allowed characters
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 Bug ID: 43457 Summary: Make sure authorised_value only includes allowed characters Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: System Administration Assignee: koha-bugs@lists.koha-community.org Reporter: bibliothek@th-wildau.de QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Target Milestone: --- The manual says 'Authorized value is limited to 80 characters and cannot have spaces or special characters other than underscores and hyphens in it.' Source: https://koha-community.org/manual/24.11/en/html/administration.html#adding-n... Unfortunately there are several AVs in the database already which have spaces under the categories RDACARRIER and RDACONTENT: There should be a validation before adding new AVs. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 Jan Kissig <bibliothek@th-wildau.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=38196 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- (In reply to Jan Kissig from comment #0)
The manual says 'Authorized value is limited to 80 characters and cannot have spaces or special characters other than underscores and hyphens in it.'
Is the manual correct? Neither authorized values or item types enforce that validation, although the patron categories entry form does. It makes logical sense to be consistent but if it isn't causing bugs elsewhere it might better to leave it alone. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 --- Comment #2 from Owen Leonard <oleonard@myacpl.org> --- Oh you're referring to this issue raised on Bug 38196
Are the TICKET_STATUS AVs named like 'Option 1' or 'Option1'. I just found that having a white space in an AV the filters don't work.
-- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 --- Comment #3 from David Nind <david@davidnind.com> --- I'm sure the manual was correct at some stage 8-). But, yes in this case I did "discover" when testing Bug 38196 that: - having a space in the authorized value caused issues - there was no validation of the value entered in the field to make sure it met the rules The length of authorized value is 80, as per the database configuration: +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | category | varchar(32) | NO | MUL | | | | authorised_value | varchar(80) | NO | MUL | | | | lib | varchar(200) | YES | MUL | NULL | | | lib_opac | varchar(200) | YES | | NULL | | | imageurl | varchar(200) | YES | | NULL | | +------------------+--------------+------+-----+---------+----------------+ -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think it would probably need to be optional, like the "numerical" checkbox. I also think the manual is not correct there or "too strict". There are cases where hyphens also are an issue (think collections e-book and book). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43457 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- One example where this would cause problems is using AV in cataloguing. Koha does replace the code with the description for display, but there are some cases where you want the bibliographic record to not have a code but a description on export and that could well contain spaces. Think some standard link texts for 856$y. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org