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: Importing Contacts to WLM


19 Jan 2012   #1

W7 x 64
 
 
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   #2

 

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   #3

W7 x 64
 
 

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   #4

 

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   #5

W7 x 64
 
 

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   #6

 

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   #7

W7 x 64
 
 

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




Thread Tools



Similar help and support threads for2: 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 to Live Mail Browsers & Mail
Importing contacts from outlook into ms fax win7 Microsoft Office
Importing contacts Browsers & Mail
Importing Contacts to Outlook 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 06:16 PM.
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