Solved Importing Contacts to WLM

[Jon the geek]

Hi

I have created a csv file from excel with all the contacts on and am trying to load it up to WLM on W7 x64. I have loaded them all up in WM Vista with out a problem so the csv file is ok. Now trying WLM in W7 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?

 

[Qdos]

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?

Name,E-mail Address
Trudi Ball,[email protected],,
Ted Armstrong,[email protected],,
Tony Narbell,[email protected],,

 

[Jon the geek]

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 W7.

 

[Qdos]

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

 

[Jon the geek]

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.

 

[Qdos]

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

 

[Jon the geek]

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.