English (United States) English (United Kingdom)
 
Thursday, March 18, 2010

Smart-Thinker DNN Forums
Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement. 

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service. We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.
 
 
  Forums  DotNetNuke  Simple SQL  Creating new DNN users via SQL?
Previous Previous
 
Next Disabled
New Post 11/4/2008 11:21 AM
Unresolved
  rocketTendon
1 posts
No Ranking


Creating new DNN users via SQL?  (United States)

First off... I really appreciate that somebody took the time to publish the SQL statements for various DNN tasks... just wanted to let you guys know that your time and effort is appreciated.

http://www.smart-thinker.com/DotNetNuke/Resources/SimpleSQL/tabid/267/Default.aspx

Has anybody ever tried to create a new user via SQL for DNN? I have a mySQL database (UBBthreads) that has 24,000 users... I've managed to port over the mySQL db to MS SQL via a linked server... but I am running into a wall with the aspnet_Membership stuff... passwordSalt, encrypted... etc... Any ideas?

Thanks in advance for your time.
 
New Post 11/5/2008 6:00 PM
  Rodney Joyce
3227 posts
www.DNNDir.com
1st Level Poster




Re: Creating new DNN users via SQL?  (Australia)

Thanks for the comments - glad it is helping someone!

 

I have never tried to create a new user via SQL but ultimately the core does this so it should not be too hard to find out how by checking the core code..

Maybe your time would be spent better using an importer? I have used Work Controls importer and you can run it on a SQL table (with your own queries) and it does all the hard work for you.

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
 Page 1 of 1
Previous Previous
 
Next Disabled
  Forums  DotNetNuke  Simple SQL  Creating new DNN users via SQL?
Top Threads Minimize
In the past 1 week, we have 2 new thread(s) and 3 new post(s)
The most popular thread has been Edit Events and Groups
The most active thread has been Edit Events and Groups
Print  

Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
© 2008 Smart-Thinker