Hi, All.
I just noticed that when I downloaded data from the phone through ODK
briefcase and exported it to csv, my date/time field displays data in this
format: 05 22, 13 3:29:32 PM. How do make it appear in this format:
5/22/2013 3:29:32 PM?
Thanks.
Vinia,
Is this in the raw .csv file (opened in a text editor so you can see what's
really coming from ODK), or in Excel? If you're opening in Excel, it will
very often take what it recognizes as a date/time and format it however it
is set to format dates and times.
If you're importing into a statistical package, you'll need to parse the
ODK date/time strings into whatever internal date/time format is relevant
for your software. Our Stata templates, for example, parse into native
Stata format, so that Stata commands can easily see and manipulate those
variables.
Best,
Chris
Hi, All.
I just noticed that when I downloaded data from the phone through ODK
briefcase and exported it to csv, my date/time field displays data in this
format: 05 22, 13 3:29:32 PM. How do make it appear in this format:
5/22/2013 3:29:32 PM?Thanks.
--
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/groups/opt_out.
Hi, Chris.
In the xml file in the instances folder it shows
"2013-05-22T15:28:06.865+08" but when I open the csv file,
both excel and and OOCalc displays 05 22, 13 3:28:06 PM.
Thanks,
Vinia
Vinia,
Is this in the raw .csv file (opened in a text editor so you can see
what's really coming from ODK), or in Excel? If you're opening in Excel, it
will very often take what it recognizes as a date/time and format it
however it is set to format dates and times.If you're importing into a statistical package, you'll need to parse the
ODK date/time strings into whatever internal date/time format is relevant
for your software. Our Stata templates, for example, parse into native
Stata format, so that Stata commands can easily see and manipulate those
variables.Best,
Chris
On Fri, May 24, 2013 at 6:29 AM, Vinia Marciano viniamarciano@gmail.comwrote:
Hi, All.
I just noticed that when I downloaded data from the phone through ODK
briefcase and exported it to csv, my date/time field displays data in this
format: 05 22, 13 3:29:32 PM. How do make it appear in this format:
5/22/2013 3:29:32 PM?Thanks.
--
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/groups/opt_out.--
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/groups/opt_out.
Hi Vinia,
The date/time formatting may be coming from your OS language/region
settings. In any case, the thing you really want to do is open the .csv
file in a text editor so that you can see the raw file. Excel and OOCalc
may both re-format, but the question is whether the format coming from ODK
is okay in the .csv. I suspect that it is. In that case, you may need to
use Excel and/or OOCalc to change the display format of those cells to
whatever format suits you.
Best,
Chris
Hi, Chris.
In the xml file in the instances folder it shows
"2013-05-22T15:28:06.865+08" but when I open the csv file,
both excel and and OOCalc displays 05 22, 13 3:28:06 PM.Thanks,
Vinia
On Fri, May 24, 2013 at 2:31 PM, Christopher Robert <crobert@surveycto.com wrote:
Vinia,
Is this in the raw .csv file (opened in a text editor so you can see
what's really coming from ODK), or in Excel? If you're opening in Excel, it
will very often take what it recognizes as a date/time and format it
however it is set to format dates and times.If you're importing into a statistical package, you'll need to parse the
ODK date/time strings into whatever internal date/time format is relevant
for your software. Our Stata templates, for example, parse into native
Stata format, so that Stata commands can easily see and manipulate those
variables.Best,
Chris
On Fri, May 24, 2013 at 6:29 AM, Vinia Marciano viniamarciano@gmail.comwrote:
Hi, All.
I just noticed that when I downloaded data from the phone through ODK
briefcase and exported it to csv, my date/time field displays data in this
format: 05 22, 13 3:29:32 PM. How do make it appear in this format:
5/22/2013 3:29:32 PM?Thanks.
--
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/groups/opt_out.--
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/groups/opt_out.--
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/groups/opt_out.
Hi, Chris.
Many many thanks! I reset the regional settings to restore default
settings. Looks good now. 
Have a great weekend!
Cheers,
Vinia
Hi Vinia,
The date/time formatting may be coming from your OS language/region
settings. In any case, the thing you really want to do is open the .csv
file in a text editor so that you can see the raw file. Excel and OOCalc
may both re-format, but the question is whether the format coming from ODK
is okay in the .csv. I suspect that it is. In that case, you may need to
use Excel and/or OOCalc to change the display format of those cells to
whatever format suits you.Best,
Chris
On Fri, May 24, 2013 at 10:01 AM, Vinia Marciano viniamarciano@gmail.comwrote:
Hi, Chris.
In the xml file in the instances folder it shows
"2013-05-22T15:28:06.865+08" but when I open the csv file,
both excel and and OOCalc displays 05 22, 13 3:28:06 PM.Thanks,
Vinia
On Fri, May 24, 2013 at 2:31 PM, Christopher Robert < crobert@surveycto.com> wrote:
Vinia,
Is this in the raw .csv file (opened in a text editor so you can see
what's really coming from ODK), or in Excel? If you're opening in Excel, it
will very often take what it recognizes as a date/time and format it
however it is set to format dates and times.If you're importing into a statistical package, you'll need to parse the
ODK date/time strings into whatever internal date/time format is relevant
for your software. Our Stata templates, for example, parse into native
Stata format, so that Stata commands can easily see and manipulate those
variables.Best,
Chris
On Fri, May 24, 2013 at 6:29 AM, Vinia Marciano <viniamarciano@gmail.com wrote:
Hi, All.
I just noticed that when I downloaded data from the phone through ODK
briefcase and exported it to csv, my date/time field displays data in this
format: 05 22, 13 3:29:32 PM. How do make it appear in this format:
5/22/2013 3:29:32 PM?Thanks.
--
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/groups/opt_out.--
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/groups/opt_out.--
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/groups/opt_out.--
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/groups/opt_out.