By Lee Sykes
June 2008
In this tutorial we demonstrate how to administer Skins and Containers in DotNetNuke through the use of SQL queries.
In particular we demonstrate how to change the container of a module displayed on all or several pages, how to change the container of a module to a new container based on the name of the old container, and how to change the skin of a page to a new skin based on the name of the old skin.
The techniques used in this tutorial are especially useful when re-skinning an existing site and will save you a lot of time. Using SQL queries instead of logging in as an administrator and manually updating the settings for skins and containers can literally reduce days of work into seconds.
Tutorial References
Introduction to using SQL queries with SQL Server Express and DotNetNuke
The videos contain:
Video 1 - How to Change Module Containers Using SQL
- Introduction
- How to change the container of a copied module which is displayed on all or several pages
- How to identify the Module ID of module
- How to change the container of a module
- How to view all of the copied instances of a module from several pages using a SQL query
- How to use a ‘SELECT’ query to find a modules settings from a specific page
Time length: 8min 14secs
Video 2 - How to Change Module Containers Based On The Container Name Using SQL
- How to use an ‘UPDATE’ query to change the container of all instances of a copied module from several pages
- How to create a test page
- How to view the module settings data of all modules on a page using SQL
- How the change the container of a module based on the name of the old container
Time length: 8min 26secs
Video 3 - How to Change a Page Skin Based On The Skin Name Using SQL
- How to create a test page
- How to view the data from the Tabs table
- How to view the page settings for a page using SQL
- How to change the skin of a page to a new skin based on the name of the old skin
Time length: 7min 10secs
Total time length: 23min 50secs