mass user account creation

All Replies

• Wednesday, October 14, 2009 10:29 AMMeinolf Weber [MVP-DS]MVP

   
  

  0

  Sign In to Vote
  Hello,
  
  you have to use a scripting solution like:
  http://www.cruto.com/resources/vbscript/vbscript-examples/vbscript-sitemap.asp
  
  http://technet.microsoft.com/en-us/scriptcenter/dd793613.aspx
  
  http://www.petri.co.il/create_users_for_testing_purposes.htm#2
  
  http://gallery.technet.microsoft.com/ScriptCenter/en-us/
  
  Also you should choose a scripting forum/newsgroup. This forum is realted to IT management, not administration. Thank you for understanding.

  ---

  Best regards Meinolf Weber Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights.

  • Marked As Answer byKevin RemdeMSFT, OwnerWednesday, October 14, 2009 4:30 PM
  •  
  • Reply
  • Quote

   
• Thursday, October 15, 2009 10:22 AMManU PhiliP

   
  

  0

  Sign In to Vote

  Hello,
  
  Check this simple import as described below
  ------------------------------------------------------------------
  Copy my example below and paste into an Excel spreadsheet at precisely cell A1.
  
  objectClass,sAMAccountName,dn
  user,manup," CN=Manu philip,OU=vipl,DC=vision,dc=com"
  user,josepha," CN=Joseph abraham,OU=vipl,DC=vision,dc=com"
  user,albie," CN=Albi Easo,OU=vipl,DC=vision,dc=com"
  user,smithas," CN=Smitha Sree,OU=vipl,DC=vision,dc=com"
  user,brose," CN=Bilu Rose,OU=vipl,DC=vision,dc=com"
  user,sonumv," CN=Sonu MV,OU=vipl,DC=vision,dc=com"

  2) In Excel, select the Data Menu and then Text to Columns.  Naturally, choose the comma delimiter. Save the file as .csv for example, vipl.csv

  3) Make sure that the 3 LDAP fields are in the first row.  (ObjectClass, sAMAccountName, and DN.)

  4) Once you have opened the file in Excel, it is easier to manipulate the values.  For example, you may wish to find and replace dc=vision, dc=com with the name of your domain.

  5) When you have finished preparing the spreadsheet to your liking, then Save As and make sure you select Save as type CSV (Comma delimiter).  Since the next step is the command prompt, save the file into an easily accessible folder. E.g. C:\csv.

  The Actual CSVDE -i import command

  After all the hard work in preparing the spreadsheet, we are now ready for the import.  Open the CMD prompt, navigate to the folder where you saved your .csv file.

  Type this command:  CSVDE -i -f vision.csv

  To check your new users, launch Active Directory Users and Computers and examine the vision Organizational Unit.  After each import, right click the OU and select Refresh from the short cut menu.  Simply pressing F5 is not good enough.

  ---

  ManuPhilip
  • Reply
  • Quote

   
• Thursday, October 15, 2009 10:26 AMManU PhiliP

   
  

  0

  Sign In to Vote
  Hello,
  Please see this valuable thread from Microsoft also http://support.microsoft.com/default.aspx/kb/327620

  ---

  ManuPhilip
  • Reply
  • Quote