berne
Junior Member
Posts: 85
|
Post by berne on Dec 25, 2019 11:13:54 GMT -8
Hi, I'm trying to capture historical data from my Ourweather V2. I can download CSV data from Blynk and it appears to have a DateTime component from your function returnDateTime(now). But I can't find this function to see how the date time is constructed. The Blynk CSV files have values like "1576704660000'. In Excel how would I parse that into a date and time? Where is the routine that defines the function returnDateTime(now)? Thanks.
On another note, since I can't get WeatherUnderground working, I want store the historical data in Excel of Google sheets. Any advice on the easiest way to do this?
Many thanks, Berne
|
|
berne
Junior Member
Posts: 85
|
Post by berne on Dec 25, 2019 11:40:21 GMT -8
Addendum: Have made progress using Excel Power query add on, with the data as a CSV. At least it loads the FullDataString output into separate columns. Will have to do some massaging and Macroing in Excel to get something more robust.
|
|
berne
Junior Member
Posts: 85
|
Post by berne on Dec 25, 2019 11:45:22 GMT -8
Discrete queries like "IndoorTemperature" appear to come out correctly formatted in a table structure using JSON feature in the Power query add-on.
|
|
|
Post by SDL on Dec 26, 2019 6:50:06 GMT -8
|
|
berne
Junior Member
Posts: 85
|
Post by berne on Dec 27, 2019 12:12:52 GMT -8
Thanks. Any hints on my other questions?
|
|
berne
Junior Member
Posts: 85
|
Post by berne on Dec 27, 2019 14:24:46 GMT -8
Actually the link is not quite correct, since you are giving Blynk the milliseconds since Unix epoch, so 86400 needs to be 86400000
|
|
|
Post by SDL on Dec 30, 2019 16:57:35 GMT -8
Very true on milliseconds.
On your google sheets question. I've seen it done but have never done it myself.
BP
|
|