Hi,

I would like to create a new page from a template page using sql (to automate the page creation after a successful subscription). Does anyone have any idea if the sql (stored proc) exists for this, or have done something similar themselves?
Thanks
Anthony

You wouldn't want to do this in SQL as there is way too much going on. It's better to do this programmatically (in code). Take a look at this blog:

http://kemmis.info/blog/archive/200...pages.aspx

While I haven't read this carefully, and while it may be a tad out of date (that is, there may be more properties of the tabinfo object), this probably tells you at least 95% of what you need to know. You will have to figure out how to specify a template to use when creating the page. This isn't clear to me from my brief reading, but ... it you dig through the source code for the code that creates pages in the control panel, I'm sure that you can do it.

I also found this at dataquadrant.com:

How to Create a Page Programmatically in DotNetNuke
By Marian Dumitrascu on 7/30/2007 5:44 AM

This snippet of code shows you how to programmatically create a page (tab) in DotNetNuke 4.x from a template.
It is called from the context of a module, so we have access to some of the main objects of DNN framework, such as PortalSettings.
Few properties are copied from the current active page: TabPermissions, SkinSrc, ContainerSrc. With a little effort you can specify your own values, if these ones are not appropriate.

The most important point is the use of the page template. By default, DotNetNuke comes with one template that is adding a HTML module to the main ContentPane. This template is placed in “…\Portals\_default\Templates\ Default.page.template” file. It is a XML file and you can easily change it or clone it to create your own template.

'create new hidden page
Dim ctrTab As New DotNetNuke.Entities.Tabs.TabController
Dim objTab As New DotNetNuke.Entities.Tabs.TabInfo
Dim objActiveTab As DotNetNuke.Entities.Tabs.TabInfo
objActiveTab = Me.PortalSettings.ActiveTab
objTab.IsVisible = False
objTab.PortalID = Me.PortalId
objTab.TabID = Null.NullInteger
objTab.PortalID = PortalId
objTab.TabName = "Page Name"
objTab.Title = "Page Name"
objTab.Description = "Description"
objTab.KeyWords = ""
'we make it hidden this time
objTab.IsVisible = False
objTab.DisableLink = False
objTab.ParentId = -1
objTab.IconFile = ""
objTab.IsDeleted = False
objTab.Url = "N"
'get the same permissions as the current active page
objTab.TabPermissions = objActiveTab.TabPermissions
'get the same skin as the current active page
objTab.SkinSrc = objActiveTab.SkinSrc
objTab.ContainerSrc = objActiveTab.ContainerSrc
objTab.TabPath = GenerateTabPath(objTab.ParentId, objTab.TabName)
objTab.StartDate = Null.NullDate
objTab.EndDate = Null.NullDate
objTab.PageHeadText = ""
objTab.TabID = ctrTab.AddTab(objTab)
'create the page from our template
Dim xmlDoc As New System.Xml.XmlDocument
xmlDoc.Load(Server.MapPath(Me.Page.TemplateSourceDirectory & "/Portals/_default/Templates") & _
"\Default.page.template")
Dim objPortals As New PortalController
objPortals.ParsePanes(xmlDoc.SelectSingleNode("//portal/tabs/tab/panes"), _
objTab.PortalID, objTab.TabID, PortalTemplateModuleAction.Ignore, New Hashtable)

I will conclude that creating pages programmatically is not complicated in DotNetNuke, and can be useful in the process of custom module creation, when we want to save the admin user few extra steps.

Thanks for all the help and suggestions.
Anthony