A request for a tutorial. Export/Import users and roles.
Last Post 07/16/2010 7:15 AM by Joseph Craig. 4 Replies.
Author Messages
Mark ODonnell
Nuke Ace
Nuke Ace
Posts:41


--
07/13/2010 9:01 AM
    I was wondering if you guys would mind doing a tutorial for exporting and importing users and roles. I see a number of 3rd party modules available but I find it hard to believe this could not be accomplished with SQL (export/import), Excel, and XML. I am kinda stuck with 2 production websites and the new one has to inherit the users from the old one but I am unsure how to accomplish this without breaking my dnn install.
    Lee Sykes
    DNN Creative Staff
    Nuke Master VI
    Nuke Master VI
    Posts:4945


    --
    07/14/2010 9:51 AM
    Hello,

    Thanks for the suggestion, I will look into it
    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    07/14/2010 4:13 PM
    In the meantime, DNNMasters_MMS_PRO module is a nice module.  It paid for itself instantly.

    Joe Craig, Patapsco Research Group
    Complete DNN Support
    Mark ODonnell
    Nuke Ace
    Nuke Ace
    Posts:41


    --
    07/15/2010 8:45 AM
    A reply to my own thread because I wanted to share with you some of my findings. I tested the method below with a DNN test install of DNN 5.4.4 with 20 roles and 1000+ users and it seems to have worked fine. If your interested I have provided my intructions in the attached text file. I used several different tools, and free resources. Thanks! I look forward to a refined method, and one that does not required $$.
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    07/16/2010 7:15 AM
    Thanks for the information.  I have used John Mitchell's approach several times.  It does require some additional knowledge.  It would also be possible to extend that approach to add roles to the xml file and add code to the page to populate users in the required roles.  If you did that, you could avoid the SQL part.

    Joe Craig, Patapsco Research Group
    Complete DNN Support


    ---