View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
07165Bug reportsImport/Exportpublic2013-01-09 02:482013-01-29 12:44
Reportermfaber Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07165: VV-Import/Export leads to changes of data
Description

When exporting data using VV-export and succesively importing the same data again, values change.
Don't know if the problem is with importing/exporting or both.

Some problems that occured to me:
!!! [missing] in Yes/No questions becomes "N" !!!
[missing] number becomes number "0"
[missing] date becomes 30.11.1999
[missing] in matrix becomes "NULL"

Steps To Reproduce

Use a survey with responses present
Export responses using VV-export
Import responses using VV-import

Compare original and imported responses in response browser or in a separate excel-export.

TagsNo tags attached.
Attached Files
survey_archive_892852.lsa (3,854 bytes)
Bug heat6
Complete LimeSurvey version number (& build)130108
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL (recent XAMPP)
Server OS (if known)Win7 Pro
Webserver software & version (if known)Apache (recent XAMPP)
PHP VersionPHP (recent XAMPP)

Users monitoring this issue

mfaber

Activities

mfaber

mfaber

2013-01-17 19:17

reporter   ~23703

Did some more testing today. This is what I did:
Took a survey with different question types producing as many missings as possible.

Exported this record using vv-export.
Imported the same file again.
--> 2 answers in DB (1 original, 1 imported)

Problem seems to be with IMPORTING:
Missings are exported as [empty] or as "{question not shown}"
If "{question not shown}", however, is imported it becomes "0" in number questions and "0000-00-00 00:00:00" in date questions.
In limesurvey data viewer this date is shown as "30.11.1999".
c_schmitz

c_schmitz

2013-01-21 21:39

administrator   ~23735

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11335
c_schmitz

c_schmitz

2013-01-21 21:40

administrator   ~23736

Can you please check and give feedback if the attached patch resolves the issue?
mfaber

mfaber

2013-01-21 22:05

reporter   ~23737

Patched the dataentry.php file, emptied browser cache, exported, imported...
unfortunately the problem persists
c_schmitz

c_schmitz

2013-01-21 23:17

administrator   ~23738

Can you attach your small sample survey as .lsa file please?
That would really speed up debugging.
c_schmitz

c_schmitz

2013-01-22 21:19

administrator   ~23769

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11357
mfaber

mfaber

2013-01-23 20:42

reporter   ~23780

it seems the batch solved the issue with the number field. Thanks!
Only the issue with the date field persists. Attached you may find the requested .lsa!

regards!
mfaber

mfaber

2013-01-23 20:45

reporter   ~23781

Last edited: 2013-01-23 20:46

btw: first response is the original data (qestionnaire taken and only missings produced).
second response is the first one again but exported and imported again.
Difference is in the date question.
c_schmitz

c_schmitz

2013-01-23 21:42

administrator   ~23782

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11368
c_schmitz

c_schmitz

2013-01-23 21:44

administrator   ~23783

mfaber, please report if this last patch works as expected for you
mfaber

mfaber

2013-01-24 20:14

reporter   ~23798

patched the file, cleared the browser cache, exported, imported. WORKS! Thanks!
c_schmitz

c_schmitz

2013-01-29 12:44

administrator   ~23887

New version 2.00+ Build 120129 released

Related Changesets

LimeSurvey: master 51612edf

2013-01-21 20:39:41

c_schmitz

Details Diff 		Fixed issue 07165: VV-import/export leads to changes of data Affected Issues
07165
mod - application/controllers/admin/dataentry.php Diff File

LimeSurvey: 2.1 66ea302f

2013-01-21 20:39:41

c_schmitz

Details Diff 		Fixed issue 07165: VV-import/export leads to changes of data Affected Issues
07165
mod - application/controllers/admin/dataentry.php Diff File

LimeSurvey: master 9007457d

2013-01-23 20:42:07

c_schmitz

Details Diff 		Fixed issue 07165: VV-import/export leads to changes of data
Fixed issue: VV-import/export not working on Postgres or MSSQL Server		 Affected Issues
07165
mod - application/controllers/admin/dataentry.php Diff File

Issue History

Date Modified Username Field Change
2013-01-09 02:48 mfaber New Issue
2013-01-09 23:40 mfaber Issue Monitored: mfaber
2013-01-10 14:11 c_schmitz Assigned To => c_schmitz
2013-01-10 14:11 c_schmitz Status new => assigned
2013-01-17 19:17 mfaber Note Added: 23703
2013-01-21 21:39 c_schmitz Changeset attached => LimeSurvey master 51612edf
2013-01-21 21:39 c_schmitz Note Added: 23735
2013-01-21 21:39 c_schmitz Resolution open => fixed
2013-01-21 21:40 c_schmitz Note Added: 23736
2013-01-21 21:40 c_schmitz Status assigned => resolved
2013-01-21 21:40 c_schmitz Fixed in Version => 2.00+
2013-01-21 22:05 mfaber Note Added: 23737
2013-01-21 22:05 mfaber Status resolved => feedback
2013-01-21 22:05 mfaber Resolution fixed => reopened
2013-01-21 23:17 c_schmitz Note Added: 23738
2013-01-22 21:19 c_schmitz Changeset attached => LimeSurvey 2.1 66ea302f
2013-01-22 21:19 c_schmitz Note Added: 23769
2013-01-23 20:42 mfaber Note Added: 23780
2013-01-23 20:42 mfaber Status feedback => assigned
2013-01-23 20:42 mfaber File Added: survey_archive_892852.lsa
2013-01-23 20:45 mfaber Note Added: 23781
2013-01-23 20:46 mfaber Note Edited: 23781
2013-01-23 21:42 c_schmitz Changeset attached => LimeSurvey master 9007457d
2013-01-23 21:42 c_schmitz Note Added: 23782
2013-01-23 21:44 c_schmitz Note Added: 23783
2013-01-23 21:44 c_schmitz Status assigned => resolved
2013-01-23 21:44 c_schmitz Resolution reopened => fixed
2013-01-24 20:14 mfaber Note Added: 23798
2013-01-29 12:44 c_schmitz Note Added: 23887
2013-01-29 12:44 c_schmitz Status resolved => closed
2021-08-02 21:52 guest Bug heat 4 => 6