[horde] Sort names in shared address books

Dominik Erdmann horde_mailing at der-domi.de
Fri Oct 11 19:45:30 UTC 2013


Am 11.10.2013 11:10, 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?
>
> No. But what does IMP have to do with this now? Until now you only
> talked about different users seeing different results.

I noticed that the settings I done are ignored. At least it looks like 
that. What do you think? Maybe it is a turba issue or something else. I 
don't know the architecture. You are the specialist.

Best regards,
Dominik


More information about the horde mailing list