Import Contacts via CSV into Roundcube   January 9th, 2017

There is documentation about how to import Contacts into the Roundcube address books from CSV files: https://docs.roundcube.net/doc/help/1.1/en_US/addressbook/importexport.html

Unfortunately, that documentation does not come with a description of the columns supported.

I had a look at the source:

From that you can see, that the import from GMail and from Outlook is supported via CSV files.

So I tried an export with GMail (see https://support.google.com/mail/answer/1069522?hl=de, over the old interface of the GMail address book you can export via CSV).

Here is a sample CSV file, that should work:

First Name,Middle Name,Last Name,Title,Suffix,Initials,Web Page,Gender,Birthday,Anniversary,Location,Language,Internet Free Busy,Notes,E-mail Address,E-mail 2 Address,E-mail 3 Address,Primary Phone,Home Phone,Home Phone 2,Mobile Phone,Pager,Home Fax,Home Address,Home Street,Home Street 2,Home Street 3,Home Address PO Box,Home City,Home State,Home Postal Code,Home Country,Spouse,Children,Manager's Name,Assistant's Name,Referred By,Company Main Phone,Business Phone,Business Phone 2,Business Fax,Assistant's Phone,Company,Job Title,Department,Office Location,Organizational ID Number,Profession,Account,Business Address,Business Street,Business Street 2,Business Street 3,Business Address PO Box,Business City,Business State,Business Postal Code,Business Country,Other Phone,Other Fax,Other Address,Other Street,Other Street 2,Other Street 3,Other Address PO Box,Other City,Other State,Other Postal Code,Other Country,Callback,Car Phone,ISDN,Radio Phone,TTY/TDD Phone,Telex,User 1,User 2,User 3,User 4,Keywords,Mileage,Hobby,Billing Information,Directory Server,Sensitivity,Priority,Private,Categories
Max,,Mustermann,Herr,,,,male,,,,,,,test@example.org,,,,,,,,,,Beispielweg 2,,,,Beispielhausen,,12345,Deutschland,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Eva,,Musterfrau,Frau,,,,female,27.03.1970,,,,,,example@example.org,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

 

Tags: ,
This entry was posted on Monday, January 9th, 2017 at 9:02 am and is filed under Hosting, Software Development. You can follow any responses to this entry through the RSS 2.0 feed.Both comments and pings are currently closed.

No Responses