Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Manipulation of pages via SQL
Previous Previous
 
Next Next
New Post 7/15/2008 7:38 AM
User is offline JohnPL
20 posts
10th Ranked


Manipulation of pages via SQL 

Hello,

Is there a way to automate the production of a new page in DNN ?

As DNN seems entirely database driven it occurred to me that it is possible to build a new page purely via a SQL script to insert into SQL the new tabid and modules required via the 'Tab' tables, then to insert content into the HtmlText table.

Has anyone experience in this approach, or have any advice on how it might be achieved ?

Thankyou

John

 
New Post 7/15/2008 8:05 AM
User is offline Sebastian Leupold
14328 posts
www.deutschnetnuke.de
1st Ranked












Re: Manipulation of pages via SQL 

John,

this is possible for sure, but be aware, that the database interface is not an official programming interface and might be subject to change. I always suggest to use business layer objects instead.


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 7/15/2008 10:29 AM
User is offline Mitch Sellers
5575 posts
www.mitchelsellers.com
3rd Ranked




Re: Manipulation of pages via SQL 

I am with Sebastian on this one.

if you really need to automate page creation, create a module that uses the various API calls to create a tab, insert a module, etc.  This way if you upgrade at a later point in time, the code will still work, even if there are backend changes.


-Mitchel Sellers
MCITP, MCPD, MCTS
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Consulting Quotes, and DNN Technical Support Services

I reccomend 3Essentials for shared hosting and BaseCamp for project management
 
New Post 7/15/2008 10:39 AM
User is offline JohnPL
20 posts
10th Ranked


Re: Manipulation of pages via SQL 

Sebastian, Mitch,
Thankyou both for your inputs.

Can I read further on this - i.e. are the API calls documented ?

Regards
John

 
New Post 7/15/2008 10:44 AM
User is offline Sebastian Leupold
14328 posts
www.deutschnetnuke.de
1st Ranked












Re: Manipulation of pages via SQL 

sure they are documented - in source code ;-)

unfortunately the documentation team is still working on the API description.


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Manipulation of pages via SQL
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


The Forerunner Network
The Forerunner Network consists of a group of Dynamic Website & Interactive Membership Portal hosting services that are managed by Forerunner Communications. Our services span a wide range of markets and enable individuals, organizations and businesses to build and manage dynamic, interactive portals and websites.
The Forerunner Network
ZLDNN.COM
We provide commercial DotNetNuke modules.
www.zldnn.com
DNNhost Scandinavia
SUPER fast QuadCore DELL servers, MSSQL servers, DotNetPanel, daily backup, Check out our customers websites
DNNhost.dk

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP