View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06502 | Bug reports | Import/Export | public | 2012-08-19 09:41 | 2019-07-13 18:33 |
| Reporter | DenisChenu | Assigned To | mfaber | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Summary | 06502: Unable to import exported multi lang survey | ||||
| Description | If we make a multi lang survey, export in excel format and import it again, then second langage is breaked. For survey langage settings : all OK | ||||
| Steps To Reproduce | Export a simple multi lang survey and import it again. | ||||
| Additional Information | In DB: Same think for qid. The test with $gname/$qname/$sqname are breaked. I think we need $gseq/$qseq/$aseq raary for each lanage. For the group: | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 12 | ||||
| Complete LimeSurvey version number (& build) | 120819 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | Mysql 5 | ||||
| Server OS (if known) | debian/linux | ||||
| Webserver software & version (if known) | apache | ||||
| PHP Version | PHP Version 5.3 | ||||
| Git branch / Pull Request URL | |||||
| related to | 06501 | closed | DenisChenu | Import excel with same title for 2 group make Duplicate entry |
| related to | 06426 | closed | c_schmitz | following Excel import - "Invalid group number for this survey:" error , cured by QA |
| related to | 08119 | closed | mfaber | advanced question attributes broken on survey txt-import |
| related to | 08201 | closed | mfaber | TSV-Import: subquestions of text/number matrix questions are not imported |
| related to | 14944 | closed | Adding id and related_id in TSV export make it complicated to edit |
|
The Group title (column C) is a unique identifier that must be the same for each language. So, the reason the second language does not appear in this example is that the group title is "Group title" for en, and "Titre group" for fr. It must be Group Title for both. The core problem is that many users may be using the Group title for language-specific display purposes rather than as a unique identifier for the group. As 2.0 extends the data model, it should have separate fields for group code (so that we can have a reliable Gcode to complement the Qcodes), plus a language-specific title for display purposes. |
|
|
I understand why. But, user: Export excel: OK |
|
|
Perhaps we should add the following: |
|
|
$newgid = Groups::model()->insertRecords($insertdata)// or safeDie($clang->gT('Error').": Failed to insert group Speed correction, but insert next question in the previous group (but remove it after while). And think there are problem with: Another possibility is to use an array for each langage with $gseq, and maybe $qseq. |
|
|
Reminder sent to: c_schmitz Carsten: http://git.io/LsyhLQ fix this issue BUT: still a problem with export/import. Did i found a solution for 2.0 or for 2.1 ? |
|
|
Shnoulle, does this problem still exist with the latest TSV import/export ? |
|
|
The TSV needs a way of uniquely identifying the group so that it can be repeated. Feel free to make one of the columns the unique identifier, and another the language-specific label for the group. |
|
|
Yep, The question is: Denis |
|
|
Carsten : feel free to close the bug: like Thomas say it's a in TSV import conception. |
|
|
Shnoulle, can you work on this for 2.1 ? |
|
|
Adding a "group_code" ? |
|
|
group_code sounds fine to me |
|
|
OK, the wait for 2.0 stabilizing. A lot of think to do for 2.1 8-O |
|
|
Adding a 'group_code' might require adding an extra column to the Excel format. If we have to do that anyway, perhaps we should update the data model and admin GUI so that we have the following for both group and question: (1) var_name - this will be the variable name (e.g. title/qcode for question) We currently have #1 for question but no #2; and #2 for group but no #1. |
|
|
And for LS2 , we have already "randomization_group". I think for "title" for group, title are set automaticly to group_name if empty. My problem is : title is used only for tsv export, did you think we can use in EM ? For example count the question in a group or something like that ? It's for 2.1 then not urgent. |
|
|
Dev's note: Use default-langage title for code. Some solution
|
|
|
@mfaber : Thank you ;). Like say in IRC: think we can use actual txt for importing. 1st: create a $aGroupDefaultLang. Each time we have a new group in DEFAULT language: And But do what you want ;) It's just some reflexion here. |
|
|
Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13118 |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13119 |
|
|
LimeSurvey: 2.05 551a9889 2013-09-30 15:06 Committer: mfaber Details Diff |
Fixed issue 06502: Unable to import multi-lang surveys (.txt) Dev: groups are now exported with a unique identifier. Dev: older multi-lang .txt files should also be properly Dev: imported. Here we make up an identifier during Dev: import. |
Affected Issues 06502 |
|
| mod - application/helpers/admin/import_helper.php | Diff File | ||
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
|
LimeSurvey: master 91068ed1 2013-09-30 15:06 Committer: mfaber Details Diff |
Fixed issue 06502: Unable to import multi-lang surveys (.txt) Dev: groups are now exported with a unique identifier. Dev: older multi-lang .txt files should also be properly Dev: imported. Here we make up an identifier during Dev: import. |
Affected Issues 06502 |
|
| mod - application/helpers/admin/import_helper.php | Diff File | ||
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
|
LimeSurvey: 2.05 81384ffc 2013-10-01 21:33 Details Diff |
Merge pull request #134 from mfaber/multilangTSV205 Fixed issue 06502: Unable to import multi-lang surveys (.txt) |
Affected Issues 06502 |
|
| mod - application/helpers/admin/import_helper.php | Diff File | ||
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-08-19 09:41 | DenisChenu | New Issue | |
| 2012-08-19 09:41 | DenisChenu | File Added: limesurvey_survey_multilang.xls | |
| 2012-08-19 09:41 | DenisChenu | Relationship added | related to 06501 |
| 2012-08-19 09:42 | DenisChenu | Relationship added | related to 06426 |
| 2012-08-19 14:34 | TMSWhite | Note Added: 20522 | |
| 2012-08-19 14:34 | TMSWhite | Status | new => feedback |
| 2012-08-19 14:41 | DenisChenu | Note Added: 20523 | |
| 2012-08-19 14:41 | DenisChenu | Status | feedback => new |
| 2012-08-19 14:50 | TMSWhite | Note Added: 20525 | |
| 2012-08-19 14:58 | DenisChenu | Note Added: 20527 | |
| 2012-08-19 18:45 | c_schmitz | Assigned To | => DenisChenu |
| 2012-08-19 18:45 | c_schmitz | Status | new => assigned |
| 2012-08-19 19:58 | DenisChenu | Issue Monitored: c_schmitz | |
| 2012-08-19 19:58 | DenisChenu | Note Added: 20533 | |
| 2012-10-02 14:56 | c_schmitz | Note Added: 20980 | |
| 2012-10-02 15:04 | TMSWhite | Note Added: 20983 | |
| 2012-10-02 15:08 | DenisChenu | Note Added: 20984 | |
| 2012-10-11 13:11 | DenisChenu | Assigned To | DenisChenu => c_schmitz |
| 2012-10-11 13:12 | DenisChenu | Note Added: 21211 | |
| 2012-10-11 13:18 | c_schmitz | Note Added: 21213 | |
| 2012-10-11 13:18 | c_schmitz | Project | Bug reports => @10@ |
| 2012-10-11 14:22 | DenisChenu | Note Added: 21220 | |
| 2012-10-11 14:31 | c_schmitz | Note Added: 21221 | |
| 2012-10-11 14:31 | c_schmitz | Assigned To | c_schmitz => DenisChenu |
| 2012-10-11 14:46 | DenisChenu | Product Version | 2.00RC9 => |
| 2012-10-11 14:47 | DenisChenu | Note Added: 21224 | |
| 2012-10-11 14:47 | DenisChenu | Note Edited: 21224 | |
| 2012-10-16 21:24 | TMSWhite | Note Added: 21390 | |
| 2012-10-17 09:13 | DenisChenu | Note Added: 21392 | |
| 2012-10-22 14:38 | DenisChenu | Note Added: 21533 | |
| 2013-01-30 04:15 | mfaber | Issue Monitored: mfaber | |
| 2013-09-01 15:42 | mfaber | Relationship added | related to 08119 |
| 2013-09-29 18:52 | mfaber | Relationship added | related to 08201 |
| 2013-09-30 14:57 | mfaber | Assigned To | DenisChenu => mfaber |
| 2013-09-30 14:59 | mfaber | Reproducibility | have not tried => always |
| 2013-09-30 14:59 | mfaber | Product Version | => 2.05 |
| 2013-09-30 15:04 | DenisChenu | Note Added: 26447 | |
| 2013-10-01 21:33 | mfaber | Changeset attached | => LimeSurvey 2.05 551a9889 |
| 2013-10-01 21:33 | c_schmitz | Changeset attached | => LimeSurvey 2.05 81384ffc |
| 2013-10-01 21:33 | c_schmitz | Note Added: 26464 | |
| 2013-10-01 21:33 | c_schmitz | Assigned To | mfaber => c_schmitz |
| 2013-10-01 21:33 | c_schmitz | Resolution | open => fixed |
| 2013-10-01 21:59 | mfaber | Assigned To | c_schmitz => mfaber |
| 2013-10-01 21:59 | mfaber | Status | assigned => resolved |
| 2013-10-01 21:59 | mfaber | Fixed in Version | => 2.05 |
| 2013-10-01 22:25 | mfaber | Changeset attached | => LimeSurvey master 91068ed1 |
| 2013-10-01 22:25 | mfaber | Note Added: 26465 | |
| 2014-01-11 09:11 | mfaber | Status | resolved => closed |
| 2019-07-13 18:33 | DenisChenu | Relationship added | related to 14944 |
| 2022-07-28 10:21 | DenisChenu | Bug heat | 8 => 12 |
| 2022-07-28 20:25 | guest | Bug heat | 12 => 8 |
| 2022-11-17 16:11 | DenisChenu | Bug heat | 8 => 12 |
| 2022-11-19 01:10 | guest | Bug heat | 12 => 8 |
| 2023-04-05 12:34 | DenisChenu | Bug heat | 8 => 12 |
| 2023-04-09 16:58 | guest | Bug heat | 12 => 8 |
| 2023-04-19 18:20 | DenisChenu | Bug heat | 8 => 12 |
| 2023-04-20 09:04 | guest | Bug heat | 12 => 8 |
| 2023-09-22 09:28 | c_schmitz | Bug heat | 8 => 12 |
| 2023-09-23 06:32 | guest | Bug heat | 12 => 8 |
| 2023-12-02 19:19 | DenisChenu | Bug heat | 8 => 12 |
| 2023-12-03 15:06 | guest | Bug heat | 12 => 8 |
| 2025-01-28 11:16 | DenisChenu | Bug heat | 8 => 12 |