Hello,
What is the best way to transfer date and datetime (and time) variables, e.g. start/end or birthday, from KoBo Toolbox to SPSS, preferably using XLSX download?
As KoBo downloads all variables (except some internal ones) as text, standard SPSS import will type them (wrong) as text (A) type.
Dear @Kal_Lam,
Thanks. Did you try it, please? At least for numeric the Excel format change didn’t work, we had to use convert to text (per column).
We were hopeful to find something less manual (as these are IT tools? ).
And we would need to do manual conversion also for all numeric KoBo variables downloaded (as text).
In addition there is the case of KoBo datetime types, like start/end, submission_time. How to best treat them, please?
Kind regards
Thanks, @Kal_Lam, for the github link (2017/2018) and your prompt reply. Unfortunately, we start analysis now again, so cannot wait until the request (from 2017/2018) is getting activated.
We are looking for a best workaround, please, and hoping that the community has hints. Other SPSS users should have the same problem.
Maybe we missed something. This step seems not working in Excel. Could you check it, please. Which (Excel) date format pattern (and locale) do you use?
We attach a typical export example, with 3 different date/time formats as provided by KoBo XLSX download. Date_Export_01.xlsx (8.0 KB)
OK, maybe you could do a small workaround (it’s a bit manual but it should fulfill your requirement) as outlined below to address your current needs:
In your xls data create duplicate variable called today_e for today and submission_e for _submission_time as outlined in the attached xls file. You could keep them in text format.
Thanks again, @Kal_Lam,
As far as we know this would only work BEFORE data submission, would need to do the same for each project and adapt at two places (KoBo and SPSS) for each date/time variable.
Therefore, if there is no other solution, we would go for similar adaption/recodes directly in SPSS (by script, or in Excel) only.
But we still hope for hints from the community.