none
mass user account creation RRS feed

  • Question

  • Is there a way to create mass user accounts in server 2008 standard edition?  Any help at all would save me alot of time thanks!
    Tuesday, October 13, 2009 4:44 PM

Answers

  • 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 by Kevin Remde Wednesday, October 14, 2009 4:30 PM
    Wednesday, October 14, 2009 10:29 AM
  • 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
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:47 PM
    Thursday, October 15, 2009 10:22 AM
  • Hello,
    Please see this valuable thread from Microsoft also http://support.microsoft.com/default.aspx/kb/327620
    ManuPhilip
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:47 PM
    Thursday, October 15, 2009 10:26 AM
  • Another answer for you is to use PowerShell.  There are several 3rd-party toolsets that you can add to PowerShell v1 in Server 2008, or you can upgrade to Server 2008 R2 and have built-in AD management/configuration PowerShell cmdlets.
    Kevin Remde US IT Evangelism - Microsoft Corporation http://blogs.technet.com/kevinremde
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:50 PM
    Wednesday, July 28, 2010 12:49 PM

All replies

  • 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 by Kevin Remde Wednesday, October 14, 2009 4:30 PM
    Wednesday, October 14, 2009 10:29 AM
  • 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
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:47 PM
    Thursday, October 15, 2009 10:22 AM
  • Hello,
    Please see this valuable thread from Microsoft also http://support.microsoft.com/default.aspx/kb/327620
    ManuPhilip
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:47 PM
    Thursday, October 15, 2009 10:26 AM
  • While effective, all user accounts are automatically disabled when imported with csvde. This is the one aspect which is not good, especially if you're creating a bulk user base.

    creating them in vbscript might serve more useful.

    Saturday, July 24, 2010 11:04 PM
  • Another answer for you is to use PowerShell.  There are several 3rd-party toolsets that you can add to PowerShell v1 in Server 2008, or you can upgrade to Server 2008 R2 and have built-in AD management/configuration PowerShell cmdlets.
    Kevin Remde US IT Evangelism - Microsoft Corporation http://blogs.technet.com/kevinremde
    • Marked as answer by Kevin Remde Wednesday, July 28, 2010 12:50 PM
    Wednesday, July 28, 2010 12:49 PM