[Koha-bugs] [Bug 21447] New: Inventory lists incorrectly sorted
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Sep 28 08:29:31 CEST 2018
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 at lists.koha-community.org
Reporter: dcook at prosentient.com.au
QA Contact: testopia at 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.
More information about the Koha-bugs
mailing list