Thursday, February 7, 2008

CSVDE exports and import user accounts

Domain: VAN.COM
OU: Students

Inside the Students Organizational Unit, I have many user accounts. I want to recreate them in my VANSTUDENTS.COM domain.

First, run:
C:\>csvde -d "ou=students,dc=van,dc=com" -f c:\out.csv

Second, open the out.csv with MS Excel and modify it by keeping only the following columns:

DN
objectClass
ou
distinguishedName
name
cn
sn
givenName
displayName
sAMAccountName
userPrincipalName

===
Replace the VAN with VANSTUDENTS
Save it
===
Import it to VANSTUDENTS.COM domain

C:\>csvde -i -f C:\out.csv

All users and organizational Unit will be created. All users have the disabled status and no password.