Umbraco Database

cotton31

cotton31

cotton31

Associate
Joined
25 Feb 2007
Posts
905
Location
Midlands
I need a way to insert data into Umbraco's database.

Basically, we already have a bespoke CMS powering our site but want to migrate to Umbraco - I need to pull all the content out of the current CMS and insert it into Umbraco.

Having looked at the database, it doesn't look as though the content is stored in there :confused: is that right?

Alternatively, if anyone has a better way of doing this, let me know! :D
 
Content is stored in various tables in the database. dbo.cmsxxx.
The properties are stored in cmsContentXml, and is stored as XML.

You'll need to construct the XML string for each page yourself:

<node id="111" version="r6ec1b07-132e-48ac-8e6b-e1a11dcd1532" parentID=11 level="2"
writerID="1" creatorID="0" nodeType="1083" template="1" sortOrder="1"
createDate="2010-06-09T09:21:46" updateDate="2010-09-22T10:52:19"
nodeName="Page 1" urlName="page-1"
writerName="admin" creatorName="admin" nodeTypeAlias="template+1" path="-1,11,111">
<data alias="bodyID">exhibitions</data>
<data alias="bodyText"></data>
<data alias="metaKeywords"></data>
</node>

How complex is the data you are trying to import?
I think there are Umbraco plugins that you can get to assist with data import
 
Not very complex, I don't think constructing the XML string myself would be that difficult.

However, I don't seem to have any tables which are prefixed with cms!

I only have ones prefixed with Attribute and Node and one called Locale.

These all live in a database called umbraco - is there an additional database?

I'm a bit in the dark as I didn't install it!
 
If it's an umbraco database, you will have tables prefixed cms.
What version of Umbraco is it?

You should be able to find this out by logging into the cms and clicking the about button
 
to get into the admin site of umbraco, you need to go to {your-site-url}/umbraco/umbraco.aspx and then logon.

It might be that you have not yet set up a site, which is why the tables are missing. It "should" take you though a setup wizard.

Otherwise, I'd suggest downloading it again from http://umbraco.com/download.
Click on the "install using Microsoft webplatform installer link"

EDIT: Just saw you said Version 5 (I read it as Visual studio).
I've not used V5 yet, so I don't know it's data structure.

We made a decision in our team to wait until V5.1 at the earliest before using it for any commercial sites, as there are always issues with major releases
 
Last edited:
Right Ok, so the demo site doesn't have the tables our real site will have?

That would make sense as we haven't started moving our site yet, I was just investigating moving our data!
 
cotton31 said:
Right Ok, so the demo site doesn't have the tables our real site will have?

That would make sense as we haven't started moving our site yet, I was just investigating moving our data!
Click to expand...

No. I think Version 5 has a completely different data structure, hence you seeing the missing tables.

The Demo site is still a fully functioning site.
 
You must log in or register to reply here.
Back
Top Bottom