Importing Roles

Oct 26, 2011 at 2:23 PM

This looks like a great tool. Thanks for posting - been looking for a while. I've got more than 4000 users to import!

I haven't looked at the source, not that experienced with it and only use VS Web Developer Express 2010.

Would it be possible to import User Roles. I have two groups of users all obviously must be registered users, but they could belong to one or both of two Roles.

Thanks
Richard

Dec 10, 2013 at 7:59 PM
Edited Dec 10, 2013 at 8:00 PM
I used a script like this:
INSERT INTO [dbo].[dnn_UserRoles]
           ([UserID]
           ,[RoleID]
           ,[ExpiryDate]
           ,[IsTrialUsed]
           ,[EffectiveDate]
           ,[CreatedByUserID]
           ,[CreatedOnDate]
           ,[LastModifiedByUserID]
           ,[LastModifiedOnDate]
           ,[Status]
           ,[IsOwner])
     SELECT UserID, 5, Null, 1, Null, 1, GetDate(), 1, GetDate(), 1, 0
     FROM DNN_Users
So above the role is a #5. I added an existing user to an existing group and viewed the UserRoles table to see what the user got as a new role assignment and voila.
Coordinator
Jan 13, 2014 at 8:14 AM
Edited Jan 13, 2014 at 8:15 AM
Advanced version of module allows to import/export roles, profile properties as well. https://usersexportimport.codeplex.com/