How to assign the multiple specific roles in single user via Bulk User Upload?

Ramakrishnan G asked on September 3, 2019 10:46

In kentico 10 we using bulk user upload from excel, the field name is Username, Email, fname, lname, Role1, Role2 and Role3. The user will be insert working fine.

Recent Answers


vasu yerramsetti answered on September 3, 2019 12:25 (last edited on September 3, 2019 12:42)

Please follow below steps

  1. Read user data from excel
  2. First insert roles into Roles object (CMS_Role) and get role ID and hold it for Step 6
  3. Insert user into User object (CMS_User)
  4. Insert user into User Settings object (CMS_UserSettings)
  5. Add user to website (CMS_UserSite)
  6. Add role to user (CMS_UserRole)
0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on September 4, 2019 06:30

Check the duplicate question and provided answer. Your last statement was simply that "it didn't work". That doesn't provide any details or direction. What didn't work or what's not working? You need to provide more detail before anyone can help.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.