Thursday, January 08, 2009     | Register
To start or answer a thread you will need to login...


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 12:21 PM
Unresolved
  rocketTendon
1 posts
No Ranking


Creating new DNN users via SQL?  (N/A)

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 7:00 PM
  Rodney Joyce
3064 posts
www.DNNDir.com
1st Level Poster




Re: Creating new DNN users via SQL?  (N/A)

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
 
Previous Previous
 
Next Disabled
  Forums  DotNetNuke  Simple SQL  Creating new DNN users via SQL?
Top Threads
In the past 1 week, we have 23 new thread(s) and 61 new post(s)
The most popular thread has been Re: Sponsored Enhancement Proposal Estimate - StoryFeed Commenting
The most active thread has been accept Friend Request?
Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
© 2008 Smart-Thinker   |  Privacy Statement  |  Terms Of Use