I have three languages which was translated in the XLS file. I’ve been over the XLS file numerous times and everything with the translations is fine. However when I upload the XLS it strips 2 of the translations and only keeps the default “English”. I ran the XLS through the ODK validator and only receive the following messages:
Language ‘English (en)’ is missing the survey constraint_message column.
Language ‘default’ is missing the survey columns hint, label.
Both these messages is not correct because I have English under the constains column as: constraint_message::English (en)
The defaul language is set in the “Setting” sheet of the XLS as:
It seems that you have not provided complete and identical columns for ALL rextual elements for your 3 ::languages (2-letter-code), e.g. constraint_message, labels, hint, Incl. survey, choices (and settings).
I added the following column to the “setting” sheet: “form_title” with the name of my project. I uploaded the XLS as a new project and now the translation works 100%. Thanks for all the advice.