View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
17501Bug reportsImport/Exportpublic2021-09-06 10:59
ReporterGuernseyResearch Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionreopened 
Product Version5.x 
Summary17501: Export of a survey with a single space in the Subquestion of an array results in the word "array" inserted
Description

In order to provide a proper screen display of a question with a single row the subquestion was replaced with a single space and the column width set to one.
Export is incorrect as the space is replaced by the word "array". Later when an import is done the word array is displayed.

Steps To Reproduce

Create a question of Array (Type F)
Enter the question
In the only subquestion enter just a single space
On "Display" set the sub-question width to "1"

(attached is an .lsq file of the question)

Export the survey as a tab-separated-values format
View the export file to see that the single space has been replaced with the word "array" (see attached graphic to match question)

Additional Information

Possibly related:

I created a survey with just that single question above.
I exported the survey
I imported the survey
The imported survey has the question and NO subquestion - it appears to have lost the "space"

TagsNo tags attached.
Attached Files
limesurvey_question_605.lsq (7,190 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Question</LimeSurveyDocType>
 <DBVersion>452</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>encrypted</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[605]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[684317]]></sid>
    <gid><![CDATA[5]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q22]]></title>
    <preg/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <encrypted><![CDATA[N]]></encrypted>
    <question_order><![CDATA[30]]></question_order>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </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>preg</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>encrypted</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
   <fieldname>id</fieldname>
   <fieldname>question</fieldname>
   <fieldname>help</fieldname>
   <fieldname>script</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[648]]></qid>
    <parent_qid><![CDATA[605]]></parent_qid>
    <sid><![CDATA[684317]]></sid>
    <gid><![CDATA[5]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[SQ001]]></title>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <encrypted><![CDATA[N]]></encrypted>
    <question_order><![CDATA[1]]></question_order>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
    <id><![CDATA[648]]></id>
    <question><![CDATA[ ]]></question>
    <help/>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </subquestions>
 <question_l10ns>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>qid</fieldname>
   <fieldname>question</fieldname>
   <fieldname>help</fieldname>
   <fieldname>script</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[605]]></id>
    <qid><![CDATA[605]]></qid>
    <question><![CDATA[How satisfied are you with the overall purchase process for this invoice? Use a scale from 1-7 where 1 is extremely dissatisfied and 7 is extremely satisfied.]]></question>
    <help/>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </question_l10ns>
 <answers>
  <fields>
   <fieldname>aid</fieldname>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <aid><![CDATA[145]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A1]]></code>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[53]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A2]]></code>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[133]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A3]]></code>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[134]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A4]]></code>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[135]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A5]]></code>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[136]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A6]]></code>
    <sortorder><![CDATA[6]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[137]]></aid>
    <qid><![CDATA[605]]></qid>
    <code><![CDATA[A7]]></code>
    <sortorder><![CDATA[7]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <answer_l10ns>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>aid</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[145]]></id>
    <aid><![CDATA[145]]></aid>
    <answer><![CDATA[<span style="white-space: nowrap;">Extremely </span><br><span style="white-space: nowrap;">dissatisfied - 1</span>]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[53]]></id>
    <aid><![CDATA[53]]></aid>
    <answer><![CDATA[2]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[133]]></id>
    <aid><![CDATA[133]]></aid>
    <answer><![CDATA[3]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[134]]></id>
    <aid><![CDATA[134]]></aid>
    <answer><![CDATA[4]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[135]]></id>
    <aid><![CDATA[135]]></aid>
    <answer><![CDATA[5]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[136]]></id>
    <aid><![CDATA[136]]></aid>
    <answer><![CDATA[6]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[137]]></id>
    <aid><![CDATA[137]]></aid>
    <answer><![CDATA[<span style="white-space: nowrap;">Extremely </span><br><span style="white-space: nowrap;">satisfied - 7</span>]]></answer>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </answer_l10ns>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[605]]></qid>
    <attribute><![CDATA[answer_width]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
  </rows>
 </question_attributes>
</document>
limesurvey_question_605.lsq (7,190 bytes)   
survey export clip.jpg (130,458 bytes)
Bug heat8
Complete LimeSurvey version number (& build)Version 5.0.13+210804
I will donate to the project if issue is resolvedNo
Browsern/a
Database type & version mysqlnd 5.0.12-dev - 20150407
Server OS (if known)
Webserver software & version (if known)
PHP Version7.3.29

Relationships

related to 17506 closedc_schmitz Error while upgrading a database from Ver 3.2.7.11+210809 to Ver 5.0.14+210811 

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2021-08-09 15:41

administrator   ~65886

Please always attach a complete lss file and not lsq. Otherwise we have to guess which language(s) are used in the lsq file, or check manually. Thank you.

GuernseyResearch

GuernseyResearch

2021-08-09 23:45

reporter   ~65895

I cannot reproduce this in a single question survey so I have attached the LSS file for the survey where we are having the problem.
Q22, Q24, Q29, Q39, and "conf" are the questions that have this problem. This survey is only in English.

GuernseyResearch

GuernseyResearch

2021-08-09 23:53

reporter   ~65896

Ignore the previous comment

Attached is the LSS for a single question survey (Q22)
Export the survey as TXT
Import into a new survey and the question will have lost its subquestion.

limesurvey_survey_839379.lss (19,882 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>452</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <answers>
  <fields>
   <fieldname>aid</fieldname>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <aid><![CDATA[884]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A1]]></code>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[885]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A2]]></code>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[886]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A3]]></code>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[887]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A4]]></code>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[888]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A5]]></code>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[889]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A6]]></code>
    <sortorder><![CDATA[6]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <aid><![CDATA[890]]></aid>
    <qid><![CDATA[1868]]></qid>
    <code><![CDATA[A7]]></code>
    <sortorder><![CDATA[7]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <answer_l10ns>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>aid</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[1322]]></id>
    <aid><![CDATA[884]]></aid>
    <answer><![CDATA[<span style="white-space: nowrap;">Extremely </span><br><span style="white-space: nowrap;">dissatisfied - 1</span>]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1323]]></id>
    <aid><![CDATA[885]]></aid>
    <answer><![CDATA[2]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1324]]></id>
    <aid><![CDATA[886]]></aid>
    <answer><![CDATA[3]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1325]]></id>
    <aid><![CDATA[887]]></aid>
    <answer><![CDATA[4]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1326]]></id>
    <aid><![CDATA[888]]></aid>
    <answer><![CDATA[5]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1327]]></id>
    <aid><![CDATA[889]]></aid>
    <answer><![CDATA[6]]></answer>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[1328]]></id>
    <aid><![CDATA[890]]></aid>
    <answer><![CDATA[<span style="white-space: nowrap;">Extremely </span><br><span style="white-space: nowrap;">satisfied - 7</span>]]></answer>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </answer_l10ns>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[54]]></gid>
    <sid><![CDATA[839379]]></sid>
    <group_order><![CDATA[1]]></group_order>
    <randomization_group/>
    <grelevance><![CDATA[1]]></grelevance>
   </row>
  </rows>
 </groups>
 <group_l10ns>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[124]]></id>
    <gid><![CDATA[54]]></gid>
    <group_name><![CDATA[My first question group]]></group_name>
    <description/>
    <language><![CDATA[en]]></language>
    <sid><![CDATA[839379]]></sid>
    <group_order><![CDATA[1]]></group_order>
    <randomization_group/>
    <grelevance><![CDATA[1]]></grelevance>
   </row>
  </rows>
 </group_l10ns>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>encrypted</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[1867]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[839379]]></sid>
    <gid><![CDATA[54]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[Q00]]></title>
    <preg/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <encrypted><![CDATA[N]]></encrypted>
    <question_order><![CDATA[0]]></question_order>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[1868]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[839379]]></sid>
    <gid><![CDATA[54]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q22]]></title>
    <preg/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <encrypted><![CDATA[N]]></encrypted>
    <question_order><![CDATA[1]]></question_order>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </questions>
 <question_l10ns>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>qid</fieldname>
   <fieldname>question</fieldname>
   <fieldname>help</fieldname>
   <fieldname>script</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[2338]]></id>
    <qid><![CDATA[1867]]></qid>
    <question><![CDATA[A first example question. Please answer this question:]]></question>
    <help><![CDATA[This is a question help text.]]></help>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <id><![CDATA[2339]]></id>
    <qid><![CDATA[1868]]></qid>
    <question><![CDATA[How satisfied are you with the overall purchase process for this invoice? Use a scale from 1-7 where 1 is extremely dissatisfied and 7 is extremely satisfied.]]></question>
    <help/>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </question_l10ns>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[1867]]></qid>
    <attribute><![CDATA[id]]></attribute>
    <value><![CDATA[1860]]></value>
    <language/>
   </row>
   <row>
    <qid><![CDATA[1868]]></qid>
    <attribute><![CDATA[answer_width]]></attribute>
    <value><![CDATA[1]]></value>
    <language/>
   </row>
   <row>
    <qid><![CDATA[1868]]></qid>
    <attribute><![CDATA[id]]></attribute>
    <value><![CDATA[1861]]></value>
    <language/>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>gsid</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>ipanonymize</fieldname>
   <fieldname>refurl</fieldname>
   <fieldname>showsurveypolicynotice</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>tokenencryptionoptions</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[839379]]></sid>
    <gsid><![CDATA[1]]></gsid>
    <admin><![CDATA[inherit]]></admin>
    <adminemail><![CDATA[inherit]]></adminemail>
    <anonymized><![CDATA[N]]></anonymized>
    <format><![CDATA[I]]></format>
    <savetimings><![CDATA[I]]></savetimings>
    <template><![CDATA[inherit]]></template>
    <language><![CDATA[en]]></language>
    <additional_languages/>
    <datestamp><![CDATA[I]]></datestamp>
    <usecookie><![CDATA[I]]></usecookie>
    <allowregister><![CDATA[I]]></allowregister>
    <allowsave><![CDATA[I]]></allowsave>
    <autonumber_start><![CDATA[0]]></autonumber_start>
    <autoredirect><![CDATA[I]]></autoredirect>
    <allowprev><![CDATA[I]]></allowprev>
    <printanswers><![CDATA[I]]></printanswers>
    <ipaddr><![CDATA[I]]></ipaddr>
    <ipanonymize><![CDATA[I]]></ipanonymize>
    <refurl><![CDATA[I]]></refurl>
    <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
    <publicstatistics><![CDATA[I]]></publicstatistics>
    <publicgraphs><![CDATA[I]]></publicgraphs>
    <listpublic><![CDATA[I]]></listpublic>
    <htmlemail><![CDATA[I]]></htmlemail>
    <sendconfirmation><![CDATA[I]]></sendconfirmation>
    <tokenanswerspersistence><![CDATA[I]]></tokenanswerspersistence>
    <assessments><![CDATA[I]]></assessments>
    <usecaptcha><![CDATA[E]]></usecaptcha>
    <usetokens><![CDATA[N]]></usetokens>
    <bounce_email><![CDATA[inherit]]></bounce_email>
    <emailresponseto><![CDATA[inherit]]></emailresponseto>
    <emailnotificationto><![CDATA[inherit]]></emailnotificationto>
    <tokenlength><![CDATA[-1]]></tokenlength>
    <showxquestions><![CDATA[I]]></showxquestions>
    <showgroupinfo><![CDATA[I]]></showgroupinfo>
    <shownoanswer><![CDATA[I]]></shownoanswer>
    <showqnumcode><![CDATA[I]]></showqnumcode>
    <bounceprocessing><![CDATA[N]]></bounceprocessing>
    <showwelcome><![CDATA[I]]></showwelcome>
    <showprogress><![CDATA[I]]></showprogress>
    <questionindex><![CDATA[-1]]></questionindex>
    <navigationdelay><![CDATA[-1]]></navigationdelay>
    <nokeyboard><![CDATA[I]]></nokeyboard>
    <alloweditaftercompletion><![CDATA[I]]></alloweditaftercompletion>
    <tokenencryptionoptions/>
   </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_policy_notice</fieldname>
   <fieldname>surveyls_policy_error</fieldname>
   <fieldname>surveyls_policy_notice_label</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>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[839379]]></surveyls_survey_id>
    <surveyls_language><![CDATA[en]]></surveyls_language>
    <surveyls_title><![CDATA[array problem]]></surveyls_title>
    <surveyls_url/>
    <surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[Dear {FIRSTNAME},you have been invited to participate in a survey.The survey is titled:"{SURVEYNAME}""{SURVEYDESCRIPTION}"To participate, please click on the link below.Sincerely,{ADMINNAME} ({ADMINEMAIL})----------------------------------------------Click here to do the survey:{SURVEYURL}If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:{OPTOUTURL}If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:{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},Recently we invited you to participate in a survey.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.The survey is titled:"{SURVEYNAME}""{SURVEYDESCRIPTION}"To participate, please click on the link below.Sincerely,{ADMINNAME} ({ADMINEMAIL})----------------------------------------------Click here to do the survey:{SURVEYURL}If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:{OPTOUTURL}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[Dear {FIRSTNAME},You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.To complete this survey, click on the following URL:{SURVEYURL}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},this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.Sincerely,{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[9]]></surveyls_dateformat>
    <email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj>
    <email_admin_notification><![CDATA[Hello,A new response was submitted for your survey '{SURVEYNAME}'.Click the following link to see the individual response:{VIEWRESPONSEURL}Click the following link to edit the individual response:{EDITRESPONSEURL}View statistics by clicking here:{STATISTICSURL}]]></email_admin_notification>
    <email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj>
    <email_admin_responses><![CDATA[Hello,A new response was submitted for your survey '{SURVEYNAME}'.Click the following link to see the individual response:{VIEWRESPONSEURL}Click the following link to edit the individual response:{EDITRESPONSEURL}View statistics by clicking here:{STATISTICSURL}The following answers were given by the participant:{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
   </row>
  </rows>
 </surveys_languagesettings>
 <themes>
  <theme>
   <sid>839379</sid>
   <template_name>fruity</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
 </themes>
 <themes_inherited>
  <theme>
   <sid>839379</sid>
   <template_name>fruity</template_name>
   <config>
    <options>
     <ajaxmode>off</ajaxmode>
     <brandlogo>on</brandlogo>
     <brandlogofile>themes/survey/fruity/files/logo.png</brandlogofile>
     <container>on</container>
     <backgroundimage>off</backgroundimage>
     <animatebody>off</animatebody>
     <bodyanimation>fadeInRight</bodyanimation>
     <bodyanimationduration>500</bodyanimationduration>
     <animatequestion>off</animatequestion>
     <questionanimation>flipInX</questionanimation>
     <questionanimationduration>500</questionanimationduration>
     <animatealert>off</animatealert>
     <alertanimation>shake</alertanimation>
     <alertanimationduration>500</alertanimationduration>
     <font>noto</font>
     <bodybackgroundcolor>#ffffff</bodybackgroundcolor>
     <fontcolor>#444444</fontcolor>
     <questionbackgroundcolor>#ffffff</questionbackgroundcolor>
     <questionborder>on</questionborder>
     <questioncontainershadow>on</questioncontainershadow>
     <checkicon>f00c</checkicon>
     <animatecheckbox>on</animatecheckbox>
     <checkboxanimation>rubberBand</checkboxanimation>
     <checkboxanimationduration>500</checkboxanimationduration>
     <animateradio>on</animateradio>
     <radioanimation>zoomIn</radioanimation>
     <radioanimationduration>500</radioanimationduration>
     <zebrastriping>off</zebrastriping>
     <stickymatrixheaders>off</stickymatrixheaders>
     <greyoutselected>off</greyoutselected>
     <hideprivacyinfo>off</hideprivacyinfo>
     <crosshover>off</crosshover>
     <showpopups>1</showpopups>
     <showclearall>off</showclearall>
     <questionhelptextposition>top</questionhelptextposition>
     <notables>1</notables>
    </options>
   </config>
  </theme>
 </themes_inherited>
</document>
limesurvey_survey_839379.lss (19,882 bytes)   
galads

galads

2021-08-13 15:55

reporter   ~65968

I cannot reproduce this issue. Can you check if this still exists in the latest release?

GuernseyResearch

GuernseyResearch

2021-08-14 01:42

reporter   ~65981

Problem still exists in Version 5.1.2+210813

Start with the attached lss above
export as a tab-separated-values format (TXT)
create a new survey by importing that TXT file.
Look at the second question which no longer has a sub-question because the single space has been lost. If you import the TXT file into EXCEL you will find the sub question does not exist.

galads

galads

2021-08-16 08:27

reporter   ~65983

Thank you for providing more information. I can reproduce this error.

c_schmitz

c_schmitz

2021-08-16 08:38

administrator   ~65984

The survey "limesurvey_survey_839379.lss" you attached does not have any subquestions.

c_schmitz

c_schmitz

2021-08-16 09:00

administrator   ~65987

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=32541

GuernseyResearch

GuernseyResearch

2021-08-16 16:13

reporter   ~66005

Sorry, but the problem is NOT fixed in Version 5.1.3+210817

c_schmitz

c_schmitz

2021-08-17 07:54

administrator   ~66019

It works for me just fine, please check again.
What is not working for you in detail?

GuernseyResearch

GuernseyResearch

2021-08-17 19:08

reporter   ~66044

I created a fresh install of Version 5.1.3+210817 and ran the test again. It does work, although if you EDIT the question it does not appear the subquestion exists. You may close this bug.

Related Changesets

LimeSurvey: master 838a9849

2021-08-16 08:59:56

c_schmitz

Details Diff
Fixed issue 17501: TSV export of survey with empty subquestion text has word "array" inserted instead Affected Issues
17501
mod - application/helpers/export_helper.php Diff File

Issue History

Date Modified Username Field Change
2021-08-07 00:59 GuernseyResearch New Issue
2021-08-07 00:59 GuernseyResearch File Added: limesurvey_question_605.lsq
2021-08-07 00:59 GuernseyResearch File Added: survey export clip.jpg
2021-08-09 15:40 ollehar Priority none => normal
2021-08-09 15:41 ollehar Note Added: 65886
2021-08-09 15:41 ollehar Bug heat 0 => 2
2021-08-09 23:45 GuernseyResearch Note Added: 65895
2021-08-09 23:45 GuernseyResearch File Added: limesurvey_survey_684317.txt
2021-08-09 23:45 GuernseyResearch Bug heat 2 => 4
2021-08-09 23:50 GuernseyResearch File Deleted: limesurvey_survey_684317.txt
2021-08-09 23:53 GuernseyResearch Note Added: 65896
2021-08-09 23:53 GuernseyResearch File Added: limesurvey_survey_839379.lss
2021-08-12 11:02 galads Assigned To => galads
2021-08-12 11:02 galads Status new => acknowledged
2021-08-12 16:34 c_schmitz Relationship added related to 17506
2021-08-13 15:55 galads Note Added: 65968
2021-08-13 15:55 galads Bug heat 4 => 6
2021-08-13 15:55 galads Status acknowledged => feedback
2021-08-14 01:42 GuernseyResearch Note Added: 65981
2021-08-14 01:42 GuernseyResearch Status feedback => assigned
2021-08-16 08:27 galads Note Added: 65983
2021-08-16 08:27 galads Status assigned => confirmed
2021-08-16 08:38 c_schmitz Status confirmed => feedback
2021-08-16 08:38 c_schmitz Note Added: 65984
2021-08-16 08:38 c_schmitz Bug heat 6 => 8
2021-08-16 09:00 c_schmitz Changeset attached => LimeSurvey master 838a9849
2021-08-16 09:00 c_schmitz Note Added: 65987
2021-08-16 09:00 c_schmitz Assigned To galads => c_schmitz
2021-08-16 09:00 c_schmitz Resolution open => fixed
2021-08-16 09:00 c_schmitz Status feedback => resolved
2021-08-16 16:13 GuernseyResearch Note Added: 66005
2021-08-16 16:14 ollehar Status resolved => new
2021-08-16 16:14 ollehar Resolution fixed => reopened
2021-08-17 07:54 c_schmitz Status new => feedback
2021-08-17 07:54 c_schmitz Note Added: 66019
2021-08-17 19:08 GuernseyResearch Note Added: 66044
2021-08-17 19:08 GuernseyResearch Status feedback => assigned
2021-08-17 19:10 ollehar Status assigned => closed
2021-08-18 09:02 galads Status closed => resolved
2021-09-06 10:59 c_schmitz Status resolved => closed