getting fieldset name for xslt email - Contour

David W. 159 posts 284 karma points c-trib

Nov 27, 2014 @ 11:43

Getting Fieldset name for XSLT-email

I'm trying to render the fieldset name in a XSLT-transformed-email. As of now, I'm only looping fields like so

<xsl:for-each select="$records//fields/child::*">

Wich generates a flat list. Been consulting the documentation (and forums), but I am not able to find how I can get the Fieldset into the equation. Some sort of nested loop might do the trick, but not sure how.

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Nov 27, 2014 @ 11:58

Hi David

What does the structure you're trying to match look like? It's been a while since I've had to deal with the XML Contour gives you but you should be able to get to the fieldset pretty easy.

What should your HTML output be?

Looking forward to hearing from you.

/Jan

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 27, 2014 @ 12:47

Hi,

Actually I am not sure exactly how the Contour record-XML is structured. This part of the docs explains it a bit though: http://our.umbraco.org/projects/umbraco-pro/contour/documentation/Developer/Working-with-Contour-data-in-XSLT/

Dont really care much on what the HTML-strucure will be, but perhaps something like this

<h2>Fieldset One Name</h2>
<ul>
 <li><h3>Field 1 caption</li><p>Field 1 value</p>
 <li><h3>Field 2 caption</li><p>Field 2 value</p>
</ul> 
<h2>Fieldset Two Name</h2>
<ul>
 <li><h3>Field 3 caption</li><p>Field 3 value</p>
 <li><h3>Field 4 caption</li><p>Field 4 value</p>
</ul>

Thanks.

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Nov 27, 2014 @ 12:58

Hi David

Ok, let's see what the XML looks like so we can begin working with it then :)

You can see the XML in $records by writing this

<textarea row="10" col="20">
   <xsl:copy-of select="$records" />
</textarea>

Please copy/paste a record snippet in here from the result that you get back in this textarea.

Cheers, Jan

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 27, 2014 @ 13:33

Pasted below. It appears to me that the Fieldsetnames are not present? Only Fieldset index? (Sorry, wasn't able to code-format)

<state>Submitted</state>

<företagsnamn record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="0" pageindex="0" fieldsetindex="0">

<caption>Företagsnamn</caption>

<datatype>String</datatype>

</values>

</företagsnamn>

<företagslogotyp record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="1" pageindex="0" fieldsetindex="0">

<caption>Företagslogotyp</caption>

<datatype>String</datatype>

</values>

</företagslogotyp>

<caption>Produktnamn</caption>

<datatype>String</datatype>

<value>some stuff</value>

</values>

</produktnamn>

<caption>Produktlogotyp</caption>

<datatype>String</datatype>

</values>

</produktlogotyp>

<datatype>String</datatype>

</values>

</eankod>

<förpackning record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="5" pageindex="0" fieldsetindex="0">

<caption>Förpackning</caption>

<datatype>String</datatype>

</values>

</förpackning>

<key>4ade3dec-723e-4e67-a215-919d11feead6</key>

<caption>Produktbild</caption>

<datatype>String</datatype>

</values>

</produktbild>

<caption>Produktbild 2</caption>

<datatype>String</datatype>

</values>

</produktbild2>

<datatype>String</datatype>

<value>value from next filedet</value>

</values>

</text>

<använddetaljfrånproduktbild record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="1" pageindex="0" fieldsetindex="1">

<caption>Använd detalj från produktbild</caption>

<datatype>String</datatype>

<value>False</value>

</values>

</använddetaljfrånproduktbild>

<fieldKey>7db8e754-ba3d-4076-ae06-d1471afeabc5</fieldKey>

<caption>Produktbild</caption>

<datatype>String</datatype>

</values>

</produktbild>

<datatype>String</datatype>

<value>another fieldset</value>

</values>

</text>

<använddetaljfrånproduktbild record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="1" pageindex="0" fieldsetindex="2">

<caption>Använd detalj från produktbild</caption>

<datatype>String</datatype>

<value>False</value>

</values>

</använddetaljfrånproduktbild>

<caption>Produktbild</caption>

<datatype>String</datatype>

</values>

</produktbild>

<datatype>String</datatype>

<value>yet another fieldset</value>

</values>

</text>

<caption>Lifestylebild</caption>

<datatype>String</datatype>

</values>

</lifestylebild>

<datatype>String</datatype>

<value>

yet another fieldset (are you kidding me)?!

:)

</value>

</values>

</text>

<caption>Temperatur</caption>

<datatype>String</datatype>

</values>

</temperatur>

<beläggning record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="1" pageindex="0" fieldsetindex="5">

<caption>Beläggning</caption>

<datatype>String</datatype>

</values>

</beläggning>

<uppvärmining record="1367d8e4-2025-4f56-9162-ed0bef740bf3" sortorder="2" pageindex="0" fieldsetindex="5">

<caption>Uppvärmining</caption>

<datatype>String</datatype>

</values>

</uppvärmining>

<caption>Bredd</caption>

<datatype>String</datatype>

</values>

</bredd>

</fields>

</uformrecord>

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Nov 27, 2014 @ 13:37

Hi Grant

Hmm, yeah you're right does not seem that anything else than the fieldsetindex is available.

Would it be of any use in your scenario to only write out that?

I'm not sure how the fieldset names an be fetched though. Thought the XML provided it all.

/Jan

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 27, 2014 @ 13:47

I guess a devider of some kind would be of use as it provides some sort of separation. How would I do that?

Better ofcourse if there is some kind of library/api I can use to fetch the fieldset name.

Also, name is not Grant :)

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Nov 27, 2014 @ 13:51

What!? I'm not allowed to call you whatever I want? :) Sorry about that...I'm trying to help out in another post as well where the guy I'm helping is named Grant :D

So, David - I don't know if you could perhaps use Razor to fetch the data instead? http://our.umbraco.org/projects/umbraco-pro/contour/documentation/Developer/Working-with-Contour-data-in-Razor/

If I remember correctly there currently is no API available but I think it's coming in the new release of Umbraco Forms (The artist formerly known as Contour).

What version of Umbraco and what version of Contour are you currently using btw?

/Jan

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 27, 2014 @ 14:20

Using 7.1.8 and Contour 3.0.23-Build.20.

Well, I'm using the "Send xslt-transformed E-mail" as a workflow item. I don't think there is a razor equivalent? Also, would a Razor-module really make the fieldset name accessible?

/D

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 28, 2014 @ 11:48

Still trynig to solve this. Currently not able to render any kind of sepeartion between fieldsets. Been trying to put the fieldsetindex into a varaible and compare that to current node. That's not how you roll in terms of xslt from what i gather. Is there a way to comapare to prevois node somhow?

/Grant

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Nov 28, 2014 @ 11:53

Hi David

Sorry, missed the last post from you yesterday.

I'll try to see if I can make some code that can split things up in a way that you would like if I have time during the weekend. It should be possible. But currently I'm at work and during the weekend I'm moving so don't have so much time to make up a code sample.

But maybe someone else will beat me to it before then! :)

/Jan

Copy Link

David W. 159 posts 284 karma points c-trib

Nov 28, 2014 @ 12:34

Managed to get a horizontal ruler int here with the following syntax:

<xsl:if test="preceding-sibling::*[1]/./@fieldsetindex != ./@fieldsetindex">
  <hr />
</xsl:if>

Thanks Jan!

(Still intrested in how (if at all) it would be possible to get the actual fieldset name in there.)

/David

Copy Link

Steve 472 posts 1216 karma points

Jan 20, 2015 @ 18:05

Could you please explain your test? I don't quite understand it. It would help me greatly!

Copy Link

Mohamed A 1 post 71 karma points

Jul 19, 2020 @ 21:24

Not sure if anybody else is still having an issue with the xslt grouping fieldsets, but the code below is how I managed to get it working for my purposes.

This script is manually rendering the fieldset name which is the caption for the questions with two parts, a rating and a comment. In order to do this the data is evaluated using a number of

The form has 3 pages with a number of formsets, the fieldsetindex resets to 0 for each page, so a check of page number is required.

The sortorder is 0 for the first member of the fieldset, so if it is 0 then render the question header.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:umbraco.library="urn:umbraco.library" version="1.0" exclude-result-prefixes="xsl msxsl user umbraco.library">
<xsl:output method="html" media-type="text/html" doctype-public="-//W3C//DTD XHTML 1.0 Strict//EN" doctype-system="DTD/xhtml1-strict.dtd" cdata-section-elements="script style" indent="yes" encoding="utf-8"/>
<xsl:param name="records"/>
<xsl:template match="/">
<table style="border-collapse:collapse;border:1px solid black;">
<xsl:for-each select="$records//fields/child::*">
<xsl:sort select="@pageindex" order="ascending" data-type="number"/>
<xsl:sort select="@fieldsetindex" order="ascending" data-type="number"/>
<xsl:sort select="@sortorder" order="ascending" data-type="number"/>
<xsl:if test="@fieldsetindex=0 and @pageindex=1 and @sortorder=0">
<tr>
<td colspan="2">
<b>1. Were the course objectives clearly stated at the outset</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=1 and @pageindex=1 and @sortorder=0">
<tr>
<td colspan="2">
<b>2. How well were the course objectives met?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=2 and @pageindex=1 and @sortorder=0">
<tr>
<td colspan="2">
<b>3. To what extent did the course provide relevant skills & practice?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=0 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>4. Knowledge/Expertise?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=1 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>5. Oral Presentation?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=2 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>6. Structure of Presentation?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=3 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>7. Class Participation? Did you feel being “online” affected this?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=4 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>8. Visual Aids Used?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=5 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>9. Manual/Supporting Notes?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=6 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>10. How useful were the workshops /exercises/examples</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=7 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>11. How easy did you find Microsoft Teams to use for the meeting?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=8 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>12. How easy did you find TeamViewer to use for accessing the training machine?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=9 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>13. How would you rate the course administration/support?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=10 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>14. What is your overall course rating?</b>
</td>
</tr>
</xsl:if>
<xsl:if test="@fieldsetindex=11 and @pageindex=2 and @sortorder=0">
<tr>
<td colspan="2">
<b>ANY OTHER COMMENTS?</b>
</td>
</tr>
</xsl:if>
<tr style="border:1px solid black;">
<td valign="top" style="border:1px solid black;padding:5px;font-family:Verdana,Helvetica,Arial,sans-serif;font-size:11px;">
<strong>
<xsl:value-of select="./caption"/>
</strong>
</td>
<td valign="top" style="border:1px solid black;padding:5px;font-family:Verdana,Helvetica,Arial,sans-serif;font-size:11px;">
<xsl:choose>
<xsl:when test="contains(.//value, '/umbraco/plugins/umbracoContour/files/')">
<a href="http://{umbraco.library:RequestServerVariables('SERVER_NAME')}{.//value}">
<xsl:value-of select="substring-after(substring-after(.//value, '/files/'), '/')"/>
</a>
</xsl:when>
<xsl:otherwise>
<xsl:for-each select="./values/value">
<xsl:if test="position() > 1">
<br/>
</xsl:if>
<xsl:value-of select="umbraco.library:ReplaceLineBreaks(.)"/>
</xsl:for-each>
</xsl:otherwise>
</xsl:choose>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

I hope this helps someone else who is struggling like me with how contour xslt renders emails that are sent.

Copy Link

is working on a reply...

Flag this post as spam?

Getting Fieldset name for XSLT-email