How to Limit Access to Administrator Modules in DotNetNuke 5

In this tutorial we demonstrate how to setup a limited DotNetNuke administrators access account. This option is only available from DotNetNuke version 5 onwards where the administrator modules can now be added to any page and configured for any user to access and use the features of the administrator modules.

The videos contain:

• Video 1 - Introduction, Configuration of Admin Page and Admin User
• Video 2 - How to Create a Security Roles Page for Members of Staff
• Video 3 - How to Configure User Accounts, Console and Newsletters Modules
• Video 4 - How to Configure the FileManager Module
• Video 5 - How to Configure the Tabs Module

Total Time Length: 42min 10secs

View: How to setup a limited DotNetNuke administrators access account

11 DotNetNuke Video Tutorials - Professional DotNetNuke Administration using SQL (Part 2)

DNN Creative have released issue 33 of the DotNetNuke Magazine.

This month we are dedicating another full issue of DNN Creative Magazine to improving the efficiency of your administration time with DotNetNuke using SQL queries.

The SQL methods we show you in this issue are very powerful techniques which will reduce weeks of work into seconds. The tutorials are especially useful if you are re-skinning a large DNN installation.

To start with we show you how to update the Page Settings of a page using SQL queries.

We demonstrate how to use SQL queries to delete a group of modules from a page, move modules between content panes and insert a copy of a module to a page. Manually moving, deleting and inserting modules when re-skinning your DotNetNuke installation can take up to 10 minutes per page, for a 500 page website this would take 5000 minutes. Using SQL queries will allow you to apply changes across your entire site within seconds.

We then take a look at the DotNetNuke SQL Module. This module comes free with Dot Net Nuke and is only available to the host user on your DotNetNuke installation. Although we thoroughly recommend you use SQL Server Express to build and check your queries, this module is very useful if you already have a good understanding of SQL queries.

Finally, we show you how to work with Skins and Containers in DNN using SQL queries. In the previous tutorials we demonstrated how to change a container on a single page, in this tutorial we show you how to change the container for a copied module that is displayed on several or all 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.

Using the techniques outlined in this issue will literally save you weeks of work.

Shadow Modules in DotNetNuke using SQL

DNN Creative Magazine is still in the land of SQL!

As I mentioned earlier in the blog, we have been responding to enquires from readers on how they can update DotNetNuke websites more efficiently.

So another tip we would like to share with you, that will save you lots of time, is how to use Shadow or copied modules.

Shadow or Copied modules can be used to update the same content on several pages from one central area. In issue 32 we demonstrate how to setup a shadow page which contains modules that are displayed on several pages across our Dot Net Nuke portal. From this one central shadow page we can administer the content of several modules at once.

We also show you how to use SQL queries to easily maintain these copied modules, including re-ordering the modules in a content pane across all pages in a DotNetNuke portal, updating the container of a module copied across several pages and how to update the container of a module based on the name of the current container the module is using.

If you were to try and manually update copied modules across a large DNN portal, it would more than likely take weeks of work. With the powerful SQL techniques shown in this tutorial you can apply the updates in seconds.

Here is a short list of what the tutorial covers:

Video 1 - Introduction, Shadow Modules, Add Existing Module
Video 2 - Copy Module to All Pages and Reordering Modules
Video 3 - SQL Queries to Update the Module Order in Content Panes
Video 4 - How to Update the Container for All Shadow / Copied Modules in a Portal Using SQL
Video 5 - Using SQL to Update a Module Container to a New Container Based on the Name of the Old Container

11 DotNetNuke Video Tutorials - Powerful Efficient Techniques for DotNetNuke Administration using SQL

DNN Creative have released issue 32 of the DotNetNuke Magazine.

This very special issue of DNN Creative Magazine is dedicated to improving the efficiency of your administration time with DotNetNuke.

In this issue we focus on using SQL queries to automate some of the repetitive tasks that you have to carry out as an administrator on a DotNetNuke portal.

These are very powerful techniques which for large Dot Net Nuke websites can reduce a week of work into seconds.

If you are new to SQL you can follow each of these tutorials through step by step. We provide a quick start guide to using SQL queries with SQL Server Express. We also show you how to set up SQL Server Management Studio Express using Windows Vista so that you can execute a basic query on both a localhost and live DotNetNuke database.

Following this we demonstrate using SQL queries for working with DotNetNuke security roles and users, focusing on exporting registered users to Excel and removing users from a security role based on their email address.

To finish we demonstrate working with shadow / copied modules. This is an essential and powerful administration task that can enhance your DNN portals and reduce administration time. Shadow or Copied modules can be used to update the same content on several pages from one central area. We demonstrate how you can use SQL queries to easily maintain these copied modules.

The SQL techniques outlined in this tutorial are very powerful techniques for easily and quickly manipulating multiple copied modules across thousands of pages in a DotNetNuke portal and are particularly useful if you are re-skinning an already established site.

DotNetNuke Deployment and Synchronization, Admin Menu Access and Free CSS Skin

In issue 26 of DNN Creative Magazine we explore the development and deployment of a DotNetNuke website, how to synchronise a local installation with a live installation.

This allows you to update the content on the live or local installation and keep both versions in sync without taking the live site offline.

We also demonstrate how to set access to the admin menu so that users can access elements of the menu without the need for full administration privileges.

To finish, we have also included a new pure CSS XHTML skin.

How to synchronize local and live DotNetNuke installations
(Deployment using Red Gate Data Compare software)
(4 videos – 33mins)

How to limit access to the admin menu
(Video - 11min)

Free CSS Skin – Internet Sharing