Getting Public Contacts to Apple Address Book and Treo
Problem: User has a Treo 700p and needs a local copy of the Global Address List (”Public Contacts” in Kerio) on his MacBook to sync with.
Fix:
Unfortunately requires Windows with Outlook and Thunderbird. Haven’t tried it with Entourage.
1. Install Kerio Outlook Connector and open Outlook.
2. Export a CSV (Windows).
3. Import the CSV into Mozilla Thunderbird.
4. Export as LDIF.
5. Import LDIF into Apple Address Book.
6. HotSync the Treo.
Notes:
I took the basic idea from Paul Thurrott after having similar CSV import problems. I also tried Thunderbird for Mac, but the field mappings were off and about half were missing. Also tried CSV2LDIF, but that’s only useful if you speak LDIF-ese.
I also tried VersaMail’s sync feature to directly sync with Kerio Mailserver. The rub there is that even though Kerio claims you can view the Global Address List (GAL) from VersaMail, it’s only email address lookup. No numbers. On a smartphone. Useless.
VersaMail will sync the phone’s contacts with your personal contacts on the server, but there’s no way to sync the public contacts (or calendar) with your phone. Furthermore, the “mini” version of Kerio Webmail that shows up when you try to log in via Treo is also email only; no contacts or calendar.