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 ListXLS Script Column Heading IssueXLS Script Column Heading Issue
Previous
 
Next
New Post
9/16/2008 1:13 PM
 

Hello everyone,

I've recently discovered the User Defined Table and I have to say that it is working pretty well for me.  I was dreading having to create my own modules at the moment, but the UDT has filled my need in a fantastic manner.

I just upgraded to 04.09.00 and the upgrade went well.

Ok, to my problem already.  I've been using the XLS Script to create master/detail pages.  There are two issues that I've run into that are driving me a bit batty.

The first is that I can't figure out how to make the column headers show up.  Nor can I make the Sorting option (or the search option either) to work when creating a new script.  The search/sorting/paging options would be nice, but I can live without them for the moment, but I really need to have the column headers show up in the list view.  I tried modifing the script to include a th, but it just shows up in front of each item.

The second thing I noticed is that I can not insert a space into the script.  I wanted to place two fields together in the same cell, seperated by a space.  I tried  , but it caused an error.

I'm new to the XLS bit, but I've been around DNN for quite a while.  Any help would be greatly appreciated.  Thanks.

Tom

 
New Post
9/16/2008 5:42 PM
Accepted Answer 
  • UDT5 will include clickable headers also for custom XSL
  • Sorting support inside custom XSL means, that your settings regarding sort order are respected
  • Search the XSL Script for the template responsible for "/udt:UserDefinedTable", add a header row directly after the < table > tag
  • Use [ ] inside the token template for a space or &#160; inside the XSL instead of &nbsp;
 
New Post
9/16/2008 8:33 PM
 

Outstanding... thank you very much.  Now I won't have to listen to the boss say "Why doesn't it have column titles?"

The &#160; worked for the space too!

So, what you are saying about the Sorting is that if it's checked to be sorted and you generate a new XLS, the sorting with be retained.  I'm assuming it will not reflect a change to the sorting without re-generating a new XLS sheet.  Is that correct?

Thanks a million.  I did search for this information and I read the documentation as well, and I even search google, but I didn't find the answers.  I'm glad you had them.

 
New Post
10/9/2008 2:44 AM
 

Would you mind further explain pt3? I get exactly same problem, but I still get lost after ur provided solution. or can u give some sample code let me follow?

 
New Post
10/11/2008 10:11 AM
 
  • Search the XSL Script for the template responsible for "/udt:UserDefinedTable", add a header row directly after the < table > tag

maps to:

...
<xsl:template match="/udt:UserDefinedTable">
<xsl:variable name="currentData" select="udt:Data" />
<xsl:if test="$currentData">
<table>
<tr>
<th></th>
<th>Column1</th>
<th>Column2</th>
</tr>

<xsl:apply-templates select="$currentData" mode="list">
</xsl:apply-templates>
</table>
</xsl:if>
</xsl:template>
...

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListXLS Script Column Heading IssueXLS Script Column Heading Issue


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