Hi, we finalized collecting data through a form consisting mostly of Yes/No questions and some multiple-choice questions that we built on Kobotoolbox. The was updated a couple of times (some questions were eliminated and some edited + we added an English version of the form later) and and therefore were deployed several times. One of the earlier versions of the form responses were working just fine, but now we cannot see the results correctly listed in any of the two languages when we download the results of the form as an Excel file. The answers are showing as , 1, and other symbols that won’t tell us anything.
Could someone please help fix this?
We looked for solutions all over the Kobotoolbox forum but couldn’t find an answer that works for us and we’re also afraid to lose our data while trying something experimental.
Welcome to the community, @Dulguun! Could you also share with the community a screenshot of your issue so that the community could understand it pictorially and help you out?
Hint: Changes during data collection should better be avoided, e.g. through systematic pre-tests. If nevertheless some changes are needed, first test them with a clone of your form, incl. test of data export.
Thank you so much for responding and wanting to help out, Kal!
Here are the screenshots of the error. We can see that all the submitted data are still there (and the form itself still looks correct). However, when we look at the results and want also download the results, we cannot read the responses. You can also see that the downloading value and header format options are limited:
You should first check, please, if the problem only appears for one language: switching the language in the report and in the table view.
You could download your (empty) form and check that all languages have a 2-letter code included, all languages have values for all labels (incl. choices), all hints/guidance hints, all messages.
@Dulguun, when I investigated your issue, I could see that you did not have any other language options at the beginning. You started collecting data, and it seems like the data collection was also over. Then you tried to have multiple languages, Mongolian (mn) and English (en). Did I get you correct?
@Kal_Lam, the form was first built in Mongolian (mn) and the English (en) translation was added later, as our reports come out in English, but the knowledge tests are taken by Mongolians in Mongolian language.
Could you please provide us with a solution for this? We’ve been begging for your support since two weeks and are truly in urgent need to get our data out right.
@Kal_Lam thank you so much for the notice! We really really hope that you can solve this issue ASAP, as we’re meeting a deadline of an important report which will require the results of this test! Do you have an approximate time about when it would be able to get fixed?
We truly appreciate you and your team for working on this. Thank you so much!
Hello @Dulguun, I looked at all of your submissions on this project and found that they used 4 versions of your form. I created an artificial new version of your form that is a combination of all questions and choices from those 4 versions. Because it looked like data collection had already stopped as of last week (March 22), I deployed this artificial version, which allows us to use that version when generating exports.
Important: to use this artificial version when exporting, you MUST uncheck “Include fields from all 9 versions”. By doing that, and choosing Mongolian as the language, I am able to download an XLS file where all questions and choices have their proper, human-readable labels. You can log into your account and do the same right now. Please note that your form has English translations for some labels, but not all of them, so if you attempt to export in English instead of Mongolian, you will still see certain responses appear like ___1.
I would strongly recommend that you NOT modify this form nor use it for any further data collection. Instead, if you need to collect more data, please make a new form and be sure that you name all your languages before allowing anyone to make submissions. You don’t have to remake the form from scratch: our diligent support team can help you clone your existing form or export and re-import it using XLSForm.
Thanks for your patience. We will work on adding safeguards against this type of scenario happening again.
Hi @jnm. Thank you so much for your help on this! I downloaded the artificial version as you have suggested, cleaned the data and now it looks complete.
Would you please tell us step-by-step what we should do/not do the next time with our forms in order to not face the same issue again?