Bulk Domain User Creation from CSV without powershell scripting

Flexible and very simple way to create user from another active directory , I had tried multiple different kind of tool and PowerShell scripting method but so far what I like is below.

Step 1 Export Domain Users to CSV File

1. Here all my users are in one OU, if that OU has ‘nested OU’s within it that’s OK.

1

Bulk Export Users

2. The command to ‘export’ is as follows;

Note: You need to ‘run as administrator

csvde -d {LDAP Path} -f c:\filename.csv

Example

csvde -d “ou=Main-Site,dc=pnl,dc=com” -f C:\ExportedUsers.csv

clip_image002

 

Bulk Export Users CSVDE

3. The users will be exported. If it fails at this point it will give you a descriptive error, CSVDE has been around for a while, Google the error (most fixes are pretty simple).

clip_image003

CSVDE Export Users

4. Now open the CSV File with Excel, the second line will probably be the OU, you can leave this here if you want but if your target OU is different (or Like me you prefer to create it manually), then delete row 2 (Don’t delete Row 1!).

Edit csv file

clip_image004

5. You do not need all the columns, delete all the columns EXCEPT,

DN

objectClass

ou

distinguishedName

name

cn

sn

givenName

displayName

sAMAccountName

userPrincipalName

clip_image005

 

So when complete it should look like the following;

clip_image006

Complete CSV for CSVDE Active Directory

6. Change any details in the LDAP path that are different for the new domain.

clip_image007

CSV File find and replace

7. You may also need to change the domain name that’s listed on the userPrincipleName.

clip_image008

CSVDE userprinciplename

Step 2 Import Domain Users from CSV File

1. On the target domain, (if you are not importing the OU’s, then make sure they already exist). The syntax for the import is;

csvde -i -f c:\filename.csv

clip_image009

Bulk Import Users

9. Your users should be imported.

clip_image010

Bulk Import Users CSVDE

10. By default they will be disabled, but you can bulk enable them.

clip_image011

Screen shots are from :- petenetlive

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s