How to convert the CSV to UTF8 from briefcase command line

Support
1

Hello,

I want to convert the csv exported files through briefcase command line to
UTF8 to show the Arabic letter. I use the following command, is there any
other parameter I need to pass to make this happen. This is the command
line I use:

java -jar "C:\Briefcase.jar" --form_id test_v1.0 --storage_directory
"D:\ODK" --aggregate_url https://test.appspot.com/ --odk_username odkadmin
--odk_password newP0o9I8u7 --pem_file D:\key.pem --export_directory
D:\Export\PHC\ --export_filename PHC.csv --overwrite_csv_export
--exclude_media_export

Regards, -H

2

Hi Hanan,

You'll need to figure out where the Unicode issue is happening. Build
three data sets -- one with simple text (hello), then common unicode
(héllô), then Arabic letters. Now try the following.

Export from the UI and from the command line interface. Does either
data set work?

What happens if you try a different application to open the CSV
(Excel, Notepad++, Libreoffice)? Does either data set work?

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Fri, Feb 5, 2016 at 12:53 PM, Hanan Aqilan hjameelq@gmail.com wrote:

Hello,

I want to convert the csv exported files through briefcase command line to
UTF8 to show the Arabic letter. I use the following command, is there any
other parameter I need to pass to make this happen. This is the command line
I use:

java -jar "C:\Briefcase.jar" --form_id test_v1.0 --storage_directory
"D:\ODK" --aggregate_url https://test.appspot.com/ --odk_username odkadmin
--odk_password newP0o9I8u7 --pem_file D:\key.pem --export_directory
D:\Export\PHC\ --export_filename PHC.csv --overwrite_csv_export
--exclude_media_export

Regards, -H

--

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.

3

my Hosni
can you send me excel questionnaire which sample that you made in order to understanding because that parts is difficult can you help me please in case you have questionnaires and excels different
xusni571@gmail.com

4

Note that importing CSV files requires special steps in Excel

The data should be fine on the device and in Briefcase and the csv output
file.

The problem is in how you load the csv into Excel.

You cannot just double-click it to open it.

··· On Sat, Feb 13, 2016 at 11:43 PM, Yaw Anokwa wrote:

Hi Hanan,

You'll need to figure out where the Unicode issue is happening. Build
three data sets -- one with simple text (hello), then common unicode
(héllô), then Arabic letters. Now try the following.

Export from the UI and from the command line interface. Does either
data set work?

What happens if you try a different application to open the CSV
(Excel, Notepad++, Libreoffice)? Does either data set work?

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Fri, Feb 5, 2016 at 12:53 PM, Hanan Aqilan hjameelq@gmail.com wrote:

Hello,

I want to convert the csv exported files through briefcase command line
to
UTF8 to show the Arabic letter. I use the following command, is there any
other parameter I need to pass to make this happen. This is the command
line
I use:

java -jar "C:\Briefcase.jar" --form_id test_v1.0 --storage_directory
"D:\ODK" --aggregate_url https://test.appspot.com/ --odk_username
odkadmin
--odk_password newP0o9I8u7 --pem_file D:\key.pem --export_directory
D:\Export\PHC\ --export_filename PHC.csv --overwrite_csv_export
--exclude_media_export

Regards, -H

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com