Hi Sebastian,
if you are using LOC callnumbers you could try to include the
items.cn_sort column in your reports and try sorting on that. Koha
generates cn_sort as a sortable form of the callnumber for LOC and DDC
if the $2 in the item is set to the correct classification.
Hope this helps,
Katrin
On 28.09.2018 11:10, Sebastian Hierl wrote:
Thank you for raising this issue, David.
We sort the reports we generate from Koha in Excel with the following
formula by Lee Ann Nolan and Jameson Conley:
https://scholarsphere.psu.edu/concern/generic_works/qv33rw719
The formula is a big help, but it doesn't work for call numbers starting
three letters, such as in the K class
<https://www.loc.gov/aba/publications/FreeLCC/freelcc.html>, where there
are numerous call numbers starting with KJA, KKH, KZA, etc.
I would love to hear whether anyone has devised a better script or formula
to sort LC call numbers in either LibreOffice / OpenOffice or Excel.
Thank you,
Sebastian
--
Sebastian Hierl, Ph.D.
Drue Heinz Librarian, Arthur & Janet C. Ross Library
American Academy in Rome
Via Angelo Masina 5
00153 Rome
Italy
T: +39 06 5846 417
F: +39 06 5810 788
On Fri, Sep 28, 2018 at 8:33 AM David Cook <dc...@prosentient.com.au> wrote:
Hi all,
Has anyone had a problem where the lists generated by the inventory tool
don't seem to be sorted correctly?
I received reports of this and during my investigation I found
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19021 but that
didn't seem to solve the root problem, which actually appears to be with
the
item data stored in the database - rather than Koha code per se. I've
opened
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21447 to look
into
this.
I've solved it in my case using touch_all_items.pl, but it might not be
feasible for everyone to run this. Keen to hear ideas about how people
think
we should resolve this issue for all people.
David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St
Ultimo, NSW 2007
Australia
Office: 02 9212 0899
Direct: 02 8005 0595
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
