[horde] Sort names in shared address books

Dominik Erdmann horde_mailing at der-domi.de
Thu Oct 10 19:55:45 UTC 2013


Am 09.10.2013 09:18, schrieb Jan Schneider:

>>>> UserA owns an address book. UserB use the shared address book from
>>>> UserA. I
>>>> added a new address book for UserB (filled with the same contacts) and
>>>> shares it with UserA.
>>>>
>>>> The sort names option is ignored for both address books for UserB.
>>>> The names
>>>> always sorted by "lastname, firstname". (The view names option is
>>>> correctly
>>>> interpreted.)
>>>> But for UserA works the sort option for both address books. For the
>>>> own ones
>>>> and for the shared ones.
>>>
>>> Sounds like UserB simply doesn't have the preference set (correctly).
>>
>> Okay. Where can I set the preference? Under "Preferences => Address
>> Book => Name Format" I set for both users "firstname lastname" for
>> viewing and sorting. Is there any possibility to check the correctness
>> of the setting in the data base?
>
> If you submit the preference form on that page, any incorrect values
> should be overridden in the preference backend. Though you can compare
> those users' values directly in the database of course.

The SQL statement

SELECT `pref_uid`, CAST( `pref_value` AS CHAR ) AS `name_sort`
FROM `horde_prefs`
WHERE ( `pref_uid` = "UserA" OR `pref_uid` = "UserB" )
AND `pref_scope` = "turba"
AND `pref_name` = "name_sort"

returns

pref_uid   name_sort
---------------------
UserA      first_last
UserB      first_last


I made a new Horde installation on an other server. I exported UserA's 
address book and imported it to UserA's account (IMAP authentication) on 
the new server and made the same settings for name_sort. But the 
contacts are also sorted by "lastname, firstname" and displayed as 
"firstname lastname" in the address book window of composing a new message.
Could it be that IMP does ignore the preference?


Best regards,
Dominik


More information about the horde mailing list