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

[Mario248]

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?

[Jagadeesh_Prakash]

@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-u...

https://experienceleague.adobe.com/docs/experience-manager-learn/foundation/authentication/adobe-ims...

[Mario248]

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

[Jagadeesh_Prakash]

@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

[Mario248]

Tried all possible options. Already tried with one row but still ended up the same error. Also tried with customer and adobe internal email but no luck 

[Jagadeesh_Prakash]

@Mario248 can you check if you have access to create and update users in IMS

[krati_garg]

Please add a screen shot of your CSV here.

@Mario248 

[Mario248]

Here is the CSV file

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

[krati_garg · Accepted solution]

@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%2...

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

[Mario248]

Thank you so much.'<identity type>-<email address>,<identity type>-<email address>...' worked