Monday, June 6, 2005

DotNetNuke Crew In Orlando

Book signings, free food...what a life. ;op

http://wroxblog.typepad.com/minatel/2005/06/wrox_authors_at.html

DotNetNuke Database Backup Module

Just saw this posting regarding a new module.

This can be downloaded here http://www.gruposur.com.uy/Descargas/tabid/96/Default.aspx

BackupLite is a FREE DNN module that allows you to perform a database backup, compress it and download it.

We'll have to give it a go when time permits.

Sunday, June 5, 2005

Create RSS and XML feeds with DotNetNuke

Found a great little DotNetNuke module today. The GX-Page Feed module from GXDO.com is a great little module. The concept is simple. It simply looks anywhere on the page for a series of tags and associated child tags. It then uses these to generate RSS 1.0, RSS 2.0, Atom and XML feeds of the hidden data.

I found that by including the approrpriate feed tags in Xmod List View templates we could generate appropriate RSS feeds of our Xmod data. Now couple that with the power of Xmod Remote Data module and you can generate RSS feeds from any supported data platforms.

This seems to signal a recent trend in creating modules that can work with other modules. LucasLabs.Net have made the Xmod Remote Data module allow an integration option with the PowerReports Professional module while leveraging the templating engine for the Xmod module. GX-Page Feed can allow for RSS feeds from Text/HTML, PowerReports Professional, Xmod and other DNN modules.

Interesting concepts and ideas. Motiviated individuals are creating some unique ways to utilizing this type of interaction to increase the power of DNN.

Saturday, June 4, 2005

XMod RemoteData 1.1

In case you had not already see information about the latest release of the Xmod Remote Data 1.1 module from LucasLabs.net here are a few quick facts.

Xmod Remote Data from LucasLabs.Net is an Xmod add-on desktop module for the DotNetNuke portal that allows customers to retrieve database data in your DotNetNuke or other remote database table to any tab in the portal. Once the data has been retrieved, users can define Xmod templates to be used for both "List View" and "Detail View" customization and reporting.

What's New to version 1.1

  • New module configuration settings.
  • Data Sorting.
  • Allow user data sorting.
  • Allow user data searching.
  • Admin defined fields available for user sorting.
  • Admin defined fields available for user searching.
  • Supports Xmod 3.2
  • One purchase gets you DNN 2.1.2 and DNN 3.0 compatible versions in one package!

Thursday, June 2, 2005

Five Xmod Related Products are Top Picks

Did we really see what we thought we saw? Yes, it was confirmed here. Today we find that all 5 of the top 5 bestsellers at Snowcovered are XMod-related products for the DotNetNuke portal system:

#1 XMod Calendar
#2 Upcoming Events for XMod (Scott Jennings)
#3 XMod 3.2
#4 XMod Remote Data 1.1 (LucasLabs.Net)
#5 Classified Ads for XMod (GotDNN)

Wednesday, June 1, 2005

Poor Performance After DotNetNuke Upgrade

Some folks are experiencing slow response times or poor performance following their latest DNN upgrade. We ran into this and found that the problem was actually a couple of things.

First we noticed some severe pagination of the database and indexes. We performed some much needed index re-builds which significantly improved performance. Lastly, there were circular references in the tabs table. Thanks to Scott Willhite who posted the great little script to check for this. Here is the original post.

DECLARE @TabId INT
DECLARE @PortalId INT
DECLARE @ParentId INT
DECLARE @Level INT
DECLARE @PortalName NVARCHAR(128)
DECLARE
@NewTabId INT
DECLARE @NewParentId INT
DECLARE @MSG NVARCHAR(1000)

DECLARE @PreviousPortalId INT
SET @PreviousPortalId = -999

DECLARE cur CURSOR LOCAL SCROLL STATIC READ_ONLY FOR
SELECT TabId,
PortalId, ParentId, [Level] FROM Tabs ORDER BY PortalId, TabId

OPEN cur
FETCH NEXT FROM cur INTO @TabId, @PortalId, @ParentId, @Level

WHILE
(@@FETCH_STATUS = 0)
BEGIN
IF (ISNULL(@PortalId, -1) <>
@PreviousPortalId)
BEGIN
PRINT
'================================================='
SELECT @PortalName =
PortalName FROM Portals WHERE PortalId = @PortalId
PRINT 'Processing Portal:
' + ISNULL(@PortalName,'No Portal, Host Menu')
PRINT
'================================================='
END

SET
@NewParentId = @ParentId
SET @NewTabId = @TabId
PRINT 'Validating Tab ['
+ LTRIM(CAST(@TabId AS VARCHAR(10))) + '] :'
WHILE (1 = 1)
BEGIN
SET
@MSG = CHAR(9) + LTRIM(CAST(@NewTabId AS VARCHAR(10))) + ' >> '
IF
@NewParentId IS NULL
BEGIN
SET @MSG = @MSG + '[NULL]... OK'
PRINT
@MSG
BREAK
END
ELSE
BEGIN
SET @MSG = @MSG +
LTRIM(CAST(@NewParentId AS VARCHAR(10))) + '... '
END
SELECT @NewTabId =
TabId, @NewParentId = ParentId FROM Tabs WHERE TabId = @NewParentId

PRINT @MSG
END

SET @PreviousPortalId = @PortalId
FETCH
NEXT FROM cur INTO @TabId, @PortalId, @ParentId, @Level
END
CLOSE cur
DEALLOCATE cur