Time out by 2 hours

Hi All

I have a local ODK aggregate instance running and accepting form data fine.
It shows all data and time properly.

However my published data to google Spreadsheets are out by exactly 2
hours. The time-stamp in the spreadsheet shows 2 hours earlier than the
time it was submitted.

I have checked the time and zones on both the server and Google Drive and
both are set to GMT+2

Any ideas?

Bash

Dates and times are stored as GMT and published as GMT. So the data
published into the spreadsheet is presented in GMT+0 time zone.

Mitch

··· On Thu, Nov 15, 2012 at 12:50 AM, Bashir Jahed wrote:

Hi All

I have a local ODK aggregate instance running and accepting form data
fine. It shows all data and time properly.

However my published data to google Spreadsheets are out by exactly 2
hours. The time-stamp in the spreadsheet shows 2 hours earlier than the
time it was submitted.

I have checked the time and zones on both the server and Google Drive and
both are set to GMT+2

Any ideas?

Bash

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

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

Great

Thanks for this.

Future plans to allow selecting time zones within ODK?

Bash

··· On Thu, Nov 15, 2012 at 9:29 PM, Mitch S wrote:

Dates and times are stored as GMT and published as GMT. So the data
published into the spreadsheet is presented in GMT+0 time zone.

Mitch

On Thu, Nov 15, 2012 at 12:50 AM, Bashir Jahed admin@osilab.net wrote:

Hi All

I have a local ODK aggregate instance running and accepting form data
fine. It shows all data and time properly.

However my published data to google Spreadsheets are out by exactly 2
hours. The time-stamp in the spreadsheet shows 2 hours earlier than the
time it was submitted.

I have checked the time and zones on both the server and Google Drive and
both are set to GMT+2

Any ideas?

Bash

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

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

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

For ODK1, not any time soon. You can star this issue:
http://code.google.com/p/opendatakit/issues/detail?id=554

We intend to preserve timezones in the ODK2 storage structure.

Mitch

··· On Thu, Nov 15, 2012 at 11:30 PM, Bashir Jahed wrote:

Great

Thanks for this.

Future plans to allow selecting time zones within ODK?

Bash

On Thu, Nov 15, 2012 at 9:29 PM, Mitch S mitchellsundt@gmail.com wrote:

Dates and times are stored as GMT and published as GMT. So the data
published into the spreadsheet is presented in GMT+0 time zone.

Mitch

On Thu, Nov 15, 2012 at 12:50 AM, Bashir Jahed admin@osilab.net wrote:

Hi All

I have a local ODK aggregate instance running and accepting form data
fine. It shows all data and time properly.

However my published data to google Spreadsheets are out by exactly 2
hours. The time-stamp in the spreadsheet shows 2 hours earlier than the
time it was submitted.

I have checked the time and zones on both the server and Google Drive
and both are set to GMT+2

Any ideas?

Bash

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

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

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

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

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