Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

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

Avatar

Level 9

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?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@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

 

View solution in original post

9 Replies

Avatar

Community Advisor

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

 

Avatar

Level 9

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

Avatar

Community Advisor

@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

Avatar

Level 9

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 

Avatar

Community Advisor

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

Avatar

Employee Advisor

Please add a screen shot of your CSV here.

 

@Mario248 

Avatar

Level 9

Here is the CSV file

 

Mario248_0-1669618259361.png

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

Avatar

Correct answer by
Employee Advisor

@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

 

Avatar

Level 9

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