[Bug 21447] New: Inventory lists incorrectly sorted
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21447 Bug ID: 21447 Summary: Inventory lists incorrectly sorted Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: dcook@prosentient.com.au QA Contact: testopia@bugs.koha-community.org In the real world, I've found the cn_sort field does not always have correct values, and the same itemcallnumber field may have different cn_sort values. My theory is that the method for generating cn_sort changed at some point, and that has created inconsistencies in the creation of cn_sort value, especially in Koha databases that have existed for a long period of time. -- I received reports that the lists generated by /cgi-bin/koha/tools/inventory.pl and shown on screen weren't sorted by call number. That led me to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19021 and that seemed to solve the problem as it resorted the data table by the call number. However, when using the "Export to CSV file" option, the data was still not sorted correctly, and thus was incompatible with the data table shown on screen, which defeats the purpose of doing an inventory without a scanned barcode file. -- This can be solved by running touch_all_items.pl. However, this is not a systematic solution. Perhaps we should do a database revision that runs ModItem for all items. This seems problematic for databases with large numbers of items, but it seems a good idea to provide a systematic solution instead of requiring people to run touch_all_items.pl if they notice the problem. -- 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=21447 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=19021 -- 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=21447 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Maybe the name of this bug should then be "Add a script to update cn_sort"? This is a data problem and not a problem of the sorting itself. touch_items is rather costly/time consuming, we recently fixed it using a little script creating SQL statements for the updates. -- 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=21447 --- Comment #2 from David Cook <dcook@prosentient.com.au> --- (In reply to Katrin Fischer from comment #1)
Maybe the name of this bug should then be "Add a script to update cn_sort"? This is a data problem and not a problem of the sorting itself.
Yeah that could be a good idea. I guess I'm not sure at this point why the cn_sort values became inconsistent, so looking for ideas. Although based on what you said on IRC, I'm thinking maybe it's an issue with an external dependency? If it is an external dependency, maybe I can trace in what version it changed and then base the update around that?
touch_items is rather costly/time consuming, we recently fixed it using a little script creating SQL statements for the updates.
You mean you created a little script for updating cn_sort? I hadn't thought of doing the update directly like that. That's a good idea. I don't suppose we use the cn_sort value in any indexes? -- 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=21447 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think we have foregone the Zebra updates - but we will update them soon anyway which will include a full reindex. Another thing to check: Is cn_source set correctly in all items? It's easy to have some bad configuration there. -- 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=21447 Michal Denar <black23@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |black23@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21447 --- Comment #4 from David Cook <dcook@prosentient.com.au> --- (In reply to Katrin Fischer from comment #3)
Another thing to check: Is cn_source set correctly in all items? It's easy to have some bad configuration there.
I was thinking that as well but in my case the items seemed to all have cn_source set correctly. -- 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=21447 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WONTFIX --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I feel if we agree this is a data issue, the bug could probably be closed? I filed bug 22263 for adding a maintenance script. -- 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=21447 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=22263 -- 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=21447 --- Comment #6 from David Cook <dcook@prosentient.com.au> --- (In reply to Katrin Fischer from comment #5)
I feel if we agree this is a data issue, the bug could probably be closed? I filed bug 22263 for adding a maintenance script.
Sounds good to me. -- 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