By Lee Sykes
December 2008
In this tutorial we demonstrate a method for quickly adding large amounts of data into a DotNetNuke module. The module in this example is the core Documents module.
Throughout the tutorial we walk you through the methods used for investigating how to add large amounts of data into the Documents module so that you can adapt these methods to add content to other modules.
This tutorial assumes that you are already familiar with DotNetNuke and that you have installed DotNetNuke on a localhost installation. In this tutorial we work on a local installation, but it is easy to apply this method to a live website.
In the tutorial we use SQL Server Express and Microsoft Excel.
The videos contain:
Video 1 - Introduction, Initial Demonstration with Documents Module
- Introduction
- The Documents module
- How to add a link to the Documents module
- What happens when you need to add a large number of links?
- SQL Server Management Studio Express
- How to view the contents of the Documents module table
- Explanation of the contents of the Documents module table
- How to find the ModuleID of a module
- How to add content to the Documents module table using SQL Server
- How to apply the sort order to the Documents module
Time Length: 8min 57secs
Video 2 - Testing, Errors and Link Tracking Tables
- Testing the Documents module links
- Errors with Link Click tracking
- UrlTracking and Urls tables
- Explanation of the contents of the UrlTracking table
- Explanation of the contents of the Urls table
- Adding a file to the Documents module
- Viewing the content in the Documents, UrlTracking and Urls tables
- Files table
- How to add content into the Documents module using SQL Server with correct Link Tracking
Time Length: 9min 53secs
Video 3 - Creating an Excel file of Data for the Documents Module
- Documents Settings table
- Explanation of the contents of the Documents Settings table
- How to create a Microsoft Excel file for importing into SQL Server and populating the Documents module
- How to create the Documents table data in Excel
- How to create the URL Tracking table data in Excel
- How to create the URLs table data in Excel
- How to create the Documents Settings table data in Excel
Time Length: 13min 03secs
Video 4 - Copying the Data from Excel to SQL Server, Testing, Adding Files
- How to copy the data from Excel to SQL Server
- How to copy data to the Documents, Ur lTracking, Urls, Documents Settings tables
- Viewing and testing the new data in the Documents module
- Restart Application to ensure you view the changes
- How to add files into the Documents module using Excel and SQL Server
- How to upload files so that the files are added to the Files table
Time Length: 7min 47secs
Total Time Length: 39min 40secs