14976: Timings for SPSS export - LimeSurvey bugs and feature requests

This bug affects 2 person(s).

12

ID	Project	Category	View Status	Date Submitted	Last Update

14976	Feature requests	Statistics	public	2019-06-14 17:51	2023-02-21 15:37

Reporter	f_funke	Assigned To	cdorin
Priority	none	Severity	feature
Status	assigned	Resolution	open

Summary	14976: Timings for SPSS export
Description	At present, timings are not exported for SPSS. The SPSS data file ("survey_<surveyID>_SPSS_data_file.dat") does neither contain the total time nor group timings nor question timings. SPSS data file should contain all timings and the and SPSS syntax file should contain all variable names and variable labels.
Tags	No tags attached.
Attached Files

Bug heat	12
Story point estimate
Users affected %

~~dominikvitt~~ 2019-06-20 14:12 developer ~52485	@f_funke: Please create simple example file(s) showing actual implementation, so it would be clear what export files should look like.

f_funke 2019-06-21 18:07 developer ~52490	I created a simple survey with just one open question (see attachment). If you export the responses as CSV or Excel the dataset contains the following variables: 01: Response ID 02: Date submitted 03: Last page 04: Start language 05: Seed 06: Date started 07: Date last action 08: IP address 09: Referrer URL 10: A first example question. Please answer this question: 11: Total time 12: Group time: My first question group 13: Question time: Q00 The SPSS data file only contains the variables 01 to 10, so total time, group time, and question time are missing. survey_archive_181135.lsa (4,204 bytes) survey_181135_SPSS_data_file.dat (394 bytes) '2','21-06-2019 17:47:57','1','en','129722108','21-06-2019 17:47:43','21-06-2019 17:47:57','5.146.250.42','https://questiontypes.limequery.com/admin/survey/sa/view/surveyid/181135','test FF 190621', '3','21-06-2019 17:48:20','1','en','1330606741','21-06-2019 17:48:12','21-06-2019 17:48:20','5.146.250.42','https://questiontypes.limequery.com/admin/survey/sa/view/surveyid/181135','test 2', survey_181135_SPSS_data_file.dat (394 bytes) results-survey181135.xlsx (4,908 bytes) results-survey181135.csv (691 bytes) "Response ID","Date submitted","Last page","Start language","Seed","Date started","Date last action","IP address","Referrer URL","A first example question. Please answer this question:","Total time","Group time: My first question group","Question time: Q00" "2","2019-06-21 17:47:57","1","en","129722108","2019-06-21 17:47:43","2019-06-21 17:47:57","5.146.250.42","https://questiontypes.limequery.com/admin/survey/sa/view/surveyid/181135","test FF 190621","14.28","14.28","" "3","2019-06-21 17:48:20","1","en","1330606741","2019-06-21 17:48:12","2019-06-21 17:48:20","5.146.250.42","https://questiontypes.limequery.com/admin/survey/sa/view/surveyid/181135","test 2","8.24","8.24","" results-survey181135.csv (691 bytes)

umrosa 2023-02-21 15:37 reporter ~73910	I would greatly appreciate if this was implemented for LimeSurvey 3.x

Date Modified	Username	Field	Change
2019-06-14 17:51	f_funke	New Issue
2019-06-20 10:50	~~dominikvitt~~	Assigned To	=> dominikvitt
2019-06-20 10:50	~~dominikvitt~~	Status	new => assigned
2019-06-20 14:12	~~dominikvitt~~	Note Added: 52485
2019-06-21 18:07	f_funke	File Added: survey_archive_181135.lsa
2019-06-21 18:07	f_funke	File Added: survey_181135_SPSS_data_file.dat
2019-06-21 18:07	f_funke	File Added: results-survey181135.xlsx
2019-06-21 18:07	f_funke	File Added: results-survey181135.csv
2019-06-21 18:07	f_funke	Note Added: 52490
2019-07-15 11:41	~~dominikvitt~~	Assigned To	dominikvitt => cdorin
2023-02-21 15:37	umrosa	Note Added: 73910
2023-02-21 15:37	umrosa	Bug heat	4 => 12