If you use Cumulus, please donate Image

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
HRVistaWeather
Posts: 159
Joined: Mon Apr 09, 2012 2:38 pm
Weather Station: Davis VP2 Plus - 24hr FARS
Operating System: Windows 10 (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.
Tony

Huon River Vista Weather - South Franklin - Tasmania
Davis Vantage Pro 2 Plus - FARS, Cumulus MX, 2 Soil Temp/Moist Solar/Rad.
Weather PC Died 2016/11/21 15:25 Cannot justify replacement (Website dead)

User avatar
steve
Cumulus Author
Posts: 26193
Joined: Mon Jun 02, 2008 6:49 pm
Weather Station: None
Operating System: None
Location: On tour in France
Contact:

Re: Cumulus MX ExtraLogs MySql Utilisation

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

Looks good.

Enjoying France immensely, thanks!
Steve
-----
Hosting available for Cumulus web sites. See http://sandaysoft.com/forum/viewtopic.php?f=2&t=11876

Like Cumulus and want to support it? Please donate! Image


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 3 guests