This temp fix present in export_data_functions.php must be applied in order to allow correct export to spss >=16 :

/*

• Temp quick fix for replacing decimal dots with comma's
  if (my_is_numeric($strTemp)) {
  $strTemp = str_replace('.',',',$strTemp);
  }
  */

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,
Guillaume JAOUEN

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.
Regards.

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.
My version of SPSS (19) only accepts decimal values ​​separated by commas, whatever the locale. We changed all possible settings in SPSS but imported correctly only decimal values ​​separated by comma in .data file. If I change the values ​​manually in this file, the values ​​are imported correctly.

Anyway, now I have implemented the temp fix (see attached) and works fine.

Thanks.
Regards.

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.