Features:

• Easily bulk import Active Directory user accounts
• Automate user provisioning
• Includes CSV template
• Add or remove users to groups
• Supports a large number of attributes

Requirements:

• You need permission to create user accounts in Active Directory.
• The following headers are required in the CSV template. All other headers are optional.
  • SamAccountName = This will be the users logon name.
  • password = users password. Make sure it meets your password requirements.
  • givenName = First name
  • sn = Last name

How to Use the AD User Creation Tool

1. Click on User management > Import Users
2. Click “Download CSV Template”
3. Fill out the csv with the user details
4. The CSV requires the following headers, all other headers are optional.
   • SamAccountName = This will be the users logon name.
   • password = users password. Make sure it meets your password requirements.
   • givenName = First name
   • sn = Last name
5. Click Import options button if you need to change the following
   • Enable or disable the account (Enabled by default)
   • Force password change at next logon
   • Change name format to lastName, FirstName
6. Select your CSV file and click Run.

CSV Example below

Click here to download my example template.

Verify the Import (Optional)

A quick way to verify the accounts imported correctly is to use the export users tool.

You are not actually going to export anything but you can quickly preview accounts and their settings.

Click on Export Users and click Run (if you want to check users in a specific OU select the OU).

Now you can scroll through the list and verify all of the user fields are set correctly.

Supported Attributes List

Below is a list of attributes included in the template. The CSV headers are case sensitive and can be in any order. You can delete any columns from the template that you do not need.

Attribute Name (column headers)	Example Value	Description
sAMAccountName	test.user1	This is the users logon name
password	Fullb@@ller02#	The users password.
ou	OU=ADPRO Users2,DC=ad,DC=activedirectorypro,DC=com	The OU where you want to import accounts to.
memberof	it_wrk_admins,it_srv_admins	Adds users to groups. Separate multiple groups with a comma.
userPrincipalName	test.user1@activedirectorypro.com	The users user principal name.
givenName	Robert	The users first name
initials	RA	The users initials
sn	Allen	The users last name
displayname	Robert Allen	The users display name
description	IT staff	The description field in AD.
physicalDeliveryOfficeName	1st floor	This is the office field in Active Directory (General tab).
telephoneNumber	1-888-214-3802	This is the Telephone number field (General tab).
mail	robert@activedirectorypro.com	This is the E-mail field (General tab).
wwwHomepage	activedirectorypro.com	P.O Box field (Address tab).
streetAddress	123 W. EagleCrest LN	Street field (Address tab).
postOfficeBox	PO Box 1	P.O Box field (Address tab).
l	Springfield	This is the City field (Address tab).
st	MO	State/province field (Address tab).
postalCode	65802	Zip/Postal Code field (Address tab).
c	US	2-digit string value
profilePath	\file1\profiles\%username%	Profile path field (Profile tab).
scriptPath	it.bat	Logon script field (Profile tab).
homeDirectory	\file2\users\IT\%username	This is the home folder path (Profile tab)
homePhone	1-888-214-3802	Home phone (Telephones tab)
mobile	1-888-214-3802	Mobile number (Telephones tab)
ipPhone	1-888-214-3802	Ip phone (Telephones tab)
title	Network Manager	Job title field (Organization tab)
department	IT	Department field (Organization tab)
company	Active Directory Pro	Company field (Organization tab)
employeeid	12345	This is the employeeID attribute
employeenumber	1	This is the employeenumber attribute
manager	robert.allen	This will assign a manager to the user account. Use the managers logon name.
proxyAddresses	SMTP:test.user1@activedirectorypro.com, smtp:test.user2@activedirectorypro.com	This column will add additional proxyAddress to the user.

Add Additional Attributes

You can add additional user attributes to the CSV file, you just need to know the LDAP name. You can find the LDAP name by opening the attribute editor in Active Directory Users and Computers. You could also use PowerShell to list all user account properties.

To see the attribute editor you first need to enable the advanced features in Active Directory Users and Computer

Click view from the top menu then select advanced features.

Now when you open an account you will see the attribute editor tab.

The attribute editor screen will show you all the user LDAP properties.

Now just find the attribute name and add it to the CSV. For example, I want to add information to the other Home telephone section for users.

In the attribute editor, I see the name is “otherHomePhone”. I will add this to the CSV.

All done. That is how you add additional attributes to the CSV file to import with new accounts.

Schedule User Creation

You can use the built-in task scheduler to automate importing new user accounts.

1. Click on Scheduler.
2. Click on the Add button.
3. For the type select “Import new users”
4. Give the task a name.
5. Set the credentials.
   
6. Click Next
7. Set the schedule frequency. You can choose from Daily, Weekly or Monthly.
8. Click Next
9. Select your CSV template. Click the options button to change import options if needed.
10. Your task will now appear in the list.