Import and Export of Contacts

It is reported that many csv formatted files from other applications will "just work":

"We've successfully imported Thunderbird, Yahoo, Google, and various forms of Outlook CSV files." (from a developer posting)

Following are examples of what the .csv looks like on export from zimbra. The export/import functions are located under Preferences->Contacts.


The first line that defines each column:

"Birthday","Business City","Business Country","Business Fax","Business Phone","Business Phone 2","Business Postal Code","Business State","Business Street","Business Street 2","Business Street 3","Callback","Car Phone","Company","Company Main Phone","Department","E-mail Address","E-mail Display Name","E-mail Type","E-mail 2 Address","E-mail 2 Display Name","E-mail 2 Type","E-mail 3 Address","E-mail 3 Display Name","E-mail 3 Type","First Name","Home City","Home Country","Home Fax","Home Phone","Home Phone 2","Home Postal Code","Home State","Home Street","Home Street 2","Home Street 3","Initials","Job Title","Last Name","Middle Name","Mobile Phone","Notes","Other City","Other Country","Other Fax","Other Phone","Other Postal Code","Other State","Other Street","Other Street 2","Other Street 3","Pager","Suffix","Web Page"


An example entry:

"","New York","US","212-555-4321","212-555-1212","212-555-1213","10012","NY","1234 Main WOrk","","","","","TestCo, Inc.","212-555-1111","","bob@test.com","","","bobhome@home.com","","","bob@elsewhere.com","","","Bob","Testville","US","516-555-1235","516-555-1234","n/a","10011","NY","234 Home Blvd #A-3","","","","Head Tester","Tester","J.","917-555-1234","Bob is our test entry. Here's some notes. Blah blah.","other city","other country","222-222-2223","222-222-2222","12345","other state","other street","","","","","http://home.bobtester.com/"


So if you're migrating from elsewhere (either a mail program or another web-based collaboration suite), you may be able to fetch your existing entries if you can fit them into the above format.

Perhaps we can add some examples?

Here is a forum posting that includes a python script to convert either Squirrelmail or Thunderbird csv files into something that ZImbra can directly import.

Here's a mysql query that will dump a phpgroupware address book into a .csv that zimbra can read:

select bday,adr_one_locality,adr_one_countryname,tel_fax,tel_work,tel_work,adr_one_postalcode,adr_one_region,adr_one_street,NULL,NULL,NULL,tel_car,org_name,tel_work,org_unit,email,email,email_type,email_home,email_home,email_home_type,NULL,NULL,NULL,n_given,adr_two_locality,adr_two_countryname,NULL,tel_home,NULL,adr_two_postalcode,adr_two_region,adr_two_street,NULL,NULL,NULL,title,n_family,n_middle,tel_cell,note,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,tel_pager,n_suffix,url into outfile '/tmp/phpgw.csv' fields terminated by ',' optionally enclosed by '"' from phpgw_addressbook;


Using a php script to convert squirrelmail .abook files to zimbra cvs

Jump to: navigation, search