View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
07885 | Bug reports | Import/Export | public | 2013-05-28 04:00 | 2013-08-16 13:54 |
Reporter | rowanc | Assigned To | mdekker | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.05 RC | ||||
Summary | 07885: Multiple issues with excel/tsv export and subsequent import | ||||
Description | 1) When using a drop down list as a question, the export file duplicates the code/name of the element in the relevance column, which breaks the import 2) When using a text array, the x-axis duplicates the code/name in the relevance column, and the default code for the x-axis sub question is the same as the default for the y-axis - this breaks the import (primary key violation?). | ||||
Steps To Reproduce | 1) Build survey, with dropdown or array, export to tsv | ||||
Additional Information | LSS example survey attached (tsv fails for this one, but I can only attach one file) | ||||
Tags | No tags attached. | ||||
Attached Files | limesurvey_survey_756269.txt (14,445 bytes)
class type/scale name relevance text help language validation mandatory other default same_default allowed_filetypes alphasort answer_width array_filter array_filter_exclude assessment_value category_separator display_columns display_rows dropdown_dates_year_min dropdown_dates dropdown_dates_year_max dropdown_prefix dropdown_prepostfix dropdown_separators dropdown_size dualscale_headerA dualscale_headerB em_validation_q_tip em_validation_q em_validation_sq em_validation_sq_tip equals_num_value exclude_all_others exclude_all_others_auto hidden hide_tip input_boxes location_city location_country location_defaultcoordinates location_mapheight location_mapservice location_mapwidth location_mapzoom location_nodefaultfromip location_postal location_state max_answers max_filesize max_num_of_files max_num_value max_num_value_n maximum_chars min_answers min_num_of_files min_num_value min_num_value_n multiflexible_checkbox multiflexible_max multiflexible_min multiflexible_step num_value_int_only numbers_only other_comment_mandatory other_numbers_only other_replace_text page_break prefix public_statistics random_group random_order reverse scale_export show_comment show_grand_total show_title show_totals slider_accuracy slider_default slider_layout slider_max slider_middlestart slider_min slider_rating slider_separator slider_showminmax suffix text_input_width time_limit_action time_limit_countdown_message time_limit_disable_next time_limit_disable_prev time_limit_message time_limit_message_delay time_limit_message_style time_limit_timer_style time_limit_warning_2_display_time time_limit_warning_2_message time_limit_warning_2_style time_limit_warning_2 time_limit_warning time_limit time_limit_warning_display_time time_limit_warning_message time_limit_warning_style use_dropdown S sid 756269 S owner_id 1 S admin Administrator S active N S adminemail bob.smith@whatever.com S anonymized N S format G S savetimings N S template default S language en S datestamp N S usecookie N S allowregister N S allowsave Y S autonumber_start 0 S autoredirect N S allowprev N S printanswers N S ipaddr N S refurl N S datecreated 2013-05-28 S publicstatistics N S publicgraphs N S listpublic N S htmlemail Y S sendconfirmation Y S tokenanswerspersistence N S assessments N S usecaptcha D S usetokens N S bounce_email bob.smith@whatever.com S attributedescriptions a:0:{} S tokenlength 15 S showxquestions Y S showgroupinfo B S shownoanswer Y S showqnumcode X S bounceprocessing N S showwelcome Y S showprogress Y S allowjumps N S navigationdelay 0 S nokeyboard N S alloweditaftercompletion N SL surveyls_title DropDownTest en SL surveyls_description Testing the export of dropdowns and arrays en SL surveyls_email_invite_subj Invitation to participate in a survey en SL surveyls_email_invite Dear {FIRSTNAME}, you have been invited to participate in a survey. The survey is titled: "{SURVEYNAME}" "{SURVEYDESCRIPTION}" To participate, please click on the link below. Sincerely, {ADMINNAME} ({ADMINEMAIL}) ---------------------------------------------- Click here to do the survey: {SURVEYURL} If you do not want to participate in this survey and don't want to receive any more invitations please click the following link: {OPTOUTURL} If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: {OPTINURL} en SL surveyls_email_remind_subj Reminder to participate in a survey en SL surveyls_email_remind Dear {FIRSTNAME}, Recently we invited you to participate in a survey. We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. The survey is titled: "{SURVEYNAME}" "{SURVEYDESCRIPTION}" To participate, please click on the link below. Sincerely, {ADMINNAME} ({ADMINEMAIL}) ---------------------------------------------- Click here to do the survey: {SURVEYURL} If you do not want to participate in this survey and don't want to receive any more invitations please click the following link: {OPTOUTURL} en SL surveyls_email_register_subj Survey registration confirmation en SL surveyls_email_register Dear {FIRSTNAME}, You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. To complete this survey, click on the following URL: {SURVEYURL} If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}. en SL surveyls_email_confirm_subj Confirmation of your participation in our survey en SL surveyls_email_confirm Dear {FIRSTNAME}, this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. Sincerely, {ADMINNAME} en SL surveyls_dateformat 9 en SL surveyls_attributecaptions a:0:{} en SL email_admin_notification_subj Response submission for survey {SURVEYNAME} en SL email_admin_notification Hello, A new response was submitted for your survey '{SURVEYNAME}'. Click the following link to reload the survey: {RELOADURL} Click the following link to see the individual response: {VIEWRESPONSEURL} Click the following link to edit the individual response: {EDITRESPONSEURL} View statistics by clicking here: {STATISTICSURL} en SL email_admin_responses_subj Response submission for survey {SURVEYNAME} with results en SL email_admin_responses Hello, A new response was submitted for your survey '{SURVEYNAME}'. Click the following link to reload the survey: {RELOADURL} Click the following link to see the individual response: {VIEWRESPONSEURL} Click the following link to edit the individual response: {EDITRESPONSEURL} View statistics by clicking here: {STATISTICSURL} The following answers were given by the participant: {ANSWERTABLE} en SL surveyls_numberformat 0 en G First Grop 1 The first group of questions en Q ! DropDown1 1 Select from the list en N 1 A 0 A1 A1 Some example answer option en A 0 A2 A2 New answer option en A 0 A3 A3 Another answer option en Q ! DropDown2 1 Another dropdown, this time quick add. en N 1 A 0 A1 A1 option 1 en A 0 A2 A2 Option 2 en A 0 A3 A3 Option 3 en Q ; Array1 1 This should be an array text input en N 1 SQ 0 SQ001 SideThingy1 en SQ 0 SQ002 SideThingy2 en SQ 0 SQ003 SideThingty3 en SQ 1 SQ001 SQ001 X-Scale Defaults to same sub question code SQ001 as y - this causes key error? en | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 130406 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | firefox | ||||
Database type & version | MYSQL 5.5.27 | ||||
Server OS (if known) | Windows XP | ||||
Webserver software & version (if known) | Apache/2.4.3 (Win32) | ||||
PHP Version | PHP/5.4.7 | ||||
Please update to the latest 2.0 build and let us know if you still can reproduce the problems. |
|
Feedback please? |
|
In 2.05: I think this revisits the discussion about enforcing unique variable names (codes) which should be implemented for 2.05. |
|
Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=12842 |
|
Only fixed for 2.05, we need to discuss moving version compatibility to the model so all imports work the same. In this case I had trouble with allowjumps at survey level and for answers that relevance/assesment_value field should be numeric. This was done in other imports, but not in tsv import. |
|
2.05 beta 6 released |
|
LimeSurvey: 2.05 17e03c42 2013-08-12 13:14 Details Diff |
Fixed 07885: Multiple issues with excel/tsv export and subsequent import dev: Fixed for 2.05 only dev: it would be best to solve backward compatibility in the model so we don't have to do it for all import/exports separately, check my comment in the survey.php to keep track of changes |
Affected Issues 07885 |
|
mod - application/helpers/admin/import_helper.php | Diff File | ||
mod - application/models/Survey.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2013-05-28 04:00 | rowanc | New Issue | |
2013-05-28 04:00 | rowanc | File Added: limesurvey_survey_756269.lss | |
2013-05-28 06:21 | rowanc | File Added: limesurvey_survey_756269.txt | |
2013-05-28 09:03 | mfaber | Issue Monitored: mfaber | |
2013-06-02 17:54 | c_schmitz | Note Added: 25448 | |
2013-06-02 17:54 | c_schmitz | Assigned To | => c_schmitz |
2013-06-02 17:54 | c_schmitz | Status | new => feedback |
2013-06-14 14:59 | c_schmitz | Note Added: 25531 | |
2013-07-21 15:59 | mfaber | Note Added: 25819 | |
2013-07-21 19:37 | mfaber | Relationship added | related to 07970 |
2013-07-21 19:45 | mfaber | Status | feedback => confirmed |
2013-08-12 13:17 | mdekker | Changeset attached | => LimeSurvey 2.05 17e03c42 |
2013-08-12 13:17 | mdekker | Note Added: 25972 | |
2013-08-12 13:17 | mdekker | Assigned To | c_schmitz => mdekker |
2013-08-12 13:17 | mdekker | Resolution | open => fixed |
2013-08-12 13:19 | mdekker | Note Added: 25973 | |
2013-08-12 13:19 | mdekker | Status | confirmed => resolved |
2013-08-12 13:19 | mdekker | Fixed in Version | => 2.05 RC |
2013-08-16 13:54 | c_schmitz | Note Added: 26011 | |
2013-08-16 13:54 | c_schmitz | Status | resolved => closed |
2021-08-02 17:32 | guest | Bug heat | 6 => 8 |