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!
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.
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?
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.
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
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
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
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
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
is working on a reply...