Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Import email contacts to WLM from gmail - how?


11 Oct 2012   #1

Windows 7 Home Premium 64 bit
 
 
Import email contacts to WLM from gmail - how?

Hi,

I have saved my gmail contacts as a .csv file in excel. But, it does give this error message:

Attachment 236078

Although the data is there in excel:


Then I try to import to Windows Live Mail as so:


And it says "importing"..... and then nothing else. No contacts come in and no other message.

Please can somebody tell me what I'm doing wrong?


My System SpecsSystem Spec
.

15 Oct 2012   #2

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Sorry - didn't see this thread.

Yeah, the import in WLM and Outlook suffer the same problem. there is no "select all".

So you have to tick each field you want to import.... each time you perform an import. It does remember some fileds, but not the ones you might expect, such as name.

anyway, the default mapping should suffice - just tick all fields and try again.
My System SpecsSystem Spec
16 Oct 2012   #3

Windows 7 Home Premium 64 bit
 
 

Hi again Bill,

Thank you very much for your message. I have made the recommended adjustments!

Right, I will try again now with ticking all the boxes and see what happens.
My System SpecsSystem Spec
.


16 Oct 2012   #4

Windows 7 Home Premium 64 bit
 
 

Okay,
I saved the file again and I go through the following screens:
Name:  15oct1.PNG
Views: 7
Size:  64.5 KB
Name:  15oct2.PNG
Views: 7
Size:  65.2 KB
Name:  15oct3.PNG
Views: 6
Size:  29.5 KB
Name:  15oct4.PNG
Views: 6
Size:  30.1 KB
Import email contacts to WLM from gmail - how?-15oct5.png

I only added email address as it wasn't ticked.

Then when I click finish, a screen comes up saying "import in progress" but it's very quick so I can't capture it. Then it goes and I am left with an empty contacts list still!!


My System SpecsSystem Spec
16 Oct 2012   #5

Win7 H.Prem. 32bit+SP1
 
 

Before exporting/importing contacts from Gmail to WLM, you should do this first. WLM Mail Tips.docx


My System SpecsSystem Spec
16 Oct 2012   #6

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Well, I think you've stumped me. I checked the tutorial section and found this - it looks as though I essentially gave you the same steps, but you might want to read through it, just to be certain I didn't miss something.

The only thing I did notice is that not all of the fields were selected. Since you're having difficulty - eliminate one possibility, that one of the fields is needed to complet the import.

Try ticking all of the fields and use the default mapping WLM, i.e. don't change the mapping - if the .CSV file doesn't have the column, it will just skip that field.

If that doesn't work, try just one address. Make a copy of your .CSV file, edit the copy and delete everything below the first address, keep the header. Or create a dummy import file and test with either one.
Name,E-Mail Address,Phone
Bill,Bill@somedomain.com,555-1212
There might be a character in one of the rows that WLM doesn't like or the .CSV structure is out of whack.

If one entry gets imported..... we'll cross that bridge in a bit.
My System SpecsSystem Spec
16 Oct 2012   #7

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

I keep reading and find nothing that indicates you're doing anything wrong. so, we'll have to dig a little deeper. I suspect that your contacts DB might be corrupt.

1st thing to try (this is just a short way to run WLM repair - instead of control panel, program & features)
type wlarp.exe into the search box on the start menu and hit enter
select repair

Try importing the small or dummy import.csv - if succesful, import the full file.
if not successful......
Next thing if repair doesn't fix it for you:
Please provide a screenshot of what's in the following folders (you'll need to view hidden system files)
C:\Users\YourName\AppData\Local\Microsoft\Windows Live\Contacts
and
C:\Users\YourName\AppData\Local\Microsoft\Windows Live\Contacts\default

there are two choices
1) use a big hammer to remove the "corrupt" contacts file - this might cause more issues down the line or other issues might be lurking
2) export any email you want to retain, uninstall WLM, remove trace folders, and reinstall WLM 2012 - you'll have to import any email you exported and the .aif and .csv files. - I prefer the standard uninstall install route, but that's up to you. It's probably easiest since teh machine is relatively new - not too much to import.

I'll provide more information on the processes above if the repair doesn't solve the problem.
But see if the wlarp repair helped first.
My System SpecsSystem Spec
20 Oct 2012   #8

Windows 7 Home Premium 64 bit
 
 

If that doesn't work, try just one address. Make a copy of your .CSV file, edit the copy and delete everything below the first address, keep the header. Or create a dummy import file and test with either one.
Name,E-Mail Address,Phone
Bill,Bill@somedomain.com,555-1212
There might be a character in one of the rows that WLM doesn't like or the .CSV structure is out of whack.

If one entry gets imported..... we'll cross that bridge in a bit.[/QUOTE]

Yes, it worked. I deleted loads of stuff and left just First Name, Last Name and E-mail Address with just one entry....and it imported!!!

So, until I hear from you again, I will try it with a couple more in the same layout and let you know. One thing I noticed is that some of my phone numbers are displaying oddly.

Most of my numbers start with a "+" or a "0". they look like that in the edit bar of excel, but in the actual spreadsheet some of them show like this:

2.59E+11

Maybe, it didn't like these numbers? I'll try the original list without the numbers too, and let you know.
My System SpecsSystem Spec
20 Oct 2012   #9

Windows 7 Home Premium 64 bit
 
 

Quote   Quote: Originally Posted by Roderunner View Post
Before exporting/importing contacts from Gmail to WLM, you should do this first. Attachment 236869
Thanks Roderunner,

I had actually found your post to another reader with this help file and read it and tried it. I seem to be doing everything right. Very puzzling.
My System SpecsSystem Spec
20 Oct 2012   #10

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Good news Jenni,

Interesting..... your difficulty importing might be due to using Excel to edit the .CSV file. I don't recall having this issue in the past, but who knows?

2.59E+11 is just Excel's way of displaying large numbers. To "fix" that, select all cells (upper left box on sheet, or Ctrl-A) and format cells - change format to text. Take a look at the results and if they look good (phone number, dates, etc - anything with numbers) then save as... .CSV

Probably the easiest thing to do is export to a new .CSV file and don't use Excel to look at it - use a text editor. Notepad works fine and it's on every Windows system.

I like Textpad, it's a trial version that doesn't really expire. I became so used to it that I eventually paid for it. Note that I had some problems with the latest & greatest Textpad v6, so I installed Textpad v 5.4.2

Bill
Quote   Quote: Originally Posted by sonyvaio2012 View Post
.....
Yes, it worked. I deleted loads of stuff and left just First Name, Last Name and E-mail Address with just one entry....and it imported!!!

So, until I hear from you again, I will try it with a couple more in the same layout and let you know. One thing I noticed is that some of my phone numbers are displaying oddly.

Most of my numbers start with a "+" or a "0". they look like that in the edit bar of excel, but in the actual spreadsheet some of them show like this:

2.59E+11

.....
My System SpecsSystem Spec
Reply

 Import email contacts to WLM from gmail - how?




Thread Tools



Similar help and support threads for2: Import email contacts to WLM from gmail - how?
Thread Forum
Can I import my old gmail emails to outlook.com? Browsers & Mail
Import OL 6 email to WLM problem , missing email after import Browsers & Mail
Solved how to import outlook 2007 emails to Gmail? Microsoft Office
Import contacts into Windows Contacts folder Microsoft Office
Can't Import Multiple Contacts into MLM Software
gmail contacts by last name Browsers & Mail
import contacts in outlook 07 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:56 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33