Solved

Bulk user creation script

Posted on 2004-03-30
9
552 Views
Last Modified: 2010-04-19
Hi

I have an excel spreadsheet containing a large number of usernames, password, and various other attributes from which I would like to create users in an Active Directory Domain.
I need a script (preferably vbs) which will reference the spreadsheet, looping through the rows and create the users for automatically me.
0
Comment
Question by:toffee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 2

Expert Comment

by:Ugrum
ID: 10712209
You can use utilities such as ldifde and cvsde to automate bulk object creation tasks.
0
 

Author Comment

by:toffee
ID: 10712320
Thanks  I am aware of those but am really after a vbscript using ADSI as I am a bit more familiar with that and hope to use this as the basis of other scripts for the future.
0
 
LVL 2

Expert Comment

by:Ugrum
ID: 10712640
Then take a look at the following link:
http://www.microsoft.com/technet/community/scriptcenter/default.mspx
a LOT of examples there, should be enough to make what you want.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 20

Expert Comment

by:What90
ID: 10712991
I used Active Directory Cookbook. I found this book a great help.

Have a look at some of the demo codes in the users section:
http://www.rallenhome.com/books/adcookbook/code.html
0
 

Author Comment

by:toffee
ID: 10713388
Loads of useful info in there in clear simple scripts which I like.  But what I'm really after is something which will take the usernames/passwords/descriptions from a spreadsheet and create the users in AD.

I suppose I could write some thing in VBA which will create a text file in .ldf format then use LDIFDE to create the users, but I was hoping someone had a script which would do it in the one operation i.e. a vbs accessing excel to get the information and setting up the users as it goes.
0
 
LVL 3

Expert Comment

by:following
ID: 10716006
I used the sample code from this article: http://www.winnetmag.com/Article/ArticleID/19830/19830.html

I modified it to fit my environment, adding/removing AD properties as necessary to fit our users.  There is an error when you press ctrl-d to run the code: click debug and change both references to frmLocalAdminPwd to frmUserCreation.  I added another worksheet into which I pasted all my users, passwords, etc.  I then made the code loop through each cell of the worksheet, instead of taking each user individually.

Hope this helps,
-jdm
0
 
LVL 3

Accepted Solution

by:
following earned 500 total points
ID: 10777739
Here is another example that may be helpful:

http://cwashington.netreach.net/depo/view.asp?Index=915&ScriptType=vbscript

I have found the scripts from cwashington to be of excellent quality -- I haven't tried this one, but it looks fairly standard to me.

-jdm
0
 

Author Comment

by:toffee
ID: 10781650
Thanks following.

Thats just what I need.
0
 
LVL 3

Expert Comment

by:following
ID: 10782798
Toffee,

I really appreciate the thank you!  It's actually nicer to know that the solution helped than to just gain more points...

-jdm
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question