View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
10044Bug reportsImport/Exportpublic2015-11-17 13:532016-02-06 01:16
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary10044: Subquestions are not imported when importing array question lsq file
Description

When importing a array question with several subqeustions (lsq file), the subquestions are not imported. The answer options are OK.

Steps To Reproduce

Setup questionnaire. Import array question separately from lsq file (attached).

TagsNo tags attached.
Attached Files
Import_Vrg_limesurvey_question_46709.lsq (6,686 bytes)    
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Question</LimeSurveyDocType>
 <DBVersion>184</DBVersion>
 <languages>
  <language>nl</language>
 </languages>
 <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>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[46709]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[98255]]></sid>
    <gid><![CDATA[3343]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[sf36Q11]]></title>
    <question><![CDATA[11. Hoe JUIST of ONJUIST is <u>elk</u> van van de volgende uitspraken voor u? <i>(Kies &eacute;&eacute;n antwoordoptie op elke regel.)</i>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[40]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <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>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[46751]]></qid>
    <parent_qid><![CDATA[46709]]></parent_qid>
    <sid><![CDATA[98255]]></sid>
    <gid><![CDATA[3343]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[a]]></title>
    <question><![CDATA[a. Ik lijk wat gemakkelijker ziek te worden dan andere mensen ]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[ ]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[46752]]></qid>
    <parent_qid><![CDATA[46709]]></parent_qid>
    <sid><![CDATA[98255]]></sid>
    <gid><![CDATA[3343]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[b]]></title>
    <question><![CDATA[b. Ik ben even gezond als andere mensen die ik ken]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[ ]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[46753]]></qid>
    <parent_qid><![CDATA[46709]]></parent_qid>
    <sid><![CDATA[98255]]></sid>
    <gid><![CDATA[3343]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[c]]></title>
    <question><![CDATA[c. Ik verwacht dat mijn gezondheid achteruit zal gaan]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[ ]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[46754]]></qid>
    <parent_qid><![CDATA[46709]]></parent_qid>
    <sid><![CDATA[98255]]></sid>
    <gid><![CDATA[3343]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[d]]></title>
    <question><![CDATA[d. Mijn gezondheid is uitstekend]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[ ]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
  </rows>
 </subquestions>
 <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[46709]]></qid>
    <code><![CDATA[1]]></code>
    <answer><![CDATA[Volkomen juist]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[46709]]></qid>
    <code><![CDATA[2]]></code>
    <answer><![CDATA[Grotendeels juist]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[46709]]></qid>
    <code><![CDATA[3]]></code>
    <answer><![CDATA[Weet ik niet]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[46709]]></qid>
    <code><![CDATA[4]]></code>
    <answer><![CDATA[Grotendeels onjuist]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[46709]]></qid>
    <code><![CDATA[5]]></code>
    <answer><![CDATA[Volkomen onjuist]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[1]]></assessment_value>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[46709]]></qid>
    <attribute><![CDATA[answer_width]]></attribute>
    <value><![CDATA[50]]></value>
   </row>
  </rows>
 </question_attributes>
</document>
Import_Vrg_limesurvey_question_46709.lsq (6,686 bytes)   
Capture du 2015-11-19 09-24-06.png (11,098 bytes)   
Capture du 2015-11-19 09-24-06.png (11,098 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)2.06+ 151018 (also 150911)
I will donate to the project if issue is resolvedNo
BrowserAny
Database type & versionMS SQL server 2008R2 10.50.6220 (X64)
Server OS (if known)DB server: Windows NT 6.1 <X64> build 7601 SP1
Webserver software & version (if known)Linux RHEL 7, Apache 2.4.6
PHP Version5.6.13

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-11-19 09:05

developer   ~33591

What is the language of the lsq (to test import on last version) ?
fvanderstarre

fvanderstarre

2015-11-19 09:06

reporter   ~33592

It's in Dutch ('nl').
DenisChenu

DenisChenu

2015-11-19 09:27

developer   ~33594

Next time : better in english please. Confirm issue , and information returned is bad
No Sub question in DB at this time.
c_schmitz

c_schmitz

2015-12-04 12:32

administrator   ~33682

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

c_schmitz

2015-12-04 12:32

administrator   ~33683

The subquestions cannot be imported because the mandatory field is set to a blank space.
This usually points to problem with an incorrectly configure MSSQL driver now or in the past ( see https://manual.limesurvey.org/Troubleshooting/de#No_questions_are_shown_when_using_MSSQL_Server_with_FreeTDS_on_Linux ) or the file was edited manually.
c_schmitz

c_schmitz

2015-12-04 15:13

administrator   ~33691

2.06+ Build 151205 released
fvanderstarre

fvanderstarre

2016-01-22 07:52

reporter   ~34332

Hi Carsten, I just installed 2.06+ build 160121 to test lsq file import.
It is now correctly stated that 0 subquestions are imported - but that was not what I considered to be the bug! I checked TDS version in freetds.conf, it's set to 8.0.
So I think the real issue still has to be fixed....

Frank
c_schmitz

c_schmitz

2016-02-06 01:16

administrator   ~34673

Well, if the file is valid it will get correctly imported.
The file is invalid so there is no bug, except the part already corrected.

Related Changesets

LimeSurvey: master 618588fa

2015-12-04 11:32:15

c_schmitz

Details Diff 		Fixed issue 10044: Subquestions are shown as imported even when skipped due to malformed SQL Affected Issues
10044
mod - application/helpers/admin/import_helper.php Diff File

Issue History

Date Modified Username Field Change
2015-11-17 13:53 fvanderstarre New Issue
2015-11-17 13:53 fvanderstarre File Added: Import_Vrg_limesurvey_question_46709.lsq
2015-11-19 09:05 DenisChenu Note Added: 33591
2015-11-19 09:06 fvanderstarre Note Added: 33592
2015-11-19 09:27 DenisChenu Note Added: 33594
2015-11-19 09:27 DenisChenu File Added: Capture du 2015-11-19 09-24-06.png
2015-12-04 11:45 c_schmitz Assigned To => c_schmitz
2015-12-04 11:45 c_schmitz Status new => assigned
2015-12-04 12:32 c_schmitz Changeset attached => LimeSurvey master 618588fa
2015-12-04 12:32 c_schmitz Note Added: 33682
2015-12-04 12:32 c_schmitz Resolution open => fixed
2015-12-04 12:32 c_schmitz Note Added: 33683
2015-12-04 12:32 c_schmitz Status assigned => resolved
2015-12-04 12:32 c_schmitz Fixed in Version => 2.06+
2015-12-04 15:13 c_schmitz Note Added: 33691
2015-12-04 15:13 c_schmitz Status resolved => closed
2016-01-22 07:52 fvanderstarre Note Added: 34332
2016-01-22 07:52 fvanderstarre Status closed => feedback
2016-01-22 07:52 fvanderstarre Resolution fixed => reopened
2016-02-06 01:16 c_schmitz Note Added: 34673
2016-02-06 01:16 c_schmitz Status feedback => closed
2016-02-06 01:16 c_schmitz Resolution reopened => unable to reproduce