View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05740 | Bug reports | public | 2012-02-01 15:43 | 2015-08-21 15:51 | |
| Reporter | Assigned To | DenisChenu | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Summary | 05740: Improve VV response import | ||||
| Description | If I try to import a vv file to get the responses back into a survey it seems to work (there is no error message) but if I have a look at the responses table then no answers are being imported. I tested this with two other surveys and it is also the same problem there. | ||||
| Steps To Reproduce |
| ||||
| Additional Information | Attachments:
| ||||
| Tags | No tags attached. | ||||
| Attached Files | vvexport_42385.csv (2,406 bytes)
Antwort ID Datum Abgeschickt Letzte Seite Start-Sprache Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Wie bewerten Sie aus heutiger Sicht folgende Themen? Sollten Sie in der Tabelle aufgeführte Themen schlechter als 3 bewerten, bitten wir Sie um Kommentierung: Wir bitten Sie darum, stichpunktartig die aus Ihrer Sicht wichtigsten Themen zu nennen, wo Sie Verbesserung erwarten. Verbesserungen des persönlichen Arbeitsumfelds: Verbesserungen der Zusammenarbeit mit Kollegen: Verbesserungen bei den Führungskräften und Geschäftsführung: Verbesserungen für die Kundenzufriedenheit: Sonstige Verbesserungen: id submitdate lastpage startlanguage 42385X83X5791#0 42385X83X5791#1 42385X83X5792#0 42385X83X5792#1 42385X83X5793#0 42385X83X5793#1 42385X83X5794#0 42385X83X5794#1 42385X83X5795#0 42385X83X5795#1 42385X83X5796#0 42385X83X5796#1 42385X83X5797#0 42385X83X5797#1 42385X83X5798#0 42385X83X5798#1 42385X83X5799#0 42385X83X5799#1 42385X83X57910#0 42385X83X57910#1 42385X83X57911#0 42385X83X57911#1 42385X83X580 42385X84X581 42385X84X582 42385X84X583 42385X84X584 42385X84X585 42385X84X586 1 1980-01-01 00:00:00 2 de 3 2 2 4 2 fghgfh gfhg gfhgf fghfg gfh fghgf 2 1980-01-01 00:00:00 2 de 4 3 2 3 2 1 2 2 ghjgh ghjgh jghjghj ghjhgj ghjghj ghjgh | ||||
| Bug heat | 12 | ||||
| Complete LimeSurvey version number (& build) | 12269 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Mozilla Firefox 9.0 | ||||
| Database type & version | MySQL Community Server 5.5.8 | ||||
| Server OS (if known) | Windows Server 2008 R2 Standard | ||||
| Webserver software & version (if known) | Apache 2.2.17 | ||||
| PHP Version | 5.2.17 | ||||
| Git branch / Pull Request URL | |||||
|
Hello, CAn you have a look too : http://www.limesurvey.org/forum/development/73528-vv-import-blank-responses?lang=fr#73532 :) |
|
|
Yes, it works this way. But I think it's strange that you don't even get a warning if you try to import a vv file and there is no matching group and question in it. People might think everything is okay because there is no warning or error message. It would also be nice if there is a way to automaticly do this change. I think people will complain if they have to edit all their vv files in order to match the correct group and question. Perhaps there is a better way doing this, e.g. check if the number of groups and questions matches, then try to import it and skip entries with errors. |
|
|
Carsten, I think this is a very useful feature, but the way it currently works is not user friendly and hard to dealm with for the common user.
(Instead of showing SGQA codes we should use question/answer texts). What do you think? |
|
|
Why not match on the variable names instead of the randomly changing SGQA-codes? That would also solve my problem with using the same survey on different machines and collecting/importing the different VV-files on one "master-machine" into one central database containing all the interviews. So happy if this would work without having to manually change the first two lines in every VV-file to import! |
|
|
mfaber,that's an excellent idea. Matching by code is the best option, imho. |
|
|
But, If same code are used twice, then we can't use code. Then:
When importing, thing we can use some EM function. |
|
|
Well in general the rule is that we do not use a code twice - in 2.0 there is only a warning if a code is used twice. In 2.05 we can also start enforcing it. |
|
|
Maybe, But what for old survey updated from 1.90,1.91 ... etc . No rules for same code in 1.91 and less. Did we break completely vvexport ? I'm not sure vvexport are used a lot but : who know ;) . EDIT: |
|
|
Denis, can you start working on this for 2.05, please? |
|
|
Think i can start(re-start) on friday. |
|
|
If you need any beta testing...i am happy to pull from git and give it a try. |
|
|
I have the export, and partial import. But need more adpatation. SUrely end of this week in 2.05 GIT version (maybe tomorrow). But actual system have problem with existing id too. |
|
|
thanks! if I don't hear from you I'll try to test and give you feedback this weekend. |
|
|
If i don't put information here : then it must be a "lack of time to work on it" . |
|
|
Reworked completely system. |
|
|
Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=12559 |
|
|
Fix some bug in some condition Can be tested with: https://github.com/LimeSurvey/LimeSurvey/archive/2.05.zip |
|
|
LimeSurvey: 2.05 8ed8bfb0 2013-06-09 19:12 Details Diff |
New feature 05740: Improve VV response import Dev: new feature can be use to import file with EMcode in header Dev: need some control more at import (column number etc ..) Dev: VV version 1 can be exported Dev: fixed some JS issue in browse |
Affected Issues 05740 |
|
| mod - application/controllers/admin/conditionsaction.php | Diff File | ||
| mod - application/controllers/admin/dataentry.php | Diff File | ||
| mod - application/controllers/admin/export.php | Diff File | ||
| mod - application/controllers/admin/tokens.php | Diff File | ||
| mod - application/helpers/admin/import_helper.php | Diff File | ||
| mod - application/helpers/common_helper.php | Diff File | ||
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
| mod - application/helpers/viewHelper.php | Diff File | ||
| mod - application/views/admin/dataentry/vvimport.php | Diff File | ||
| add - application/views/admin/dataentry/vvimport_result.php | Diff File | ||
| mod - application/views/admin/export/vv_view.php | Diff File | ||
| mod - application/views/admin/participants/importCSV_view.php | Diff File | ||
| mod - scripts/admin/browse.js | Diff File | ||
|
LimeSurvey: 2.05 d1113091 2013-06-09 19:21 Details Diff |
Dev: some child fix 05740 child |
Affected Issues 05740 |
|
| mod - application/helpers/admin/import_helper.php | Diff File | ||
|
LimeSurvey: 2.05 ba085731 2013-06-10 11:17 Details Diff |
Dev: Some optimization on new feature 05740 New feature : Aallow to use first line for header in vvimport Dev: Add some css for success/error/warning Dev: fix some part in vvimport ( {cr}{nl} ...) Dev: fix some issue with debug=2 |
Affected Issues 05740 |
|
| mod - application/controllers/admin/database.php | Diff File | ||
| mod - application/controllers/admin/dataentry.php | Diff File | ||
| mod - application/controllers/admin/export.php | Diff File | ||
| mod - application/helpers/admin/import_helper.php | Diff File | ||
| mod - application/helpers/common_helper.php | Diff File | ||
| mod - application/views/admin/dataentry/vvimport.php | Diff File | ||
| mod - application/views/admin/dataentry/vvimport_result.php | Diff File | ||
| rm - application/views/admin/dataentry/vvimport_upload.php | Diff | ||
| rm - application/views/admin/dataentry/warning_header.php | Diff | ||
| mod - application/views/admin/export/vv_view.php | Diff File | ||
| mod - styles/adminstyle.css | Diff File | ||
|
LimeSurvey: 2.05 09116c5e 2013-06-10 11:24 Details Diff |
Dev: fix dualscale for vvexport v2 |
Affected Issues 05740 |
|
| mod - application/helpers/viewHelper.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-02-01 15:43 |
|
New Issue | |
| 2012-02-01 15:43 |
|
File Added: limesurvey_survey_42385.lss | |
| 2012-02-01 15:43 |
|
File Added: vvexport_42385.csv | |
| 2012-02-01 15:44 |
|
File Added: LimeSurveyMissingResponses.jpg | |
| 2012-02-02 02:11 | DenisChenu | Note Added: 17156 | |
| 2012-02-02 09:00 |
|
Note Added: 17158 | |
| 2012-02-02 12:56 | Mazi | Assigned To | => c_schmitz |
| 2012-02-02 12:56 | Mazi | Status | new => assigned |
| 2012-02-02 13:02 | Mazi | Note Added: 17169 | |
| 2012-02-06 14:21 | c_schmitz | Project | Bug reports => @10@ |
| 2012-02-06 14:22 | c_schmitz | Assigned To | c_schmitz => |
| 2012-02-06 14:22 | c_schmitz | Status | assigned => new |
| 2012-08-14 23:02 | c_schmitz | Product Version | 1.92RC3 => |
| 2012-08-14 23:02 | c_schmitz | Summary | Import vv file: No responses are imported => Improve VV response import |
| 2012-12-11 16:52 | mfaber | Note Added: 23149 | |
| 2012-12-11 16:56 | mfaber | Issue Monitored: mfaber | |
| 2013-01-03 03:49 | mfaber | Issue End Monitor: mfaber | |
| 2013-01-03 03:49 | mfaber | Issue Monitored: mfaber | |
| 2013-03-05 16:48 | c_schmitz | Note Added: 24557 | |
| 2013-03-05 17:24 | DenisChenu | Note Added: 24558 | |
| 2013-03-06 09:32 | c_schmitz | Note Added: 24563 | |
| 2013-03-06 11:19 | DenisChenu | Note Added: 24566 | |
| 2013-03-06 11:19 | DenisChenu | Assigned To | => DenisChenu |
| 2013-03-06 11:19 | DenisChenu | Status | new => assigned |
| 2013-03-06 11:20 | DenisChenu | Note Edited: 24566 | |
| 2013-04-22 10:25 | DenisChenu | Relationship added | related to 07761 |
| 2013-05-28 09:29 | c_schmitz | Note Added: 25400 | |
| 2013-05-28 12:51 | DenisChenu | Note Added: 25402 | |
| 2013-06-04 15:34 | mfaber | Note Added: 25463 | |
| 2013-06-04 15:37 | DenisChenu | Note Added: 25464 | |
| 2013-06-04 16:14 | mfaber | Note Added: 25466 | |
| 2013-06-04 16:15 | DenisChenu | Note Added: 25467 | |
| 2013-06-09 19:17 | DenisChenu | Changeset attached | => LimeSurvey 2.05 8ed8bfb0 |
| 2013-06-09 19:18 | DenisChenu | Note Added: 25494 | |
| 2013-06-09 19:18 | DenisChenu | Status | assigned => resolved |
| 2013-06-09 19:18 | DenisChenu | Fixed in Version | => 2.05 |
| 2013-06-09 19:18 | DenisChenu | Resolution | open => fixed |
| 2013-06-09 19:25 | DenisChenu | Changeset attached | => LimeSurvey 2.05 d1113091 |
| 2013-06-09 19:25 | DenisChenu | Note Added: 25495 | |
| 2013-06-10 11:22 | DenisChenu | Changeset attached | => LimeSurvey 2.05 ba085731 |
| 2013-06-10 11:28 | DenisChenu | Changeset attached | => LimeSurvey 2.05 09116c5e |
| 2013-06-10 11:46 | DenisChenu | Note Added: 25496 | |
| 2013-06-10 11:46 | DenisChenu | Status | resolved => feedback |
| 2013-06-10 11:46 | DenisChenu | Resolution | fixed => reopened |
| 2013-06-10 11:47 | DenisChenu | Note Edited: 25496 | |
| 2013-06-10 11:47 | DenisChenu | Status | feedback => resolved |
| 2013-06-10 11:47 | DenisChenu | Resolution | reopened => fixed |
| 2015-08-21 15:51 | c_schmitz | Status | resolved => closed |
| 2022-09-15 12:10 | DenisChenu | Bug heat | 10 => 12 |
| 2022-09-15 17:03 | guest | Bug heat | 12 => 10 |
| 2022-11-08 12:25 | DenisChenu | Bug heat | 10 => 12 |
| 2022-12-11 21:48 | guest | Bug heat | 12 => 10 |
| 2026-11-19 23:36 | c_schmitz | Bug heat | 10 => 12 |
| 2026-11-20 10:33 | c_schmitz | Category | Import/Export => (No Category) |