how do I import my gmail contact to evolution

Asked by Valkyrie on 2007-11-10

I tried to import my gmail contacts with CVS outlook file but when evolution imports it the fields don't match so I would have to fix one by one...which kind of defeats the purpose of the whole thing...

Is there a better way to do this?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu evolution Edit question
Assignee:
No assignee Edit question
Last query:
2007-11-10
Last reply:
2008-09-27
Josh Barrick (random125) said : #2

After some playing around, I found the proper order for at least the first and last name, nickname, and email:
<code>firstname,lastname,nickname,email</code>

Any more than that you will have to continue doing what I did:
Open the csv with OOO Calc and move the columns around. After each import, you can click on the contact to see where the data went, this should tell you the order of the columns according to how evolution sees it.

Josh Barrick (random125) said : #3

oops, C&P'ed my last message...remove the "<code>" or the "</code>" part...

After some playing around, I found the proper order for at least the first and last name, nickname, and email:
firstname,lastname,nickname,email

Any more than that you will have to continue doing what I did:
Open the csv with OOO Calc and move the columns around. After each import, you can click on the contact to see where the data went, this should tell you the order of the columns according to how evolution sees it.

Last night I exported my Google contacts in vCard format and imported these contacts without any problems in Evolution.

Hope this helps,
Jan

Mehul J. Rajput (mehulrajput) said : #5

how did you import the vcard in to evolution?

Mehul J. Rajput (mehulrajput) said : #6

I selected the vcard and evolution imported it. Have all my contacts from gmail to Evolution now.

Charles Tryon (charles-tryon) said : #7

The Google vCard export does reasonably well, except for the street addresses. I actually maintain my Gmail contacts with phone numbers and physical as well as email addresses. MOST of the stuff in the vcard (including company name and multiple email addresses) import pretty well, but not the address.

I may be able to come up with a SED script to modify the address format to get it to work.

Charles Tryon (charles-tryon) said : #8

Here's a pretty brute force way to fix the address lines:

#!/bin/sh

dos2unix | awk '
/^LABEL;TYPE=HOME/ {
 line0 = $0;
 gsub("LABEL;", "ADR;", line0);
 gsub(":", ":;;", line0);
 gsub("=0D=0A=", ";", line0);
 next;
 }
/.*/ {
 if (line0 != "")
  gsub(", ", ";", $0); \
  gsub(" ", ";", $0);
 printf("%s%s\n", line0, $0);
 line0 = "";
 next;
 }'

Can you help with this problem?

Provide an answer of your own, or ask Valkyrie for more information if necessary.

To post a message you must log in.