[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 668
  • Last Modified:

Is it possible to Create users in AD from an xls spreadsheet?

I work in a high school and every year we get about 400 new students. When I create the new user accounts in AD, is there a way to create the users in AD from an xls spreadsheet? It is very tedious making 400 accounts by hand and I want to avoid it if possible. Are there any tools or articles I can look at to see how to do this?

Thanks!
0
dsheltzel
Asked:
dsheltzel
1 Solution
 
Irwin SantosComputer Integration SpecialistCommented:
Here is a SystmProg solution from PAQ

You can use LDIDE...its very easy to use and can modify according to ur need..:-

With Video :-)
http://www.winstructor.com/videos/server2003/creating_user_accounts_automation.htm

***Quote***

Do you want to create a lot of User Accounts at one time?

Or perhaps you want to migrate a large list of User Accounts into your Active Directory Domain?

In Windows Server 2003, we use Active Directory Users and Computers to create User Accounts. A User Account is what Windows uses to identify and authenticate the user and grant them access to resources inside the domain.

User Accounts can also be used by Windows Services to allow the Service access to specific resources on the computer or network.

In this video we show you how to use LDIFDE to create user Accounts Automatically. LDIFDE is a command line utility that enables you to import a text file containing User Accounts. LDIFDE is incredibly flexible and powerful. Once you use LDIFDE, you'll wonder why you never found it sooner!

CSVDE is a utility similar to LDIFDE, except CSVDE uses a CSV file as the basis for importing new User Accounts. CSVDE is the weapon of choice for many as you can use the more flexible approach of importing a spreadsheet containing user accounts and have CSVDE do the work.

The DS Commands, consisting of DSADD, DSGET, DSMOVE, DSRM, DSQUERY and DSMOD are Active Directory commands that you can use to automate and manipulate User Account Creation and Modification. They are very powerful and show be part of every Active Directory Administrators Toolkit.

Finally, theres the good old NET USER command. This is a legacy command, but its still useful for pumping out a few quick User Accounts.

***End Quote***

Create User Accounts from Information in an Excel Spreadsheet
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting04132004.asp

USING WSH :-

***Quote***
Introduction - Creating new users with WSH
In active directory, when you need to create one or two users, Active Directory User's and Computers is the classic tool.  However, there may be times when you prefer to use WSH (Windows Scripting Host) to generate new user accounts.

WSH Topics
Creating a new OU
Creating a new user
Setting the password
Disabling the account
Instructions
Error Messages
Creating a new OU

http://www.computerperformance.co.uk/Logon/WSH_User.htm
0
 
Debsyl99Commented:
Hi dsheltzel,
This is worth checking out. Be careful to test scripts first and always ensure a good backup prior to running any against your ad.
Tutorial for Creating User Accounts from a Spreadsheet
http://www.computerperformance.co.uk/vbscript/vbscript_user_spreadsheet.htm

Deb :))
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now