Skip to main content

How to enter multiple users into ActiveDirectory 2008 from a CSV

To create multiple users into ActiveDirectory 2008 Server from one single CSV file containing the users login information, you can use the following wsf file:

   1: <job id="main">
   2:  
   3:     <script language="VBScript">
   4:         dim text_out
   5:         text_out = ""
   6:         Dim oContainer 'Parent container of new   user 
   7:         Dim oUser 'Created user
   8:         'Get parentcontainer
   9:         Set oContainer=GetObject("LDAP://OU=yourouname, DC=your,DC=domain,DC=local")
  10:         'Read the file with user information
  11:         Const ForReading = 1
  12:         Set objFSO = CreateObject("Scripting.FileSystemObject")
  13:         Set objTextFile = objFSO.OpenTextFile _
  14:         ("users.txt", ForReading)
  15:         Do Until objTextFile.AtEndOfStream
  16:             strNextLine = objTextFile.Readline
  17:             user_info = Split(strNextLine , ",") 'split comma-delimited line
  18:             username = LCase(Left(user_info(0),1) & user_info(1))
  19:             'Create user
  20:             Set oUser = oContainer.Create("User","CN=" & user_info(0) & " " & user_info(1) )
  21:             'Assign properties values to user
  22:             oUser.Put "samAccountName",username
  23:             oUser.Put "givenName",user_info(0)
  24:             oUser.Put "sn",user_info(1)
  25:             oUser.Put "userPrincipalName",username & "@your.domain.local"
  26:             oUser.IsAccountLocked = False
  27:             oUser.SetPassword user_info(2)
  28:             oUser.SetInfo
  29:             'Clean up
  30:             Set oUser = Nothing
  31:             
  32:         Loop 
Set oContainer = Nothing
  33:         WScript.Echo "Finished"
  34:     </script>
  35: </job>

You CSV file (users.txt) must be located in the same folder where the script is and its contents must be in the following format (no headers):

  First Name, Last Name, Password

 

The script will use the first name and last name to create a username. It will take the first letter of the first name and the complete last name, for example: jsmith.

You will need to replace yourdomain in the script with the name of your Windows Domain. Also you need to change “yourouname” in the script to the name of the organizational unit that will hold your new users.

The code is under the MIT license.

Comments

Post a Comment

Popular posts from this blog

Mail labels and letter templates for jasperreports

The following are free (MIT license) mailing labels and letter templates for jasperreports that you can download and use in jasperserver and/or ireport: Update 3/15/2011 : I moved the Mail templates zip file here . Please consider making a small donation if the templates are of help to you, Thank you! If you need more information on how to use those templates please leave a comment in the blog.
14 comments
Read more

How to create online multiplayer HTML5 games in Contruct2

  Construct2 can use websockets to send and receive messages between games. By using socket-io , we can use a Node.js script as the server and my modification to the socket-io plugin for Construct2 to allow the games to synchronize data between them in real-time. There are two parts to this design: the Node.js server and the Construct2 clients (the games playing). The main part of building an online multiplayer HTML5 game is to plan: how the clients will communicate how often and what to communicate how much of the logic will go into the server and how much to the client. In my sample game, I chose to have each client own a player and have the server just relay messages: Use string messages in the form TypeOfMessage, Parameter1, Paremeter2, Parater3, etc to communicate. Have the clients send their player position about 16 times a second. Whenever their player shoots, the client needs to send a message immediately. Almost all of the game logic will...
9 comments
Read more

Send Email from C# using Outlook's COM late binding

The following sample code shows how to send emails from Outlook and Exchange using C#. This code works with any version of Outlook because it uses Late Binding to automate Outlook. Parts of the code where taken from other websites. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Reflection; using System.Threading; namespace LateBindingTest { class OutlookEmailerLateBinding { private object oApp; private object oNameSpace; private object oOutboxFolder; public OutlookEmailerLateBinding() { Type outlook_app_type; object[] parameter = new object[1]; //Get the excel object outlook_app_type = Type.GetTypeFromProgID("Outlook.Application"); //Create instance of excel oApp = Activator.CreateInstance(outlook_app_type); //Set the parameter which u want to set parameter[0] = "MAPI...
5 comments
Read more