Hi, Is there a way to upload a set of users (300+) in DNN. Of course, I can just populate the table Users, but, do I need consider something else? what if the password is encrypted, how can I uploaded?, exists a store procedure for taht, and what about the automatic role assignation?

Thanks,
Alfonso

Look on snowcovered. there are 2 user manager modules that do this well. I tried both - look at the DnnMasters module. I think it has what you are looking for.

User accounts are referenced in the following tables...

aspnet_membership
aspnet_users
users
userportals

On my blog site I do have a tutorial that shows you how to create a host user via SQL, to create a regular user you will need to do one thing differently and 1 additional step. 

That is, you will set the "IsSuperUser" field to 0 instead of 1.  You will also need to insert a record in the 'UserPortals" table for the specific user. 

Now, the downside to doing it this way is that you will need to copy the password from another account, therefore they will all be set to the same thing.  This might not be a big deal as you can use the forgotten password feature to get a new password e-mailed to the user.

---

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.


Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services