View Issue Details

IDProjectCategoryView StatusLast Update
06623Bug reports[All Projects] Import/Exportpublic2012-10-05 15:26
ReporterTMSWhiteAssigned ToTMSWhite 
Status closedResolutionfixed 
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




2012-10-01 19:09




2012-10-02 09:30

administrator   ~20968

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.


2012-10-03 00:46

reporter   ~20997

Fix committed to master branch:


2012-10-03 00:48

reporter   ~20998

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.


2012-10-05 15:26

administrator   ~21086

New version 2.00+ build 121005 released.

Related Changesets

LimeSurvey: master 49da6fb4

2012-10-02 15:45:40


Details Diff
Fixed issue 06623: imported tab delimited surveys are not visible
mod - application/helpers/admin/import_helper.php Diff File

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