Articles

In this tutorial we demonstrate using SQL queries for working with DotNetNuke security roles and users.

Using SQL queries can help you to easily maintain and manipulate the registered user and security role data in your DotNetNuke portal. These SQL query methods are ideal for managing users of your DotNetNuke portal for email newsletters, paid subscriptions, etc.

If you do not have any experience of SQL, we demonstrate how you can use the built in Query Editor in SQL Server Express to build your own SQL queries.

The videos contain:

• Video 1 - Introduction to SQL queries and How to Use The Query Editor
• Video 2 - Exporting Users and Removing Security Roles using SQL

Total Time Length: 16mins

In this tutorial we provide a quick start guide to using SQL queries with SQL Server Express. In particular we demonstrate how to set up SQL Server Express so that you can execute SQL queries on your DotNetNuke database, on both a local and a live database.

This tutorial helps you to set up SQL Server Management Studio Express and execute a basic query, following this tutorial you can then progress onto the more advanced SQL query tutorials.

The videos contain:

• Video 1 - How to Attach a DotNetNuke Database to SQL Server Express using Windows Vista
• Video 2 - How to Create a User Account and set up Permissions
• Video 3 - How to Edit the Web.config Connection String
• Video 4 - How to Create a SQL Query, How to Connect to a Live Database

Total Time Length: 29mins

In this tutorial we demonstrate how to install DotNetNuke v4.8.1 to Windows Vista. You can install DotNetNuke to Vista home premium, business, and ultimate editions.

We walk you through how to configure and install the required programmes for installing DotNetNuke using a fresh installation of Windows Vista Ultimate, once we have setup the required programmes we then demonstrate how to install DotNetNuke to Vista Ultimate.

The videos cover:

• Video 1 - Introduction, configuring Vista, installing IIS and downloading SQL Server
• Video 2 - Installing SQL Server Express
• Video 3 - Configuring IIS
• Video 4 - Installing DotNetNuke and initial configuration

Total Time Length: 33mins

In this tutorial we demonstrate how to setup and use Microsoft’s Virtual PC 2007. Virtual PC is available for free download and it allows you to run multiple operating systems at the same time within one physical computer.

Virtual PC virtualizes the hardware of a physical computer; this means that a Virtual PC uses a standard hardware configuration which is not reliant on the hardware of the host computer. Therefore you can transfer a Virtual PC to another host computer without any software driver issues.

There are many possibilities for improving your working environment by using Virtual PC and in this tutorial we provide a quick start guide to Virtual PC.

The videos cover:

• Video 1 - Introduction and installation of Virtual PC
• Video 2 - Installation of Windows Vista to Virtual PC

Total Time Length: 17mins

In this tutorial we demonstrate how to use the DotNetNuke Store core module. We demonstrate how to set up a store module that sells mountain bikes and how to configure the module to sell those products via PayPal.

The store module consists of five individual modules. We cover each of these modules in detail.

The videos cover:

• Video 1 - Introduction to the store modules and initial configuration
• Video 2 - PayPal gateway provider, tax and shipping, categories
• Video 3 - Adding products, offers, initial configuration for displaying products
• Video 4 - Store account, reviews, test purchasing a product using PayPal sandbox
• Video 5 - Managing orders, viewing emails, reviews, shipping setup
• Video 6 - Module styling, CSS, fixing errors
• Video 7 - Configuring display of Store Catalog module
• Video 8 - Working with templates to change the layout and style of the store

Total Time Length: 72mins

In this tutorial we demonstrate how to setup the PayPal Sandbox test environment. This allows you to create test PayPal buyer and seller accounts which you can then use to test the selling of products within DotNetNuke.

For instance, if you are using the DotNetNuke store core module, there is an option within the admin settings to use the PayPal sandbox, if you tick this option the store will ask for payment via the sandbox rather than the main PayPal website. This allows you to log in as a test user and send dummy test payments.

This is an essential technique for your ecommerce toolbox.

Time Length: 13mins

In this video tutorial we demonstrate how to style the search box in DotNetNuke skins. We walk you through how we applied the styling to the search box in the free ‘internet sharing’ skin.

This covers how we expanded the width of the search box, how to use a graphic for the search box, how to style the text that the search box uses, how to style the search link as a button and how to replace the search link with an image.

In this tutorial we demonstrate how to use Token Replacement which is available for DotNetNuke versions 4.6 and above.

Token replacement allows you to display information such as the username, date, portal title etc. and you can display this information directly within the text of your modules.

Token Replacement is currently available for the Text / HTML, Newsletter and User Defined Table (UDT) core modules, and it is likely that it will be included in other core modules in future releases as well.

Time Length: 13mins

In this tutorial we demonstrate how to use the User Defined Table (UDT) module. The UDT module allows you to create a custom table and store records within that table.

The table can include sorting of columns, paging, filtering by content and search. It also includes some powerful features such as the use of calculated columns, token replacement and layout templates through the use of XSL transformation files.

The videos cover:

• Video 1 - Installation, creating a basic table
• Video 2 - Adding records, sorting, creating a second UDT table
  
• Video 3 - Calculated columns, advanced options
• Video 4 - Permissions, users adding content
• Video 5 - Advanced options for data types
• Video 6 - Display settings
• Video 7 - Search, predefined XSL transformation files (templates)
• Video 8 - Editing and auto generation of XSL transformation files
• Video 9 - Further XSL transformation file options and tokens

Total Time Length: 76mins

This tutorial is part 2 of the How to create a DotNetNuke skin from an XHTML template tutorial.

In Part 2 of the tutorial we cover how to create the containers, semantically coding the content, styling and formatting the content, overriding the DotNetNuke default classes, how to easily add the additional skin layout variations, and how to setup and create a print.css file so that you can style your own print layout of the skin.

The videos cover:

• Video 1 - Creating the containers
• Video 2 - Text styling and overriding the default DotNetNuke styles
• Video 3 - Styling the header tags
• Video 4 - Styling content based on the content pane location
• Video 5 - Creating layout variations
• Video 6 - Creating an additional styled menu
• Video 7 - How to create a print layout (print.css)

Total Time Length: 60mins