Discussion on:

DOWNLOAD: Create Active Directory users and Exchange accounts with VBScript

Creating users and Exchange accounts can be tedious, especially when user information already resides in your company's HR system. Instead of manually creating an Active Directory user and Exchange account, you can use a script that accomplishes the same goal. This handy, VBScript will create users with passwords in Active Directory in the Users container and an Exchange account. During the process it creates an output log that provides you with three information points for each account that is created:

Whether or not the Active Directory user account itself was created;
Whether or not the password was set successfully and the account enabled;
Whether or not the application of Exchange attributes was successful.

If these is a failure in one of these three areas, the error number and, if available, the error description will be written to the log file along with the current date and time.

Download the VBScript:
http://techrepublic.com.com/5138-10877-6026861.html

Join this ongoing discussion and let us know if this script is helpful and if there's anything we can do to improve the download's format or content.

Hi,

I have downloaded and modified this script and pleased to say its working well.

However, I was wondering why I can't get wscript.echo to work or to call a shell within this script.

Am I missing something, all looks good to me.

I have Dl'ed teh script, made teh suggested changes, named my csv file example.csv,
Sample of teh CSV:
sLogon sFirstName slastName sDisplayName sPassword
rsuzuki Ryuichi Suzuki Ryuichi Suzuki Pa$$w0rd
vflint Vasili Flint Vasili Flint Pa$$w0rd


But when I get to Line 93:

oInputRecordSet.open "SELECT * FROM " & sCSVFile,oInputConnection

I get an error
Line: 93
Char: 1
The connection cannot be used to perform the operation. It is either closed or invalid in this context.
Code: 800A0E70
Source: ADODB Recordset

Any help very appericated

Reg
West Palm Beach Fl

Is the .csv file in the correct location and correctly formatted?
Each value should be seperated by comma, for example
rsuzuki,Ryuichi,Suzuki,Ryuichi,Suzuki,Pa$$w0rd

Also check your values line up with the statement.
Suggest you stick with defaults first then edit to include display name value.

hope this helps ;_)

Steven, thanks, I think I do not have the ODBC drivers set up correctly. The CSV file is comma separated. The Display name was Dim'ed, so I assumed it was used?

I am convinced it is something in the ODBC setup. I did not have any drivers listed and the Jet... option is not in my select list...

Any help is appreciated.

Cheers

Well the scripte worked for creating the users, however I got his error and none of the Exchange accounts were created. I followed the directions of using the CVSDE -f exchattribs.csv in order to extract and locate the msExchHomeServerName? and ?homeMDB
infor that needs to be replaced in the script. Not really a big deal only 25 corporate users. Just wanted to know for future use.

Thanks,
Matt

Wouldnt it be great if this work would be wraped up in a gui , thus making the administrator ,
browse for the csv file -
write the Domain in a dialog box
choose with check boxes if the password is Null , can be changed at next logon, never expire etc.
open to view & verify csv columns before importing the users.
more options i am sure can be implemented!
who can/will peek up the this project and make it real

I've gone through this for hours, i keep getting this error in the log and the accounts are not created:

fbloggs: Error creating account: 424Object required

Anyone have any ideas of a solution to this?
Running on a Windows 2003 SBS server by the way.

Thanks

I am experiencing the same error. Has there been a resolution???

Help!!!

Thanks

After a litle working time, i could finaly get the script working just the way I wanted.

Thanks a lot!
I just got one more question.
If the user has more than one e-mail address, or other e-mail type (X400, X500, others smtp), I couldn't get it right. when I change the proxyAddresses string (ex: SMTP:slogon@sldapdomain;smtp:givenName.sn@sldapdomain, the addresses aren't put on diferent lines, in the snap-in.
Is there anything I can do to work this out?

thanks in advance

on following the guide and executing it throws and error saying "loop required at line no 96"

Hey all,

did anyone resolve this issue? I need to create 180 users and would prefer not to do it manually.

Thanks,

Aaron

I cannot get this to work, the log file doesn't show anything except for the date. Almost impossible to troubleshoot.

Right when I run the script I get this:
"createusersfromcsv+exch+err.vbs(113, 1) (null): 0x80005000"

It doesn't do anything? I think there may be somethings missing from the instructions?

Anyone else have some scripts that do the same thing they can share? Or Utilities they like that can do this? Anyone recommend any sites that may help?

I need to create accounts in a ou 2 levels deep.

Thanks!

Unless I'm blind and continue to miss where it's at, I can't seem to find the layout requirements of the csv file... please help.

Hi all, I got this script working and it creates mailboxes like "Fozzie_Bear@exchange.mydomain.com", but to be consistent with our other accounts I want to have it also add a Primary SMTP address like "Fozzie_Bear@domain.com".

Does anyone know what specific modifications/lines need to be added to the script to do this?

Cheers.

I downloaded the scripts. Jowever i did not see an sample .csv file attached..
Can someone provide me a sample .csv file with field description).

Thanks a lot!

Hi Bill,

I can't seem to download your script. The page states "We???re sorry, but the page you requested could not be found."

Thanks,
Rick

Hi Guys,
I keep getting "424Object required" error, tried the workaround mentioned above ( added the 4 title row in the first line, and modified sLDAPhomeMDB data being in the same line ) and no luck, think the problem is with the csv layout, do you have any working csv sample?

Thanks in advanced!

Miss typed sLDAPhomeMDB data, after having corrected it, it worked just great!

Thx.