LimeSurvey issue tracker
Registration

View Issue Details Jump to Notes ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
06623Bug reports[All Projects] Import/Exportpublic2012-10-01 19:092012-10-05 15:26
ReporterTMSWhite 
Assigned ToTMSWhite 
PrioritynormalSeverityminor 
StatusclosedResolutionfixed 
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
I will donate to the project if issue is resolved within 48 hrsNo
LimeSurvey build number OR git commit ID120931
Browser
Database & DB-VersionMysql 5.3
Operating System (Server)Windows XP
Webserver software & versionXAMPP
PHP Version5.3
Attached Filestxt file icon Survey_debug_test2 (1).txt [^] (27,232 bytes) 2012-10-01 19:09 [Show Content]

- Relationships

-  Notes
User avatar (20968)
c_schmitz (administrator)
2012-10-02 09:30

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.
User avatar (20997)
TMSWhite (reporter)
2012-10-03 00:46

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9622 [^]
User avatar (20998)
TMSWhite (reporter)
2012-10-03 00:48

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.
User avatar (21086)
c_schmitz (administrator)
2012-10-05 15:26

New version 2.00+ build 121005 released.

- Related Changesets
LimeSurvey: master 49da6fb4
Timestamp: 2012-10-02 15:45:40
Author: TMSWhite
Committer: Thomas White
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


Copyright © 2000 - 2014 MantisBT Team
Powered by Mantis Bugtracker