View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
05902Bug reportsImport/Exportpublic2012-03-12 23:572012-03-15 01:49
Reportertacman1123 Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionnot fixable 
Product Version1.92+ 
Summary05902: Importing vv file isn't working
Description

I'm moving a survey, and its results, from one server to another. I export the .lss file and the csv file (via Export VV), but when I import the file, the answers to the questions are missing (id's are there, though)

Steps To Reproduce

Import lss file (attached)
Activate Survey.
Import vv file (attached)
View Results

TagsNo tags attached.
Attached Files
import_bug.zip (19,223 bytes)
Bug heat6
Complete LimeSurvey version number (& build)155
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5
Server OS (if known)all
Webserver software & version (if known)Apache 2.2
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

tacman1123

tacman1123

2012-03-13 00:00

reporter   ~17903

Not sure how often the demo site is purged, but I tried it there as well, and it's not working, here are the results:

http://demo.limesurvey.org/admin/admin.php?action=browse&sid=71416&subaction=all&limit=50&order=desc

user18695

2012-03-13 17:01

  ~17906

Hello tacman1123,
About this problem, we can fix this in many ways. I need to know some info. How are you trying to import. The approach i took is why not convert the .csv , .lss file to xml
tacman1123

tacman1123

2012-03-13 17:04

reporter   ~17907

I went to my site (also running 1.92+), exported the survey as a .lss file, and exported the results using the Export VV File command, as a .csv file.

Then I imported the survey on the demo site, then imported the .csv file (using Import VV File). Only the basic info came in, not the actual answers.

Perhaps it's an issue with line breaks?

How does one import and export survey responses in XML?

user18695

2012-03-14 14:40

  ~17915

If the survey is designed to take XML, it will import XML file. I don't think the .csv file is empty . I have seen it. It shall get imported. Anyways, I will post you about this again. Let me take a closer look.
tacman1123

tacman1123

2012-03-14 16:09

reporter   ~17916

I don't follow what you're saying about designing a survey to take XML.

The CSV (that is, VV file) isn't empty, but the answers aren't being imported. It's a tab-delimitted file, with all the responses, generated by Export VV. There are no delimiter option.

Thank you for looking at this, it's a fairly important issue, I'm sure lots of people want to know that if they back up their survey responses that they'll be able to recover them or move them to a new server.
c_schmitz

c_schmitz

2012-03-15 01:49

administrator   ~17936

This is actually the intended behaviour. To have the VV-data import the SGQA must exactly match for each field. If it does not, it does not get imported.

Issue History

Date Modified Username Field Change
2012-03-12 23:57 tacman1123 New Issue
2012-03-12 23:57 tacman1123 File Added: import_bug.zip
2012-03-13 00:00 tacman1123 Note Added: 17903
2012-03-13 17:01 user18695 Note Added: 17906
2012-03-13 17:04 tacman1123 Note Added: 17907
2012-03-14 14:40 user18695 Note Added: 17915
2012-03-14 16:09 tacman1123 Note Added: 17916
2012-03-15 01:49 c_schmitz Note Added: 17936
2012-03-15 01:49 c_schmitz Status new => closed
2012-03-15 01:49 c_schmitz Assigned To => c_schmitz
2012-03-15 01:49 c_schmitz Resolution open => not fixable