I want to transfer about 150 members from on Umbraco V4 (an old, serveral times upgraded, not very stable version) to another V4 installation (clean and fast).
Is there a tool for such thing? Which tables do I have to copy? Any SQL avail? ;-)
As far as I'm aware there isn't any export/ import for Members (there's nothing OOB I know that). You'll also have some problems if you want to write the SQL yourself, because of the primary key relationships, but these are the tables:
umbracoNode
cmsMember
cmsMemberType
cmsPropertyData
cmsPropertyType
cmsContent
cmsContentType
Or at least I think that's all of them. A member is very similar to Media and Document.
For importing data into your new Install you can use umbImport. You can use Sql server to import the members. Don't know if you have a lot of properties on the Membertype. If not it's easy. Just create the Membertypes and groups in the new install. Then Use umbimport to select data from the cmsMember table in the old DB and add the member to the groups/membertypes. If it has some properties use the steps above as the base an select the extra property data using the relations that Slace suggested.
I solved the problem writing a small C#-program which did the trick for me. First I added the neccessary Membergroups and Membertypes using the dashboard on my new installation. Then my program created all the needed tableentries on: umbracoNode, cmscontent, cmsmember, cmsMember2MemberGroup, cmsConentVersion, and cmsPropertyData - a hell lot of tables are involved in this. That way, after about 4 hours getting to know the DBs, 2 hours of programming, 1 hour of testing and about 10 sec runtime all my Members where copied.
@slace: cmsConentVersion is also needed because it maps the cmsPropertyData to an umbracoNode.
@richard: Watched your screencasts, looks quite promising, if you need to batch-import preformated data!
If someone needs help for a similar problem, just contact me - I'll see if I can help.
Which db-tables for members?
Hello,
I want to transfer about 150 members from on Umbraco V4 (an old, serveral times upgraded, not very stable version) to another V4 installation (clean and fast).
Is there a tool for such thing? Which tables do I have to copy? Any SQL avail? ;-)
I'm running Umbraco on MS-SQL 2005 I guess.
Thanx, Arnim.
As far as I'm aware there isn't any export/ import for Members (there's nothing OOB I know that). You'll also have some problems if you want to write the SQL yourself, because of the primary key relationships, but these are the tables:
Or at least I think that's all of them. A member is very similar to Media and Document.
Hi Arnim,
For importing data into your new Install you can use umbImport. You can use Sql server to import the members. Don't know if you have a lot of properties on the Membertype. If not it's easy. Just create the Membertypes and groups in the new install. Then Use umbimport to select data from the cmsMember table in the old DB and add the member to the groups/membertypes. If it has some properties use the steps above as the base an select the extra property data using the relations that Slace suggested.
Hope this helps you,
Richard
Thanx for yours answers,
I solved the problem writing a small C#-program which did the trick for me. First I added the neccessary Membergroups and Membertypes using the dashboard on my new installation. Then my program created all the needed tableentries on: umbracoNode, cmscontent, cmsmember, cmsMember2MemberGroup, cmsConentVersion, and cmsPropertyData - a hell lot of tables are involved in this. That way, after about 4 hours getting to know the DBs, 2 hours of programming, 1 hour of testing and about 10 sec runtime all my Members where copied.
@slace: cmsConentVersion is also needed because it maps the cmsPropertyData to an umbracoNode.
@richard: Watched your screencasts, looks quite promising, if you need to batch-import preformated data!
If someone needs help for a similar problem, just contact me - I'll see if I can help.
Greets, Arnim.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.