We are about to launch a country-wide survey in South Sudan and are facing an issue uploading the final xls with all the translations (we are performing the survey in 7 different languages).
I have followed the instructions on how to input the translations, but unfortunately when I go to upload the xls file to the website it gives me this error message:
Error: global name ‘datetime’ is not defined
I tried to modify the survey and the xls form to see if I could fix this, but have not had any luck. Any information you can provide is greatly appreciated.
Happy to upload the xls if needed.
Warm regards,
Matthew (on behalf of the South Sudan Law Society)
We are about to launch a country-wide survey in South Sudan and are facing an issue uploading the final xls with all the translations (we are performing the survey in 7 different languages).
I have followed the instructions on how to input the translations, but unfortunately when I go to upload the xls file to the website it gives me this error message:
Error: global name ‘datetime’ is not defined
I tried to modify the survey and the xls form to see if I could fix this, but have not had any luck. Any information you can provide is greatly appreciated.
Happy to upload the xls if needed.
Warm regards,
Matthew (on behalf of the South Sudan Law Society)
–
You received this message because you are subscribed to the Google Groups “Kobo Users” group.
I just sent you back the fixed form you emailed me privately.
The issue was the some of your options in the Arabic translation (choices sheet) had dates in them, which Excel saves in a peculiar way that causes issues when importing the form back into KoBo. To avoid this just enter these values as text. Because Excel likes to convert anything that looks like a date into dates, you can do one of the following:
select the entire column and select Text as the cell format in Excel. Then re-enter the value (e.g. 12/1/2013)
enter an apostrophe in front of the date (e.g. '12/1/2013) which Excel recognizes then as text.
In your form I think there may be an issue with the translation as well, as the English is ‘December 2013 - present’, while the Arabic just stored ‘12/1/2013’. There are seven response options where this was the case.
To be sure, this has nothing to do with the datetime question type. We will fix this issue to give a more informative error or, better yet, allow importing select options even if they contain dates rather than text.
We are about to launch a country-wide survey in South Sudan and are facing an issue uploading the final xls with all the translations (we are performing the survey in 7 different languages).
I have followed the instructions on how to input the translations, but unfortunately when I go to upload the xls file to the website it gives me this error message:
Error: global name ‘datetime’ is not defined
I tried to modify the survey and the xls form to see if I could fix this, but have not had any luck. Any information you can provide is greatly appreciated.
Happy to upload the xls if needed.
Warm regards,
Matthew (on behalf of the South Sudan Law Society)
–
You received this message because you are subscribed to the Google Groups “Kobo Users” group.
