Hi, Currently i set my groov view trends to read values such as temperature, temperature setpoint and gas valve position. Which is logged every 15 seconds for 1 year. The data is downloaded as csv. Is there a way to transfer data to sql from trends link? or i have to use nodered to inject the data?
Use the forum search to get tips on how to do each part of this.
For example, @torchard flow at the bottom of this thread to get the data from that URL:
Overview:
Use an inject set at the rate you want to get the data.
The inject feeds into a http get node with that ‘download URL’.
The http node goes into a CSV node to break up the data.
A function node will take each data point from the CSV and make a SQL inject (Or batch it up, Im not SQL smart (more of a sqlite guy - sort of).
Done.
Honestly, you would be better to just get the data from the same source as groov View and log it to SQL from there, but that’s just how I do it.