Two Date-Time Formats & Inability to Correctly Sort Date-Times in Google Fusion

Support
1

Hi,

I'm using a form which records (amongst other things) the Submission
Date, Start and End of data capture. An extract from the CSV file
downloaded from ODK Aggregate is shown below.

"SubmissionDate","Start","End","Deviceid"
"Monday, March 28, 2011 1:03:30 PM UTC","Mon Mar 28 12:12:38 UTC
2011","Mon Mar 28 12:14:05 UTC 2011","359028039382641"
"Monday, March 28, 2011 1:03:45 PM UTC","Mon Mar 28 12:19:49 UTC
2011","Mon Mar 28 12:21:02 UTC 2011","359028039382641"

I've two problems ...

Problem 1: The dates use different formats
SubmissionDate = "Monday, March 28, 2011 1:03:30 PM UTC"
Start date/time = "Mon Mar 28 12:12:38 UTC 2011"

Is there any way (e.g. in an xForm) of controlling the output format?
Indeally I would prefer yyyy-mm-dd hh:mm:ss (e.g. 2011-03-28
03:03:30).

Problem 2: The second problem is that when these dates are imported
into Google Fusion (even although they appear to be recognised as date/
times - under edit/modify columns) - when you try to sort them only
Ascii sort is supported. This means that Thursday comes before
Wednesday - regardless of the actual numeric date!)

Any pointers welcomed.

Kirby

2

Hi Kirby,

Would it be possible for you to share your Fusion Table with me and I will
file a bug/feature request with the Fusion Tables team about the ASCII sort
issue if there isn't a suitable workaround?

Thanks,
Tanya

ยทยทยท On Tue, Apr 5, 2011 at 7:17 AM, KirbyJames wrote:

Hi,

I'm using a form which records (amongst other things) the Submission
Date, Start and End of data capture. An extract from the CSV file
downloaded from ODK Aggregate is shown below.

"SubmissionDate","Start","End","Deviceid"
"Monday, March 28, 2011 1:03:30 PM UTC","Mon Mar 28 12:12:38 UTC
2011","Mon Mar 28 12:14:05 UTC 2011","359028039382641"
"Monday, March 28, 2011 1:03:45 PM UTC","Mon Mar 28 12:19:49 UTC
2011","Mon Mar 28 12:21:02 UTC 2011","359028039382641"

I've two problems ...

Problem 1: The dates use different formats
SubmissionDate = "Monday, March 28, 2011 1:03:30 PM UTC"
Start date/time = "Mon Mar 28 12:12:38 UTC 2011"

Is there any way (e.g. in an xForm) of controlling the output format?
Indeally I would prefer yyyy-mm-dd hh:mm:ss (e.g. 2011-03-28
03:03:30).

Problem 2: The second problem is that when these dates are imported
into Google Fusion (even although they appear to be recognised as date/
times - under edit/modify columns) - when you try to sort them only
Ascii sort is supported. This means that Thursday comes before
Wednesday - regardless of the actual numeric date!)

Any pointers welcomed.

Kirby

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--

Tanya Keen
Program Manager
Google Earth Outreach
earth.google.com/outreach

Google Earth & Maps blog: http://google-latlong.blogspot.com
Follow @earthoutreach on Twitter: http://twitter.com/earthoutreach