Unable to use Edit User groups by CSV in Adobe Admin console | Community
Skip to main content
Mario248
Mario248
Level 7
November 25, 2022
Solved

Unable to use Edit User groups by CSV in Adobe Admin console

  • November 25, 2022
  • 2 replies
  • 1542 views

When I use the "Edit User groups by CSV" option to add more groups, the bulk operation fails with the following error message: "Operation failed [row:2 column:3] xxx@xxx.com : Invalid entry". The email address I am providing is valid, and I am able to use the same email address when creatng groups manually.

 

No matter what email I used or if I did not enter any email, none of them worked. Do you know if this is a known issue or am I missing something?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by krati_garg

@mario248 

Haven't done hands on - but can you please check below link and validate the data you have entered for the User Group Admins. It is looking for following format:

Enter the admin email addresses and identity types in the User Group Admins field of the CSV row in the following (comma separated) format enclosed within single quotes:

'<identity type>-<email address>,<identity type>-<email address>...'

For example:

'Federated ID-test-account@acme.com,Enterprise ID-test-user@acme.com'

https://helpx.adobe.com/enterprise/using/user-groups.html#main-pars_header_1044465184:~:text=Enter%20the%20admin,user%40acme.com%27

 

 

 

Or it could be as simple as not copy pasting the data, but typing into CSV

 

2 replies

Jagadeesh_Prakash
Community Advisor
Jagadeesh_PrakashCommunity Advisor
Community Advisor
November 25, 2022

@mario248  I faced similar issue in one of my project and it is always recommanded to download the sample csv file which is available at admin console IMS. If you use the sample csv and fill in the details it will work for sure. Refer to below URL 

 

https://experienceleague.adobe.com/docs/experience-manager-learn/cloud-service/accessing/adobe-ims-user-groups.html?lang=en

https://experienceleague.adobe.com/docs/experience-manager-learn/foundation/authentication/adobe-ims-authentication-technical-video-understand.html?lang=en

 

    Mario248
    Mario248Author
    Level 7
    November 25, 2022

    I used the Adobe Admin Console sample file and made the changes, but I am still experiencing problems

      Jagadeesh_Prakash
      Community Advisor
      Jagadeesh_PrakashCommunity Advisor
      Community Advisor
      November 25, 2022

      @mario248 But It will show the error where exactly the file is breaking. Try doing it with one user and keep on increasing. Then you might get the exact issue

        krati_garg
        Adobe Employee
        krati_gargAdobe Employee
        Adobe Employee
        November 28, 2022

        Please add a screen shot of your CSV here.

         

        @mario248 

          Mario248
          Mario248Author
          Level 7
          November 28, 2022

          Here is the CSV file

           

          There is no option to add csv file hence attached screen shot

            krati_garg
            Adobe Employee
            krati_gargAdobe EmployeeAccepted solution
            Adobe Employee
            November 28, 2022

            @mario248 

            Haven't done hands on - but can you please check below link and validate the data you have entered for the User Group Admins. It is looking for following format:

            Enter the admin email addresses and identity types in the User Group Admins field of the CSV row in the following (comma separated) format enclosed within single quotes:

            '<identity type>-<email address>,<identity type>-<email address>...'

            For example:

            'Federated ID-test-account@acme.com,Enterprise ID-test-user@acme.com'

            https://helpx.adobe.com/enterprise/using/user-groups.html#main-pars_header_1044465184:~:text=Enter%20the%20admin,user%40acme.com%27

             

             

             

            Or it could be as simple as not copy pasting the data, but typing into CSV

             

              Terms & ConditionsAccessibility statement

              Loading footer...