Script contacts creation via csv file (csvde)
Hi, I'm trying to create a csv template to import 60 contacts. I've been looking for the min requirements to accomplish this. I want it to be as simple as it can be so it's not more work than actually handjamming these contacts. So far I have what is listed
below.
objectClass,displayName,DN,mailNickname,targetAddress,proxyAddresses,msExchPoliciesExcluded,mail
contact,Martin Charles A,"CN=Martin Charles A,OU=Contacts,OU=Accounts,DC=Test,DC=Com",CMartin,CMartin@joe.com,###,###,CMartin@joe.com
This format makes it a bit of work to get the csv setup easily. As well I'm worried about the 2 fields for "proxyAddresses" and "msExchPoliciesExcluded". Are both of these required? If some one could show me an example I would appreciate it.
Thanks for the help.
Los,
April 24th, 2011 12:41pm
For a mail enabled contact this is what I've used minimally in the past.
dn: CN=jchong,OU=Chicago,DC=company,DC=com
changetype: add
displayName: jchong
mailnickname: jchong
targetaddress:jchong@test.com
objectclass:contactJames Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2011 10:54am
Hi Los,
Since you seek the solution in the Exchange forum, I would suggest you bulk create contacts using cmdlet,
New-MailContact.
You can see the example in this thread:
Bulk import cmd for "mail contacts" and csv headers?
http://social.technet.microsoft.com/Forums/en-US/exchangesvrgeneral/thread/9163478f-3178-4b58-a065-86e5c7b52dfe
Or I would recommend you seek the solution in the AD forum:
http://social.technet.microsoft.com/Forums/en-US/winserverDS/threads
Frank Wang
TechNet Subscriber Support
in forum
If you have any feedback on our support, please contact
tngfb@microsoft.com
Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
April 25th, 2011 10:50pm
Hi Los,
Any updates?Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 9:31pm
Hi Guys,
I'm still working this I will post an update once I get it working.
April 28th, 2011 10:28am