Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Hassan Gilani 9 posts 29 karma points
    Jan 11, 2011 @ 12:04
    Hassan Gilani
    0

    Importing existing users from old site to Umbraco membership DB

    Hello Everyone,

    I've built a new website for my company using Umbraco and now I'm stuck with this task. We already have an old site and it has 3000 user logins. I must import all that user data to new site in Umbraco and make it work seamlessly. Being a newbie to Umbraco and also to ASP.net somehow, I don't have a clear idea how would I go about it. 

    Can anybody guide me in this regard? Do I need to create a new DB and link it to Umbraco? if yes, how? Or do I need to write some code to create users may be using CreateUser() method? 

    I'd really appreciate any guidance in this regard!

    Hassan

     

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Jan 11, 2011 @ 12:18
    Richard Soeteman
    0

    Hi Hassan,

    You can try CMSImport to import the data for you, the free version is limited to import 500 records at a time. Only thing is that your password is propably encrypted in you old system, when you import it in Umbraco you can set the passwordFormat="ClearText" on the  Membership nod in web.config. Then when the import is finishe you switch back to passwordFormat="Hashed" or whatever you had on the old system.

    <a

     

     

    dd name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="Another Type" passwordFormat="ClearText" />

    So to test you can use the Free edition of CMSImport, if you want to import 3000 members in one run you can buy a PRO license whics costs 99 euro.

    Cheers,

    Richard

     

  • Hassan Gilani 9 posts 29 karma points
    Jan 11, 2011 @ 12:50
    Hassan Gilani
    0

    Thanks Richard, 

    I'm looking into it and it seems quite promising. 

    Can we import all the columns from the old DB including address, custom fields, Tax numbers etc. and will umbraco recognize these in the member profile? 

    Regards,

    Hassan

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Jan 11, 2011 @ 13:08
    Richard Soeteman
    0

    Hi Hassan,

    Yes create a membertype in Umbraco, use a query, or view  that returns the member and profile data as a single table  and CMSImport lets you select columns from the old member database. Don't know how profile data is stored in the Asp.Net membership database so you might need a few joins.

    Cheers,

    Richard

     

  • Hassan Gilani 9 posts 29 karma points
    Jan 11, 2011 @ 15:50
    Hassan Gilani
    0

    Hi Richard,

    So I'm definitely going to try it out and if it works as intended then we're going to buy the Pro license for sure!

    Thanks for your help!

    Cheers,

    Hassan

Please Sign in or register to post replies

Write your reply to:

Draft