This space has helped me lot solving issues regarding data collection.I hope to lean new things from the community.
Survey is being held in rural areas where surveyor doesnt aware of English language. So when i use local language in my CSV for Pull data functionality, kobo collect app shows ??? like characters.
MS excel supports my local language but CSV doesnt…
In case it’s not too late, here are my 2 cents.
Excel is really terrible at handling CSVs. I am working with mixed Latin and Arabic characters and here is what I do, I hope it can help you:
After clicking on “Save As” in Excel, don’t choose “CSV” as the file type, but “Unicode text”…
After the TXT file was saved, open it with a text editor (like Notepad++, or if you have nothing else, Windows Notepad)…
Fields are separated by something else than commas (probably tabulations). If it is the case, make sure you don’t have commas inside text field values (and if there are, put double quotes to those values, for example with a “Search and Replace” based on a regular expression),
Do a quick “search and replace” to put commas everywhere as field separators, instead of the tabulation
Or you can use LibreOffice Calc, which will natively produce the right and intended result without additional steps (if you can live with LibreOffice’s bugs and slowness).
Hi, I’m in the process of developing a survey for which a long list of villages (around 14,000). I added them as a csv file. and tested with dummy data. The result in the table shows only the "name’, not the ‘label’. Can you help, please? Many thanks,