View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06694Bug reportsImport/Exportpublic2012-10-19 16:21
Reporterrobk84625 Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06694: [SPSS Export] No numbers if matrix was used
Description

After the import in SPSS, there are no values (full numbers) if you use the Numeric input field.

Steps To Reproduce

a) active survey
b) SPSS Export
c) no values inside of the numeric fields, only a dot.

TagsNo tags attached.
Attached Files
Unbenannt-2.png (3,800 bytes)   
Unbenannt-2.png (3,800 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)121013
I will donate to the project if issue is resolvedNo
BrowserFF & MS IE
Database type & versionn/a
Server OS (if known)Linux
Webserver software & version (if known)Apache 2
PHP Version5.3.16

Relationships

related to 05490 closedmdekker Spss export error in decimal values 

Users monitoring this issue

There are no users monitoring this issue.

Activities

robk84625

robk84625

2012-10-13 19:08

reporter   ~21295

Summary is wrong... no matrix - i mean the numeric input field.

mdekker

mdekker

2012-10-15 11:26

reporter   ~21315

Can you please attach your exported survey and the syntax file (no need for the data). You can mark the report as private if you like so only you and the developers can see the attached files.

robk84625

robk84625

2012-10-15 19:19

reporter   ~21337

I can't make publish the survey output-
but i did a screenshot of the empty column.

mdekker

mdekker

2012-10-16 14:22

reporter   ~21364

Before you import, set your locale in spss to english and set it back to german (i guess) after import.

SHOW LOCALE.
SET LOCALE='en_UK'.
EXECUTE.
now run import
SET LOCALE= and use the output from show locale

mdekker

mdekker

2012-10-16 16:04

reporter   ~21369

Ok update... for me this works:

open the syntax, modify:

  • Just to make sure show current locale.
    SHOW LOCALE.
    PRESERVE LOCALE.
    SET LOCALE='en_UK'.
    <now the normal syntax>
    RESTORE LOCALE.
robk84625

robk84625

2012-10-17 00:33

reporter   ~21391

hey mdekker,
yes this works... thank you very much.
but isn't it easier for everyone to integrate your
source above in the output of the limesurvey
syntax?

lots of greetings,
robert

mdekker

mdekker

2012-10-17 10:47

reporter   ~21400

Thanks for the feedback. Now I know that it works for at least two people I will put the change in the limesurvey syntax output. Expect to see it in the coming 2.0 plus updates.

c_schmitz

c_schmitz

2012-10-19 16:21

administrator   ~21494

New version 2.00+ Build 121019 released. Please update.

Related Changesets

LimeSurvey: master 6ee354e8

2012-10-17 02:30:37

mdekker

Details Diff
Fixed 05490: Spss export should now handle different decimal separator (locale) better Affected Issues
05490, 06694
mod - application/controllers/admin/export.php Diff File

Issue History

Date Modified Username Field Change
2012-10-13 19:06 robk84625 New Issue
2012-10-13 19:08 robk84625 Note Added: 21295
2012-10-13 20:57 c_schmitz Assigned To => mdekker
2012-10-13 20:57 c_schmitz Status new => assigned
2012-10-15 11:26 mdekker Note Added: 21315
2012-10-15 12:03 c_schmitz Status assigned => feedback
2012-10-15 19:18 robk84625 File Added: Unbenannt-2.png
2012-10-15 19:19 robk84625 Note Added: 21337
2012-10-15 19:19 robk84625 Status feedback => assigned
2012-10-16 14:22 mdekker Note Added: 21364
2012-10-16 16:01 mdekker Relationship added related to 05490
2012-10-16 16:04 mdekker Note Added: 21369
2012-10-17 00:33 robk84625 Note Added: 21391
2012-10-17 10:47 mdekker Note Added: 21400
2012-10-17 11:31 mdekker Status assigned => resolved
2012-10-17 11:31 mdekker Fixed in Version => 2.00+
2012-10-17 11:31 mdekker Resolution open => fixed
2012-10-17 11:32 mdekker Changeset attached => LimeSurvey master 6ee354e8
2012-10-19 16:21 c_schmitz Note Added: 21494
2012-10-19 16:21 c_schmitz Status resolved => closed