View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05490 | Bug reports | Import/Export | public | 2011-10-04 18:52 | 2012-10-19 16:21 |
Reporter | Assigned To | mdekker | |||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.91+ | ||||
Target Version | 2.00a2 | Fixed in Version | 2.00+ | ||
Summary | 05490: Spss export error in decimal values | ||||
Description | When exporting survey results for spss >16 the data file contain numbers with decimal like this "1.20" but after the import, the result in spss is "1.00" so we lost the decimal values. For export under spss of decimal values please format the data file with coma as decimal separator and not point otherwise all decimal values are lost during import. | ||||
Steps To Reproduce | 1) Create a survey with numeric data save with decimal values (default coma for decimal separator). | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | 121016 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 4.0.1 | ||||
Database type & version | mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1 | ||||
Server OS (if known) | CentOS release 5.6 (Final) | ||||
Webserver software & version (if known) | Apache/2.2.3 | ||||
PHP Version | PHP 5.2.10 | ||||
This temp fix present in export_data_functions.php must be applied in order to allow correct export to spss >=16 : /*
|
|
The decimal separator is an input specification that can be set for every language independently. The result in the database is always a decimal dot. If I remember correctly the SPSS input format depends on the set locale in SPSS and this can not be easily manipulated. The only way to fix this is to make a switch for comma/dot in export that defaults to the format in the survey base language but maybe admin language makes more sense? |
|
Hello, You're perfectly true. But under spss 19, I try to change default settings for decimal separator between coma and point separator with no success. Never mind, it could be great if the default separator could be linked with the default language LS is displaying it's interface:EN ".", FR ",". Otherwise maybe it's possible to let the user choose the separator he wants to apply to it's spss export on the export data screen ? Best regards, |
|
I will see if it is possible to implement a switch that defaults to the current display language. Will report back here when I have a patch. As you already found the quickfix, I assume you are not in a hurry. |
|
mdekker, maybe we can in the SPSS export screen just ask for the decimal mark (which would default to '.') ? Do you think you can implement such a new feature in the Yii version? |
|
Hi, I have the same problem when I export to SPSS, and the temp fix does not work for me. How I can use it? Thanks. |
|
It's possible that this is fixed in 1.92. Internally, 1.92 now properly converts all numbers to using a period as the radix separator. When I export to SPSS, I'm seeing all of the values are accurate, and use the period as the decimal separator. If you want SPSS to receive a comma separator, that conversion could be centralized as a last step before generating the CSV output for SPSS. |
|
Would be perfect, I work with statistical data and is very important to keep the entered values. Anyway, now I have implemented the temp fix (see attached) and works fine. Thanks. |
|
Reminder sent to: mdekker Menno, still up for it? |
|
Time is very limited at the moment so no promises, but I will look into it now that the yii branch is nearly stable |
|
Moving to development. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9907 |
|
Found a way to have SPSS handle the decimal separator on import. |
|
New version 2.00+ Build 121019 released. Please update. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2011-10-04 18:52 |
|
New Issue | |
2011-10-04 18:53 |
|
Issue Monitored: user14164 | |
2011-10-05 12:03 |
|
Note Added: 16370 | |
2011-10-05 16:28 | Mazi | Assigned To | => mdekker |
2011-10-05 16:28 | Mazi | Status | new => assigned |
2011-10-10 13:11 | mdekker | Note Added: 16383 | |
2011-10-10 13:43 |
|
Note Added: 16384 | |
2011-10-10 13:47 | mdekker | Note Added: 16385 | |
2012-01-23 16:54 | c_schmitz | Note Added: 16917 | |
2012-01-23 16:54 | c_schmitz | Target Version | => 2.00a2 |
2012-03-09 14:37 | DWS | Note Added: 17800 | |
2012-03-09 16:28 | TMSWhite | Note Added: 17805 | |
2012-03-09 16:29 | TMSWhite | Relationship added | related to 05792 |
2012-03-09 17:29 | TMSWhite | Relationship added | related to 05524 |
2012-03-12 10:58 | DWS | Note Added: 17886 | |
2012-03-12 12:10 | DWS | Note Edited: 17886 | |
2012-03-12 12:11 | DWS | File Added: export_data_functions.php | |
2012-07-27 10:29 | c_schmitz | Note Added: 20014 | |
2012-07-27 10:29 | c_schmitz | Note Edited: 20014 | |
2012-08-14 13:54 | mdekker | Note Added: 20423 | |
2012-10-02 14:20 | c_schmitz | Note Added: 20979 | |
2012-10-02 14:20 | c_schmitz | Project | Bug reports => Development |
2012-10-16 16:01 | mdekker | Relationship added | related to 06694 |
2012-10-17 11:27 | mdekker | Project | Development => Bug reports |
2012-10-17 11:29 | mdekker | LimeSurvey build number | 11026 => 121016 |
2012-10-17 11:31 | mdekker | Changeset attached | => LimeSurvey master 6ee354e8 |
2012-10-17 11:31 | mdekker | Note Added: 21402 | |
2012-10-17 11:31 | mdekker | Resolution | open => fixed |
2012-10-17 11:42 | mdekker | Note Added: 21403 | |
2012-10-17 11:42 | mdekker | Status | assigned => resolved |
2012-10-17 11:42 | mdekker | Fixed in Version | => 2.00+ |
2012-10-19 16:21 | c_schmitz | Note Added: 21493 | |
2012-10-19 16:21 | c_schmitz | Status | resolved => closed |