Import and Export of Contacts

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Import and export Contacts

   KB 1475        Last updated on 2015-07-11  




0.00
(0 votes)

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. Technical details:

  • Separator: ,
  • Enclosure: "
  • Newline separator: "\n" (Unix-Standard)
  • Charset: UTF-8.

The first line that defines each column:

"Extra","anniversary","assistantPhone","birthday","callbackPhone","carPhone","company","companyPhone","department","email","fileAs","firstName","homeCity","homeCountry","homeFax","homePhone","homePostalCode","homeState","homeStreet","homeURL","imAddress1","imAddress2","imAddress3","imAddress4","imAddress5","jobTitle","lastName","maidenName","middleName","mobilePhone","namePrefix","nameSuffix","nickname","notes","otherCity","otherCountry","otherFax","otherPhone","otherPostalCode","otherStreet","pager","workCity","workCountry","workFax","workPhone","workPostalCode","workState","workStreet"


An example entry:

"a","2011-01-01","a","2011-01-01","a","a","a","a","a","a","2","a","a","a","a","a","a","a","a","other://a","local://a","yahoo://a","aol://a","msn://a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a","a"


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

Verified Against: unknown Date Created: 5/1/2006
Article ID: https://wiki.zimbra.com/index.php?title=Import_and_Export_of_Contacts Date Modified: 2015-07-11



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »

Jump to: navigation, search