Login
Register
09-09-2010

Resources for the DotNetNuke Community


Support this site

  Support forums  

You need to be logged in in order to post to this forums.
SearchForum Home
  DotNetNuke Development  Templates  bulk users uplo...
 bulk users upload directly into DB?
 
imgOfflineccflau
3 posts
Joined
2/15/2006

bulk users upload directly into DB?
Posted: 14 Mar 06 1:32 PM

we are migrating our sites into DNN4 from some non-DNN sites. therefore, we have 50,000+ users with username and password from the old site which must be imported into this new DNN's database. let's say we have all the necessary parameters, and for passwordformat we are using 'clear'(plain passwd store in DB), is that possible just to do a bunch of insert statements into all user related tables for these 50000+ users?

what tables should have data insert: i identified about 4 aspnet_* tables and 1 Users tbl and 1 UserRoles tbl. i added respective info in all 6 of these tbls but when using the username/passwd to logon, it fails.., what exactly did i do wrong?

please advise.

imgOfflinednnjungle
151 posts
5th
Joined
3/13/2005

Re: bulk users upload directly into DB?
Posted: 15 Mar 06 1:36 AM
This is not as simple as just storing the users there since the aspnet_ table have some fields that are build by the membershipprovider (password hash, salt, ...)

You can take a look at how dnn creates a user and write yourself a utility to do that bulk import or you can try some of the modules out there that just do that. Search for it on snowcovered.

Disgrafic.com
  DotNetNuke Development  Templates  bulk users uplo...
© Vicenç Masanas Terms Of Use Privacy Statement   
.