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



Latest revision as of 23:41, 11 July 2015

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