Historical Data file and data format

[kunoch 27]

I just wanted to read the power data from my lawn mower and exported the data as so called csv.

This is how the content looks like:

"deviceId","name","timestamp","value"
196,"Rasenmaeher",1523595578,6.225

First of all, this so called CSV data can not be imported in excel directly, it must be pre-processed first to lead to a reasonable result.

my main question is about the timestamp. what format is this?

1523595578 how to translate this into a date and time?

anyone having a clue?

 

[jakub.jezek 353]

Time, that Fibaro uses in timestamp is Linux time. Number of seconds from 1. 1. 1970.

 

Conversion in Excel:

Please login or register to see this link.

[kunoch 27]

ok, I already thougt so, just wanted to be sure beacause I have not found anything about this in the manual or 'overread' it.

thanks!

[ErikWout 0]

Hi

 

I find this to work better for me

=(((A1/60)/60)/24)+DATE(1970,1,1)

and then depending on settings replace the comma for semi-colon