Due to high demand expect some shipping delays at this time, orders may not ship for 1-2 business days.
0

Data download out of order at midnight UTC
Moderators: adafruit_support_bill, adafruit

Forum rules
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.
Please be positive and constructive with your questions and comments.

Data download out of order at midnight UTC

by cswiger on Sat Nov 07, 2015 10:33 am

Dunno if this is a bug or what - minor annoyance that's actually interesting - my excel export format data misplaces ONE datapoint, that's interestingly right at midnight UTC:

15393142 3811.99,8129.44 0 2015-11-06 23:50:00 UTC 2015-11-06 23:50:00 UTC 2015-11-06 23:50:00 19.99999965
15395474 3812.73,8122.62 0 2015-11-07 00:00:22 UTC 2015-11-07 00:00:23 UTC 2015-11-07 00:00:22 622.0000002
15393229 3812.08,8129.15 0 2015-11-06 23:50:21 UTC 2015-11-06 23:50:21 UTC 2015-11-06 23:50:21 -601.0000003
15393318 3812.17,8128.87 0 2015-11-06 23:50:42 UTC 2015-11-06 23:50:42 UTC 2015-11-06 23:50:42 20.99999988
15393389 3812.28,8128.62 0 2015-11-06 23:51:02 UTC 2015-11-06 23:51:02 UTC 2015-11-06 23:51:02 20.00000027


My spreadsheet calculates the time difference between data points so the normally 20 second interval showed up as over 600 seconds and really stood out. Once I moved that ONE line in the collection of 207 datapoints everything else was good.

cswiger
 
Posts: 3
Joined: Wed Oct 21, 2015 10:49 am

Re: Data download out of order at midnight UTC

by adafruit_support_bill on Sat Nov 07, 2015 10:50 am

Thanks for the heads-up. I'll let the adafruit.io team know.

adafruit_support_bill
 
Posts: 80984
Joined: Sat Feb 07, 2009 10:11 am

Re: Data download out of order at midnight UTC

by cswiger on Sat Nov 07, 2015 11:34 am

The other part of the data - it was the 2nd datapoint after midnight that got moved back almost exactly 10 minutes to 23:50.

15395307 90 0 2015-11-06 23:59:39 UTC 2015-11-06 23:59:39 UTC 2015-11-06 23:59:39 20.00000027
15395386 90 0 2015-11-07 00:00:02 UTC 2015-11-07 00:00:02 UTC 2015-11-07 00:00:02 22.99999972
< The 15395473 00:00:22 datapoint should be here to be in order >
15395546 90 0 2015-11-07 00:00:43 UTC 2015-11-07 00:00:43 UTC 2015-11-07 00:00:43 41.00000015
15395620 90 0 2015-11-07 00:01:04 UTC 2015-11-07 00:01:04 UTC 2015-11-07 00:01:04 20.99999988

cswiger
 
Posts: 3
Joined: Wed Oct 21, 2015 10:49 am

Please be positive and constructive with your questions and comments.