Javik Posted August 14, 2011 Posted August 14, 2011 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.
water Posted August 14, 2011 Posted August 14, 2011 (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 August 14, 2011 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now