In W2K Server is there a way to....

[PeeluckyDuckee]

say create a list of user accounts simultaneously, and apply them to a specific OU, with default passwords, until they first logon then have to change over themselves? Say I have a school and this year there are 60 new student enrollments. How can I add those user accounts in the most efficient way?

If it can be done, how? By script?

 

[Saltin]

csvde.exe will do it. It comes with Win2k

 

[PeeluckyDuckee]

ok, so that is the command you use to execute, but isn't there some prep work involved before hand? I recall a fellow doing it once in school, he used excel to enter all the data? What format or order does the data have to be entered in?

Doing a search on MS site right now too...

Thx.
Plucky

 

[Saltin]

CSVDE is comma deliniated. Example. The key goes Firstname, Lastname, Telephone Number, Age.
The first line could be John, Smith, 5551234, 28.

Sure there's prepwork. There's no way to get around the fact that you actually have to MAKE the accounts one way or the other : ).

 

[PeeluckyDuckee]

Ok, so I tried it out and here's where I'm having problems with.

I used excel to create two user account, with the "name", "objectclass", "distinguishedname", "dc", "ou", and "password" properties defined. In AD, I've created an OU called "testou" at the root level.

When I save in Excel the default is a *.xls extension. But csvde.exe works with the *.csv extension, so I made that change.

Now when I use the command prompt and issue the command as follows:
csvde -i -f c:\temp\testou.csv -s notebook

I get the message:
"Invalid file format. DN Attribute not defined"

What shoud be the proper syntax? Do I have to use the -c FromDN ToDN syntax? I'm not importing though, just creating. And is the -c syntax requesting for the fqdn path?

Plucky