locked
best way to import a csv containing 46000 contacts RRS feed

  • Question

  • Hi, we have a requirement to import approximately 46,000 contacts contained in a csv into Exchange 2003.
    we only have a group of 10-20 poeple that need access to these contacts

    what is the best way to go about this? do we import these into a distribution list?

    none of these contacts have email addresses listed, their only info is name, address, and come custom fields

    any ideas?

    thanks,

    jason

    Tuesday, September 18, 2012 7:09 PM

All replies

  • You could import them using Outlook, then copy them to a Public Folder.

    [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

    Tuesday, September 18, 2012 8:27 PM
  • I tried importing the 46,000 into my outlook but it stops after 21,000.
    the contacts folder is now 33745 bytes
    is there some sort of limit?
    Thursday, September 20, 2012 4:39 PM
  • I don't know.  I've never tried importing that many contacts.  Maybe a question for the Clients forum.

    I think this would probably be better accomplished using the Exchange EWS Managed API, and creating them directy into the folder.


    [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

    Thursday, September 20, 2012 4:43 PM
  • Have you checked the folder limit to see if you've configured any size limit on the folder? After it stops at 21K, what happens if you try to import 1 more contact does it still fail?

    James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com

    Thursday, September 20, 2012 6:55 PM
  • i have run the same import twice into 2 different mailboxes and it crashed at the exact same number of contacts,

    we have no limits set on this mailbox or on any folders

    i am able to go in and add manually another contact after it crashes

    Thursday, September 20, 2012 8:16 PM
  • I ran just ran import 3 times simultaneosuly on 3 different mailboxes and in all cases it stops at 21825 contacts
    Friday, September 21, 2012 4:07 PM
  • Hi

    Import these 21825 contacts and move them to a public folder. Then remove the imported entries from the csv file and run the import again. Repeat this step until you have them all in a public folder.

    Or you split the csv file into 3 or 4 smaller ones.


    Regards
    Pano


    Pano Boschung, PageUp AG


    Friday, September 21, 2012 6:06 PM
  • there has to be some sort of limit in the import GUI in Outlook 2010 as it crashes at exact same point every time
    Sunday, September 23, 2012 4:53 PM
  • Hi

    Try to divide it into 2 or 3 parts, then see if it will also stop at 21825 contacts,

    Perhaps it is caused by that contact

    Cheers


    Zi Feng

    TechNet Community Support

    Wednesday, September 26, 2012 5:23 AM
    Moderator
  • does  anyone have a script to import contacts in a csv into a persons outlook contacts? If it is a limitation of the gui, a script may work?
    Wednesday, September 26, 2012 2:04 PM
  • Hi

    If you would like to ask for a scrpit, perhaps you can try on Script Forum

    http://social.technet.microsoft.com/Forums/en/ITCG/threads

    Cheers


    Zi Feng

    TechNet Community Support

    Thursday, September 27, 2012 2:02 AM
    Moderator