Google Analytics is great - I use it all the time. But integrating it into a DotNetNuke website should be easier than it is, or so I thought. In a fit of frustration I developed a module to handle all the messy plumbing, and it's been tarted up for public consumption.

As a starting point, the 'friendly' Urls in the standard DotNetNuke install are OK. Kind of polite-stranger friendly. But what I want is a real welcome-to-my-house over the top friendly. This is the results from my first attempt.

Read More »

I've been working on full integration of unit tests in with regular builds on my TFS setup - I've been ignoring it for a while but with a large battery of unit tests setup, it was time to take the plunge. However, I ran into some troubles with running my tests because I don't have the full Visual Studio Team System (I have Team Edition for Developers). I worked out how to fix that, but then it all started...

Read More »

I learnt this tricky little piece of syntax for updating a sequence number in a table a while ago, but I can never remember it when it comes to using it. It's also very hard to find in search engines, so I've decided to put it in my blog for later reference.

Read More »

The previous entry was about an ASP.NET Google sitemap Generator using the Provider model. This was a test project for the real reason I was working on Google Sitemap generation - a DotNetNuke-specific Sitemap generator. There are already several DotNetNuke sitemap generators around, but the one I have developed provides a run-time extensible model based on the type of content on each page.

Read More »

In order to generate a dynamic Google Sitemap, you need to read the pages of the website and output an XML file. In this article, I have developed a base provider which will simply read the physical pages in the website directory, and output the sitemap. This is only a base for my future developments, which will generate dynamic sitemaps based on dynamic database driven content (like this blog). This exercise was also done to learn the intricacies of developing a custom ASP.NET provider. Source code and demo code is avaiable.

Read More »

Sometimes moving data around between servers and databases is a real pain. Security restrictions, server versions and locations and many other things make it difficult. This posting discusses a T-SQL Script which will create insert statements and update statements from data selected out of a source table. The source table and destination tables must be identical, but this is often the case when moving between test and live environments.

Read More »

The DotNetNuke platform has a lot of features surrounding timezones - registered users can have a different timezone setting from the portal - and each portal on an installation can have a different timezone. However, an underlying assumption of much of the code is that the server and host portal are on the same timezone, which affects many things - not least of all the Website Log reports.

Read More »