Bug when trying to load csv file with the French translation

[N-thony]

I'm able to load this data under the English translation but when I switch to French translation, I'm no longer able to load.
Here is the loading under English translation

this is what I get when I switch to French

this is the file kisii_pyreth_data.csv

[N-thony]

I'm able to load this data under the English translation but when I switch to French translation, I'm no longer able to load. Here is the loading under English translation

this is what I get when I switch to French

this is the file kisii_pyreth_data.csv

@lloyddewit could we discuss this?

[N-thony]

@lloyddewit I did a quick investigation on this and I found that in the import function for csv/excel file we have a parameter called sep which takes value recognized in R from Separator input control i.e by default Automatic when you translate in French it becomes Automatique and this is not recognized in R. So, to fix I set ucrInputSeparatorCSV control in the database to DoNotTranslate, and to prevent such bug I suggest if we can set all the input controls, input text controls to DoNotTranslate. What do you think.

[lloyddewit]

@N-thony Thank you for finding and documenting this bug.
I agree that setting the controls to DoNotTranslate seems the best solution.

to prevent such bug I suggest if we can set all the input controls, nud controls, input text controls to DoNotTranslate. What do you think?

Do you mean just the controls in this dialog?
If yes, then I agree. Basically any control that creates an enumeration parameter (e.g. Automatic) should be set as DoNotTranslate.

[N-thony]

@lloyddewit ideally it will be good setting the controls to any susceptible dialogues.