Windows 7 Forums


Windows 7: Importing Contacts to WLM

19 Jan 2012  
Jon the geek

W7 x 64
4 posts
 
 
Importing Contacts to WLM

Hi

I have created a csv file from excel with all the contacts on and am trying to load it up to WLM on Windows 7 x64. I have loaded them all up in WM Vista with out a problem so the csv file is ok. Now trying WLM in Windows 7 but it will only take the first 172 ish contacts and then close. I have deleted the contacts from the csv file that imported, in the hope that the next 172 contacts will load up, but no; nothing loads up. It will also load up duplicates and have had 878 contacts so the number is no a problem. Any ideas guys?

My System SpecsSystem Spec

19 Jan 2012  
Qdos

W7 x64
4,027 posts
3rd Rock from the Sun
 
 

When your .csv file is constructed is it correctly formatted throughout? Double comma after each complete field, single comma between field variables?

Are the headers constructed with a single comma between field variables and without any comma at the end of the header section?

Quote:
Name,E-mail Address
Trudi Ball,tball213@googlemail.com,,
Ted Armstrong,e.armstrong@hmcts.gsi.gov.uk,,
Tony Narbell,tony.narbell@torridge.gov.uk,,
My System SpecsSystem Spec
19 Jan 2012  
Jon the geek

W7 x 64
4 posts
 
 

The format is nothing like that. It all appears in different cells. I exported one contact to a csv file to see how it was constructed, and then typed the rest. It imports and exports fine, but only up to 172 contacts, and all the remaining ones are identical format. It imports to WM on vista but not WLM on Windows 7.
My System SpecsSystem Spec
.


19 Jan 2012  
Qdos

W7 x64
4,027 posts
3rd Rock from the Sun
 
 

The excerpt shown in my earlier post is how a .csv archive suitable for WLM import should look.

You may have more fields, but the format must comply...

Simply right click your .csv file and open with notepad/wordpad, or your preferred text editor, to verify/modify
My System SpecsSystem Spec
19 Jan 2012  
Jon the geek

W7 x 64
4 posts
 
 

Ok, so opening it in notepad looks like you say, and also far more contacts that where it stops at as well; so they are all in there.
My System SpecsSystem Spec
19 Jan 2012  
Qdos

W7 x64
4,027 posts
3rd Rock from the Sun
 
 

Then it should import OK.

If it's stopping part way through then have you got a double comma where there should be a single one, or vice-versa? Has Excel formatting in any way caused a line break?

Drag your notepad window size around a bit to look for errors...
My System SpecsSystem Spec
19 Jan 2012  
Jon the geek

W7 x 64
4 posts
 
 

Sorted. by trial and error and shifting data about..... My contacts are labelled as Mr & Mrs Bloggs as the first name. The middle name is down as their kids Tom, Dick & Harry. but 2 families are rather large - 6 kids and it is those 2 lines that WLM drops out on the imports.
Thanks for assisting.
My System SpecsSystem Spec
Reply

 Importing Contacts to WLM problems?



Thread Tools



Similar help and support threads for: Importing Contacts to WLM
Thread Forum
Importing Contacts to All Accounts Microsoft Office
Solved Outlook 2010 problem importing contacts Microsoft Office
Importing contacts from outlook into ms fax win7 Microsoft Office
Importing contacts Browsers & Mail
Importing Contacts to Outlook Microsoft Office


All times are GMT -5. The time now is 01:25 PM.



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