Wikis - Page Details

First published by Kurt L Hudson MSFT
When: 13 Jan 2011 1:57 PM
Last revision by Richard Mueller (cMVP, Microsoft Community Contributo)
When: 7 Jan 2013 5:20 PM
Revisions: 9
Comments: 6

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

How to Import Mail Contact into Active Directory Using CSVDE

To add contact records to Active Directory using CSVDE, you need only define the Lightweight Directory Access Protocol (LDAP) location in the directory where you want to place the contact (DN), object class (objectClass), and email (mail) address for each entry. For example, assume that you have the following file named NewContacts.csv. The contents of the NewContacts.csv file in the C:\Users folder has the following three lines:

DN,objectClass,mail
"CN=Ben Smith,OU=HQ,DC=contoso,DC=com",contact,BSmith@cpandl.com
"CN=Brian Smith,OU=HQ,DC=contoso,DC=com,contact,BrianSmith@cpandl.com

After running the command csvde -i -f c:\Users\NewContacts.csv you would see output similar to:

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "NewContacts.csv"
Loading entries...
2 entries modified successfully.
The command has completed successfully

Then you could go verify that your contact records were added by using an LDAP tool, like LDP.EXE or ADSIEDIT.EXE or just Active Directory Users and Computers (dsa.msc) as shown in the following figure.