Jump to content

Recommended Posts

Posted

I am a former Novell / Netware network administrator setting up a new Microsoft 2008 R2 domain this summer, and I need to create about 500 user accounts in the domain in the next two weeks.

Generally it appears that Microsoft does not offer a good way (with error and sanity checking) to read in users from a comma delimited list or from columns in an Excel spreadsheet.

Yes, there are various visual basic scripts on MSDN but they are without error checking, and if an error occurs, the scripts can barf all over the domain and screw things up, potentially leaving droppings here and there in the domain database.

I am resigning myself to the fact that if I want to automate this process and have protections against scripted failure or invalid field data, I am probably going to have to write a tool to do it myself, probably with AutoIT..

Or just do the account creation by hand.. which at 60 seconds per manual account creation, that would be 8.3 hours of extremely repetitive work. Bleah.

Posted (edited)

You could use the written by ProAndy to read the CSV file into a multi dimensional array.

To create a user use my Active Directory UDF, function _AD_CreateUser.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...