Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Cumulus MX ExtraLogs MySql Utilisation

Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.

Moderator: mcrossley

Locked
User avatar
BeaumarisWX
Posts: 360
Joined: Mon 09 Apr 2012 2:38 pm
Weather Station: Davis VP2 Plus - 24hr FARS
Operating System: Windows 10 Pro Hades Canyon
Location: Beaumaris, Tasmania, AU
Contact:

Cumulus MX ExtraLogs MySql Utilisation

Post by BeaumarisWX »

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.
Tony Beaumaris, Tasmania (AUS)

CMX Mobile : https://beaumaris-weather.com/BWX/
CMX Default: https://beaumaris-weather.com/cumulusmx_default/
Colour Dashboard : https://beaumaris-weather.com/dashborad_color.php
Click below for Saratoga Template :
Image
User avatar
steve
Cumulus Author
Posts: 26702
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: Cumulus MX ExtraLogs MySql Utilisation

Post by steve »

Looks good.

Enjoying France immensely, thanks!
Steve
Locked