Domain - user creation from CSV / Excel

[Javik 0]

I am a former Novell / Netware network administrator setting up a new Microsoft 2008 R2 domain this summer, and I need to create about 500 user accounts in the domain in the next two weeks.

Generally it appears that Microsoft does not offer a good way (with error and sanity checking) to read in users from a comma delimited list or from columns in an Excel spreadsheet.

Yes, there are various visual basic scripts on MSDN but they are without error checking, and if an error occurs, the scripts can barf all over the domain and screw things up, potentially leaving droppings here and there in the domain database.

I am resigning myself to the fact that if I want to automate this process and have protections against scripted failure or invalid field data, I am probably going to have to write a tool to do it myself, probably with AutoIT..

Or just do the account creation by hand.. which at 60 seconds per manual account creation, that would be 8.3 hours of extremely repetitive work. Bleah.

[water 1,883]

You could use the written by ProAndy to read the CSV file into a multi dimensional array.

To create a user use my Active Directory UDF, function _AD_CreateUser.

Edited August 14, 2011 by water