Issue description   

When attempting to modify a user's manager using a CSV file in ADManager Plus, you may encounter the following error message:

"All values for the manager attribute given in the CSV could not be found in AD. Values for the manager attribute must be specified in DN format or mail or displayName. Please provide the samAccountName, displayName, mail, distinguishedName, employeeID, or employeeNumber for the manager attribute."

Possible causes   

1. Non-unique value used  : The technician used a non-unique value in the Manager column of the CSV file.

2. Missing or invalid attribute  : The specified manager attribute value is either empty or does not exist in AD.

3. Incorrect format  : The manager's name was entered incorrectly or in an unsupported format.

Prerequisites   

• Ensure that the manager exists in AD.

• Use one of the following unique identifiers for the manager in the CSV file:

• samAccountName

• mail

• distinguishedName

• employeeID

• employeeNumber

Resolution   

Step 1: Verify the manager’s information in ADManager Plus  

1. Log in to ADManager Plus as an admin.

2. Navigate to Reports > User Reports > All Managers Report.

3. Locate the intended manager’s account.

4. Verify that one of the supported attributes (samAccountName, mail, distinguishedName, employeeID, or employeeNumber) is correct and unique.

Step 2: Format the CSV file correctly  

• Open your CSV file and ensure the Manager column contains values in one of the accepted formats.

• Example of a correctly formatted CSV file:

sAMAccountName,Manager
jdoe,john.doe@company.com
asmith,12345678
bwilliams,CN=John Doe,OU=Managers,DC=company,DC=com

Step 3: Reimport the CSV file into ADManager Plus  

1. Log in to ADManager Plus.

2. Navigate to Management > User Management > Modify Bulk Users.

3. Upload the CSV file and click Next.

4. Click Apply Changes and verify the update.

Tips 

• To streamline this process, consider configuring your access control matrix within modification templates. This approach allows you to easily update user permissions and ensure that they have the appropriate access based on their new department and manager. For more details, refer to the user modification rules.

How to reach support