Dear @osmanburcu
I hope this message finds you well.
I have encountered an issue while downloading the datasets with the repeat groups, I downloaded my dataset but when I review the data the choices of the data are not downloaded in English some of them re downloaded however most of them are in Persian Language while I just want my data to download in English.
I appreciate your support in this regard.
Please do let me know if you have any questions.
Regards,
Farzad
survey_beneficiaries.xlsx (49.6 KB)
Hi @farzad_hussaini,
The data you shared did not give me much idea because i need to review the forms itself not the collected data, but from what i observed, you might be confused with the language at some point and added arabic to english translation or vice versa. If you can share your form i can quickly check
1 Like
I got the problem,
In your calculations you used “jr:choice-name” formula, this capture the visible value in the screen, for example if i fill the form you will see this data in english when you download, but if i fill it in Dari, you will find it in Dari. There is no problem regarding to system, it is a wrong use of the formula.
1 Like
Dear @osmanburcu,
Thanks for you support.
In this case how I can handle this, is there any other formula to use instead of the “jr:choice-name” formula to handle this issue?
I would appreciate your support in this case.
Regards,
Farzad
@osmanburcu,
This is a gentle reminder to the above message.
Regards,
Hi, i am not sure if it is possible to collect it directly desired label language, so there is two option here,
1- you will add a measure question and use reference to that questions such as ${questionid} and it will save the options XML value, and you can replace them later in the excel file.
2- You will add a measure with an if sentence that automatically translate them in the desired language and you will use that column.
I am not sure if there is any other option here, if the community has more option they will share i belive
