Koha - Problem sorting items by call number and cn_sort
The items.cn_sort field seems to be generated automatically using the item.itemcallnumber field normalized(maybe?) by the cn_sort field. We are having trouble getting serials to sort properly, as it seems to be using an ascii sort order. Is there a way to get around this? Thanks in advance. -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
You may consider alter the C4/ClassSortRoutine/Generic.pm routine -if your sysprefs use it. The best way would be to duplicate Generic.pm to obtain your own routine, and set the new one as the default cn_sorter, or apply it to your serials. Anyway, if I'm not wrong, Koha doesn't have an utility to rebuild cn_sort. I wrote a simple rebuild_cnsort utility, very slow... Let me know if you need more help. Stefano On Apr 1, 2011, at 21:08 , Linda Culberson wrote:
The items.cn_sort field seems to be generated automatically using the item.itemcallnumber field normalized(maybe?) by the cn_sort field. We are having trouble getting serials to sort properly, as it seems to be using an ascii sort order. Is there a way to get around this?
Thanks in advance. -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi, On Apr 4, 2011, at 4:11 AM, Stefano Bargioni wrote:
Anyway, if I'm not wrong, Koha doesn't have an utility to rebuild cn_sort. I wrote a simple rebuild_cnsort utility, very slow...
The command line script misc/maintenance/touch_all_items.pl will do this. This script is available in master and will be released in 3.4, but at first glance it looks like it should work for 3.2.x as well. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
The script would work if you copied it into a 3.2 installation, yes. I have used it on 3.2.5. Regards, Jared On Tue, Apr 5, 2011 at 10:51 AM, Galen Charlton <gmc@esilibrary.com> wrote:
Hi,
On Apr 4, 2011, at 4:11 AM, Stefano Bargioni wrote:
Anyway, if I'm not wrong, Koha doesn't have an utility to rebuild cn_sort. I wrote a simple rebuild_cnsort utility, very slow...
The command line script misc/maintenance/touch_all_items.pl will do this. This script is available in master and will be released in 3.4, but at first glance it looks like it should work for 3.2.x as well.
Regards,
Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jared Camins-Esakov Freelance bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
Hi, On Apr 5, 2011, at 10:53 AM, Jared Camins-Esakov wrote:
The script would work if you copied it into a 3.2 installation, yes. I have used it on 3.2.5.
I figured as much, thanks for confirming. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
participants (4)
-
Galen Charlton -
Jared Camins-Esakov -
Linda Culberson -
Stefano Bargioni