[Koha] call number sort problem

[Fridolin SOMERS]

Hie,

If you changed the default classification source, it will not affect the 
actual classification source in items, nor the items.cn_sort.

You may use the script touch_items.pl to edit all items and so recompute 
the items.cn_sort.

Best regards,

Le 04/07/2014 18:25, Bruce A Metcalf a écrit :
> Fridolin SOMERS <fridolin.somers at biblibre.com> wrote:
>
>> Look into database the values of items.cn_sort for thoses callnumbers.
>
> The call numbers are fine. It's the sorting sequence I wanted to change.
>
> As in my previous post, I effected this by changing to a different set
> of "Classification Filing Rules". "LCC" did what I wanted, "Generic" did
> not.
>
> Regards,
> / Bruce /
> Bruce A. Metcalf
> Librarian
> The Augustan Society, Inc.
>
>> Le 11/06/2014 05:29, Bruce A Metcalf a écrit :
>>> Fridolin SOMERS <fridolin.somers at biblibre.com> wrote:
>>>> Le 21/03/2014 22:05, Margo Duncan a écrit :
>>>>> We're having some issues with call number sort in our reports and
>>>>> I'm wondering if anyone has any insights.
>>>>>
>>>>> It appears that cn_sort has two different methods of sorting call
>>>>> numbers.  One way is that 0 is added so that a call number of
>>>>> HD30.19 is HD003019.  The other way is with _ so HD30.19 is
>>>>> HD_0030_19. ... So can I adjust the sorting  method, or is there
>>>>> something wrong with my data?
>>>>
>>>> items.cn_sort calculation depends on items.cn_source value, if no
>>>> value, the default classification source is used (defined in syspref
>>>> "DefaultClassificationSource").
>>>
>>> I think I understand this, but I don't understand how to make a call
>>> number like "H B34" sort before one like "HM B34".
>>>
>>> It seems the default is to sort spaces after letters and numbers (which
>>> takes me all the way back to Hollerith sorts!).
>>>
>>> Can this be changed, and if so, how?
>>>
>>> Regards,
>>> / Bruce /
>>> Bruce A. Metcalf
>>> Library Director
>>> The Augustan Society, Inc.
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>> --
>> Fridolin SOMERS
>> Biblibre - Pôles support et système
>> fridolin.somers at biblibre.com
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.somers at biblibre.com