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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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