Working with CSV and AD

To export Contacts from AD to CSV use

CSVDE -F CONTACTS.CSV -R “(objectclass=contact)”

To import contacts from file:

CSVDE –I -F CONTACTS.CSV

To import with logging:

CSVDE –I -F CONTACTS.CSV –j c:

Note: User path for logfiles, not name of logfile.

Format of contact import file:

objectClass,displayName,DN,mailNickname,targetAddress,proxyAddresses,msExchPoliciesExcluded,mail

contact,Aaron Adams,”CN=Aaron Adams,OU=Category, OU=Distribution, DC=Domain, DC=com”, aadams, SMTP:aadams@domain.com,SMTP:aadams@domain.com,{26491CFC-9E50-4857-861B-0CB8DF22B5D7},aadams@domain.com

Links:

CSVDE:

http://support.microsoft.com/default.aspx/kb/327620

http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/b5afac99-e684-4ee2-a830-7eb71a78ae12/

Great SCV Editor:

http://csved.sjfrancke.nl/index.html

Comments

Leave a Reply

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Find out more about Webmentions.)