Export responses - Revision history

MERose: It's called Stata, not STATA. See http://www.stata-journal.com/sjpdf.html?articlenum=gn0017

2023-03-14T08:40:29Z

It's called Stata, not STATA. See http://www.stata-journal.com/sjpdf.html?articlenum=gn0017

← Older revision		Revision as of 10:40, 14 March 2023
Line 141:		Line 141:


	==Export ~~STATA~~-xml== <!--T:200-->		==Export Stata-xml== <!--T:200-->


	<!--T:202-->		<!--T:202-->
	~~STATA~~ is a commercial data analysis and statistical software package.		Stata is a commercial data analysis and statistical software package.

	<!--T:203-->		<!--T:203-->
	This export routine was created to facilitate rapid analysis of data collected with LimeSurvey. It creates an XML-file in ~~STATAs~~ proprietary format. This format offers several advantages over importing plain CSV files:		This export routine was created to facilitate rapid analysis of data collected with LimeSurvey. It creates an XML-file in Stata's proprietary format. This format offers several advantages over importing plain CSV files:
	*Data sets are fully labelled including variable labels (question, subquestion) and value labels (answers, if applicable).		*Data sets are fully labelled including variable labels (question, subquestion) and value labels (answers, if applicable).
	*Dates are already transformed to ~~STATAs~~ internal date format and thus can directly be used to calculate differences between days etc.		*Dates are already transformed to Stata's internal date format and thus can directly be used to calculate differences between days etc.
	*Variable names are, if necessary, converted to a ~~STATA~~ compatible format.		*Variable names are, if necessary, converted to a Stata compatible format.
	*Data formats of variables (string, integer, float, etc.) are already set according to the underlying data (no more numbers encoded as strings!).		*Data formats of variables (string, integer, float, etc.) are already set according to the underlying data (no more numbers encoded as strings!).

	<!--T:204-->		<!--T:204-->
	'''How to load the file in ~~STATA~~:'''		'''How to load the file in Stata:'''
	# In ~~STATA~~'s menu, click on File, Import, xml-data		# In Stata's menu, click on File, Import, xml-data
	# Choose browse to navigate to your exported file and click 'OK'.		# Choose browse to navigate to your exported file and click 'OK'.

	<!--T:255-->		<!--T:255-->
	{{Note\|If you prefer ~~STATA~~'s binary .dta files, you can just save your data again in this format.}}		{{Note\|If you prefer Stata's binary .dta files, you can just save your data again in this format.}}


	<!--T:205-->		<!--T:205-->
	{{Alert\|title=Attention\|text=		{{Alert\|title=Attention\|text=
	*Due to a limitation in ~~STATA~~'s data format, the length of string (text) variables have a maximum of 244 characters (Stata versions 8-12) and 2045 characters (Stata version 13 and above). Please indicate your Stata version in the settings of the [[Plugin menu\|export plugin]]:		*Due to a limitation in Stata's data format, the length of string (text) variables have a maximum of 244 characters (Stata versions 8-12) and 2045 characters (Stata version 13 and above). Please indicate your Stata version in the settings of the [[Plugin menu\|export plugin]]:


Line 177:		Line 177:

	<!--T:258-->		<!--T:258-->
	*~~STATA~~ only supports attaching value labels to numerical values. So, to achieve short answers (usually one or two digits) and have these properly labelled, one should use numerical answer-codes in LimeSurvey (1=Totally agree). If non-numerical answer codes are used (A=Totally agree), then the complete answer text will be used as answer (eg., 'Totally agree').}}		*Stata only supports attaching value labels to numerical values. So, to achieve short answers (usually one or two digits) and have these properly labelled, one should use numerical answer-codes in LimeSurvey (1=Totally agree). If non-numerical answer codes are used (A=Totally agree), then the complete answer text will be used as answer (eg., 'Totally agree').}}

	=Export responses to SPSS= <!--T:9-->		=Export responses to SPSS= <!--T:9-->

C schmitz at 13:42, 5 September 2022

2022-09-05T13:42:39Z

← Older revision		Revision as of 15:42, 5 September 2022
Line 206:		Line 206:
	<!--T:14-->		<!--T:14-->
	*'''Data selection:''' you can select which data should be selected for export: all responses OR only complete responses OR only incomplete responses		*'''Data selection:''' you can select which data should be selected for export: all responses OR only complete responses OR only incomplete responses
	*'''SPSS version:''' Check your SPSS installation version. Three different export options can be chosen: Prior to version 16 / PSPP", "16 or up" and "16 or up with Python Essentials"		*'''SPSS version:''' Check your SPSS installation version. Three different export options can be chosen: "Prior to version 16 / PSPP", "16 or up" and "16 or up with Python Essentials"
	*'''Language:''' acts like a filter that allows you to filter the exported responses based on the language used to fill out the survey		*'''Language:''' acts like a filter that allows you to filter the exported responses based on the language used to fill out the survey
	*'''Limit:''' type in any numerical value to get exported only the first "n" entries from your response table		*'''Limit:''' type in any numerical value to get exported only the first "n" entries from your response table

C schmitz: Updated export options

2022-09-05T13:42:13Z

Updated export options

← Older revision		Revision as of 15:42, 5 September 2022
Line 206:		Line 206:
	<!--T:14-->		<!--T:14-->
	*'''Data selection:''' you can select which data should be selected for export: all responses OR only complete responses OR only incomplete responses		*'''Data selection:''' you can select which data should be selected for export: all responses OR only complete responses OR only incomplete responses
	*'''SPSS version:''' ~~check~~ your SPSS installation version. ~~Two~~ different export options can be chosen: ~~prior~~ to version 16 and 16 or up		*'''SPSS version:''' Check your SPSS installation version. Three different export options can be chosen: Prior to version 16 / PSPP", "16 or up" and "16 or up with Python Essentials"
	*'''Language:''' acts like a filter that allows you to filter the exported responses based on the language used to fill out the survey		*'''Language:''' acts like a filter that allows you to filter the exported responses based on the language used to fill out the survey
	*'''Limit:''' type in any numerical value to get exported only the first "n" entries from your response table		*'''Limit:''' type in any numerical value to get exported only the first "n" entries from your response table
Line 231:		Line 231:
	#Choose 'Run/All' from the menu to run the import.		#Choose 'Run/All' from the menu to run the import.
	#Done		#Done


	=VVExport= <!--T:27-->		=VVExport= <!--T:27-->

C schmitz: Text replacement - " enclose="div"" to ""

2022-02-16T12:59:07Z

Text replacement - " enclose="div"" to ""

← Older revision		Revision as of 14:59, 16 February 2022
Line 316:		Line 316:

	<!--T:214-->		<!--T:214-->
	<syntaxhighlight lang="text~~" enclose="div~~">		<syntaxhighlight lang="text">
	Response ID Date submitted Last page Start language Token please vote from 1 to 6 (1 - super, 6 - worst)		Response ID Date submitted Last page Start language Token please vote from 1 to 6 (1 - super, 6 - worst)
	id submitdate lastpage startlanguage token 46492X40X1991		id submitdate lastpage startlanguage token 46492X40X1991
Line 329:		Line 329:

	<!--T:216-->		<!--T:216-->
	<syntaxhighlight lang="text~~" enclose="div~~">		<syntaxhighlight lang="text">
	Response ID Date submitted Last page Start language Token please vote from 1 to 6 (1 - super, 6 - worst)		Response ID Date submitted Last page Start language Token please vote from 1 to 6 (1 - super, 6 - worst)
	id submitdate lastpage startlanguage token QCODE		id submitdate lastpage startlanguage token QCODE

Cdorin at 09:16, 15 April 2020

2020-04-15T09:16:01Z

← Older revision		Revision as of 11:16, 15 April 2020
Line 86:		Line 86:
	**''Convert spaces in question text to underscores:'' disabled by default. If enabled, the spaces from the question text are converted to underscores.		**''Convert spaces in question text to underscores:'' disabled by default. If enabled, the spaces from the question text are converted to underscores.
	**''Text abbreviated:'' disabled by default. If enabled, the question text will be abbreviated. The length of the question text is given by the number put into the "Number of characters". Please note that this option is useful in the case in which you wish to abbreviate the question texts resulted from selecting either "Full question text" or "Question code & question text" as heading text.		**''Text abbreviated:'' disabled by default. If enabled, the question text will be abbreviated. The length of the question text is given by the number put into the "Number of characters". Please note that this option is useful in the case in which you wish to abbreviate the question texts resulted from selecting either "Full question text" or "Question code & question text" as heading text.
	** ''Use ExpressionScript code:'' disabled by default. If enabled, the questions and subquestions will be exported as they are used within the ExpressionScript. Therefore, the heading would resemble the [[~~Expression_Manager_~~-~~_presentation~~#Qcode_variable_naming\|qcode variable naming]]. Please note that one of the following question heading options has to be chosen: "Question code" or "Question code & question text".		** ''Use ExpressionScript code:'' disabled by default. If enabled, the questions and subquestions will be exported as they are used within the ExpressionScript. Therefore, the heading would resemble the [[ExpressionScript - Presentation#Qcode_variable_naming\|qcode variable naming]]. Please note that one of the following question heading options has to be chosen: "Question code" or "Question code & question text".
	** ''Number of characters:'' set up a maximum number of characters to be displayed in the headings. This option works if you wish to export your question as abbreviated question text. The default number is 15.		** ''Number of characters:'' set up a maximum number of characters to be displayed in the headings. This option works if you wish to export your question as abbreviated question text. The default number is 15.
	** ''Code/text separator:'' select the option you wish to use to separate the question code from the text of the question. By default, it is a "dot" followed by an empty string (<SPACE>).		** ''Code/text separator:'' select the option you wish to use to separate the question code from the text of the question. By default, it is a "dot" followed by an empty string (<SPACE>).
Line 178:		Line 178:
	<!--T:258-->		<!--T:258-->
	*STATA only supports attaching value labels to numerical values. So, to achieve short answers (usually one or two digits) and have these properly labelled, one should use numerical answer-codes in LimeSurvey (1=Totally agree). If non-numerical answer codes are used (A=Totally agree), then the complete answer text will be used as answer (eg., 'Totally agree').}}		*STATA only supports attaching value labels to numerical values. So, to achieve short answers (usually one or two digits) and have these properly labelled, one should use numerical answer-codes in LimeSurvey (1=Totally agree). If non-numerical answer codes are used (A=Totally agree), then the complete answer text will be used as answer (eg., 'Totally agree').}}


	=Export responses to SPSS= <!--T:9-->		=Export responses to SPSS= <!--T:9-->

C schmitz: Text replacement - "Expression Manager" to "ExpressionScript"

2020-02-11T13:40:12Z

Text replacement - "Expression Manager" to "ExpressionScript"

← Older revision		Revision as of 15:40, 11 February 2020
Line 86:		Line 86:
	**''Convert spaces in question text to underscores:'' disabled by default. If enabled, the spaces from the question text are converted to underscores.		**''Convert spaces in question text to underscores:'' disabled by default. If enabled, the spaces from the question text are converted to underscores.
	**''Text abbreviated:'' disabled by default. If enabled, the question text will be abbreviated. The length of the question text is given by the number put into the "Number of characters". Please note that this option is useful in the case in which you wish to abbreviate the question texts resulted from selecting either "Full question text" or "Question code & question text" as heading text.		**''Text abbreviated:'' disabled by default. If enabled, the question text will be abbreviated. The length of the question text is given by the number put into the "Number of characters". Please note that this option is useful in the case in which you wish to abbreviate the question texts resulted from selecting either "Full question text" or "Question code & question text" as heading text.
	** ''Use ~~Expression Manager~~ code:'' disabled by default. If enabled, the questions and subquestions will be exported as they are used within the ExpressionScript. Therefore, the heading would resemble the [[Expression_Manager_-_presentation#Qcode_variable_naming\|qcode variable naming]]. Please note that one of the following question heading options has to be chosen: "Question code" or "Question code & question text".		** ''Use ExpressionScript code:'' disabled by default. If enabled, the questions and subquestions will be exported as they are used within the ExpressionScript. Therefore, the heading would resemble the [[Expression_Manager_-_presentation#Qcode_variable_naming\|qcode variable naming]]. Please note that one of the following question heading options has to be chosen: "Question code" or "Question code & question text".
	** ''Number of characters:'' set up a maximum number of characters to be displayed in the headings. This option works if you wish to export your question as abbreviated question text. The default number is 15.		** ''Number of characters:'' set up a maximum number of characters to be displayed in the headings. This option works if you wish to export your question as abbreviated question text. The default number is 15.
	** ''Code/text separator:'' select the option you wish to use to separate the question code from the text of the question. By default, it is a "dot" followed by an empty string (<SPACE>).		** ''Code/text separator:'' select the option you wish to use to separate the question code from the text of the question. By default, it is a "dot" followed by an empty string (<SPACE>).

Han at 15:40, 11 March 2019

2019-03-11T15:40:14Z

← Older revision		Revision as of 17:40, 11 March 2019
Line 519:		Line 519:

	<!--T:304-->		<!--T:304-->
	The ~~[[Export_responses]] pages~~ will be loaded:		The next page will be loaded:

Han: link: export responses -> Export_responses

2019-03-11T15:37:37Z

link: export responses -> Export_responses

← Older revision		Revision as of 17:37, 11 March 2019
Line 519:		Line 519:

	<!--T:304-->		<!--T:304-->
	The [[~~export responses~~]] pages will be loaded:		The [[Export_responses]] pages will be loaded:

Han: ) removed

2019-03-09T14:39:00Z

) removed

← Older revision		Revision as of 16:39, 9 March 2019
Line 390:		Line 390:

	<!--T:277-->		<!--T:277-->
	{{Note\|For more information on how to import a VV file, check the following wiki subsection: [[Import_responses#Import_a_VV_survey_file\|Import a VV survey file]]).}}		{{Note\|For more information on how to import a VV file, check the following wiki subsection: [[Import_responses#Import_a_VV_survey_file\|Import a VV survey file]].}}

	=Other export options= <!--T:132-->		=Other export options= <!--T:132-->

Han: missing {

2019-03-09T14:16:40Z

missing {

← Older revision		Revision as of 16:16, 9 March 2019
Line 361:		Line 361:
	* <code>{cr}</code> : Carriage return		* <code>{cr}</code> : Carriage return
	* <code>{newline}</code> : A new line		* <code>{newline}</code> : A new line
	* <code>{lbrace}</code> : Left bracket (for example, if you want to have {cr} in response : use <code>{lbrace}cr}</code> )		* <code>{lbrace}</code> : Left bracket (for example, if you want to have {cr} in response : use <code>{lbrace}{cr}</code> )


	==Editing a VV survey file== <!--T:37-->		==Editing a VV survey file== <!--T:37-->