Where does date conversion to local language and format take place?

In our workflow, which takes place in various countries, surveys capture timestamps, get uploaded to ODK Aggregate, and then get downloaded via ODK Briefcase. Finally, we get .csv files from ODK Briefcase. The resulting .csv files have dates in the local language and local format. I have noticed that depending on where (what country) we get the .csv files from, the date formats are slightly different, e.g. "07 Jun 15 22:27:10" vs. "Dec 4, 2014 12:45:37 PM" and "01 Agu 01" vs. "Sep 1, 1986". I am wondering where in the pipeline the conversion from a timestamp to local language happens. Does anyone know?

I know ODK Collect sends a timestamp something like "YYYY-MM-DDTHH:MM:SS.sss[##]" (I might have the format slightly wrong). Is there some way to get the original timestamp sent from the phone?

Might be easier to check yourself. Check the XML from Collect first.
Then download the CSV from Aggregate and open it in a txt editor. Are
the dates the same? Now try it in Briefcase's export.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 8:43 AM, jameskpringle@gmail.com wrote:

In our workflow, which takes place in various countries, surveys capture timestamps, get uploaded to ODK Aggregate, and then get downloaded via ODK Briefcase. Finally, we get .csv files from ODK Briefcase. The resulting .csv files have dates in the local language and local format. I have noticed that depending on where (what country) we get the .csv files from, the date formats are slightly different, e.g. "07 Jun 15 22:27:10" vs. "Dec 4, 2014 12:45:37 PM" and "01 Agu 01" vs. "Sep 1, 1986". I am wondering where in the pipeline the conversion from a timestamp to local language happens. Does anyone know?

I know ODK Collect sends a timestamp something like "YYYY-MM-DDTHH:MM:SS.sss[##]" (I might have the format slightly wrong). Is there some way to get the original timestamp sent from the phone?

--
You received this message because you are subscribed to the Google Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

The datestamp should be in the ODK Collect format up until the Export to
CSV.

Note that there are possible hour-adjustment errors in the Date processing
code

https://code.google.com/p/opendatakit/issues/detail?id=1071&q=date
https://code.google.com/p/opendatakit/issues/detail?id=1074&q=date

and perhaps other areas of the code.

The code for ODK Briefcase formatting is here:
https://github.com/opendatakit/briefcase/blob/master/src/org/opendatakit/briefcase/util/ExportToCsv.java#L345

We do whatever java.text.DateFormat.getDateInstance() does.

··· On Wed, Jul 8, 2015 at 1:22 PM, Yaw Anokwa wrote:

Might be easier to check yourself. Check the XML from Collect first.
Then download the CSV from Aggregate and open it in a txt editor. Are
the dates the same? Now try it in Briefcase's export.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 8:43 AM, jameskpringle@gmail.com wrote:

In our workflow, which takes place in various countries, surveys capture
timestamps, get uploaded to ODK Aggregate, and then get downloaded via ODK
Briefcase. Finally, we get .csv files from ODK Briefcase. The resulting
.csv files have dates in the local language and local format. I have
noticed that depending on where (what country) we get the .csv files from,
the date formats are slightly different, e.g. "07 Jun 15 22:27:10" vs. "Dec
4, 2014 12:45:37 PM" and "01 Agu 01" vs. "Sep 1, 1986". I am wondering
where in the pipeline the conversion from a timestamp to local language
happens. Does anyone know?

I know ODK Collect sends a timestamp something like
"YYYY-MM-DDTHH:MM:SS.sss[##]" (I might have the format slightly wrong).
Is there some way to get the original timestamp sent from the phone?

--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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