[Koha] Inventory lists incorrectly sorted

Discussion:

David Cook

2018-09-28 06:33:09 UTC

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
***@lists.katipo.co.nz
htt

Sebastian Hierl

2018-09-28 09:10:41 UTC

Permalink

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

Post by David Cook
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists

Katrin Fischer

2018-09-29 09:37:50 UTC

Permalink

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

Post by Sebastian Hierl
Thank you for raising this issue, David.
We sort the reports we generate from Koha in Excel with the following
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

_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lis

Sebastian Hierl

2018-10-01 10:12:04 UTC

Permalink

Hi, Katrin:

Thank you! Yes, this helps a lot and we have been using the items.cn_sort
column in some of our reports and should include them in all or where we
can, as for some reports we are running into problems and the '
items.cn_sort' is not recognized. I will have to review the select reports
where this is the case to see whether we can fix or rewrite the query so
that the function works.

Thanks again and all best,
-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

Post by Katrin Fischer
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

formula

Post by Sebastian Hierl
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

that

Post by Sebastian Hierl

Post by David Cook
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katip

David Cook

2018-10-02 00:28:36 UTC

Permalink

I think Koha should be taking care of normalizing the call number into something like “AL_333_910000000000000_WHY_1986” (admittedly a Dewey-ish example) for sorting purposes. If Koha isn’t sorting the call number correctly, I think it’s worth raising an issue.

It seems to me that the on-screen inventory list and the CSV/spreadsheet export inventory list should be identical in how they’re sorted. That way you can print off a shelf list, do your inventory, and then scroll through your screen marking items as seen in the order that they were seen for real.

David Cook

Systems Librarian

Prosentient Systems

72/330 Wattle St

Ultimo, NSW 2007

Australia

Office: 02 9212 0899

Direct: 02 8005 0595

From: Sebastian Hierl [mailto:***@aarome.org]
Sent: Friday, 28 September 2018 7:11 PM
To: ***@prosentient.com.au
Cc: Koha Devel <koha-***@lists.koha-community.org>; koha <***@lists.katipo.co.nz>
Subject: Re: [Koha] Inventory lists incorrectly sorted

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 <***@prosentient.com.au <mailto:***@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 <http://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
***@lists.katipo.co.nz <mailto:***@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https:/