[Bug 32937] New: copyright symbol
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Bug ID: 32937 Summary: copyright symbol Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: koha-bugs@lists.koha-community.org Reporter: ashley.day@rcm.ac.uk QA Contact: testopia@bugs.koha-community.org Our library includes the copyright symbol when cataloguing the publication date (264$c) according to RDA 2.11.1.3. Searching dates as free text (not using the advanced date search) is an issue for us in both the opac and staff interface. Koha is not pulling all possible results because we are using the copyright symbol in the record. I've been advised that Koha treats ©2023 and 2023 as two different words. Of course when adding the copyright symbol to the date to the general search, the correct number of results are shown. We don't want to require a user to know alt codes to produce a copyright symbol, and many students simply are not going to use an advanced date search. Is it possible for KOHA to have the ability to ignore a copyright symbol in 264c for free text searching and return search results based on the date 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=32937 ashley.day@rcm.ac.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |minor CC| |ashley.day@rcm.ac.uk -- 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=32937 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Component|Searching |Searching - Zebra Version|21.11 |master QA Contact|testopia@bugs.koha-communit | |y.org | Summary|copyright symbol |Zebra: Ignore copyright | |symbol when searching --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- For searching you should catalog the normalized date in 008 7-10, this will be used for date range search and might improve things a bit. I will also attach patches that work for ignoring © with Zebra. I am not sure if a change is needed for Elasticsearch (cannot test it currently) and I would not know where to make the changes. If you are using Elastisearch and can confirm this is a problem there too, would you mind filing another bug for the "Searching - Elasticsearch" component? -- 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=32937 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- 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=32937 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 149728 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149728&action=edit Bug 32937: Make Zebra ignore the copyright symbol in searches It's common to catalog the year with the copyright symbol attached to it. This creates some issues with search that we can fix by adding the © to the list of characters Zebra ignores in search. To test: * Search for any existing publication year with ©, example: ©1951 * Verify your record is not found * Add the copyright symbol to a record, verify it's now found with ©, but not without * Apply patch * On ktd: * sudo cp -i /kohadevbox/koha/etc/zebradb/etc/word-phrase-utf.chr /etc/koha/zebradb/etc/word-phrase-utf.chr * sudo koha-zebra --restart kohadev * sudo koha-mysql kohadev * DELETE FROM biblio WHERE biblionumber = 369; * The reindex woudl fail for me with this broken record present. * sudo koha-rebuild-zebra -f kohadev * Repeat searches, the records should be found when searching with and without ©. -- 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=32937 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- 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=32937 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #149728|0 |1 is obsolete| | --- Comment #3 from David Nind <david@davidnind.com> --- Created attachment 149736 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149736&action=edit Bug 32937: Make Zebra ignore the copyright symbol in searches It's common to catalog the year with the copyright symbol attached to it. This creates some issues with search that we can fix by adding the © to the list of characters Zebra ignores in search. To test: * Search for any existing publication year with ©, example: ©1951 * Verify your record is not found * Add the copyright symbol to a record, verify it's now found with ©, but not without * Apply patch * On ktd: * sudo cp -i /kohadevbox/koha/etc/zebradb/etc/word-phrase-utf.chr /etc/koha/zebradb/etc/word-phrase-utf.chr * sudo koha-zebra --restart kohadev * sudo koha-mysql kohadev * DELETE FROM biblio WHERE biblionumber = 369; * The reindex woudl fail for me with this broken record present. * sudo koha-rebuild-zebra -f kohadev * Repeat searches, the records should be found when searching with and without ©. Signed-off-by: David Nind <david@davidnind.com> -- 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=32937 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com --- Comment #4 from David Nind <david@davidnind.com> --- (In reply to Katrin Fischer from comment #1)
I will also attach patches that work for ignoring © with Zebra. I am not sure if a change is needed for Elasticsearch (cannot test it currently) and I would not know where to make the changes. If you are using Elastisearch and can confirm this is a problem there too, would you mind filing another bug for the "Searching - Elasticsearch" component?
I tested with KTD and Elasticsearch and OpenSearch (ktd --es7 up and ktd --os1 up). The record was found with and without the copyright symbol, so I don't think it affects Koha with Elasticsearch or OpenSearch. Note: I couldn't get KTD to start properly using --es6, --es8, and --os2. Testing notes: 1. Edited the BKS framework so that 264$c is visible in the editor. 2. Add a year to 264$c with and without the copyright symbol, as per the test plan. -- 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=32937 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |katrin.fischer@bsz-bw.de |ity.org | -- 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=32937 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #149736|0 |1 is obsolete| | --- Comment #5 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 150404 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150404&action=edit Bug 32937: Make Zebra ignore the copyright symbol in searches It's common to catalog the year with the copyright symbol attached to it. This creates some issues with search that we can fix by adding the © to the list of characters Zebra ignores in search. To test: * Search for any existing publication year with ©, example: ©1951 * Verify your record is not found * Add the copyright symbol to a record, verify it's now found with ©, but not without * Apply patch * On ktd: * sudo cp -i /kohadevbox/koha/etc/zebradb/etc/word-phrase-utf.chr /etc/koha/zebradb/etc/word-phrase-utf.chr * sudo koha-zebra --restart kohadev * sudo koha-mysql kohadev * DELETE FROM biblio WHERE biblionumber = 369; * The reindex woudl fail for me with this broken record present. * sudo koha-rebuild-zebra -f kohadev * Repeat searches, the records should be found when searching with and without ©. Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)| |23.05.00 released in| | Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 --- Comment #6 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Pushed to master for 23.05. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |Pushed to stable Version(s)|23.05.00 |23.05.00,22.11.06 released in| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 --- Comment #7 from Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com> --- Nice work everyone! Pushed to stable for 22.11.x -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com Status|Pushed to stable |Pushed to oldstable Version(s)|23.05.00,22.11.06 |23.05.00,22.11.06,22.05.14 released in| | --- Comment #8 from Lucas Gass <lucas@bywatersolutions.com> --- Backported to 22.05.x for upcoming 22.05.14 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Danyon Sewell <danyonsewell@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |danyonsewell@catalyst.net.n | |z Status|Pushed to oldstable |Pushed to oldoldstable --- Comment #9 from Danyon Sewell <danyonsewell@catalyst.net.nz> --- Not backporting to 21.11.x -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32937 Danyon Sewell <danyonsewell@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Pushed to oldoldstable |RESOLVED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org