Import Users

User Import is a feature available in EUM 6.0.8185.1 and newer. To use this feature one must have access to

1. EUM Config site in SharePoint
2. EUM Resource Group in Azure Portal

The User Import must be configured before this could be used. To set it up please follow the article Setup User Imports

Once User Import is configured, please follow the below steps to Import Users

For EUM 6.0.8185.1 to 6.0.8460.2

For EUM 6.0.8531.1 and above

For EUM 7

You might want to refer How to determine installed EUM V6 Version

For EUM 6.0.8185.1 to 6.0.8460.2

1. Fill up the User Import Excel in EUM Configuration Site

1. Navigate to EUM Config Site. Please refer to the related FAQ Finding the EUM Config SharePoint site
2. In the EUM Configuration Site click the "User Imports" under "User Manager"
   
3. Click to open the User Import.xlsx
   
4. Edit the excel. Fill in all the Required Items:
   1. Column B "Status" should remain "Ready for Import"
   2. Column C "Object ID" should be blank
   3. Column D "Email" should have the email of the user to be imported
   4. Column E and F should have the "First Name" and the "Last Name" of the user to be imported
   5. Column G should have the "Display Name"
   6. Column H may contain the EUM Group names, comma separated. These are the groups the imported user is intended to be a member of. These groups must already be present in EUM.
   7. All other columns with <Optional> value can either be filled, or left blank
   8. The file will automatically save
      

2. Run the "eum-admin-user-import" Logic App

1. Login to EUM Admin
2. Click "Azure AD" in the left hand menu
3. Click "Resource Group" under "App Services"
   
4. In the Resource Group lookout for "eum-admin-user-import" Logic App and click to open it
5. Click "Run Trigger" to run the Logic App
   
6. This will import the users and place these under the specified groups

For EUM 6.0.8531.1 and above

1. Navigate to the EUM Config site. Please refer to the related FAQ Finding the EUM Config SharePoint site
2. In the EUM Configuration Site click the "User and Group Import" under "User Manager"
   
3. Click Import Files under User Import
   
4. Click to open the User Import.xlsx
   
5. Edit the excel. Fill in all the Required Items:
   1. Column B "Status" should remain "Ready for Import"
   2. Column C "Object ID" should be blank
   3. Column D "Email" should have the email of the user to be imported
   4. Column E and F should have the "First Name" and the "Last Name" of the user to be imported
   5. Column G should have the "Display Name"
   6. Column H should have TRUE if the users created must have the Account Enabled
   7. Column I may contain the EUM Group names, comma separated. These are the groups the imported user is intended to be a member of. These groups must already be present in EUM.
   8. All other columns with <Optional> value can either be filled, or left blank
   9. The file will automatically save
      
6. Go back to the User Manager / User Imports page in EUM Config site and click Import
   
7. This will redirect you to the EUM Admin and display a confirmation message
   

For EUM 7

1. Login to EUM Admin and navigate to Users
   
2. Click Import Template to download the User Import Template
   
3. This will download an excel. Open the excel and click Enable Editing in the top near the tool bar
   
4. Fill up at minimum the Status, Email, User Status, First Name, Last Name, Display Name
   
   
   1. Status: This should be Ready for Import so a fresh user can be imported
   2. Email: This would be the email of the user to be imported
   3. User Status: Options are
      1. Active
      2. Disabled
      3. Pending Approval
      4. Rejected
   4. First Name: This would be the First Name of the user to be imported
   5. Last Name: This would be the Last Name of the user to be imported
   6. Display Name: This would be the Display Name of the user to be imported
5. Do not fill in anything in the Error Details, or in the cells highlighted grey
6. If Groups imported users are to be added to groups, the Group ID (Object ID of the Group)should be put in the Groups column. For multiple groups, these Group IDs are to be put in separated by a space
7. Save the excel once ready
8. In EUM Admin Users page, click Import Users (This button did not work?)
   
9. That would take you to the EUM Config site User Manager User Imports Document Library
10. Drag and drop the save excel there
    
11. Click the Import button beside the excel to start the import process
    
12. That would take you back to the EUM User Import page. Follow the instructions and click the Import button on top of the page. That would start the User Import process.
    

Related Articles:

Bulk Delete Guest Users using User Import excel

Import Users Button in Users page not working in EUM v7