![]() ![]() ![]() |
|
Note: The following information conveys the mandatory and useful guide lines for successful creation on users by importing from CSV List of LDAP attributes supported. Sample CSV file. |
Bulk user creation by CSV
To create a user, any one of the following naming attributes is mandatory and enough: givenName or cn or name or samAccountName.
To mention the user's OU in the CSV : In case you want to create users under different OUs, mention the user's givenName, followed by the OUName in the CSV file. Example: John, "OU=FinanceOU, DC=abc, DC=com"
In case you want to create a user in a child OU, here's a sample of the values that need to be supplied in the CSV file. Example: John, "OU=PayrollOU, OU=FinanceOU, DC=abc, DC=com". In this example, PayrollOU is the child OU and FinanceOU is the parent OU.
To have Useraccountcontrol attribute
in CSV : Useraccountcontrol should contain the flag value of
the user account properties. Example: A flag value 512 indicates that
the account is general; and value 514 indicates that the account is disabled.
For detailed information, click http://support.microsoft.com/kb/305144
While specifying the password you will be prompted to choose one of the two options:
Selecting the option User must change password at next logon will assign a value 0; to pwdLastSet
Unselecting the option, User must change password at next logon will assign a value -1 to pwdLastSet
To have memberOf attribute in CSV : A user can be a member of more than one group, to support multiple values Distinguished Name (DN) of the groups should be separated by semicolon (;). Example:"CN=Group1,CN=Users,DC=domain,DC=com;CN=Group2,CN=Users,DC=domain,DC=com"
To have primaryGroupID attribute in CSV For a user in multiple
groups only one group is considered as primary; to specify that RID should
be assigned.
AccountExpires: While specifying the account details, you will be prompted to choose one of the two options:
Selecting the option Account Never Expires will assign a value 0 to Accountexpires.
To have a expiry date set a date specify the file time. Other values should be in the FileTime format(Contains a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC).)
To have userWorkstations attribute in CSV To restrict users to specific computers the NEtbios names of computers separated by (,) should be entered and all values should be in
To have 'Country' attribute in CSV
The three values c, co, countryCode are mandatory.
c - 2 letter country code (eg. US for United states).
co - Country Name(Full Country Name).
countryCode - 3 digit country code(eg. 840 for United States).
To have manager attribute in CSV: CSV should contain the DN of the manager.
To have MailBox Enabled Users attribute in CSV: CSV should have
Minimum Attributes Needed - mailNickame, homeMDB, msExchHomeServerName.
homeMDB - should contain the DN of the mail box store.
msExchHomeServerName - value of mail server in legacyExchangeDN Format.
To have Mail Enabled Users attribute in CSV: CSV should have
Minimum Attributes Needed - mailNickname, targertAddress, msExchAdminGroup
targertAddress - value should be something like(SMTP:user@yahoo.com)
msExchAdminGroup- value of exchange Admin Group in legacyExchangeDN Format.
To have attributes Home Folders and Profile Path, TS Home Folder, ProfilePath in CSV
The values can be an absolute path of the folder
May contain variables like %userName%, %givenName% etc..
To have Additional email address
The user should have
the attribute 'proxyAddresses' set to a value.
Example - "smtp:user@mail1.com;smtp:user@mail2.com"
To have Additional Attributes
Select the 'Additional
Attributes' tab to add custom attributes. Enter the exact Attribute
name and value.
Example: If you wish to have Employee Id Number in user attributes,
then enter 'Employee Id Number' as the Attribute name and enter the value.
This will add that attribute in to the user account properties and the
information can be obtained from Reports.
User creation by Template
A user can be created by selecting the predefined templates available in the option "selected Template"
By selecting a template, all the properties of the template will be applied to the users being created.
By clicking in 'change' you can change the template from mail enabled users to mailbox enabled users etc.
A set of users with common properties can be created by using the specific template. Creating user template
Example: If your intention is to create user accounts with mailbox for permanent employees, you can select the template 'MailBox Enabled Users' and start creating accounts. All the users created eventually will bare the same properties. The below example is to create a simple user:
givenName,sn,samAccountName,password,memberOf,telephoneNumber,department,profilePath,homeDirectory,homeDrive,managedby james,smith,jamessmith,Password@123,"CN=group1,OU=Finance,DC=admp,DC=com;CN=Group2,OU=Sales,DC=admp,DC=com",+1-980-765-1234,accountant,"\\admp-dc1\UserProfile\%givenName%","\\admp-dc2\HomeFiles\%displayName%","E:","CN=Manager,OU=Finance,DC=admp,DC=com" james,william,jameswilliam,Password@123,"CN=group3,OU=HR,DC=admp,DC=com;CN=group4,OU=US,OU=HR,DC=admp,DC=com",+1-980-765-1234,HumarResoruce,"\\admp-dc1\UserProfile\%givenName%","\\admp-dc2\HomeFiles\%displayName%","G:","CN=Manager,OU=HR,DC=admp,DC=com" |
The below sample is for creating mail-enabled users:
givenname,displayname,password,msexchadmingroup,targetaddress,mailNickname james,Smith James,Password@123,"/o=First Organization/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)","smtp:jamessmith@admp.com",james1 james,William James,Password@123,"/o=First Organization/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)","smtp:jameswilliam@admp.com",james2 |
The below sample is for creating a mailbox enabled user:
givenname,displayname,password,mailNickame,homeMDB,msExchHomeServerName,proxyAddresses,msExchRequireAuthToSendTo,targetAddress,msExchRecipLimit james,Smith James,Password@123,jamessmith,"CN=Mailbox Store (EMP-EX03),CN=First Storage Group,CN=InformationStore,CN=EMP-EX03,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=First Organization,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=admp,DC=com","/o=First Organization/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=EMP-EX03","SMTP:jamessmith@admp.com",true,"smtp:jamessmith@ymail.com",999 james,William James,Password@123,jameswilliam,"CN=Mailbox Store (EMP-EX03),CN=First Storage Group,CN=InformationStore,CN=EMP-EX03,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=First Organization,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=admp,DC=com","/o=First Organization/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=EMP-EX03","SMTP:jameswilliam@admp.com",true,"smtp:jameswilliam@gmail.com",999 |
|
Note: First create a csv with all the updated information and then start the process. |
![]() ![]() ![]() |