Ticket #1326103 (new Feature Requests: None)

Opened 4 years ago

Last modified 19 months ago

Import Contacts

Reported by: christopherfink Owned by: thomasb
Priority: 5 Milestone: 0.5-beta
Component: Core functionality Version: None
Severity: normal Keywords:
Cc:

Description (last modified by thomasb) (diff)

A contact import would be very useful. I'm not sure of the main contact export file structures, but getting at least an "import from Outlook" or Gmail function would be great.

I wouldn't mind writing the PHP to parse the contact files for the various export types; this is one of the best projects I've found in a long time, and I'd love to contribute. Let me know if you're interested.

Change History

  Changed 4 years ago by nobody

Logged In: NO 

and from the little fuzzy webmail too?

  Changed 4 years ago by thomasb

  • owner changed from roundcube to nobody
  • severity changed from critical to normal
  • status changed from assigned to new
  • description modified (diff)
  • milestone changed from 0.1-beta2 to 0.1rc1

  Changed 4 years ago by nik

It would be great if one could drag and drop vCards into the address book as well

  Changed 4 years ago by thomasb

  • milestone changed from 0.1rc1 to 0.1stable

  Changed 4 years ago by offwhite

I do not know about dragging a vCard into the address book, but you certainly upload a vCard into RoundCube.

  Changed 4 years ago by thomasb

  • milestone changed from 0.1-stable to later

Moved to later. Address book redesign has to be done first.

follow-up: ↓ 8   Changed 3 years ago by doogie

Here is a workflow how to import your Addressbook contacts into Roundcube:

1) Export your contacts into a CSV file If you can only export into vCards (as from MacMail?) then you can convert your vCards to a CSV file e.g. with this webtool. http://labs.brotherli.ch/vcfconvert/

2) Inside your CSV file you need at least the columns: firstname, surename, name, email

3) import this with phpMyAdmin

Go to the table "contacts" in the database "roundcube" (or whatever you named it). Import format CSV, In the field “column names” enter the name of the columns in same order as inside your csv file e.g. “firstname, surename, name, email”

after a successfull import you might want to run the following SQL on the table roundcube.contacts

update contacts set user_id = 1, changed = NOW()

(user_id is your roundcube user_id from table roundcube.users)

in reply to: ↑ 7   Changed 2 years ago by seansan

  Changed 2 years ago by thomasb

  • milestone changed from later to 0.5-beta

  Changed 22 months ago by thomasb

  Changed 19 months ago by thomasb

  • owner changed from nobody to thomasb

Implemented vCard import in r1716. CSV import will follow...

Note: See TracTickets for help on using tickets.