Anonymous Login
2017-01-24 04:05 CET

View Issue Details Jump to Notes ] Related Changesets ]
IDProjectCategoryView StatusLast Update
06623Bug reports[All Projects] Import/Exportpublic2012-10-05 15:26
Assigned ToTMSWhite 
Product Version2.00+ 
Target VersionFixed in Version 
Summary06623: imported tab delimited surveys are not visible
DescriptionLS 2.0 says that the file loads correctly, but when you try to go to the survey (or list it), it is not found.

When you run the Check Data Integrity function, you see that there are questions, attributes, groups, and language settings that can be deleted because there is no matching surveyid - where the missing surveyid is the one listed in the URL immediately after importing the survey.

So, it appears that everything loads correctly, but the new survey id is not written to the database.
Steps To ReproduceImport attached survey
TagsNo tags attached.
Complete LimeSurvey version number (& build)120931
I will donate to the project if issue is resolvedNo
Database & DB-VersionMysql 5.3
Operating System (Server)Windows XP
Webserver software & versionXAMPP
PHP Version5.3
Attached Files




c_schmitz (administrator)

There are several issues showing here:

*The Datecreated field in the TSV contains an invalid date format
*Datecreated should not be imported at all but ignored
*The import routine does little to no error reporting if the import fails.


TMSWhite (reporter)

Fix committed to master branch:


TMSWhite (reporter)

The patch fixes the most pressing problem. Better validation is desirable, and although it could be implemented now, it may make sense to wait for 2.1 since the Question Objects code contains all of the needed validation tables/arrays.


c_schmitz (administrator)

New version 2.00+ build 121005 released.

+Related Changesets

-Issue History
Date Modified Username Field Change
2012-10-01 19:09 TMSWhite New Issue
2012-10-01 19:09 TMSWhite File Added: Survey_debug_test2 (1).txt
2012-10-02 09:28 c_schmitz Assigned To => c_schmitz
2012-10-02 09:28 c_schmitz Status new => assigned
2012-10-02 09:30 c_schmitz Note Added: 20968
2012-10-03 00:46 TMSWhite Changeset attached => LimeSurvey master 49da6fb4
2012-10-03 00:46 TMSWhite Note Added: 20997
2012-10-03 00:46 TMSWhite Assigned To c_schmitz => TMSWhite
2012-10-03 00:46 TMSWhite Resolution open => fixed
2012-10-03 00:48 TMSWhite Note Added: 20998
2012-10-03 00:48 TMSWhite Status assigned => resolved
2012-10-05 15:26 c_schmitz Note Added: 21086
2012-10-05 15:26 c_schmitz Status resolved => closed
+Issue History