[Koha] Inventory lists incorrectly sorted

[Sebastian Hierl]

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 <dcook at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>