Import and Export of Contacts: Difference between revisions
(Adding Template:Article_Footer, and Categories) |
No edit summary |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
It is reported that many csv formatted files from other applications will "just work": | {{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]) | "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. | 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. | |||
---- | ---- | ||
Line 10: | Line 20: | ||
<nowiki> | <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> | </nowiki> | ||
Line 18: | Line 28: | ||
<nowiki> | <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> | </nowiki> | ||
Latest revision as of 23:41, 11 July 2015
Import and export 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. 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