View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17364 | Bug reports | Expression Manager | public | 2021-06-11 14:46 | 2021-06-11 17:28 |
| Reporter | tammo | Assigned To | ollehar | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | duplicate | ||
| Product Version | 3.25.20 | ||||
| Target Version | 3.x | ||||
| Summary | 17364: {SURVEYURL} does not get replaced in admin email notification | ||||
| Description | Using: Hello {contact_SQ001}, | ||||
| Steps To Reproduce | Load attached survey. | ||||
| Tags | No 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>
| ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 3.27.1 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MySQL | ||||
| Server OS (if known) | Centos | ||||
| Webserver software & version (if known) | |||||
| PHP Version | 7.3 | ||||
|
In admin notification.
https://manual.limesurvey.org/Email_templates/en#Email_Placeholders edit : AND My opinion : Not a bug. |
|
|
I see now. Not a bug, but still something a user might expect to work. |
|
|
Really easy in 4.X and more. For 3.X : need to copy/paste https://gitlab.com/SondagesPro/mailing/adminNotificationHtmlAnswerTable |
|
|
The issue is more : if there are no token : what is SURVEYURL ? See https://gitlab.com/SondagesPro/coreAndTools/reloadAnyResponse |
|
|
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" Since email templates are language sensitive, the URL could also be localised. |
|
|
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 |
|
|
PS : with reloadAnyReponse EDITRESPONSEURL can be SURVEYURL ;) |
|
|
Yes, you are right, this only works for surveys without tokens... So not usable now... ;-( |
|
|
Duplicate of 16774? |
|
|
Yes, duplicate. |
|
| 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 |