You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: User transfer
Prev Next
You are not authorized to post a reply.

Author Messages
radhakrishan
Nuke Active Member
Nuke Active Member
Posts:27
09 Jan 2006 10:48 AM  

Hi,

Can you recommend a module for copying users registered in DNN2 running msaccess INTO DNN3 running SQL?

I'm in the process of upgrading and dont want to lose all my registered members.

 

Thanks.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
09 Jan 2006 11:25 AM  
Hello,

If I was approaching this I would open MSAccess and copy all of the data from the Users table and paste it into the Users table for my New installation of DNN (Using Enterprise Manager for SQL Server).

I would copy the data to a localhost installation so that you have a backup copy of all of your users and can test that you have transferred the data across correctly before attempting it on a live site.

I would double check that the passwords still work correctly and that you can login as various registered users.
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
radhakrishan
Nuke Active Member
Nuke Active Member
Posts:27
13 Jan 2006 8:45 AM  
I have copied all the users from DNN2 to xls file.

But which table I need to copy in DNN3 ? There a lot of tables with userxxx and aspnet_xxxx.

Do I need to copy to aspnet_membership table - > bcoz that has got password field in it ?
Or does it need to copied to 2-3 tables ??????

Also I haven't got DNN3 setup on my laptop, is it safe to copy live it on the server.

Any advice .....
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
13 Jan 2006 9:09 AM  
ok, I responded to this without double checking the DNN 3 table structure, the membership system changed from DNN 2 to DNN3 - the major thing is that passwords are now encoded. Because of this I don't know what to suggest and it will take me a couple of hours to research, so I would have a look at the links below for suggestions & request that when you find the answer to let us know so that we can share the information with the rest of the community.

I would not attempt anything that you are unsure of on your live server, it is just not worth the risk. Test it on a localhost install - get a localhost install setup, you will always find it useful for testing certain elements.

You may be able to find help with the bi4ce team that I interviewed at:
http://dnn.bi4ce.com/Forums/tabid/242/Default.aspx

They have a lot of experience with working with the dnn database & may have already solved this problem.

The other resource I would go to is the asp.net forums: http://forums.asp.net/90/ShowForum.aspx

Hope this gives you a starting point,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
26 Jan 2006 8:26 AM  
Following this up, I've just come across a module which covers exactly what you need:

BulkUser Import and Export

It's available at snowcovered, thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > User transfer


ActiveForums 3.7

Latest Forum Posts

Web.config Error by derpir
HelloI got this error, does this seem familiar to you? Can anyone say how to fix this error?Error 98...
No Access for me too by ristori
I suscribe for the magazine novembre 2008 13. I receive this ticket from Paypal : Prix de l...
How can I list our offices by country by bluehoops
Hi everyone!Apologies if this is a simple question, but it is driving me nuts.I run a small ISV and ...
RE: DNN Creative vs FireFoX V3 by DavidWSnow
It now looks like the error'ing extension is StumbleUpon and it effects FireFox on some, but not all...
Issue 39 Authentication by DavidWSnow
I was glad to see you address this topic. When LiveId was first added to DNN, I tried to implement i...
RE: (catalook) Itempane changes on product pages ?? by Vilaplana
Hi, I think the problem is been caused by your skin and not by Catalook itself.  In the main page, C...
Yahoo Answers by cdtguru
Hey, i was wondering if anyone knew of a module that would create a similar system to Yahoo Answers...
(catalook) Itempane changes on product pages ?? by Gaz35
Hi , hi , I don’t know if you can help me , here is the site in question http...
RE: Virtual Pc 2007 help by jeff@zina.com
You need to get the Virtual PC's network set up.  Might check the Virtual PC news group: http://www...
DNNCreative Just Keeps Getting Better by jeff@zina.com
Kudos on issue 39, the article on importing large quantities of data was both timely for me and spot...
RE: Videos by clippy
Hello from France My question is about the videos for beginners, and specially n° 3; I'm working...
skinning trouble by derpir
HelloI have uploaded a skin to my DNN-website, but I want to make som changes. I have made some chan...
RE: Column width in UDT by VickySwift
In case anyone else is looking for the answer to this, I have been able to add the headers back in b...
RE: search not working by jncraig
Did you either reindex the site to turn on the scheduled task to do it?
RE: Template Issue by jncraig
No, you need to install your custom modules before you use the template.
RE: error message in registration page by jncraig
I'm not sure that you can avoid them, short of rewriting the module.You might want to investigate Dy...
Template Issue by Bobbyjosephg
Hi,   Today I have come up with a problem with templates.I was successful in exporting a template an...
RE: search not working by sanju_k1421
I checked     host==>admin search  page   that is set both limits min //max  page     still i m n...
RE: error message in registration page by coder247
but how do I avoid the error messages provided by default in dnn?
RE: Style sheet does nothing by andorz
Oh. I was told to do that in my thread at the dotnetnuke.com forum. http://www.dotnetnuke.com/Commun...
AppTheory
RSS Feeds