Hi,

I found that some field types cannot be exported.

Indeed, the format of the fields of the sql queries is not good.

I don't know if it's good practice, I fixed the problem.

The file : common_helper.php

The function : createCompleteSGQA($iSurveyID, $aFilters, $sLanguage)

--- a/public/ls/application/helpers/common_helper.php
+++ b/public/ls/application/helpers/common_helper.php
@@ -1184,7 +1184,8 @@ function createCompleteSGQA($iSurveyID, $aFilters, $sLanguage)

             //go through all the (multiple) answers
             foreach ($result as $row) {

• $myfield2 = $flt['type'] . $myfield . reset($row);
• //$myfield2 = $flt['type'] . $myfield . reset($row);

• $myfield2 = $flt['type'].$myfield .$row['title'];//fix bug probesys
  $allfields[] = $myfield2;
  }
  break;
  @@ -1199,7 +1200,8 @@ function createCompleteSGQA($iSurveyID, $aFilters, $sLanguage)

           //go through all the (multiple) answers
           foreach ($result as $row) {

• $myfield2 = $myfield . reset($row);
• //$myfield2 = $myfield . reset($row);
• $myfield2 = $myfield .$row['title'];//fix bug probesys
  $allfields[] = $myfield2;
  }
  break;
  @@ -1217,7 +1219,8 @@ function createCompleteSGQA($iSurveyID, $aFilters, $sLanguage)
  foreach ($result as $row) {
  $fresult = Question::model()->getQuestionsForStatistics('title, question', "parent_qid=$flt[qid] AND language = '{$sLanguage}' AND scale_id = 1", 'question_order');
  foreach ($fresult as $frow) {
• $myfield2 = $myfield . reset($row) . "_" . $frow['title'];
• //$myfield2 = $myfield . reset($row) . "_" . $frow['title'];
• $myfield2 = $myfield .$row['title']. "_" . $frow['title'];//fix bug probesys
  $allfields[] = $myfield2;
  }
  }