Modify Active Directory Users Properties/Attributes by Import CSV

ADManager Plus provides the ability to modify Active Directory user accounts by just importing a CSV file which contains the list of users and the corresponding attributes to be modified. This option can also be used to move multiple users from their current location /container (OU) to another.

While the modify users via CSV import feature allows you to move users who are located in different OUs ) in the domain, to the desired OUs(that is, if there are say 50 users being moved, all these users can be located in 5 different OUs and need not be from the same OU), the move users feature in 'Bulk User Management', allows you to move users who are located within any particular/specific OU to another OU.

To modify users via CSV import,

  1. Select the AD Mgmt tab.
  2. Click the Modify users link under CSV import.
  3. Import the CSV file and click OK.
    Note: If you wish to move user accounts using this feature, the CSV file must contain the OU name. That is, for the user accounts to be moved, the CSV file must contain the LDAP attribute 'ouName' as the header, and the target container (OU) as its value.
  4. This will list all users and their attributes.
  5. Click update to update the information in Active directory.
  6. Click the Update in AD button.
    Note:
    • If you select the attribute 'ouName' from the ones displayed, the user accounts will be moved to the new container (OU) that is specified in 'ouName' attribute.
    • If there is no such container in the Active Directory, as mentioned in the value for 'ouName' attribute, ADManager Plus will create a new container with the name specified in 'ouName', and then move the corresponding user accounts to this new container.
  7. In the Select Attributes Window that opens up, select the attributes that you wish to modify, specify the criteria to locate the desired user accounts and select the appropriate options in Advanced Options tab.

Know these Tabs:

Change Headers: Clicking on this will allow you to change the attributes (eg.given name to sn).

Update in AD:

A pop-up displays all the LDAP Attributes provided in your CSV. Select the ones that you wish to modify in the Active Directory, and click the "OK" button.

Click the "Show" link, and provide a Criteria to be used for locating the users accounts to be updated.

Match  Criteria for users in AD:

This option helps you to accurately locate the user accounts that you wish to modify by using any specific LDAP attribute or a combination of LDAP attributes, as needed.

To specify the attributes based on which you wish to locate the users, click the show link and select the desired attributes.

Eg:-

For example, consider that you have two users with the name "John Smith" in your office and you want to update one of them. This option helps to identify the correct 'John Smith' uniquely by providing one or more LDAP attributes which are specific to that user.

Advanced Options

The CSV import feature offers the following options which allow you to modify the user accounts exactly the way you need:

  • Append values: By selecting this option, you can append the values imported from the CSV file to the existing values of an attribute in AD. When this option is not selected, the existing values in AD will be replaced with the ones imported from the CSV file. This option is applicable only to the multivalued attributes.

  • Clear attribute value in AD if its value in CSV is empty: If this option is selected, the existing value of an attribute in AD will be cleared if the CSV file does not contain any value for it. If this option is not selected, the existing AD value will remain untouched if the CSV file does not contain any value for it.

Note:

First create a CSV with all the updated information and then start the process.

It is recommended to give a unique value attribute like samaccountname, distinguishedname, userprincipalname to the users

If Multiple users match the same criteria then the users names will be appended by numbers starting from the number specifies the users with same name but distinguishes them by number.

The modifications done on UserAccountControl attributes using CSV will be appended.

An example entry to modify the "department" and "telephone number" for group of users is given below:

givenName,samAccountName,department,telephoneNumber

MathewIles,MathewIles,Transportation,01455 882107

Emmanuelsam,Emmanuelsam,Transportation,01455 882108

Strongosky,Strongosky,Transportation,01455 882109

Sample CSV file