Discussion:
[Koha] Koha - Problem sorting items by call number and cn_sort
Linda Culberson
2011-04-01 19:08:47 UTC
Permalink
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 at 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
Stefano Bargioni
2011-04-04 08:11:28 UTC
Permalink
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
Post by Linda Culberson
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 at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Galen Charlton
2011-04-05 14:51:17 UTC
Permalink
Hi,
Post by Stefano Bargioni
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 at esilibrary.com
direct: +1 352-215-7548
skype: gmcharlt
web: http://www.esilibrary.com/
Jared Camins-Esakov
2011-04-05 14:53:31 UTC
Permalink
The script would work if you copied it into a 3.2 installation, yes. I have
used it on 3.2.5.

Regards,
Jared
Post by Stefano Bargioni
Hi,
Post by Stefano Bargioni
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 at esilibrary.com
direct: +1 352-215-7548
skype: gmcharlt
web: http://www.esilibrary.com/
_______________________________________________
Koha mailing list http://koha-community.org
Koha at 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 at cpbibliography.com
(web) http://www.cpbibliography.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110405/7d046126/attachment.htm
Galen Charlton
2011-04-05 14:58:43 UTC
Permalink
Hi,
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 at esilibrary.com
direct: +1 352-215-7548
skype: gmcharlt
web: http://www.esilibrary.com/

Loading...