Voer Uw Contacten in GMail in

23 november, 2007 · door David Bradley

Ik heb de cliënt van Thunderbird e-mail een paar jaren nu gebruikt, voorafgaand aan dat gebruikte ik Post Pegasus, maar soms zou ik tot mijn e-mail verkiezen te kunnen online toegang hebben zonder het moeten zich over een programma ongerust maken dat op willekeurige laptop wordt geïnstalleerd. Als dusdanig, dacht ik het tijd was ik mijn contacten Thunderbird uitvoerde en hen aan mijn hoofdGoogle postrekening toevoegde.

Het is een wind om uw geheel adresboek van Thunderbird uit te voeren. Klik eenvoudig het pictogram van het Boek van het Adres in de toolbar (of klap CTRL 2 in Vensters). Selecteer het uit te voeren adresboek (ik heb alle „verzamelde“ adressen die aan mijn Persoonlijk Boek van het Adres in het programma worden toegevoegd, zodat is er slechts één met om het even welke ingangen). Dan kies het menu van de Hulpmiddelen van het adresboek en klik de Uitvoer. het standaardformaat is LDIF, maar u kunt van Afgebakend Lusje en Gescheiden Komma kiezen. Het is de laatstgenoemde, gescheiden wil de komma (CSV) u voor GMail. Sparen het dossier.

Daarna, kiest login op uw rekening GMail en de Contacten verbinden. Zodra u op dat scherm bent zult u twee verbindingen in het blauw boven uw huidige lijst van contacten - Invoer-uitvoer zien. De keus is duidelijk - de Invoer.

In het popup dialoogvakje, doorblader voor het Csv- dossier u enkel in Thunderbird (of andere e-mailcliënt) cre�ërde. Nu, klik de knoop van de Contacten van de Invoer. GMail zal elke komma gescheiden ingang uit het dossier halen en zal elk contact aan uw GMail contacteert lijst toevoegen. Nu wordt gedaan, kunt u tot uw e-mailcontacten toegang hebben overal u login aan uw rekening GMail kunt.

Natuurlijk, ontwikkelt Google ook toegang IMAP tot GMail die u zal toestaan om uw e-mailcliënt met uw e-mailrekening ook te synchroniseren.

WAARSCHUWING: Uw afstand in mijlen kan variëren, blijkbaar werkt het niet vrij zo slickly voor sommige gebruikers om wat onbekende reden. Zo gelieve te testen op een kleine gegevensreeks alvorens u het op een 1000+ contacteert lijst in werking stelt.

24 reacties tot dusver ↓

David Bradley // 29 Oct, 2007 in 4:04 p.m.

Eigenlijk, was ik een weinig economisch met de waarheid in termen van hoe olievlek het proces is.

Ik had duizenden contacten in Thunderbird en ontving dit bericht:

„Voltooide de invoer, is 3000 contacten met succes ingevoerd. Uw contacten dienen is te groot in om alles in één keer worden ingevoerd.“

Zo, beëindigde ik omhoog moetend het van Thunderbird Csv- dossier verdelen en uitvoerend de invoer in twee stappen. Maar dat is niet te tijdrovend.
russ // 16 Dec, 2007 in 4:09 p.m.

hmmm…didnt work for me, it said no contacts imported because they had no name or email - the csv export from thunderbird is a different format to gmail. darn it, thought it was going to be easy
David Bradley // Dec 16, 2007 at 5:13 pm

Hmmmm indeed. It worked reasonably well for me, aside from the number limitation. But, I see how it could go wrong, like you say where a contact is listed in the Thunderbird address book only as an email not by name. If I find out any more on that I’ll let you know or if any readers have insights please post them here.
Mana // Dec 22, 2007 at 8:04 pm

This also happened to me. I have 7o contacts in my Thunderbird address book, and they all have a name and and email. However, after I save it as a .csv, I try to import them and this message pops up:
“We were not able to import any of the
contacts found in the uploaded file.
69 contacts have been ignored because
they didn’t have a name or email.”
Like I said, I have 7o addresses stored in my address book, and they are all located in the same folder - the personal one. But to say 69 contacts have no name or email means that one of my 7o contacts “fits” the requirements (though, technically, all of them do).
Maybe having only a tiny bit of HD space left might affect this, but I don’t know…
Please help, and thanks.
John // Jan 15, 2008 at 5:10 am

Didn’t work for me either. After several attempts, I gave up and exported contacts to Outlook Express, and from there sent them to Gmail.
David Bradley // Jan 15, 2008 at 7:13 am

I blame Outlook!

db
obfusco // Jan 16, 2008 at 5:08 am

Sounds like the problem might be missing csv headers, the first line should have a comma separated list of field titles:

first name,last name,display name,nickname,email address,alt email address, work phone,home phone,fax,pager,mobile,address1,address2,city,stat e,zip,country,work address1,work address2,work city,work state, work zip,,,,organization,,,,,,,,,,notes

was suggested at http://broadbandforum.in/procedures/3902-exporting-thunderbird-address-book-gmail/

See also http://mail.google.com/support/bin/answer.py?answer=12119
David Bradley // Jan 16, 2008 at 7:55 am

Obfusco, thanks for the insights and links. Hopefully, anyone having problems will be able to figure out a fix from that information.

db
Anonymous // Jan 29, 2008 at 12:34 am

David, Obfusco - I’ve had problems also. Apparently when I imported contacts into gmail, some unrecognized fields were mangled. That resulted in some fields containing newlines. When exporting this from Google, the newline is exported inside a quoted field, but Thunderbird (and OpenOffice Calc) still treat it as the start of a new line - not a field with a newline.
David Bradley // Jan 29, 2008 at 8:06 am

Does anyone have a foolproof way to do this? It seems that lots of readers are having problems and the solution I offered does not work universally.

db
Dmitry // Feb 12, 2008 at 7:53 pm

It worked for me, but just barely. Gmail imported the Thunderbird CSV file, but it recognized the Nickname field as Name, and dumped everything else into Notes - including the e-mail address. So to use this address book I have to copy the e-mail from Notes to its proper field for each of the contacts.

Perhaps the solution is to edit the Thunderbird CSV and rename the fields so that gmail can recognize them.
David Bradley // Feb 12, 2008 at 10:09 pm

Interesting thought Dmitry. Maybe someone could create an addon for Thunderbird that would hack the database appropriately…

db
avko // Feb 14, 2008 at 5:10 pm

It worked for me, using obfusco’s method:

1) export from Thunderbird to ‘comma separated’ file
2) open file in notepad
3) replace first line with:
first name,last name,display name,nickname,email address,alt email address, work phone,home phone,fax,pager,mobile,address1,address2,city,stat e,zip,country,work address1,work address2,work city,work state, work zip,,,,organization,,,,,,,,,,notes
4)save
5) import into gmail

This worked also for contacts without e-mail address
David Bradley // Feb 14, 2008 at 5:57 pm

Many thanks for the walk-through Avko! Maybe others will have equal success using that approach.

db
Darwin // Jun 20, 2008 at 5:17 pm

I hit the same wrinkle. After reading the suggestions here and trying a few things, I can report that the column names (of interest to me) ‘Display Name’ and ‘Primary Email’ should be renamed ‘Nickname’ and ‘Email’ (case sensitive) when exporting to Gmail. That solved my problem. Thanks for having this discussion.

Darwins last blog post..Esbjörn Svensson: When Everyone Has Gone
David Bradley // Jun 20, 2008 at 5:27 pm

Many thanks for the extra tip Darwin.
emorris // Jul 12, 2008 at 12:15 pm

@avko + others:
You need to use ‘E-mail Address’ and ‘Alt E-mail Address’. The dashes in E-mail are important, otherwise GMail will not recognise it as the email address.

All I did was (on the first line) change ‘Primary Email’ to ‘E-mail Address’ and ‘Secondary Email’ to ‘Alt E-mail Address’. Thanks.
Neil Ehrenberg // Jul 29, 2008 at 8:27 am

I hate to sound like a broken record, but I too had the same type of problem exporting the e-mail addresses from Thunderbird ( Using Vista) as others have mentioned. I followed the above suggestions on changing the words in the first line (block or column titles) from the original .CSV file as recommended. The original .mab file was 469KB. The CSV ended up only 76KB and I thought I lost contacts when only 15 showed up. After editing the first line (I found that each title with the comma separation could stay as Capital and lower cased letters) and then importing the revised CSV file, I ended up with 901 contacts (WOW). It just took a while for G-mail to turn them into the correct looking contact.. Thanks to all who participated in the above discussions.

Here is how mine looked:

First Name,Last Name,Display Name,Nickname,E-mail Address,Alt E-mail,Work Phone,Home Phone,Fax,Pager,Mobile,Address1,Address2,City,State,Zip,Country,Work Address1,Work Address2,Work City,Work State,Work Zip,Work Country,Job Title,Department,Organization,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,

Neil Ehrenberg, San Jose, CA
David Bradley // Aug 4, 2008 at 9:27 am

gHacks has an alternative approach that might work better for those Scientext.com readers struggling with CSVs etc
Rob // Aug 28, 2008 at 12:58 am

I can confirm that Neil Ehrenberg’s method worked perfectly for me.

I couldn’t get it to work with any of the other responses though; Gmail just dumped all of the details into “Notes”, which was useless…
Gary C // Sep 15, 2008 at 3:47 pm

I used Neil Ehrenberg’s suggestion (dropping that final dangling comma after Notes) and it worked well. You may get some errors and you should look at them RIGHT AWAY, as it seems that once you move on you can never see which ones got “ignored” etc.

Thanks to all who have participated in this thread. VERY HELPFUL!
John // Sep 27, 2008 at 11:36 pm

emorris, thank you on your note about having to use ‘E-mail Address’ and ‘Alt E-mail Address’ as the column headers.
Joe // Sep 30, 2008 at 4:44 pm

I tried david’s and then obfusco’s approach, stupidly trying to load them in without testing the approach. Now I have 2 times 2800 unsearchable emails described as (unnamed contact). When you click on one, you can see all the detail, but gmail can’t. When I tried to delete them All, I was told you can only delete 500 at a time, and I don’t see a button for 500. This is a prescription for carpel tunnel of the finger.
David Bradley // Sep 30, 2008 at 4:56 pm

Ouch! Sorry Joe. I’ve amended the original post to warn users to test on a small data set first.