adding users from an excel file

[netguru2]

Anyone have any software or scripts that you can suggest for adding a bunch of users to active directory from an excel file or delimitted text file? I have about 4000 users that i have to add to active directory every summer. I need to add them all from a file and be able to setup a folder for them with correct permissions and give them a password and add a login script for them....They are all put in by a user id...So a typical user would need there first name to be 123456 no last name and userid 123456 and password setup to a default password for first login...a login script added to there profile...and a directory created with same name as there userid....and all the permissions set in that directory...I know there has to be some script out there or some software (freeware if possible...this is a school) out there to automate this process. Summer is about over and I need to get this done......So any help would be greatly appreciated..

Thanks

 

[rbelt]

you need to get into adsiedit ldifde type stuff. Go to the bookstore and look @ 'windows 2000 active directory' o'reilly -- half the book is about scription...

another source is this:

http://www.microsoft.com/windows2000/techinfo/planning/activedirectory/bulksteps.asp

//RB

 

[ksukenny]

check out csvde also. that is an easier tool to use to import objects into active directory. ldifde is complicated and is a good tool to change properties for bulk objects

 

[mst3k]

You can actually do just about all of that from a batch file and doing somw spreadsheet magic on getting the output of that excel sheet the right way. It's actually kind of fun when you get your brain around it. For instance,
net user {username} {password} /add /domain
Will add the user name and password to the domain that the server is a member of. So in your batch file, (that you make in excel) insert a column before the username with 'net user', so when you are done, each line of that spreadsheet will be a seperate command from in the command prompt. You can use similar syntax with the CACLS command to set permissions, and there are some other reskit utilities that you can use to add users to groups.
When getting your spreadsheet all ready, don't worry too much about the spaces not getting lined up, a trick I use is to use the 'web page preview' in excel, copy all that text and paste in to notepad. In notepad you can do find and replace for all the tect that you need to correct, as in replace all instances or two spaces with one space, etc..

hth,

 

[netguru2]

I will definatley get that book and read it cover to cover......Thanks for every1's input...I have found a GUI interface that does most of the functions I need.....The software is called ADvantage at

http://www.javelinasoftware.com

Now the only other thing I have to work out is creating there home directorys and assigning correct privledges to them....Thanks for all the help!

 

[xmsre]

Bulk import... Sounds like a job for LDIFDE.

http://www.microsoft.com/windows2000/techinfo/planning/activedirectory/bulksteps.asp

John
MOSMWNMTK, WKIL, WMDM