Received_on and completed_date

Hi everyone,

Many of our forms have a received_on value earlier that the completed_date ? I guess it is because of wrong time settings on the mobile devices.

However, just to confirm :

  • received_on stores the time stamp of when the SERVER receives the form. It uses the server time setting.
  • completed_date stores the time stamp of when the MOBILE DEVICE saves a form. It uses the server time setting.

Is that right ?

Many thanks,

··· -- Charles Flèche mHealth Advisor Télécoms Sans Frontières http://www.tsfi.org Première Urgence - Aide Médicale Internationale http://www.pu-ami.org

Hi Charles,

We’re currently working on this longstanding bug with how we deal with
timezones on stamps from the phone (completion time, date modified of cases
etc.), whcih is described at the bottom of
https://help.commcarehq.org/display/commcarepublic/Form+Completion+versus+Form+Submission+and+Timezones.
We make an effort to adjust for the error, but in certain places it isn’t
possible or cannot be done consistently, leading to unintuitive behavior.
I’m actively working on a fix that will be rolled out over the next few
months. Reveived_on should always be accurate, as it’s recorded in UTC and
only translated to your desired timezone to be shown in the web interface.

Cheers,
Danny

··· On Thu, Apr 30, 2015 at 12:40 AM, Charles Flèche wrote:

Hi everyone,

Many of our forms have a received_on value earlier that the completed_date
? I guess it is because of wrong time settings on the mobile devices.

However, just to confirm :

  • received_on stores the time stamp of when the SERVER receives the form.
    It uses the server time setting.

  • completed_date stores the time stamp of when the MOBILE DEVICE saves a
    form. It uses the server time setting.

Is that right ?

Many thanks,

Charles Flèche

mHealth Advisor

Télécoms Sans Frontières http://www.tsfi.org

Première Urgence - Aide Médicale Internationale http://www.pu-ami.org


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

Charles,

You are correct on the meanings of received_on and completion time.

To make what Danny said a bit more concrete, the times should always be
correct, but they may be shifted a bit depending on what timezone they have
been submitted from. You can set the “Timezone” in your project settings
page to help correctly shift received_on to the correct timezone for many
reports. However, timezones don’t yet work consistently across all of
CommCareHQ, so there may still be some small discrepancies. The page Danny
linked to has more details.

If the timezone doesn’t account for the discrepancy, it could also mean
that the phone that submitted the form is set to the wrong time!

Hope that helps.

Thanks,
Amelia

··· On Thu, Apr 30, 2015 at 11:06 AM, Danny Roberts wrote:

Hi Charles,

We’re currently working on this longstanding bug with how we deal with
timezones on stamps from the phone (completion time, date modified of cases
etc.), whcih is described at the bottom of
https://help.commcarehq.org/display/commcarepublic/Form+Completion+versus+Form+Submission+and+Timezones.
We make an effort to adjust for the error, but in certain places it isn’t
possible or cannot be done consistently, leading to unintuitive behavior.
I’m actively working on a fix that will be rolled out over the next few
months. Reveived_on should always be accurate, as it’s recorded in UTC and
only translated to your desired timezone to be shown in the web interface.

Cheers,
Danny

On Thu, Apr 30, 2015 at 12:40 AM, Charles Flèche <mhealth-myanmar@tsfi.org wrote:

Hi everyone,

Many of our forms have a received_on value earlier that the
completed_date ? I guess it is because of wrong time settings on the mobile
devices.

However, just to confirm :

  • received_on stores the time stamp of when the SERVER receives the form.
    It uses the server time setting.

  • completed_date stores the time stamp of when the MOBILE DEVICE saves a
    form. It uses the server time setting.

Is that right ?

Many thanks,

Charles Flèche

mHealth Advisor

Télécoms Sans Frontières http://www.tsfi.org

Première Urgence - Aide Médicale Internationale http://www.pu-ami.org


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+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
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks Danny and Amelia,

Seeing the time differences, I bet on out of sync clock on the handsets themselves. Thanks !

··· -- Charles Flèche mHealth Advisor Télécoms Sans Frontières http://www.tsfi.org Première Urgence - Aide Médicale Internationale http://www.pu-ami.org