Dear everybody, I have collected data with Kobo and have now opened it in SPSS (as XLSX file) but unfortunately the column “values” is missing completely. I read here in the forum that you have to download the SPSS labels separately and then run them in the program. I have done this, but [screensho…

Welcome to the community @mugaboema ! Would you mind having a look at the post discussed previously (it should help you solve your issue): [image] Converting data into SPSS Data Management Hi @wibonela , cc: @Chanleap Would you mind having a look at this post that has been…

Hello Anne, just some ideas. At the end of your screenshot: I am not sure, if _ is valid at the beginning of a SPSS variable name, see IBM Documentation Variable names can be up to 64 bytes long, and the first character must be a letter or one of the characters @, #, or $. Subsequent characters …

hello, here i have had the same issue, except i am not yet very familiar with the use of syntax in spss, but i have collected a huge form and if i could import it in spss without having to edit and add the labels and values it would really be helpful, i have the same issues, the syntax is not worki…

Hi @mugaboema I hope you have gone through the topic shared by @Kal_Lam . In addition, you should always ensure that the name of your question in XLSform should always fit the convention set for SPSS variable names which in summary are as follows. Each variable name must be unique. The maximum var…

Hello @stephanealoo , Would be great, if we can also collect those hints for SPSS variable LABELS, esp. in combination with the label KoBo export channel. For ex. things like / or … (dots) or - or right-left languages etc. in KoBo choice labels. Thanks in advance. Kind regards

Hi @wroos On the SPSS labels, I left it out simply because the current values and value label restrictions provided by XLSForms matches exactly what SPSS and even STATA restricts for response values. So in essence, as long as your form passes the check, the values and labels would be accepted on SP…

hello@Kal_Lam, thank you for the comment, so for me the csv file did not name the variables the same way, actually i had to edit the variable names, because what i found out was that it seems when SPSS automatically renames the variables so that they can be imported it does not rename them like the …

Hi @mugaboema , Could you also share with us a screenshot of the xlsform (survey tab- your variable names)?

@mugaboema When you have a moment, could you please download the XLS form from the project itself and share it as is. I think the issue could be your variables were renamed prior to deployment. Stephane

Kobo to SPSS Variable Name and Value Considerations

User Support Data Management

Kal_Lam December 10, 2020, 6:20am 4

Welcome to the community @mugaboema! Would you mind having a look at the post discussed previously (it should help you solve your issue):