How to add easily 1500 users to the same Role

Monjoie Dominique asked on November 28, 2017 18:26


I have an Excel File with about 1500 UserUD and I allow them the same RoleID. I try to use the Import Toolkit to import all these records in the table cms_UserRole but I cannot find it anywhere.

What's the good way to proceed ?


All the best,

Correct Answer

Brenden Kehren answered on November 28, 2017 19:37

There is not an option to import into the CMS_UserRole table. Your best bet is to do a SQL statement or import to import those newly created UserID's with the RoleID into the table. As long as both UserID and RoleID are valid, it should work without an issue (done this several times).

0 votesVote for this answer Unmark Correct answer

Recent Answers

Zach Perry answered on November 28, 2017 18:48

This a one time thing, or something that should happen more often?

0 votesVote for this answer Mark as a Correct answer

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