Is there any way to do this? I have a couple of hundred page that I need to import from one server to another (including their taxonomy tags). How would I go about scripting this?

Thanks.

Mark

Thank you, Scott. I am not sure I did a good job of phrasing my question. The data is "structured" in the sense that these are pages in the source database and, as such, presumably all their elements are in the Tabs and related table. My problem is that I don't really understand a) the DNN schema or b) what scripting interfaces exist. Let me take an example...

Let's say I have a page on my source database that uses a specific module. That page is represented in the Tabs table and then there are various other tables that describe the module and where it appears on the page. If I just copy across the contents of the Tabs table then the module ID's referenced in that table won't be the same as those in the target database.

What I really need is some "import page" (and it's related content)-type API, so that this is all abstracted for me. Is that available?

I have also looked at the schema associated with taxonomy. I see the Taxonomy_Terms and Taxonomy_Vocabularies tables, for example. But, as yet, I can't see where a particular term is associated with a page.

In short, I'd love to find some "import page" API that does all this for me.

If I don't have that option then I am back to square one. For example, when you say "Generate the pages" do you mean manually (remember, I have a couple hundred)? Is there some API call that will at least create the basic page? Same for things like "Add text/html to each page". I am not sure how to go about this from a scripting perspective.

Thanks.

Mark

Thanks Scott. So, here's my basic problem. I am downgrading from DNN Professional to Community Edition. I have a ton of data (all the pages I mentioned, for example) in my Professional database and I need to get that into Community. So, I can't import a portal since that would assume Professional to Professional.

So, what I am looking for is some sort of mechanism to bring in the page data through script. I can export a page and (with a minor amount of editing of the resultant template to remove permissions that don't apply to CE) can then import through the UI. That obviously sets up I need across the Tabs and related tables. An import API would do just that.

Another way to tackle this is if I knew enough about the schema to import content directly (SQL -> SQL). But that assumes I understand how a page is represented across all the various tables (Tabs and its relationship to modules, content, etc). That seems like a more cumbersome approach.

So, my current thinking is that if I can export the pages through an API, then import through an API then I abstract all the schema implications. But I don't know where or how I script the export and import.

Thoughts?

Thanks.

Mark