Adding Users & Passwords - Moon-on-a-stick styleee!

[Batman]

Sorry if this crosses over too many other past threads but I'm struggling to find something that quite meets my desired goals. I want the moon on a stick, basically... point and click, no thinking required!

 

I have a spreadsheet with usernames and passwords. All I want to do is import them into our new AD... but it seems to be less simple than it could be and I'm put off from CSVDE because it doesn't do the password bit.

 

Anyone have a good five minute method to do this or am I going to have to get my hands dirty and mess about with vb scripts?

Edited March 27, 2010 by Batman

[mounters]

dsadd is your friend here, set up columns in your spreadsheet which you concatenate to create the command and then just dump that column into a batch file and run it.

[Batman]

Awesome!

 

Thanks very much, I'll try that out on Monday

[kmount]

http://www.wisesoft.co.uk/software/account_management_spreadsheet/default.aspx

 

The above is a godsend for just this.

[Stuart_C]

+1 for DSADD here. Well in 2003 anyway but I'm assuming it's in 2008 as otherwise it's going to make the lovely spreadsheet I've got written that takes an output from our MIS and creates the script to add the new users to my domain, create the folders and us "subinacl" to secure the folders.

[box_l]

XIA Automation Server - CENTREL Solutions

[glennda]

I use Ad Manager Plus Real simple

 

Toby