Importing Contacts to WLM


  1. Posts : 4
    W7 x 64
       #1

    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 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?
      My Computer


  2. Posts : 3,960
    W7 x64
       #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?

    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 Computer


  3. Posts : 4
    W7 x 64
    Thread Starter
       #3

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


  4. Posts : 3,960
    W7 x64
       #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 Computer


  5. Posts : 4
    W7 x 64
    Thread Starter
       #5

    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 Computer


  6. Posts : 3,960
    W7 x64
       #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 Computer


  7. Posts : 4
    W7 x 64
    Thread Starter
       #7

    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 Computer


 

  Related Discussions
Our Sites
Site Links
About 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 18:52.
Find Us