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

Leave a Reply