Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17364Bug reportsExpression Managerpublic2021-06-11 17:28
Reportertammo Assigned Toollehar  
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version3.25.20 
Target Version3.x 
Summary17364: {SURVEYURL} does not get replaced in admin email notification
Description

Using:

Hello {contact_SQ001},<br />
<br />
You filled in your name in a survey named '{SURVEYNAME}' on the website of Respondage.<br /><br />
{SURVEYURL}
<br />
Thank you for your response. I will be in touch soon.<br /><br />
If by any chance I do not respond soon enough, please feel free to contact me at:<br />
tammo.terhark@respondage.nl<br />
<br />
Thank you, <br />
<br />
Tammo ter Hark<br />
Respondage

Steps To Reproduce

Load attached survey.
Activate
Fill in and leave your email
Notice that {SURVEYURL} does not get replaced

TagsNo tags attached.
Attached Files
limesurvey_survey_592792.lss (33,472 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>365</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[11142]]></qid>
    <code><![CDATA[A1]]></code>
    <answer><![CDATA[1 Strongly disagree]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[11142]]></qid>
    <code><![CDATA[A2]]></code>
    <answer><![CDATA[2]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[11142]]></qid>
    <code><![CDATA[A3]]></code>
    <answer><![CDATA[3]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[11142]]></qid>
    <code><![CDATA[A4]]></code>
    <answer><![CDATA[4]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[11142]]></qid>
    <code><![CDATA[A5]]></code>
    <answer><![CDATA[5 Strongly agree]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[1354]]></gid>
    <sid><![CDATA[592792]]></sid>
    <group_name><![CDATA[g1]]></group_name>
    <group_order><![CDATA[1]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[11142]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[tec1101]]></title>
    <question><![CDATA[What do you think about the following quotes?]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11143]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[X]]></type>
    <title><![CDATA[tec1190]]></title>
    <question><![CDATA[Counting total answer scores = {num1101}<br />
# Answered subquestions: {den1101}<br />
Which makes your score: {sc1101}]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[11144]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[*]]></type>
    <title><![CDATA[num1101]]></title>
    <question><![CDATA[{sum(
  countifop('==',"A1",tec1101_SQ001.NAOK,tec1101_SQ003.NAOK,tec1101_SQ004.NAOK,tec1101_SQ005.NAOK, tec1101_SQ007.NAOK,tec1101_SQ008.NAOK,tec1101_SQ009.NAOK,tec1101_SQ010.NAOK, tec1101_SQ011.NAOK,tec1101_SQ012.NAOK,tec1101_SQ013.NAOK,tec1101_SQ014.NAOK), 5*countifop('==',"A1", tec1101_SQ002.NAOK, tec1101_SQ006.NAOK, tec1101_SQ015.NAOK),
  2*countifop('==',"A2",tec1101_SQ001.NAOK,tec1101_SQ003.NAOK,tec1101_SQ004.NAOK,tec1101_SQ005.NAOK, tec1101_SQ007.NAOK,tec1101_SQ008.NAOK,tec1101_SQ009.NAOK,tec1101_SQ010.NAOK, tec1101_SQ011.NAOK,tec1101_SQ012.NAOK,tec1101_SQ013.NAOK,tec1101_SQ014.NAOK), 4*countifop('==',"A2", tec1101_SQ002.NAOK, tec1101_SQ006.NAOK, tec1101_SQ015.NAOK),
  3*countifop('==',"A3",tec1101_SQ001.NAOK,tec1101_SQ003.NAOK,tec1101_SQ004.NAOK,tec1101_SQ005.NAOK, tec1101_SQ007.NAOK,tec1101_SQ008.NAOK,tec1101_SQ009.NAOK,tec1101_SQ010.NAOK, tec1101_SQ011.NAOK,tec1101_SQ012.NAOK,tec1101_SQ013.NAOK,tec1101_SQ014.NAOK), 3*countifop('==',"A3", tec1101_SQ002.NAOK, tec1101_SQ006.NAOK, tec1101_SQ015.NAOK),
  4*countifop('==',"A4",tec1101_SQ001.NAOK,tec1101_SQ003.NAOK,tec1101_SQ004.NAOK,tec1101_SQ005.NAOK, tec1101_SQ007.NAOK,tec1101_SQ008.NAOK,tec1101_SQ009.NAOK,tec1101_SQ010.NAOK, tec1101_SQ011.NAOK,tec1101_SQ012.NAOK,tec1101_SQ013.NAOK,tec1101_SQ014.NAOK), 2*countifop('==',"A4", tec1101_SQ002.NAOK, tec1101_SQ006.NAOK, tec1101_SQ015.NAOK),
  5*countifop('==',"A5",tec1101_SQ001.NAOK,tec1101_SQ003.NAOK,tec1101_SQ004.NAOK,tec1101_SQ005.NAOK, tec1101_SQ007.NAOK,tec1101_SQ008.NAOK,tec1101_SQ009.NAOK,tec1101_SQ010.NAOK, tec1101_SQ011.NAOK,tec1101_SQ012.NAOK,tec1101_SQ013.NAOK,tec1101_SQ014.NAOK), countifop('==',"A5", tec1101_SQ002.NAOK, tec1101_SQ006.NAOK, tec1101_SQ015.NAOK)
)}]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[11145]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[*]]></type>
    <title><![CDATA[den1101]]></title>
    <question><![CDATA[{sum(countifop('==',"A1",that.tec1101.NAOK), countifop('==',"A2",that.tec1101.NAOK), countifop('==',"A3",that.tec1101.NAOK), countifop('==',"A4",that.tec1101.NAOK), countifop('==',"A5",that.tec1101.NAOK))}]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[11146]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[*]]></type>
    <title><![CDATA[sc1101]]></title>
    <question><![CDATA[{round(num1101/den1101, 1)}]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[11147]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[X]]></type>
    <title><![CDATA[fb1101]]></title>
    <question><![CDATA[{if(sc1101 <= 2.5, "This is a red score, you have a poor fit to the culture code", if(sc1101<=3.5, "This is an orange (amber?) score, you have a fair fit to the culture code", if(sc1101<=4.5,"This is a green score, you have a good fit to the culture code", "This is a green score, you have an outstanding score to the culture code")))}]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[6]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[den1101>0]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[11163]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[Q]]></type>
    <title><![CDATA[contact]]></title>
    <question><![CDATA[Are you interested in our services for developing surveys, survey themes and survey reports? Please leave your details below.]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[16]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11167]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[remarks]]></title>
    <question><![CDATA[Feel free to leave your remarks!]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[17]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[11148]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ001]]></title>
    <question><![CDATA[Quote 1]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11149]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ002]]></title>
    <question><![CDATA[Quote 2 <strong>(Reverse)</strong>]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11150]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ003]]></title>
    <question><![CDATA[Quote 3]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11151]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ004]]></title>
    <question><![CDATA[Quote 4]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11152]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ005]]></title>
    <question><![CDATA[Quote 5]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11153]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ006]]></title>
    <question><![CDATA[Quote 6 <strong>(Reverse)</strong>]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[6]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11154]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ007]]></title>
    <question><![CDATA[Quote 7]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[7]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11155]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ008]]></title>
    <question><![CDATA[Quote 8]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[8]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11156]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ009]]></title>
    <question><![CDATA[Quote 9]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[9]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11157]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ010]]></title>
    <question><![CDATA[Quote 10]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[10]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11158]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ011]]></title>
    <question><![CDATA[Quote 11]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[11]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11159]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ012]]></title>
    <question><![CDATA[Quote 12]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[12]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11160]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ013]]></title>
    <question><![CDATA[Quote 13]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[13]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11161]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ014]]></title>
    <question><![CDATA[Quote 14]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[14]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11162]]></qid>
    <parent_qid><![CDATA[11142]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ015]]></title>
    <question><![CDATA[Quote 15 <strong>(Reverse)</strong>]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[15]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11165]]></qid>
    <parent_qid><![CDATA[11163]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ001]]></title>
    <question><![CDATA[Name]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[11166]]></qid>
    <parent_qid><![CDATA[11163]]></parent_qid>
    <sid><![CDATA[592792]]></sid>
    <gid><![CDATA[1354]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[SQ002]]></title>
    <question><![CDATA[Email]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </subquestions>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[11144]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[11145]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[11146]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[11147]]></qid>
    <attribute><![CDATA[cssclass]]></attribute>
    <value><![CDATA[{if(sc1101<=3.5,"red","green")}]]></value>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>admin</fieldname>
   <fieldname>expires</fieldname>
   <fieldname>startdate</fieldname>
   <fieldname>adminemail</fieldname>
   <fieldname>anonymized</fieldname>
   <fieldname>faxto</fieldname>
   <fieldname>format</fieldname>
   <fieldname>savetimings</fieldname>
   <fieldname>template</fieldname>
   <fieldname>language</fieldname>
   <fieldname>additional_languages</fieldname>
   <fieldname>datestamp</fieldname>
   <fieldname>usecookie</fieldname>
   <fieldname>allowregister</fieldname>
   <fieldname>allowsave</fieldname>
   <fieldname>autonumber_start</fieldname>
   <fieldname>autoredirect</fieldname>
   <fieldname>allowprev</fieldname>
   <fieldname>printanswers</fieldname>
   <fieldname>ipaddr</fieldname>
   <fieldname>refurl</fieldname>
   <fieldname>publicstatistics</fieldname>
   <fieldname>publicgraphs</fieldname>
   <fieldname>listpublic</fieldname>
   <fieldname>htmlemail</fieldname>
   <fieldname>sendconfirmation</fieldname>
   <fieldname>tokenanswerspersistence</fieldname>
   <fieldname>assessments</fieldname>
   <fieldname>usecaptcha</fieldname>
   <fieldname>usetokens</fieldname>
   <fieldname>bounce_email</fieldname>
   <fieldname>attributedescriptions</fieldname>
   <fieldname>emailresponseto</fieldname>
   <fieldname>emailnotificationto</fieldname>
   <fieldname>tokenlength</fieldname>
   <fieldname>showxquestions</fieldname>
   <fieldname>showgroupinfo</fieldname>
   <fieldname>shownoanswer</fieldname>
   <fieldname>showqnumcode</fieldname>
   <fieldname>bouncetime</fieldname>
   <fieldname>bounceprocessing</fieldname>
   <fieldname>bounceaccounttype</fieldname>
   <fieldname>bounceaccounthost</fieldname>
   <fieldname>bounceaccountpass</fieldname>
   <fieldname>bounceaccountencryption</fieldname>
   <fieldname>bounceaccountuser</fieldname>
   <fieldname>showwelcome</fieldname>
   <fieldname>showprogress</fieldname>
   <fieldname>questionindex</fieldname>
   <fieldname>navigationdelay</fieldname>
   <fieldname>nokeyboard</fieldname>
   <fieldname>alloweditaftercompletion</fieldname>
   <fieldname>googleanalyticsstyle</fieldname>
   <fieldname>googleanalyticsapikey</fieldname>
   <fieldname>gsid</fieldname>
   <fieldname>showsurveypolicynotice</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[592792]]></sid>
    <admin><![CDATA[Respondage Survey Admin]]></admin>
    <adminemail><![CDATA[tammo.terhark@respondage.nl]]></adminemail>
    <anonymized><![CDATA[N]]></anonymized>
    <faxto/>
    <format><![CDATA[G]]></format>
    <savetimings><![CDATA[N]]></savetimings>
    <template><![CDATA[respondage_respondage]]></template>
    <language><![CDATA[en]]></language>
    <additional_languages/>
    <datestamp><![CDATA[Y]]></datestamp>
    <usecookie><![CDATA[N]]></usecookie>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[N]]></allowsave>
    <autonumber_start><![CDATA[2]]></autonumber_start>
    <autoredirect><![CDATA[N]]></autoredirect>
    <allowprev><![CDATA[N]]></allowprev>
    <printanswers><![CDATA[N]]></printanswers>
    <ipaddr><![CDATA[N]]></ipaddr>
    <refurl><![CDATA[N]]></refurl>
    <publicstatistics><![CDATA[N]]></publicstatistics>
    <publicgraphs><![CDATA[N]]></publicgraphs>
    <listpublic><![CDATA[N]]></listpublic>
    <htmlemail><![CDATA[Y]]></htmlemail>
    <sendconfirmation><![CDATA[Y]]></sendconfirmation>
    <tokenanswerspersistence><![CDATA[Y]]></tokenanswerspersistence>
    <assessments><![CDATA[N]]></assessments>
    <usecaptcha><![CDATA[N]]></usecaptcha>
    <usetokens><![CDATA[N]]></usetokens>
    <bounce_email><![CDATA[tammo.terhark@respondage.nl]]></bounce_email>
    <emailresponseto><![CDATA[tammo.terhark@respondage.eu]]></emailresponseto>
    <emailnotificationto><![CDATA[{if(strlen(contact_SQ002)>5, contact_SQ002, "tammo.terhark@respondage.nl")}]]></emailnotificationto>
    <tokenlength><![CDATA[15]]></tokenlength>
    <showxquestions><![CDATA[N]]></showxquestions>
    <showgroupinfo><![CDATA[X]]></showgroupinfo>
    <shownoanswer><![CDATA[N]]></shownoanswer>
    <showqnumcode><![CDATA[X]]></showqnumcode>
    <bounceprocessing><![CDATA[N]]></bounceprocessing>
    <showwelcome><![CDATA[N]]></showwelcome>
    <showprogress><![CDATA[N]]></showprogress>
    <questionindex><![CDATA[0]]></questionindex>
    <navigationdelay><![CDATA[0]]></navigationdelay>
    <nokeyboard><![CDATA[N]]></nokeyboard>
    <alloweditaftercompletion><![CDATA[Y]]></alloweditaftercompletion>
    <googleanalyticsstyle><![CDATA[0]]></googleanalyticsstyle>
    <googleanalyticsapikey/>
    <gsid><![CDATA[4]]></gsid>
    <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
   </row>
  </rows>
 </surveys>
 <surveys_languagesettings>
  <fields>
   <fieldname>surveyls_survey_id</fieldname>
   <fieldname>surveyls_language</fieldname>
   <fieldname>surveyls_title</fieldname>
   <fieldname>surveyls_description</fieldname>
   <fieldname>surveyls_welcometext</fieldname>
   <fieldname>surveyls_endtext</fieldname>
   <fieldname>surveyls_url</fieldname>
   <fieldname>surveyls_urldescription</fieldname>
   <fieldname>surveyls_email_invite_subj</fieldname>
   <fieldname>surveyls_email_invite</fieldname>
   <fieldname>surveyls_email_remind_subj</fieldname>
   <fieldname>surveyls_email_remind</fieldname>
   <fieldname>surveyls_email_register_subj</fieldname>
   <fieldname>surveyls_email_register</fieldname>
   <fieldname>surveyls_email_confirm_subj</fieldname>
   <fieldname>surveyls_email_confirm</fieldname>
   <fieldname>surveyls_dateformat</fieldname>
   <fieldname>surveyls_attributecaptions</fieldname>
   <fieldname>email_admin_notification_subj</fieldname>
   <fieldname>email_admin_notification</fieldname>
   <fieldname>email_admin_responses_subj</fieldname>
   <fieldname>email_admin_responses</fieldname>
   <fieldname>surveyls_numberformat</fieldname>
   <fieldname>attachments</fieldname>
   <fieldname>surveyls_policy_notice</fieldname>
   <fieldname>surveyls_policy_error</fieldname>
   <fieldname>surveyls_policy_notice_label</fieldname>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[592792]]></surveyls_survey_id>
    <surveyls_language><![CDATA[en]]></surveyls_language>
    <surveyls_title><![CDATA[Array count (with 3 reversely counted options)]]></surveyls_title>
    <surveyls_description/>
    <surveyls_welcometext/>
    <surveyls_endtext/>
    <surveyls_url><![CDATA[https://www.respondage.nl]]></surveyls_url>
    <surveyls_urldescription><![CDATA[Respondage website]]></surveyls_urldescription>
    <surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[Dear {FIRSTNAME},<br />
<br />
you have been invited to participate in a survey.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}<br />
<br />
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br />
{OPTINURL}]]></surveyls_email_invite>
    <surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj>
    <surveyls_email_remind><![CDATA[Dear {FIRSTNAME},<br />
<br />
Recently we invited you to participate in a survey.<br />
<br />
We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[Dear {FIRSTNAME},<br />
<br />
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br />
<br />
To complete this survey, click on the following URL:<br />
<br />
{SURVEYURL}<br />
<br />
If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]></surveyls_email_register>
    <surveyls_email_confirm_subj><![CDATA[Confirmation of your participation in our survey]]></surveyls_email_confirm_subj>
    <surveyls_email_confirm><![CDATA[Dear {FIRSTNAME},<br />
<br />
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br />
<br />
If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[2]]></surveyls_dateformat>
    <email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj>
    <email_admin_notification><![CDATA[Hello {contact_SQ001},<br />
<br />
You filled in your name in a survey named '{SURVEYNAME}' on the website of Respondage.<br /><br />
{SURVEYURL}
<br />
Thank you for your response. I will be in touch soon.<br /><br />
If by any chance I do not respond soon enough, please feel free to contact me at:<br />
tammo.terhark@respondage.nl<br />
<br />
Thank you, <br />
<br />
Tammo ter Hark<br />
Respondage]]></email_admin_notification>
    <email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj>
    <email_admin_responses><![CDATA[Hello,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{STATISTICSURL}<br />
<br />
<br />
The following answers were given by the participant:<br />
{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
    <attachments><![CDATA[a:0:{}]]></attachments>
   </row>
  </rows>
 </surveys_languagesettings>
 <themes>
  <theme>
   <sid>592792</sid>
   <template_name>respondage_respondage</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
 </themes>
 <themes_inherited>
  <theme>
   <sid>592792</sid>
   <template_name>respondage_respondage</template_name>
   <config>
    <options>
     <animatebody>off</animatebody>
     <hideprivacyinfo>off</hideprivacyinfo>
     <container>on</container>
     <bodyanimation>fadeInRight</bodyanimation>
     <brandlogo>on</brandlogo>
     <brandlogofile>./files/logo.png</brandlogofile>
     <font>noto</font>
     <showpopups>1</showpopups>
     <fixnumauto>off</fixnumauto>
    </options>
   </config>
  </theme>
 </themes_inherited>
</document>
limesurvey_survey_592792.lss (33,472 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)3.27.1
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)Centos
Webserver software & version (if known)
PHP Version7.3

Relationships

duplicate of 16774 closedc_schmitz Problem with {SURVEYURL} in admin notifications 

Activities

DenisChenu

DenisChenu

2021-06-11 14:53

developer   ~64870

Last edited: 2021-06-11 14:54

In admin notification.

  1. Show clearly as invalid
  2. Only for participant in manual

https://manual.limesurvey.org/Email_templates/en#Email_Placeholders
The URL to start the survey - if you are sending HTML emails, a full URL will be displayed to the survey participant

edit : AND
The following placeholders are allowed in invitation/reminder email templates (subject and/or body fields) and they will be replaced when sending out the emails:

My opinion : Not a bug.

tammo

tammo

2021-06-11 14:59

developer   ~64871

I see now. Not a bug, but still something a user might expect to work.
Probably not important enough to fix. Although it could be easy for a developer, I guess... ;-)

DenisChenu

DenisChenu

2021-06-11 15:18

developer   ~64872

Really easy in 4.X and more.

For 3.X : need to copy/paste https://gitlab.com/SondagesPro/mailing/adminNotificationHtmlAnswerTable

DenisChenu

DenisChenu

2021-06-11 15:19

developer   ~64873

The issue is more : if there are no token : what is SURVEYURL ?

See https://gitlab.com/SondagesPro/coreAndTools/reloadAnyResponse

tammo

tammo

2021-06-11 15:45

developer   ~64874

Denis: The issue is more : if there are no token : what is SURVEYURL ?

The survey url could be what is shown in the surveyscreen n(see attachment) or what is under the button: "Execute survey"
https://research.respondage.eu/index.php/592792?newtest=Y&amp;lang=en

Since email templates are language sensitive, the URL could also be localised.

DenisChenu

DenisChenu

2021-06-11 15:47

developer   ~64875

With token enable survey : SURVEYURL allow you to load the reponse by the token user (or show a "This token was already used")

Then : your SURVEYURL is not the same :)

for admin : we have VIEWRESPONSEURL and EDITRESPONSEURL

DenisChenu

DenisChenu

2021-06-11 15:47

developer   ~64876

PS : with reloadAnyReponse EDITRESPONSEURL can be SURVEYURL ;)

tammo

tammo

2021-06-11 16:10

developer   ~64883

Yes, you are right, this only works for surveys without tokens... So not usable now... ;-(
I could think of {PLAINSURVEYURL} for the url without any additions, but let's leave it for now.

ollehar

ollehar

2021-06-11 17:21

administrator   ~64884

Duplicate of 16774?

tammo

tammo

2021-06-11 17:24

developer   ~64885

Yes, duplicate.

Issue History

Date Modified Username Field Change
2021-06-11 14:46 tammo New Issue
2021-06-11 14:46 tammo File Added: limesurvey_survey_592792.lss
2021-06-11 14:53 DenisChenu Note Added: 64870
2021-06-11 14:54 DenisChenu Summary {SURVEYURL} does not get replaced in email template => {SURVEYURL} does not get replaced in admin email notification
2021-06-11 14:54 DenisChenu Note Edited: 64870
2021-06-11 14:59 tammo Note Added: 64871
2021-06-11 15:18 DenisChenu Note Added: 64872
2021-06-11 15:19 DenisChenu Note Added: 64873
2021-06-11 15:45 tammo Note Added: 64874
2021-06-11 15:45 tammo File Added: Firefox_Screenshot_2021-06-11T13-43-26.406Z.png
2021-06-11 15:47 DenisChenu Note Added: 64875
2021-06-11 15:47 DenisChenu Note Added: 64876
2021-06-11 16:10 tammo Note Added: 64883
2021-06-11 17:21 ollehar Relationship added duplicate of 16774
2021-06-11 17:21 ollehar Note Added: 64884
2021-06-11 17:24 tammo Note Added: 64885
2021-06-11 17:28 ollehar Assigned To => ollehar
2021-06-11 17:28 ollehar Status new => closed
2021-06-11 17:28 ollehar Resolution open => duplicate