Just some feedback on the brilliant CumulusMX and it's feature capability.
I finally got around to utilizing my ExtraLog Files.
I upload my Soil/Temp/Tension data using the 'MYSQL' Settings:
"custom SQL command to be executed at an interval in minutes - can include webtags'
Using :
Code: Select all
"INSERT IGNORE INTO VPSoilDataSql (LogDateTime,SoilTemp1,SoilTemp2,SoilMoisture1,SoilMoisture2) Values('<#time format="yy-MM-dd HH:mm:ss">',<#SoilTemp1>,<#SoilTemp2>,<#SoilMoisture1>,<#SoilMoisture2>)
And finally got around to setting up some initial queries to display the data (all be it they are RAW, it is a long way from being complete from an analytical point of displaying the data correctly, which will involve including data being summarized in different ways/periods, including the addition of Air Temps/Rainfall/Days Rain...etc in order to display a better / relevant picture of the data. All of which I can now do using MYSQL.
I will also include more detailed highcharts to assist in that display.
Thanks again for a brilliant product, hope you are enjoying your travels.
Kind regards,