|
|
|
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 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 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
Read More..
(Red Gate - SQL Data Compare)
In this tutorial we explore the development and deployment of a DotNetNuke website that is already online. - How to synchronise a local installation with a live installation.
In this tutorial we demonstrate how to add updates to the local version and apply those updates to the live version while keeping both versions completely synchronised and without taking the live site offline and vice versa.
We demonstrate how you can synchronize a live hosted website using SQL Server 2005 with a localhost installation using SQL Server Express.
The videos cover:
- Video 1 - Introduction, Setup, Comparing Databases, Viewing Data
- Video 2 - Editing the local installation and comparing with the live installation
- Video 3 - Synching local database to live and live to local
- Video 4 - Synching multiple simultaneous edits on live and local installations
Total Time Length: 33mins
(To fix problems after transferring a localhost database to a live website and other useful functions)
In this video tutorial we demonstrate using a Find and Replace SQL procedure to fix problems such as editing image urls after uploading a localhost installation to a live website.
This means that you can automatically adjust any html code within the text / html module across all of the pages in your DotNetNuke installation in a matter of seconds, rather than manually editing each page.
This method can also be used for editing words in the text / html module. For instance, suppose you wish to change your company name, you can apply these SQL techniques to search for the current company name and replace it with a new company name.
Other techniques can include searching for inline CSS code in the text/html module, such as font tags, and deleting all of the code so that all styling comes from the skin.css files.
Read More..
This tutorial explains how to enable registered users to customize their forum profile by selecting an avatar image from a selection of images stored in the portal files.
This is achieved by combining the ActiveForums module with the XMod Module. The tutorial outlines how we combined the two modules to work together.
Using XMod with Active Forums to select Avatars
The initial installation of DotNetNuke can be configured so that when you upload and initiate the installation, all of your preferred settings, modules, and skins are automatically installed.
This can be a massive time saving device.
Options can include setting up the:
- Host Menu / Site Settings
- Admin Menu / Portal Site Settings
- Parent / Child Portals
- Automatically installing 3rd party modules, skins and containers, private assemblies and language packs
Further options can also include creating a default series of pages which are automatically installed with DotNetNuke.
The tutorial comes complete with two video tutorials totalling 24 minutes in length.
Read More..
(and earn a 10% referral bonus!)
Snowcovered.com sell DotNetNuke® related products from Module and Skin developers. Snowcovered.com also provide a 10% referral bonus scheme. If one of your website visitors clicks on a link to snowcovered.com and makes a purchase, you receive 10% of the customer sales.
Following a request, Snowcovered.com agreed to create some RSS feeds so that I could easily display their latest products on DNN Creative Magazine and receive a 10% commission on sales.
This tutorial demonstrates how to add your own referral ID to the RSS feed that Snowcovered.com provide and how to display this feed on your own website.
This tutorial uses the free News Feeds (RSS) core module. You do not need to purchase any modules to set this up.
If you use the Orizonti Nuke Feeds module, there are also templates at the end of the tutorial especially for Nuke Feeds.
Read More..
Firefox Live Bookmarks in DotNetNuke
Some RSS aggregators have the capability of finding an RSS feed on a web page and making it easy for the user to subscribe to it
An example of this can be seen in the Firefox browser, whenever the browser discovers an RSS feed, it displays an orange icon in the bottom right of the browser window.
If you click on the orange Firefox icon it will give you the option to subscribe to the RSS feed.
This tutorial explains how to enable RSS auto-discovery aggregation in DotNetNuke.
Read More..
This tutorial explains how to display flash (games) within DotNetNuke®.
You can see an example of this in action on the games pages that are used in DNN Creative Magazine.
This tutorial can be applied to any flash file that you wish to incorporate into your pages, not just flash games.
There are two options available. You can either purchase a module which will automatically play flash files for you, which you can easily configure, or using a small amount of code, you can embed any flash file you require for free.
We demonstrate how to use the free method.
The tutorial does not change any of the core code in DotNetNuke and you do not need to understand flash programming to follow this tutorial. All you need is a basic understanding of how DotNetNuke works, eg. How to add a module to a page, etc.
Read More..