View Issue Details

IDProjectCategoryView StatusLast Update
14249Bug reports[All Projects] Import/Exportpublic2019-04-30 09:13
ReporteroleggorfinkelAssigned Todominikvitt 
PrioritynoneSeveritymajor 
Status closedResolutionfixed 
Product Version3.5.x 
Target VersionFixed in Version3.15.x 
Summary14249: Tab-separated export of surveys is broken
Description

When exporting a survey in tab-separated .txt format, group and question descriptions are lost (they are missing from the resulting text file), and the same thing happens with any relevance equations that don't include a field code (e.g. numerical references, such as 0 or 1).

Steps To Reproduce

Export a survey in tab-separated .txt format, and look at the output file in a text editor or import it as a new survey and check the group/question descriptions and relevance equations.

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.15.3+181108
I will donate to the project if issue is resolvedNo
BrowserChrome
Database & DB-Version10.0.27-MariaDB-cll-lve
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.4.18
PHP Version5.5.36

Activities

DenisChenu

DenisChenu

2018-11-13 23:34

developer   ~49639

Last edited: 2018-11-13 23:44

View 3 revisions

text are lost with multilingual survey (see this survey) (relevance too)



limesurvey_survey_193516.lss (30,246 bytes)
limesurvey_survey_193516.tsv (32,422 bytes)
DenisChenu

DenisChenu

2018-11-13 23:44

developer   ~49641

relevance are lost for single language
text is here



limesurvey_survey_762418.lss (20,715 bytes)
limesurvey_survey_762418.txt (18,648 bytes)
id	related_id	class	type/scale	name	relevance	text	help	language	validation	mandatory	other	default	same_default	allowed_filetypes	alphasort	answer_width	answer_width_bycolumn	array_filter	array_filter_exclude	array_filter_style	assessment_value	category_separator	choice_input_columns	choice_title	code_filter	commented_checkbox	commented_checkbox_auto	cssclass	date_format	date_max	date_min	display_columns	display_rows	display_type	dropdown_dates	dropdown_dates_minute_step	dropdown_dates_month_style	dropdown_prefix	dropdown_prepostfix	dropdown_separators	dropdown_size	dualscale_headerA	dualscale_headerB	em_validation_q	em_validation_q_tip	em_validation_sq	em_validation_sq_tip	equals_num_value	equation	exclude_all_others	exclude_all_others_auto	hidden	hide_tip	input_boxes	input_size	label_input_columns	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	max_subquestions	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	parent_order	prefix	printable_help	public_statistics	question_template	random_group	random_order	rank_title	repeat_headings	reverse	samechoiceheight	samelistheight	scale_export	show_comment	show_grand_total	show_title	show_totals	showpopups	slider_accuracy	slider_custom_handle	slider_default	slider_default_set	slider_handle	slider_layout	slider_max	slider_middlestart	slider_min	slider_orientation	slider_rating	slider_reset	slider_reversed	slider_separator	slider_showminmax	statistics_graphtype	statistics_showgraph	statistics_showmap	suffix	text_input_columns	text_input_width	time_limit	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	time_limit_warning_2	time_limit_warning_2_display_time	time_limit_warning_2_message	time_limit_warning_2_style	time_limit_warning_display_time	time_limit_warning_message	time_limit_warning_style	use_dropdown	value_range_allows_missing
		S		sid		762418																																																																																																																																											
		S		gsid		1																																																																																																																																											
		S		admin		Administrator																																																																																																																																											
		S		adminemail		denis@sondages.pro																																																																																																																																											
		S		anonymized		N																																																																																																																																											
		S		faxto																																																																																																																																													
		S		format		A																																																																																																																																											
		S		savetimings		N																																																																																																																																											
		S		template		extends_vanilla																																																																																																																																											
		S		language		en																																																																																																																																											
		S		additional_languages																																																																																																																																													
		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		showsurveypolicynotice		0																																																																																																																																											
		S		publicstatistics		N																																																																																																																																											
		S		publicgraphs		N																																																																																																																																											
		S		listpublic		N																																																																																																																																											
		S		htmlemail		Y																																																																																																																																											
		S		sendconfirmation		Y																																																																																																																																											
		S		tokenanswerspersistence		N																																																																																																																																											
		S		assessments		N																																																																																																																																											
		S		usecaptcha		N																																																																																																																																											
		S		usetokens		N																																																																																																																																											
		S		bounce_email		denis@sondages.pro																																																																																																																																											
		S		emailresponseto																																																																																																																																													
		S		emailnotificationto																																																																																																																																													
		S		tokenlength		15																																																																																																																																											
		S		showxquestions		Y																																																																																																																																											
		S		showgroupinfo		B																																																																																																																																											
		S		shownoanswer		N																																																																																																																																											
		S		showqnumcode		X																																																																																																																																											
		S		bounceprocessing		N																																																																																																																																											
		S		showwelcome		Y																																																																																																																																											
		S		showprogress		Y																																																																																																																																											
		S		questionindex		0																																																																																																																																											
		S		navigationdelay		0																																																																																																																																											
		S		nokeyboard		N																																																																																																																																											
		S		alloweditaftercompletion		N																																																																																																																																											
		S		googleanalyticsstyle																																																																																																																																													
		S		googleanalyticsapikey																																																																																																																																													
		SL		surveyls_survey_id		762418		en																																																																																																																																									
		SL		surveyls_language		en		en																																																																																																																																									
		SL		surveyls_title		"Test mandatory"		en																																																																																																																																									
		SL		surveyls_description				en																																																																																																																																									
		SL		surveyls_welcometext				en																																																																																																																																									
		SL		surveyls_endtext				en																																																																																																																																									
		SL		surveyls_url		http://limesurvey.local/master/index.php?r=survey/index&sid=151391&newtest=Y&lang=en		en																																																																																																																																									
		SL		surveyls_urldescription				en																																																																																																																																									
		SL		surveyls_email_invite_subj		"Invitation to participate in a survey"		en																																																																																																																																									
		SL		surveyls_email_invite		"Dear {FIRSTNAME},<br /><br />you have been invited to participate in a survey.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}<br /><br />If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br />{OPTINURL}"		en																																																																																																																																									
		SL		surveyls_email_remind_subj		"Reminder to participate in a survey"		en																																																																																																																																									
		SL		surveyls_email_remind		"Dear {FIRSTNAME},<br /><br />Recently we invited you to participate in a survey.<br /><br />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.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}"		en																																																																																																																																									
		SL		surveyls_email_register_subj		"Survey registration confirmation"		en																																																																																																																																									
		SL		surveyls_email_register		"Dear {FIRSTNAME},<br /><br />You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /><br />To complete this survey, click on the following URL:<br /><br />{SURVEYURL}<br /><br />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},<br /><br />this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /><br />If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}"		en																																																																																																																																									
		SL		surveyls_dateformat		1		en																																																																																																																																									
		SL		email_admin_notification_subj		"Response submission for survey {SURVEYNAME}"		en																																																																																																																																									
		SL		email_admin_notification		"Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}"		en																																																																																																																																									
		SL		email_admin_responses_subj		"Response submission for survey {SURVEYNAME} with results"		en																																																																																																																																									
		SL		email_admin_responses		"Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}<br /><br /><br />The following answers were given by the participant:<br />{ANSWERTABLE}"		en																																																																																																																																									
		SL		surveyls_numberformat		0		en																																																																																																																																									
39		G	0	QQQ				en																																																																																																																																									
475		Q	Y	Q01				en			N		0																																																																																																																																				
476		Q	T	Man				en			N		0																																																																																																																																				
477		Q	!	drop				en			N		0																																																																																																																																				
477		A	0	A1		cwxcc		en													0																																																																																																																												
477		A	0	A2		cwxcwxcwx		en													0																																																																																																																												
478		Q	Q	Mult				en			N		0																																																																																																																																				
479		SQ		SQ001		dfgdfgdfg		en			N		0																																																																																																																																				
480		SQ		SQ002		" szbz ez erzerzzerrez"		en			N		0																																																																																																																																				
guest

guest

2018-11-14 13:36

viewer   ~49654

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

c_schmitz

c_schmitz

2019-04-30 09:13

administrator   ~51688

Fixed in version 3.17.3

Related Changesets

LimeSurvey: master 7a1e5713

2018-11-14 13:36:29

Dominik Vitt

Details Diff
Fixed issue 14249: Tab-separated export of surveys is broken Affected Issues
14249
mod - application/helpers/export_helper.php Diff File

Issue History

Date Modified Username Field Change
2018-11-13 21:36 oleggorfinkel New Issue
2018-11-13 23:34 DenisChenu File Added: limesurvey_survey_193516.lss
2018-11-13 23:34 DenisChenu File Added: limesurvey_survey_193516.tsv
2018-11-13 23:34 DenisChenu Note Added: 49639
2018-11-13 23:34 DenisChenu Assigned To => dominikvitt
2018-11-13 23:34 DenisChenu Status new => assigned
2018-11-13 23:36 DenisChenu Note Edited: 49639 View Revisions
2018-11-13 23:44 DenisChenu File Added: limesurvey_survey_762418.lss
2018-11-13 23:44 DenisChenu File Added: limesurvey_survey_762418.txt
2018-11-13 23:44 DenisChenu Note Added: 49641
2018-11-13 23:44 DenisChenu Note Edited: 49639 View Revisions
2018-11-14 13:36 Changeset attached => LimeSurvey master 7a1e5713
2018-11-14 13:36 guest Note Added: 49654
2018-11-14 13:36 guest Resolution open => fixed
2018-11-14 13:36 dominikvitt Status assigned => resolved
2018-11-14 13:36 dominikvitt Fixed in Version => 3.15.x
2019-04-30 09:13 c_schmitz Note Added: 51688
2019-04-30 09:13 c_schmitz Status resolved => closed