Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

DotNetNuke Marketplace
  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  html, xlt problem
Previous Previous
 
Next Next
New Post 2/1/2008 11:11 AM
Resolved
User is offline Miriam Boudreaux
30 posts
www.mireauxms.com
10th Ranked


html, xlt problem 

I got a UDT created without any problem.  It shows ok with the predefined xls settings.  All I want to do is have the header a certain background color and column size.  I know how to do it in html, so I Generate New xls file.  I read the whole manual.  Problem is that I get a header before every new record.  This is how my code looks:

<tr border="1" cellspacing="0" cellpadding="3" class="normalbold" bgcolor="#ffff99">

<th></th><th>Date</th><th>Meeting Chair</th><th>Meeting Agenda</th><th>Presentation</th><th>Action Items</th>

</tr>

<tr border="1" cellspacing="0" cellpadding="3" class="normal">

  <td>[UDT:EditLink]</td>

  <td>[Date_UDT_Value]</td>

  <td>[Meeting Chair]</td>

  <td>[Meeting Agenda]</td>

  <td>[Meeting Presentation]</td>

  <td>[Action Items]</td>

</tr>

I know this is simple but I cannot figure it out.

 

thanks

Miriam


 

 
New Post 2/2/2008 1:30 AM
Accepted Answer 
User is offline Stefan Cullmann
1553 posts
5th Ranked








Re: html, xlt problem 

You place the header inside the token template. This token template gets repeated for ever single record.

The trick is to place the header row directly into the created XSL:
...
< xsl:template match="/udt:UserDefinedTable">
< xsl:variable name="currentData" select="udt:Data" />
< table>
< tr border="1" cellspacing="0" cellpadding="3" class="normalbold" bgcolor="#ffff99">
< th></th>< th>Date< /th>< th>Meeting Chair< /th>< th>Meeting Agenda< /th>< th>Presentation< /th>< th>Action Items< /th>
< /tr>
< xsl:apply-templates select="$currentData" mode="list">
< /xsl:apply-templates>
< /table>
< /xsl:template> 

The XSL may look different if you enbale some more options, however the template needs to be placed inside the udt:UserDefinedTable directly before the call of the list template.

 


Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport
 
New Post 2/2/2008 2:41 PM
User is offline Miriam Boudreaux
30 posts
www.mireauxms.com
10th Ranked


Re: html, xlt problem 

thanks a bunch.  That was easy. 

 
New Post 2/7/2008 11:34 AM
User is offline Mike Riley
245 posts
9th Ranked


Re: html, xlt problem 

Stefan,

Thanks for posting that.  I tried to see if I could do this after the original poster submitted their question.  I knew it was possible (because I've done it before), but kept putting my code in the wrong place.

It would be great if in the XSLT wizard, there was an option for "header" and "footer" to make things easier.

 
New Post 4/22/2008 8:51 PM
User is offline Miriam Boudreaux
30 posts
www.mireauxms.com
10th Ranked


Re: html, xlt problem 

Stefan,

After months of doing fine with the instructions above, I figured out that there were indeed other "options".  I follow you instructions in detail, and although I'm able to get the header row, the fields do not sort or can't be clicked.  Any suggestions?

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  html, xlt problem
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


XCESS expertise center b.v.
Custom made modules and complete solutions for the DNN framework. Maatwerk modules en complete webtoepassingen gebaseerd op het DNN framework.
www.xcess.nl
EMAS Pro
Strategic Enrollment Management Software for Higher Education Recruitment, Retention and Financial Aid
www.emaspro.com
Subzero Solutions
Dutch / English DotNetNuke consultancy services. Custom module development in any version. Complete application integration. Small business portal hosting. Your ideas our innovation - Your success our motivation. K.v.k Amsterdam: 34236342
www.subzero-solutions.net

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP