View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
12697Bug reportsStatisticspublic2017-09-22 21:082018-01-15 10:41
Reporterblocka Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.67.x 
Fixed in Version2.7x.x 
Summary12697: SPSS Export - responses truncated for incomplete answers
Description

We are noticing differences in the SPSS data file depending on whether we extract the SPSS file for ‘All responses’ versus ‘Completed responses only’.

It appears that the length of the text answers are longer for the ‘completed responses only’ syntax file, which show full text answers, while the text answers appear to be truncated in the “All responses” SPSS file.

However, the truncation does not appear to be consistent across variables.

Additional Information

I can't share LSA file due to privacy reasons (personal data collected by survey)

TagsNo tags attached.
Attached Files
Bug heat8
Complete LimeSurvey version number (& build)LS 2.67.3 build 170728
I will donate to the project if issue is resolvedYes
BrowserAll
Database type & versionmySQL 5.6.37
Server OS (if known)CentOs
Webserver software & version (if known)Apache
PHP Version7.0.19 7

Relationships

Relationship GraphDependency Graph
related to 12734 closedDenisChenu SPSS : exporting complete or uncomplete make different syntax 

Users monitoring this issue

There are no users monitoring this issue.

Activities

blocka

blocka

2017-09-22 22:34

reporter   ~44452

As an additional observation, what we also notice is that the syntax file for Complete Only and Incomplete Only contain different values. I've attached a comparison of the relevant parts of the SPS file (that are different).

Maybe there is a logical explanation for this?

Comparison.pdf (201,094 bytes)
DenisChenu

DenisChenu

2017-10-03 08:22

developer   ~44538

https://github.com/LimeSurvey/LimeSurvey/pull/815 Issue due to 500 first line to see the length needed in syntax.

user70560

2017-10-30 15:39

  ~44902

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

DenisChenu

2017-10-31 14:54

developer   ~44909

Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=24350
c_schmitz

c_schmitz

2018-01-15 10:41

administrator   ~45780

Version 3.0.3 released.

Related Changesets

LimeSurvey: master aaaf8454

2017-10-30 15:39:02

user70560


Committer: GitHub Details Diff 		Fixed issue 12697: SPSS Export - responses truncated for incomplete answers (#815)

Fixed issue 12697: SPSS Export - responses truncated for incomplete answers
Dev: force_refresh before exporting (like export by plugins)
Dev: unsure it fix THIS issue, but clearly : force_refresh seem needed
Fixed issue 12734: SPSS : exporting complete or uncomplete make different syntax
Dev: get the real size for string/text in the DB
Dev: Must review numeric (N/K) part ?
Dev: What for float ?
Dev: Fix invalid var without minus
Dev: MAX for max …
Dev: Fix export Array text and multi text as string (get size)
Dev: default is to export as string
Dev: Fix other/comment issue …
Dev: Fix badly set array number as dropdown for text input
Dev: fix controller part
Dev: Fix width of numeric is total width
Dev: readding $length_vallabel = 120;
Dev: constant for all SPSS version ?
Dev: Fixed issue other and comment must be string		 Affected Issues
12697, 12734
mod - application/controllers/admin/export.php Diff File
mod - application/helpers/export_helper.php Diff File

LimeSurvey: develop 50f83ded

2017-10-31 14:54:12

DenisChenu

Details Diff 		Fixed issue 12697: SPSS Export - responses truncated for incomplete answers
Fixed issue 12734: SPSS : exporting complete or uncomplete make different syntax
Dev: Conflicts: application/helpers/export_helper.php		 Affected Issues
12697, 12734
mod - application/controllers/admin/export.php Diff File
mod - application/helpers/export_helper.php Diff File

Issue History

Date Modified Username Field Change
2017-09-22 21:08 blocka New Issue
2017-09-22 22:34 blocka File Added: Comparison.pdf
2017-09-22 22:34 blocka Note Added: 44452
2017-10-03 08:22 DenisChenu Note Added: 44538
2017-10-03 08:23 DenisChenu Relationship added duplicate of 12734
2017-10-13 13:47 DenisChenu Assigned To => DenisChenu
2017-10-13 13:47 DenisChenu Status new => assigned
2017-10-13 13:48 DenisChenu Relationship replaced related to 12734
2017-10-13 13:48 DenisChenu Relationship replaced duplicate of 12734
2017-10-13 13:48 DenisChenu Relationship replaced related to 12734
2017-10-30 15:39 user70560 Changeset attached => LimeSurvey master aaaf8454
2017-10-30 15:39 user70560 Note Added: 44902
2017-10-30 15:39 user70560 Assigned To DenisChenu => user70560
2017-10-30 15:39 user70560 Resolution open => fixed
2017-10-30 18:20 DenisChenu Assigned To user70560 => DenisChenu
2017-10-30 18:20 DenisChenu Status assigned => resolved
2017-10-30 18:20 DenisChenu Fixed in Version => 2.7x.x
2017-10-31 14:54 DenisChenu Changeset attached => LimeSurvey develop 50f83ded
2017-10-31 14:54 DenisChenu Note Added: 44909
2018-01-15 10:41 c_schmitz Note Added: 45780
2018-01-15 10:41 c_schmitz Status resolved => closed