Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Import d'un fichier csv pour les invitations avec gestions des doublons - KO ?

  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago - 8 years 7 months ago #124669 by riqcles
Bonsoir,
J'avais vraiment un doute, mais je viens de tester l'import d'un fichier csv sur différentes version de limesurvey et BDD.
J'ajoute les captures d'écrans qui parle d'elle même, ainsi que le fichier csv.

Je n'ai pas pu essayer en BDD Mysql pour la dernière build : Version 2.06+ Build 150831.

Qui peut essayer pour qu'on confirme le post d'un bug ?

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
Last edit: 8 years 7 months ago by riqcles. Reason: ajout des fichiers
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago #124670 by riqcles
Je rajoute le code en mode debug sur la dernière build avec la BDD Postgres :


PHP notice

Undefined variable: writearray

/applis/galileo/apache/htdocs/limesurvey/application/controllers/admin/tokens.php(2125)

2113 $aWriteArray=isset($aWriteArray)?$aWriteArray:$sBaseLanguage;
2114
2115 if ($bFilterDuplicateToken)
2116 {
2117 $aParams=array();
2118 $oCriteria= new CDbCriteria;
2119 $oCriteria->condition="";
2120 foreach ($aFilterDuplicateFields as $field)
2121 {
2122 if (isset($aWriteArray[$field]))
2123 {
2124 $oCriteria->addCondition("{$field} = :{$field}");
2125 $aParams[":{$field}"]=$writearray[$field];
2126 }
2127 }
2128 if(!empty($aParams))
2129 $oCriteria->params=$aParams;
2130 $dupresult = TokenDynamic::model($iSurveyId)->count($oCriteria);
2131 if ($dupresult > 0)
2132 {
2133 $bDuplicateFound = true;
2134 $aDuplicateList[] = sprintf(gt("Line %s : %s %s (%s)"),$recordcount,$writearray,$writearray,$writearray);
2135 }
2136 }
2137

Stack Trace
#0
unknown(0): tokens->import("546693")
#1
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/actions/CAction.php(108): ReflectionMethod->invokeArgs(tokens, array("546693"))
#2

/applis/galileo/apache/htdocs/limesurvey/application/core/Survey_Common_Action.php(99): CAction->runWithParamsInternal(tokens, ReflectionMethod, array("surveyid" => "546693", "sa" => "import", "iSurveyId" => "546693", "iSurveyID" => "546693"))

094 $oMethod = new ReflectionMethod($this, $sDefault);
095 }
096
097 // We're all good to go, let's execute it
098 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
099 return parent::runWithParamsInternal($this, $oMethod, $params);
100 }
101
102 /**
103 * Some functions have different parameters, which are just an alias of the
104 * usual parameters we're getting in the url. This function just populates

#3
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("surveyid" => "546693", "sa" => "import"))
#4
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/CController.php(286): CController->runAction(tokens)
#5
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/CController.php(265): CController->runActionWithFilters(tokens, array())
#6

/applis/galileo/apache/htdocs/limesurvey/application/controllers/AdminController.php(164): CController->run("tokens")

159 $this->redirect(array('/admin/authentication/sa/login'));
160 }
161
162 }
163
164 return parent::run($action);
165 }
166
167 /**
168 * Routes all the actions to their respective places
169 *

#7
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/CWebApplication.php(282): AdminController->run("tokens")
#8
+
/applis/galileo/apache/htdocs/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/tokens/sa/import")
#9
+
/applis/galileo/apache/htdocs/limesurvey/framework/base/CApplication.php(184): CWebApplication->processRequest()
#10

/applis/galileo/apache/htdocs/limesurvey/index.php(211): CApplication->run()

206 die (sprintf('%s should be writable by the webserver (766 or 776).', $runtimePath));
207 }
208 }
209
210 Yii::$enableIncludePath = false;
211 Yii::createApplication('LSYii_Application', $config)->run();
212
213 /* End of file index.php */
214 /* Location: ./index.php */

2015-09-07 23:09:24 Apache/2.4.10 (Unix) PHP/5.4.35 Yii Framework/1.1.15

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago #124671 by riqcles
Je rajoute les captures d'écrans (l'erreur est mise en valeur :cheer: ).
@Denis and Co :silly: : Il vaut mieux que je colle le texte de l'erreur ou la capture d'écran ? Je voudrais pas saturer le serveur... :woohoo:

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago #124672 by riqcles
..... :sick: j'ai oublié les captures :whistle:

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago #124720 by riqcles
Bon je me confirme à moi-même :P
Le bug est aussi présent sous Mysql avec la dernière build.

En 2.05 build 141210 filtre doublon OK
En 2.06 build 150831 filtre doublon KO.

Je poste le bug

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 7 months ago #124737 by riqcles

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 7 months ago #124852 by DenisChenu
Salut,

Pour le code HTML de l'erreur:
- SUr le forum : avec la balise code
- Sur le rapport de bug : enregistrement du HTML avec le navigateur, envoi de l'HTML

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
Moderators: Nickko

Lime-years ahead

Online-surveys for every purse and purpose