Dear all,
I have one problem. The interviewer type other language in tablet in a ODK
form. it show question mark in excel format. how do i change? you can see
in the attached file.
Thanks all,
Aung thu
Aung,
Microsoft Excel does not interpret the contents of a csv file
correctly if you simply double-click it to open the file in Excel.
Instead, you must:
- open Excel (e.g., via the Start menu)
- choose Data / Get External Data From Text
- choose your csv file, click Import
- Select Delimited
- Select 65001: Unicode (UTF-8) for "File Origin"
- choose Next
- Choose Comma for the Delimiter
- Click Next
- Click Finish
- Click OK to import the data starting at the highlighted cell (typically A1)-
On Mac OSX, there are reports that this process does not work
correctly for Arabic characters. In that case, try using any other
spreadsheet program, e.g., one of the free OpenOffice.org follow-on
applications, or, on Mac, the Numbers program. If you can import the
data using one of those programs, you can then save it in XLSX format
and then open that in Microsoft Excel.
Taken from at https://opendatakit.org/help/form-design/workarounds/
Yaw
···
On Wed, Mar 1, 2017 at 2:28 AM, Cloud strife wrote: > Dear all, > > I have one problem. The interviewer type other language in tablet in a ODK > form. it show question mark in excel format. how do i change? you can see in > the attached file. > > Thanks all, > > Aung thu > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.Dear Yaw,
It is not work. Can you help me again?
···
On Wednesday, 1 March 2017 13:58:27 UTC+6:30, Cloud strife wrote: > > Dear all, > > I have one problem. The interviewer type other language in tablet in a ODK > form. it show question mark in excel format. how do i change? you can see > in the attached file. > > Thanks all, > > Aung thu >Let me send you some excel file.
Thanks.
ODK help.xlsx (16.2 KB)
···
On Wednesday, 1 March 2017 13:58:27 UTC+6:30, Cloud strife wrote: > > Dear all, > > I have one problem. The interviewer type other language in tablet in a ODK > form. it show question mark in excel format. how do i change? you can see > in the attached file. > > Thanks all, > > Aung thu >The problem is the Excel file. You must start from the CSV and import
it using the steps I posted earlier. If those steps aren't clear, try
https://help.tune.com/marketing-console/how-to-import-a-unicode-csv-to-excel/.
Alternatively, if Excel isn't behaving, try LibreOffice at
https://www.libreoffice.org/. It imports Unicode CSVs properly.
Yaw