View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
17980Bug reportsImport/Exportpublic2022-05-23 11:30
Reporterferdeng Assigned ToDenisChenu  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version5.x 
Summary17980: Txt Import Crashing - Integrity constraint violation: 1062 Duplicate entry
Description

I have a survey and made several changes directly in the browser, which works fine. When I export it as TXT and re-import (unedited), the import crashes and I get the following message
500 internal server error
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24336-en' for key 'edulime_idx1_question_ls'
When I close the error message, there is an imported survey, but some questions are lacking. I tried different combinations with different question groups, sometimes 0 questions from a group get imported, sometimes 5.

It seems to be a problem with this specific survey, it doesn't happen with all surveys, but I can't figure out what went wrong.

Not sure if it's related: https://bugs.limesurvey.org/view.php?id=9729
However, I don't have any translations in place, so I don't think it's related to any translation.

Exporting as TXT as the only way to effectively bulk-edit questions, so until I get this error, I can't export and re-import questions again.

Steps To Reproduce

Steps to reproduce

(Replace this text with detailed step-by-step instructions on how to reproduce the issue)

Expected result

(Write here what you expected to happen)

Actual result

(Write here what happened instead)

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build) Version 5.3.5+220314
I will donate to the project if issue is resolvedNo
Browser
Database type & versionI'm not the admin
Server OS (if known)
Webserver software & version (if known)
PHP VersionI'm not the admin

Users monitoring this issue

There are no users monitoring this issue.

Activities

galads

galads

2022-03-21 17:13

reporter   ~68777

For us to be able to investigate this issue please attach a 2 question sample survey demonstrating the issue, either as .lss file (survey structure) or (even better) as .lsa file (survey archive).

Just attach it to this issue and we will have a look.
Thank you!

DenisChenu

DenisChenu

2022-03-22 09:28

developer   ~68778

Can you try to edit files, delete the 1st 2 columns and try to import again ?

ferdeng

ferdeng

2022-03-22 10:01

reporter   ~68779

@DenisChenu: that doesn't help
Attached you find a reduced form of the questionnaire as LSA. Importing the LSA should work, but the error should be replicated if you export as TXT and then re-import (even without editing anything).

DenisChenu

DenisChenu

2022-04-14 13:33

developer   ~69072

Maybe related ?

DenisChenu

DenisChenu

2022-04-21 20:00

developer   ~69184

PS : remove the 2 1st column : i can import

limesurvey_survey_726315.tsv (94,650 bytes)   
class	type/scale	name	relevance	text	help	language	validation	mandatory	encrypted	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	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	placeholder	prefix	printable_help	public_statistics	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		726315																																																																																																																																											
S		gsid		1																																																																																																																																											
S		admin		test																																																																																																																																											
S		adminemail		test@test.com																																																																																																																																											
S		anonymized		N																																																																																																																																											
S		faxto																																																																																																																																													
S		format		S																																																																																																																																											
S		savetimings		Y																																																																																																																																											
S		template		bootswatch																																																																																																																																											
S		language		en																																																																																																																																											
S		additional_languages																																																																																																																																													
S		datestamp		Y																																																																																																																																											
S		usecookie		N																																																																																																																																											
S		allowregister		N																																																																																																																																											
S		allowsave		Y																																																																																																																																											
S		autonumber_start		8																																																																																																																																											
S		autoredirect		N																																																																																																																																											
S		allowprev		Y																																																																																																																																											
S		printanswers		N																																																																																																																																											
S		ipaddr		N																																																																																																																																											
S		ipanonymize		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		test@test.com																																																																																																																																											
S		emailresponseto																																																																																																																																													
S		emailnotificationto																																																																																																																																													
S		tokenlength		15																																																																																																																																											
S		showxquestions		N																																																																																																																																											
S		showgroupinfo		X																																																																																																																																											
S		shownoanswer		N																																																																																																																																											
S		showqnumcode		X																																																																																																																																											
S		bounceprocessing		N																																																																																																																																											
S		showwelcome		Y																																																																																																																																											
S		showprogress		N																																																																																																																																											
S		questionindex		0																																																																																																																																											
S		navigationdelay		0																																																																																																																																											
S		nokeyboard		N																																																																																																																																											
S		alloweditaftercompletion		N																																																																																																																																											
S		googleanalyticsstyle																																																																																																																																													
S		googleanalyticsapikey																																																																																																																																													
S		tokenencryptionoptions																																																																																																																																													
SL		surveyls_survey_id		726315		en																																																																																																																																									
SL		surveyls_language		en		en																																																																																																																																									
SL		surveyls_title		Test		en																																																																																																																																									
SL		surveyls_description				en																																																																																																																																									
SL		surveyls_welcometext		test		en																																																																																																																																									
SL		surveyls_endtext				en																																																																																																																																									
SL		surveyls_policy_notice				en																																																																																																																																									
SL		surveyls_policy_error				en																																																																																																																																									
SL		surveyls_policy_notice_label				en																																																																																																																																									
SL		surveyls_url				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		9		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																																																																																																																																									
G	0	parties				en																																																																																																																																									
Q	M	parties1	1	"<div class=""question-title-container bg-primary col-xs-12""><div class=""question-text""><div class=""ls-label-question"" id=""ls-question-text-379159X1009410088X105182""><p>In this survey, you can place up to [X] parties.</p><p>However, to avoid an unnecessarily long survey for you, you can select the parties that you want to place politically. We would be, of course, very happy if you would select all parties. You can always skip the party placement for specific statements if you cannot provide a position.</p><p><strong>Please check the boxes for all parties that you want to place.</strong></p></div></div></div>"		en		N	N	N		0							0	1																													0	0	0																																0		0					0		0						0																					0	1																							
SQ		SQ001	1	party1		en		N		N		0																																																																																																																																			
SQ		SQ002	1	party2		en		N		N		0																																																																																																																																			
SQ		SQ003	1	party3		en		N		N		0																																																																																																																																			
SQ		SQ004	1	party4		en		N		N		0																																																																																																																																			
SQ		SQ005	1	party5		en		N		N		0																																																																																																																																			
SQ		SQ006	1	party6		en		N		N		0																																																																																																																																			
SQ		SQ007	1	party7		en		N		N		0																																																																																																																																			
SQ		SQ008	1	party8		en		N		N		0																																																																																																																																			
SQ		SQ009	1	party9		en		N		N		0																																																																																																																																			
SQ		SQ010	1	party10		en		N		N		0																																																																																																																																			
SQ		SQ011	1	party11		en		N		N		0																																																																																																																																			
SQ		SQ012	1	party12		en		N		N		0																																																																																																																																			
SQ		SQ013	1	party13		en		N		N		0																																																																																																																																			
SQ		SQ014	1	party14		en		N		N		0																																																																																																																																			
SQ		SQ015	1	party15		en		N		N		0																																																																																																																																			
SQ		SQ016	1	party16		en		N		N		0																																																																																																																																			
SQ		SQ017	1	party17		en		N		N		0																																																																																																																																			
SQ		SQ018	1	party18		en		N		N		0																																																																																																																																			
SQ		SQ019	1	party19		en		N		N		0																																																																																																																																			
SQ		SQ020		party20		en		N		N		0																																																																																																																																			
G	1	Additional Statements				en																																																																																																																																									
Q	F	q014	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><u>When it comes to really important questions, scientific facts don’t help very much.</u></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	q021	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>It should be easier to have an abortion.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	q066	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>MPs in Parliament very quickly lose touch with ordinary people.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	q031	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should have more power.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	q032	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template001	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template002	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template003	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template004	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template005	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template006	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template007	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
Q	F	template008	1	<p>In your opinion, to what extent do <strong>these parties agree with this statement?</strong></p><p><strong><u>The EU should acquire its own tax raising powers.</u></strong></p>		en		N	N	N		0							0																															0	1																																		0					0	add	0		7				0																					0	1																						0	
SQ		SQ001	"((parties1_SQ001.NAOK == ""Y""))"	{parties1_SQ001.shown}		en		N		N		0																																																																																																																																			
SQ		SQ002	"((parties1_SQ002.NAOK == ""Y""))"	{parties1_SQ002.shown}		en		N		N		0																																																																																																																																			
SQ		SQ003	"((parties1_SQ003.NAOK == ""Y""))"	{parties1_SQ003.shown}		en		N		N		0																																																																																																																																			
SQ		SQ004	"((parties1_SQ004.NAOK == ""Y""))"	{parties1_SQ004.shown}		en		N		N		0																																																																																																																																			
SQ		SQ005	"((parties1_SQ005.NAOK == ""Y""))"	{parties1_SQ005.shown}		en		N		N		0																																																																																																																																			
SQ		SQ006	"((parties1_SQ006.NAOK == ""Y""))"	{parties1_SQ006.shown}		en		N		N		0																																																																																																																																			
SQ		SQ007	"((parties1_SQ007.NAOK == ""Y""))"	{parties1_SQ007.shown}		en		N		N		0																																																																																																																																			
SQ		SQ008	"((parties1_SQ008.NAOK == ""Y""))"	{parties1_SQ008.shown}		en		N		N		0																																																																																																																																			
SQ		SQ009	"((parties1_SQ009.NAOK == ""Y""))"	{parties1_SQ009.shown}		en		N		N		0																																																																																																																																			
SQ		SQ010	"((parties1_SQ010.NAOK == ""Y""))"	{parties1_SQ010.shown}		en		N		N		0																																																																																																																																			
SQ		SQ011	"((parties1_SQ011.NAOK == ""Y""))"	{parties1_SQ011.shown}		en		N		N		0																																																																																																																																			
SQ		SQ012	"((parties1_SQ012.NAOK == ""Y""))"	{parties1_SQ012.shown}		en		N		N		0																																																																																																																																			
SQ		SQ013	"((parties1_SQ013.NAOK == ""Y""))"	{parties1_SQ013.shown}		en		N		N		0																																																																																																																																			
SQ		SQ014	"((parties1_SQ014.NAOK == ""Y""))"	{parties1_SQ014.shown}		en		N		N		0																																																																																																																																			
SQ		SQ015	"((parties1_SQ015.NAOK == ""Y""))"	{parties1_SQ015.shown}		en		N		N		0																																																																																																																																			
SQ		SQ016	"((parties1_SQ016.NAOK == ""Y""))"	{parties1_SQ016.shown}		en		N		N		0																																																																																																																																			
SQ		SQ017	"((parties1_SQ017.NAOK == ""Y""))"	{parties1_SQ017.shown}		en		N		N		0																																																																																																																																			
SQ		SQ018	"((parties1_SQ018.NAOK == ""Y""))"	{parties1_SQ018.shown}		en		N		N		0																																																																																																																																			
SQ		SQ019	"((parties1_SQ019.NAOK == ""Y""))"	{parties1_SQ019.shown}		en		N		N		0																																																																																																																																			
SQ		SQ020	"((parties1_SQ020.NAOK == ""Y""))"	{parties1_SQ020.shown}		en		N		N		0																																																																																																																																			
A	0	1		Strongly Disagrees		en														0																																																																																																																											
A	0	2		 Tends to Disagree 		en														0																																																																																																																											
A	0	3		Neutral		en														0																																																																																																																											
A	0	4		 Tends to Agree 		en														0																																																																																																																											
A	0	5		 Strongly Agrees		en														0																																																																																																																											
A	0	6		Don't know		en														0																																																																																																																											
limesurvey_survey_726315.tsv (94,650 bytes)   
DenisChenu

DenisChenu

2022-04-22 11:35

developer   ~69191

@galads : this was a really complex system …

  1. Here : removing id and related_id column fix the issue
  2. But with Sample survey : we loose condition
  3. Error with default value still there (in any condition)
  4. etc …
DenisChenu

DenisChenu

2022-04-28 19:16

developer   ~69291

https://github.com/LimeSurvey/LimeSurvey/pull/2378
For THIS issue ;)

c_schmitz

c_schmitz

2022-05-20 09:01

administrator   ~69894

I tested with a multilingual version of the .lsa example file and it worked fine.

DenisChenu

DenisChenu

2022-05-20 09:11

developer   ~69896

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

LimeBot

LimeBot

2022-05-23 11:30

administrator   ~69975

Fixed in Release 5.3.16+220523

Related Changesets

LimeSurvey: master 436922a1

2022-05-20 09:00:59

DenisChenu


Committer: GitHub Details Diff
Fixed issue 17980: Txt import crashing with just exported survey (#2378)

Dev: Added rules on QuestionL10n and AnswerL10n
Dev: Integrity constraint violation: 1062 Duplicate entry
Dev: Exported survey have same qid for different question, check if not exist
Affected Issues
17980
mod - application/helpers/admin/import_helper.php Diff File
mod - application/models/AnswerL10n.php Diff File
mod - application/models/QuestionL10n.php Diff File

Issue History

Date Modified Username Field Change
2022-03-21 15:58 ferdeng New Issue
2022-03-21 17:13 galads Note Added: 68777
2022-03-21 17:13 galads Bug heat 0 => 2
2022-03-21 17:13 galads Assigned To => galads
2022-03-21 17:13 galads Status new => feedback
2022-03-22 09:28 DenisChenu Note Added: 68778
2022-03-22 09:28 DenisChenu Bug heat 2 => 4
2022-03-22 10:01 ferdeng Note Added: 68779
2022-03-22 10:01 ferdeng File Added: survey_archive_515444.lsa
2022-03-22 10:01 ferdeng Bug heat 4 => 6
2022-03-22 10:01 ferdeng Status feedback => assigned
2022-04-11 14:09 galads Assigned To galads => DenisChenu
2022-04-14 13:33 DenisChenu Note Added: 69072
2022-04-14 13:33 DenisChenu File Added: Capture d’écran du 2022-04-14 13-32-55.png
2022-04-21 20:00 DenisChenu Note Added: 69184
2022-04-21 20:00 DenisChenu File Added: limesurvey_survey_726315.tsv
2022-04-22 11:35 DenisChenu Note Added: 69191
2022-04-28 19:16 DenisChenu Note Added: 69291
2022-04-28 19:16 DenisChenu Assigned To DenisChenu =>
2022-04-28 19:16 DenisChenu Status assigned => ready for code review
2022-05-20 09:01 c_schmitz Assigned To => c_schmitz
2022-05-20 09:01 c_schmitz Status ready for code review => resolved
2022-05-20 09:01 c_schmitz Resolution open => fixed
2022-05-20 09:01 c_schmitz Note Added: 69894
2022-05-20 09:01 c_schmitz Bug heat 6 => 8
2022-05-20 09:11 DenisChenu Changeset attached => LimeSurvey master 436922a1
2022-05-20 09:11 DenisChenu Note Added: 69896
2022-05-20 09:11 DenisChenu Assigned To c_schmitz => DenisChenu
2022-05-23 11:30 LimeBot Note Added: 69975
2022-05-23 11:30 LimeBot Status resolved => closed
2022-05-23 11:30 LimeBot Bug heat 8 => 10