Ive been trying to grab data from the sqlite db, export it to a csv file, than automagically import it to a google spreadsheet. From there use that info to fill a Ducksboard dashboard.
And ive actually done it!
but now my issue.
I have 5 temperature sensors. All installed and connected to rfxcom at the same time.
But for some reason the output of all 5 is different. The amount of rows put into the sqlite is not the same.
some have 50 records, anther just 10.
But all last records have similar timestamps.
and another thing thats weird is that the timestamp column is 2 hours earlier than the lastupdated column.
having all sensors input data into ducksboard and therefor have a nice chart with 5 lines only works if all data is the same (at least the amount of rows)
if anyone can help all data is available.
thanks!