Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsLeft-side navigationLeft-side navigation
Previous
 
Next
New Post
10/20/2008 3:53 PM
 

I'm trying to make a left pane into a side navigation that will have links to other pages (inside DNN) similar to the top pane navigation.  Along with that, those list of links would also have sublinks that would act as bookmarks to parts in the content pane.

I was looking in other forums about this.  Someone mentioned that this would be possible with the Report module since you can query the different links.  I wouldn't even know how to start something like this.  Does someone even know if this is possible?  If so, how?  Or would you be able to point me in the right direction?

 
New Post
11/9/2008 11:38 AM
 

The first thing you could start is to drop a Reports module on the page, go to the Settings and enter the following Query (make sure the "DotNetNuke Data Source" is set): "SELECT * FROM {oQ}Tabs WHERE PortalId = @PortalId"

From there, you can do some more filtering if necessary by tweaking the SQL, and then use the HTML Visualizer to build the links.  The HTML Visualizer takes an HTML template with tokens like '[COLUMN_NAME]' and makes a copy of it for each row, replaces each token with the matching value in the column, and inserts it into the page.


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
4/24/2009 3:34 AM
 

im sure it would help a lot if you could show us too an example of the HTML Template that is required by the HTML Visualizer

Could i presumre the following format?

 

<html>

<body>

[TabName]

<body>

</html>

 

pardon my ignorance.

 
New Post
4/24/2009 5:31 AM
 

No problem! The fourms are here for you to ask any questions you have about the module!

There is an example of the HTML Template Visualizer in the DotNetNuke Help Library: http://www.dotnetnuke.com/Support/Help/tabid/787/TID/3025/cid/416/Default.aspx

It's very simple, and as a result lacks some features at the moment.  Basically, for each row that the query returns, the Reports Module takes the HTML template you provided and does a simple string replacement: [ColumnName] => The value of the column called 'ColumnName' in the output.  Then it injects that HTML into the module and moves to the next item.  Unfortunately, if you want support for Headers, Footers, and other more complicated templating features, you'll have to move up to the XSLT Visualizer (there are two more articles in the Help Library that should help with that: Article 1, Article 2).

Anyway, for the following query:

SELECT * FROM {oQ}Tabs

The following HTML template could be used:

<h1>Tab #[TabID]</h1>
<p>[TabName]</p>

That would generate output like this:

<h1>Tab #1</h1>
<p>Home</p>
<h1>Tab #2</h1>
<p>Another Page</p>
... and so on ...

You don't need the "<html>",  and "<body>" tags (in fact you really shouldn't use them) since the HTML generated by the template is injected into the middle of your DNN page.

As you can probably see, it's not perfect, and there are plans to improve it.  However, if you need more complicated scenarios, the XSLT Visualizer is the way to go, that Visualizer is basically the most powerful one in the bunch (though you'll have to do some Googling to learn about XSLT if you don't already know the language)


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsLeft-side navigationLeft-side navigation


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out