DNN Tutorials for Administrators

This tutorial demonstrates the steps to create a printable view of your web pages, so a user can simply go to the file menu in their browser window and select print. This presents the user with a printable, user friendly, readable page.

The tutorial shows you how to create a print stylesheet for your DotNetNuke skin, how to format the layout of the print stylesheet, how to change the text font so that it is suitable for reading when printed out, how to set the width of the stylesheet, how to format links, and also how to display the full URL of a link next to a text link so that it can be viewed on the printed page. Finally, we demonstrate how to select which content to make available for printing and how to remove content not required for printing, this is an essential technique for removing elements such as the menu and login links which are not required for a printed page.

The videos cover:

• Video 1 - Introduction, Considerations, Setup
• Video 2 - Current Print Preview, Creating the Print CSS
• Video 3 - Remove Elements from the Printed Page
• Video 4 - Repositioning the Content, Removing Content Styling
• Video 5 - Styling the Content Pane, Re-styling the Headings
• Video 6 - How to Style Links for the Printed Page
• Video 7 - Styling Unordered lists, Method Two for Print Stylesheets using Javascript

Total Time Length: 50mins

The CSS reference book is a special 112 page resource to help you learn how to use CSS for your DotNetNuke skins.

The CSS reference book demonstrates all of the currently supported CSS properties used within CSS 2.1.

The book comes in pdf format, so this makes it easy to quickly search for a CSS property and find the information you require, complete with examples and images.

Dark Ritual is a free, tableless, fixed width, XHTML compliant website. This skin comes with 2 layouts in 2 versions:

• Index 3 pane skin with text header
• Index 3 pane skin with logo
• Admin 1 pane skin with text header
• Admin 1 pane skin with logo

It also comes with 3 containers:

• h1 title
• h2 title
• transparent, no title container

Lazy Days is a free, tableless, W3C-compliant website design.This skin comes in 3 variations:

• index – a 2 pane fluid skin
• index_sub_menu - a 2 pane fluid skin with a sub menu
• 1 pane – a 1 pane fluid skin, suitable for the administration area in DotNetNuke

It also comes with 6 containers:

• h1 title gradient
• h1 title
• h2 title gradient
• h2 title
• h3 title
• transparent no title
  

Zenlike 1.0 is a free, lightweight, tableless, fluid W3C-compliant website design. This skin comes in 2 different types:

• index_with_logo - uses the logo from the admin menu / site settings
• index - uses text for the site header which you can edit in the skin files

It also comes with 5 containers:

• h4 title box
• h4 title no bot line
• h4 title with bot line
• top pane h3 title
• transparent no title

Bitter Sweet is a free, tableless, fixed width, XHTML compliant website design. This skin comes with 2 layouts in 2 versions:

• Index 2 pane skin with text header
• Index 2 pane skin with logo
• Admin 1 pane skin with text header
• Admin 1 pane skin with logo

It also comes with 3 containers:

• h1 content pane
• h2 right pane
• transparent, no title container

Greenery is a free, tableless, W3C-compliant website design. This skin comes with 3 variations

• greenery – index (main skin)
• greenery – index_submenu (main skin with a sub menu in the right pane)
• greenery – admin (single pane skin for use with admin pages)

It also comes with 2 containers:

• h1 title
• transparent, no title container 

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 videos cover:

• Video 1 - How to Change Module Containers Using SQL
• Video 2 - How to Change Module Containers Based On The Container Name Using SQL
• Video 3 - How to Change a Page Skin Based On The Skin Name Using SQL

Total Time Length: 24mins

In this tutorial we demonstrate how to use the SQL core DotNetNuke module.

This module is only available to the host user on your DotNetNuke installation and it allows you to execute SQL queries and scripts from within your DotNetNuke installation.

Although we thoroughly recommend you use SQL Server to build and check your queries, the DotNetNuke SQL module is useful if you already have a good understanding of using SQL within your DotNetNuke installation.

The video covers:

• Introduction
• How to access the DotNetNuke SQL Module
• Overview of the SQL Module
• How to load a SQL file into the DotNetNuke SQL Module
• How to edit and execute a SQL query in the DotNetNuke SQL Module

Time length: 5mins

In this tutorial we demonstrate how to quickly administrate modules on a page through the use of SQL queries.

We demonstrate how to move and delete modules from one content pane to another using several techniques and introduce you to using ‘SELECT’, ‘UPDATE’ and ‘DELETE’ SQL queries.

Following this we demonstrate how you can use SQL queries to copy existing modules to a page. This is for modules that are not set to display on all pages, and is the equivalent of using the admin control panel and selecting ‘Add Existing Module’.

The videos cover:

• Video 1 - Introduction, Deleting Modules Using SQL
• Video 2 - Deleting Modules from a Page, Moving Modules to a New Content Pane in a Page
• Video 3 - How to Move Modules on All Pages to New Content Panes
• Video 4 - How to Copy an Existing Module to a Page using SQL
• Video 5 - Using 'INSERT' queries to Copy Modules

Total Time Length: 35mins