Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Cumulus MX ExtraLogs MySql Utilisation

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
User avatar
Posts: 172
Joined: Mon Apr 09, 2012 2:38 pm
Weather Station: Davis VP2 Plus - 24hr FARS
Operating System: Windows 10 Home (64bit)
Location: Franklin, Huon Valley, Tasmania

Cumulus MX ExtraLogs MySql Utilisation

Postby HRVistaWeather » Tue Oct 03, 2017 11:22 am

Hi Steve,
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>)

As I had years of data in ExtraLogs prior to setting up the above auto upload to MYSQL, I finally worked out a way to upload the historic ExtraLogs data and then append it to the new table.
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.

Soil Temperature and Tension20171003.png

Kind regards,
You do not have the required permissions to view the files attached to this post.
Huon River Vista - South Franklin Weather - Tasmania
Davis Vantage Pro 2 Plus - FARS, Cumulus MX, 2 Soil Temp/Moist Solar/Rad.

User avatar
Cumulus Author
Posts: 26654
Joined: Mon Jun 02, 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France

Re: Cumulus MX ExtraLogs MySql Utilisation

Postby steve » Tue Oct 03, 2017 1:59 pm

Looks good.

Enjoying France immensely, thanks!
Hosting available for Cumulus web sites. See

Please read the posts in the Announcements section about the current status of Cumulus development since I have retired from my day job

Return to “Cumulus MX”

Who is online

Users browsing this forum: Warper1only and 4 guests