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 ForumsForm and ListForm and ListXSLT for multiple tablesXSLT for multiple tables
Previous
 
Next
New Post
8/11/2011 1:09 PM
 
I need to create a table of files for four different committees on one page. I learned that I cannot put multiple instances of the Forms and List module on the same page. Now I am investigating the possibility to use an XSLT stylesheet to split up one set of udt:Data into four tables. I have tested with a simple table and <xsl:for-each select""> should somehow work for this (I hope).

The questions are:
  • Where is the dtd of the data (xmlns:udt="DotNetNuke/UserDefinedTable")?
  • How to put up the select statement if there is a column called 'Committee' which may have a values for example 'RBB' or 'RAC'? For each (!) committee a table would be created, so the for-each will be repeated four times.

Regards,
Albert

 
New Post
8/11/2011 4:50 PM
 
AEZ wrote:

  • Where is the dtd of the data (xmlns:udt="DotNetNuke/UserDefinedTable")?
There is no DTD. TheXML depends always on current configuration. Try to understand the concept of the hidden columns. 
AEZ wrote:
  • How to put up the select statement if there is a column called 'Committee' which may have a values for example 'RBB' or 'RAC'? For each (!) committee a table would be created, so the for-each will be repeated four times. 
Please read http://www.formandlist.com/Documentat...
 
New Post
8/15/2011 12:52 PM
 
First of all thank you, the pointers you gave started me on the right way.

But, of course I want it more complex than that. I want one table for every committee and if there is nothing to show in the table, then the comment 'No current documents' should show. So, grouping is not the way. I created four tables, each with its own selection etc. It results in a big transformation with four repeated peaces. I will see if I can optimize that a bit, but for the moment it works.

After looking at the ouput xml carefully, I agree that a dtd for the xml would not be very useful.

Further learnings: jEdit (with XSLT plugin) helps developing a transformation. However, the development transformation used with jEdit (and possibly any parser) code needs an <xsl:template match="/"> element; while that should not be in the final transformation used in the DNN Form and List module transformation (also <xsl:template match="udt:UserDefinedTable"> in the development transformation and <xsl:template match="/udt:UserDefinedTable"> in the final version). This little bit made developing the transformation a lot easier.

So, thanks again. Great module.
Albert
 
New Post
8/15/2011 2:17 PM
 
Hi Albert, 
thank you for the jEdit tip.
I am developing any custom xslt script with in Visual Studio. I can use original script and data source. Intellisense is supported and I can even debug the transformation.

Stefan
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListXSLT for multiple tablesXSLT for multiple tables


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