[#7458] Turba letter sub page only has sub pages for ascii names
Summary Turba letter sub page only has sub pages for ascii names
Queue Turba
Queue Version 2.3
Type Enhancement
State Accepted
Priority 1. Low
Owners
Requester janne.peltonen@helsinki.fi
Created 2008-10-08 (4256 days ago)
Due
Updated 2011-04-10 (3342 days ago)
Assigned 2008-10-08 (4256 days ago)
Resolved
Milestone
Patch No

Comments
janne.peltonen@helsinki.fi 2008-10-08 10:32:10
(First, sorry if this went into a wrong queue, but I couldn't see a 
queue for Turba...)



If a user has so many contacts that Turba separates them into 
different pages according to the first letter of a name, there is 
trouble with international characters. If I have sorted my contacts 
according to the surname and have a contact with the surname of, say, 
"Äärelä", there are still only sub pages for contacts that begin with 
[A-Z]; there appears no page for contacts that begin with "Ä" (that 
is, A with two dots). I can only find contacts with non-low-ascii 
first letter on the page that contains "All" my contacts.

Jan Schneider <jan@horde.org> 2008-10-08 13:15:50
Well, and how would you want to fix that? It might be easy for Ä, 
though it's already harder than it looks like, to map it to A. But how 
about characters not from latin1 charsets, like cyrillic, chinese, 
japanese, etc.?

janne.peltonen@helsinki.fi 2008-10-08 14:07:33
> Well, and how would you want to fix that? It might be easy for Ä, 
> though it's already harder than it looks like, to map it to A. But 
> how about characters not from latin1 charsets, like cyrillic, 
> chinese, japanese, etc.?



Could you use the collation information of the locale to determine the 
set of initial characters that should be shown? (I'm not completely 
familiar with how locales work in this respect.) A Finn would expect 
to see in the end of the initial letter list the local letters "Å Ä Ö" 
when using his/her own language, and so would a Swede... a Russian 
would like to see the list of cyrillic characters (maybe in addition 
to the latin letters, for Western contacts). I don't know what a 
Japanese or a Chinese would like to see...



A completely different way to attack the problem would be to determine 
the actual initial characters from the actual contacts of the user, 
sort them according to the selected language's (locale's) collation 
rules and only show those initial characters in the list. I think that 
Cyrillic locales, for example, also contain collation rules for latin 
characters.

Jan Schneider <jan@horde.org> 2008-10-08 15:50:50
> A completely different way to attack the problem would be to

> determine the actual initial characters from the actual contacts of

> the user, sort them according to the selected language's (locale's)

> collation rules and only show those initial characters in the list. I

> think that Cyrillic locales, for example, also contain collation

> rules for latin characters.



That would defeat the paging on the server side, i.e. on the SQL or 
LDAP server.

Chuck Hagenbuch <chuck@horde.org> 2008-11-06 02:52:58
I buy this being an enhancement, but we do need to do it somehow.

david@tmv.gov.tw 2008-12-09 22:11:04
Before start this issue,perhaps we can consider a simple  solution   
ref. ticket 6790



janne.peltonen@helsinki.fi 2008-12-11 08:26:33
> Before start this issue,perhaps we can consider a simple  solution

> ref. ticket 6790



Mm. I have some users with more than 1000 contacts, and about 50 users 
with more than 500 contacts. If they were to see all their contacts on 
one page, wouldn't that take quite a while to load?





--Janne



citycat4@ngs.ru 2009-07-16 03:22:20
I have done (partly) this issue, but it is only "quick hack" and 
conatin "destructive" code, which cannot use for any locales, exclude 
ru_RU. Subpages links generation goes in 
turba/templates/list/alphaPager.inc and checking on "current" page 
goes in turba/lib/ListView.php. Patches with current "destructive" 
code attached, may be will usable :-)



To make it universal, I think, we need to know locale and where in 
current locale located letter, which will first subpage link? Locale 
we can take from login screen. So, this is only problem to know which 
in current locale is "start" letter, and which is their code

citycat4@ngs.ru 2009-07-16 03:27:14
Add second patch, because only one patch can be added at one time

je@ktf.rtu.lv 2011-04-09 17:17:39
Unfortunately, this solution does not fit to Latvian, plus, ir removes 
almost all ASCII characters.

je@ktf.rtu.lv 2011-04-10 16:24:29
even if I manage to get Latvian alphabet in alphaPager.inc and it is 
displayed, the links represented by ?, ?, ? etc are not working, 
returning "A"-s page instead.

I looked at database records and found that the info is stored not as 
UTF8 but Latin1 (???) - may be that is one of possible reasons. What 
surprises me is that search is working OK.

je@ktf.rtu.lv 2011-04-10 16:26:49
may be it is worth to cinsider raising of the importance from low to 
medium or even High as Horde seems to be used quite a lot in 
non-English speaking countries.

Jan Schneider <jan@horde.org> 2011-04-10 17:14:52
There still is no viable solution to this problem, so it doesn't make 
sense to raise the priority.