View source for Import and Export of Contacts

{{BC|Community Sandbox}}
__FORCETOC__
<div class="col-md-12 ibox-content">
=Import and export Contacts=
{{KB|{{Unsupported}}|{{ZCS 7.0}}|{{ZCS 6.0}}|}}
{{Archive}}{{WIP}}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 [http://www.zimbra.com/forums/showthread.php?t=16&page=4&pp=10&highlight=csv+import 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:

<nowiki>
"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"
</nowiki>

----

An example entry:

<nowiki>
"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"
</nowiki>

----

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 [http://www.zimbra.com/forums/showpost.php?p=6988&postcount=32 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:

<nowiki>
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;
</nowiki>


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

{{Article_Footer|unknown|5/1/2006}}

[[Category:Migration]]
[[Category:MySQL]]