Hello,
Keep them ALL, please.
As current workaround: We just add/edit in Excel a prefix like “SYS …” before, e.g. SYS_id. (And also replace some __ inside with _).
For the dates, the most critical for transfer is the datetime type. Different to date, there is no simple edit option with Excel.
Another issue is the “/”, e.g. in the multiple choices. (Invalid for SPSS).
All future changes in the export file should correspond to the SPSS Label export, please.
There was further discussion before:
https://community.kobotoolbox.org/t/problems-converting-data-from-csv-to-spss/18695/4
https://community.kobotoolbox.org/t/kobo-outputs-numbers-are-stored-as-text/371/11
https://community.kobotoolbox.org/t/when-you-create-question-with-type-multiple-selection-not-support-for-spss-syntax-file/13122/8.
I doubt, if we want the following (see https://github.com/kobotoolbox/kpi/issues/1266):
“Select_One/Select_Many: If the response is a number, it should be stored as a number and not as a text string”.
There are Pro/Cons: If it becomes numeric, SPSS will probably change the MEASUREMENT LEVEL on import to Ordinal or Scale, instead of Nominal now (which is in most cases statistically correct). Also, such format change text to number is easy to do in SPSS.
