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 4017) - 17 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 and soil sensors

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
duke

Cumulus and soil sensors

Post by duke »

Continued from 'here'
HRVistaWeather wrote:Too true Duke,

Well I finally got around to doing something with my Davis Pro2 Soil Temp and Moisture Data, for the time being anyway.

Still not uploading to BoM-WoW but at least know I'm displaying it on my website.

I setup a soilT.txt file for Cumulus to upload the Davis Pro soil data (<#date> <#timehhmmss> <#SoilTemp1> <#SoilTemp2> <#SoilMoisture1> <#SoilMoisture2>) bit overkill but for now it's uploading in realtime.

Then modified an ImpotCumulus script to store it server side in MySql table.
Then modified a RealtimeCumulusSql script to query it.
Then modified a RealtimeCumulus .js script for HighStocks Graphs.
Then a new page displaying the data from CUTags,php (created a heap of graphics for use in the display) and then added the HighStock charts.

Now just need to apply ajax updates at some stage and also some more queries to see if I can get Monthly/Yearly stats from MySql (not done much of that) if anyone has any tips.

Here's the page : http://hrvistaweather.com/wxsoil.php charts are in approx (1) min data and once it fills up will display last 7 days. (Only set it up at 09:15 EST this morning).

Happy for anyone to pick it to pieces as not done that much with soil monitoring in the past.

Not heard from Tom as yet. will post when I do Duke.

regards
Tony, hope you don't mind, started anew thread rather than hijack!
Not heard from Tom as yet. will post when I do Duke.
Thank you, I'd appreciate it. Your page looks good. It says that your scripts are based on Webster Weather and Indian Trail Weather, which ones? Would you care to share?
User avatar
BeaumarisWX
Posts: 357
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:

Re: Cumulus and soil sensors

Post by BeaumarisWX »

Hi Duke,
Thanks for the move, I'd been up for about 54hrs at the time I posted the previous message and went to bed thinking I should have started a new thread - thanks.
Thank you, I'd appreciate it. Your page looks good. It says that your scripts are based on Webster Weather and Indian Trail Weather, which ones? Would you care to share?
Original wxsoil.php was developed by Webster Weather (now - Burnsville Weather) http://www.burnsvilleweatherlive.com/wxsoil.php and they where using Weather Display tags.
Weather Display summarises the soil data to Monthly/Yearly/high/low etc (and as yet as you know Cumulus does not).

Jeff from Indian Trail Weather originally had this script http://indiantrailweather.com/wxsoil.php though recently upgraded it http://indiantrailweather.com/wxsoil2.php with assistance from others including Jim McMurry from http://jcweather.us/soil.php his upgrade uses jpgraphs rather than my HighStock Charts. Anyway all scripts where based on WD data, so until cumulus is upgraded I had to find a way to monitor/display the data using Cumulus.

The WD tags used are as follows:

Code: Select all

//
// Tags for Leaf Measurements  - Alternative Dashboard 6.5 & WXsoil 1.0
//
$VPleaf = '%VPleaf%'; // Davis Leaf wetness #1
$VPleaf2 = '%VPleaf2%';  // Davis leaf wetness #2
$VPleaf3 = '%VPleaf3%';  // Davis leaf wetness #3
$VPleaf4 = '%VPleaf4%';  // Davis leaf wetness #4
//
// Tags for Soil Temperature/Moisture Measurements  - Alternative Dashboard 6.5 & WXsoil 1.0
//

// SENSOR #1
$soiltemp = '%soiltemp%';  // Davis soil temperature #1
$maxsoiltemp = '%maxsoiltemp%';  // Davis Max Soil Temp today #1
$minsoiltemp = '%minsoiltemp%';  // Davis Min Soil Temp today #1
$mrecordhighsoil = '%mrecordhighsoil%';
$mrecordlowsoil = '%mrecordlowsoil%';
$yrecordhighsoil = '%yrecordhighsoil%';
$yrecordlowsoil = '%yrecordlowsoil%';
$recordhighsoil = '%recordhighsoil%';
$recordlowsoil = '%recordlowsoil%';

// SENSOR #2
$VPsoiltemp2 = '%VPsoiltemp2%';  // Davis soil temperature #2
$hiVPsoiltemp2 = '%hiVPsoiltemp2%';  // Davis Max Soil Temp today #2
$loVPsoiltemp2 = '%loVPsoiltemp2%';  // Davis Min Soil Temp today #2
$mrecordhighsoil2 = '%mrecordhighsoil2%';
$mrecordlowsoil2 = '%mrecordlowsoil2%';
$yrecordhighsoil2 = '%yrecordhighsoil2%';
$yrecordlowsoil2 = '%yrecordlowsoil2%';
$recordhighsoil2 = '%recordhighsoil2%';
$recordlowsoil2 = '%recordlowsoil2%';

// SENSOR #3
$VPsoiltemp3 = '%VPsoiltemp3%';  // Davis soil temperature #3
$hiVPsoiltemp3 = '%hiVPsoiltemp3%';  // Davis Max Soil Temp today #3
$loVPsoiltemp3 = '%loVPsoiltemp3%';  // Davis Min Soil Temp today #3
$mrecordhighsoil3 = '%mrecordhighsoil3%';
$mrecordlowsoil3 = '%mrecordlowsoil3%';
$yrecordhighsoil3 = '%yrecordhighsoil3%';
$yrecordlowsoil3 = '%yrecordlowsoil3%';
$recordhighsoil3 = '%recordhighsoil3%';
$recordlowsoil3 = '%recordlowsoil3%';

// SENSOR #4
$VPsoiltemp4 = '%VPsoiltemp4%';  // Davis soil temperature #4
$hiVPsoiltemp4 = '%hiVPsoiltemp4%';  // Davis Max Soil Temp today #4
$loVPsoiltemp4 = '%loVPsoiltemp4%';  // Davis Min Soil Temp today #4
$mrecordhighsoil4 = '%mrecordhighsoil4%';
$mrecordlowsoil4 = '%mrecordlowsoil4%';
$yrecordhighsoil4 = '%yrecordhighsoil4%';
$yrecordlowsoil4 = '%yrecordlowsoil4%';
$recordhighsoil4 = '%recordhighsoil4%';
$recordlowsoil4 = '%recordlowsoil4%';
//
// Tags for Soil Moisture Measurements  - Alternative Dashboard 6.5 & WXsoil 1.0
//

// SENSOR #1
$VPsoilmoisture = '%VPsoilmoisture%';  //Davis Soil Moisture #1
$hiVPsoilmoisture = '%hiVPsoilmoisture%';
$loVPsoilmoisture = '%loVPsoilmoisture%';
$mrecordhighsoilmonth = '%mrecordhighsoilmonth%';
$mrecordhighsoilday = '%mrecordhighsoilday%';
$mrecordlowsoilmonth = '%mrecordlowsoilmonth%';
$mrecordlowsoilday = '%mrecordlowsoilday%';
$yrecordhighsoilmonth = '%yrecordhighsoilmonth%';
$yrecordhighsoilday = '%yrecordhighsoilday%';
$yrecordlowsoilmonth = '%yrecordlowsoilmonth%';
$yrecordlowsoilday = '%yrecordlowsoilday%';
$recordhighsoilyear = '%recordhighsoilyear%';
$recordhighsoilmonth = '%recordhighsoilmonth%';
$recordhighsoilday = '%recordhighsoilday%';
$recordlowsoilyear = '%recordlowsoilyear%';
$recordlowsoilmonth = '%recordlowsoilmonth%';
$recordlowsoilday = '%recordlowsoilday%';

// SENSOR #2
$VPsoilmoisture2 = '%VPsoilmoisture2%'; //Davis Soil Moisture #2
$hiVPsoilmoisture2 = '%hiVPsoilmoisture2%';
$loVPsoilmoisture2 = '%loVPsoilmoisture2%';
$mrecordhighsoilmonth2 = '%mrecordhighsoilmonth2%';
$mrecordhighsoilday2 = '%mrecordhighsoilday2%';
$mrecordlowsoilmonth2 = '%mrecordlowsoilmonth2%';
$mrecordlowsoilday2 = '%mrecordlowsoilday2%';
$yrecordhighsoilmonth2 = '%yrecordhighsoilmonth2%';
$yrecordhighsoilday2 = '%yrecordhighsoilday2%';
$yrecordlowsoilmonth2 = '%yrecordlowsoilmonth2%';
$yrecordlowsoilday2 = '%yrecordlowsoilday2%';
$recordhighsoilyear2 = '%recordhighsoilyear2%';
$recordhighsoilmonth2 = '%recordhighsoilmonth2%';
$recordhighsoilday2 = '%recordhighsoilday2%';
$recordlowsoilyear2 = '%recordlowsoilyear2%';
$recordlowsoilmonth2 = '%recordlowsoilmonth2%';
$recordlowsoilday2 = '%recordlowsoilday2%';

// SENSOR #3
$VPsoilmoisture3 = '%VPsoilmoisture3%';  //Davis Soil Moisture #3
$hiVPsoilmoisture3 = '%hiVPsoilmoisture3%';
$loVPsoilmoisture3 = '%loVPsoilmoisture3%';
$mrecordhighsoilmonth3 = '%mrecordhighsoilmonth3%';
$mrecordhighsoilday3 = '%mrecordhighsoilday3%';
$mrecordlowsoilmonth3 = '%mrecordlowsoilmonth3%';
$mrecordlowsoilday3 = '%mrecordlowsoilday3%';
$yrecordhighsoilmonth3 = '%yrecordhighsoilmonth3%';
$yrecordhighsoilday3 = '%yrecordhighsoilday3%';
$yrecordlowsoilmonth3 = '%yrecordlowsoilmonth3%';
$yrecordlowsoilday3 = '%yrecordlowsoilday3%';
$recordhighsoilyear3 = '%recordhighsoilyear3%';
$recordhighsoilmonth3 = '%recordhighsoilmonth3%';
$recordhighsoilday3 = '%recordhighsoilday3%';
$recordlowsoilyear3 = '%recordlowsoilyear3%';
$recordlowsoilmonth3 = '%recordlowsoilmonth3%';
$recordlowsoilday3 = '%recordlowsoilday3%';

// SENSOR #4
$VPsoilmoisture4 = '%VPsoilmoisture4%'; //Davis Soil Moisture #4
$hiVPsoilmoisture4 = '%hiVPsoilmoisture4%';
$mrecordhighsoilmonth4 = '%mrecordhighsoilmonth4%';
$mrecordhighsoilday4 = '%mrecordhighsoilday4%';
$mrecordlowsoilmonth4 = '%mrecordlowsoilmonth4%';
$mrecordlowsoilday4 = '%mrecordlowsoilday4%';
$yrecordhighsoilmonth4 = '%yrecordhighsoilmonth4%';
$yrecordhighsoilday4 = '%yrecordhighsoilday4%';
$yrecordlowsoilmonth4 = '%yrecordlowsoilmonth4%';
$yrecordlowsoilday4 = '%yrecordlowsoilday4%';
$loVPsoilmoisture4 = '%loVPsoilmoisture4%';
$recordhighsoilyear4 = '%recordhighsoilyear4%';
$recordhighsoilmonth4 = '%recordhighsoilmonth4%';
$recordhighsoilday4 = '%recordhighsoilday4%';
$recordlowsoilyear4 = '%recordlowsoilyear4%';
$recordlowsoilmonth4 = '%recordlowsoilmonth4%';
$recordlowsoilday4 = '%recordlowsoilday4%';

$firstsnowseason = '%firstsnowseason%';
$firstsnowseasonav = '%firstsnowseasonav%';
Cumulus has:

Code: Select all

<#SoilTemp1>	Soil temperature 1
<#SoilTemp2>	Soil temperature 2
... and so on up to <#SoilTemp4>
<#SoilMoisture1>	Soil moisture 1
<#SoilMoisture2>	Soil moisture 2
... and so on up to <#SoilMoisture4>
<#LeafTemp1>	Leaf temperature 1
<#LeafTemp2>	Leaf temperature 2
<#LeafWetness1>	Leaf wetness 1
<#LeafWetness2>	Leaf wetness 2
I've attached a zip copy of the original WD based files. ("wxsoil-103a.zip")
wxsoil-103a.zip
And a copy of the files I've setup to use Cumulus (in it's current state. As mentioned I would like to try setting up some Sql Queries to display monthly/yearly/Hi/Lo data, if anyone has any ideas would be greatly appreciated.

Also Attached: (" CumulusSoil.zip ")
CumulusSoil.zip
Which contains :
VPSoilDataSqlT.txt (cumulus upload in realtime).
ImportVPSoilDataSql_v2-6.php (import "VPSoilDataSql.txt" into MySql table called "VPSoilDataSql") Cron Job runs every minute to import.
realtime_graphs_soil_vp_Sql.php (Query the MySql table called "VPSoilDataSql") for displaying HighStock Charts.
realtime_graphs_soil_vp.js (used to create the HighStock Charts). Note: Butchered to include Theme colours (can be done different - will tidy up one day) you can easily change to revert to Mark Crossley default.
realtime_graphs_soil_vp.php (used to test setup - no Saratoga inclusions).
wxsoil.php (final display file (saratoga based) uses CUtags and scripts the table data and includes the HighStock Charts.

Hopefully this answers your question.

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
duke

Re: Cumulus and soil sensors

Post by duke »

54 hours - dare I ask?

Thank you Tony, much appreciated. I must have over looked these never planning to have soil sensors at the time. Oh well, that's the problem with hobbies I guess - they just keep growing ;)

(good storm rolling in tonight - Bertha!)
MeteoBisignano
Posts: 79
Joined: Mon 09 Mar 2015 10:45 am
Weather Station: wh3080
Operating System: windows
Location: Cosenza

Re: Cumulus and soil sensors

Post by MeteoBisignano »

Function on WH-3080 with sensor UV ed Solar
MeteoBisignano
Posts: 79
Joined: Mon 09 Mar 2015 10:45 am
Weather Station: wh3080
Operating System: windows
Location: Cosenza

Re: Cumulus and soil sensors

Post by MeteoBisignano »

MeteoBisignano wrote:Function on WH-3080 with sensor UV ed Solar
pgreenaway
Posts: 4
Joined: Tue 19 Sep 2017 1:56 am
Weather Station: Davis Vantage Vue
Operating System: Windows 10
Location: Hamilton, New Zealand

Re: Cumulus and soil sensors

Post by pgreenaway »

duke wrote: Sat 02 Aug 2014 7:06 pm Continued from 'here'
HRVistaWeather wrote:Too true Duke,

Well I finally got around to doing something with my Davis Pro2 Soil Temp and Moisture Data, for the time being anyway.

Still not uploading to BoM-WoW but at least know I'm displaying it on my website.

I setup a soilT.txt file for Cumulus to upload the Davis Pro soil data (<#date> <#timehhmmss> <#SoilTemp1> <#SoilTemp2> <#SoilMoisture1> <#SoilMoisture2>) bit overkill but for now it's uploading in realtime.

Then modified an ImpotCumulus script to store it server side in MySql table.
Then modified a RealtimeCumulusSql script to query it.
Then modified a RealtimeCumulus .js script for HighStocks Graphs.
Then a new page displaying the data from CUTags,php (created a heap of graphics for use in the display) and then added the HighStock charts.

Now just need to apply ajax updates at some stage and also some more queries to see if I can get Monthly/Yearly stats from MySql (not done much of that) if anyone has any tips.

Here's the page : http://hrvistaweather.com/wxsoil.php charts are in approx (1) min data and once it fills up will display last 7 days. (Only set it up at 09:15 EST this morning).

Happy for anyone to pick it to pieces as not done that much with soil monitoring in the past.

Not heard from Tom as yet. will post when I do Duke.

regards
Tony, hope you don't mind, started anew thread rather than hijack!
Not heard from Tom as yet. will post when I do Duke.
Thank you, I'd appreciate it. Your page looks good. It says that your scripts are based on Webster Weather and Indian Trail Weather, which ones? Would you care to share?
Sorry to bring up an old post but i've had this ImportVPSoilDataSql file running and uploading my soil data for over a year now till it just stopped uploading to my sql table in February, only thing I can think of is that I may of updated Cumulus MX back then however didn't notice till a month later.
When running manually in browser it just gets stuck on "Processing VPSoilDataSqlfile: soil.txt", I've even downloaded the original files off here as I had changed them slightly but still gets stuck at the same place and refuses to upload. Anyone else using this had any issues?

Otherwise is there any other way to upload the extra sensors log text file from Cumulus MX to a sql table, will need to be automated also, any help would be much appreciated.

Any help would be much appreciated,
Philip Greenaway.

"http://taupiriweather.co.nz/data/Import ... e=soil.txt"
Image
User avatar
mcrossley
Posts: 12686
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Cumulus and soil sensors

Post by mcrossley »

Philip, it sounds like you could use one of the Cumulus Custom MySQL options to upload the data directly to your MySQL table.

You define your SQL command, and for the data values use the soil sensor web tags.

This is the way many people upload custom data to their MySQL databases - me included!
pgreenaway
Posts: 4
Joined: Tue 19 Sep 2017 1:56 am
Weather Station: Davis Vantage Vue
Operating System: Windows 10
Location: Hamilton, New Zealand

Re: Cumulus and soil sensors

Post by pgreenaway »

Thank you so much Mark, just found a chat about the custom sql and an example which helped me get it up and running again.
What would be the easy way to upload the data off the Extra Sensors Log text files to sql? I've got 5 to 6 months data missing now.. 😕 Also about a years data before I started uploading to mysql.
Image
pgreenaway
Posts: 4
Joined: Tue 19 Sep 2017 1:56 am
Weather Station: Davis Vantage Vue
Operating System: Windows 10
Location: Hamilton, New Zealand

Re: Cumulus and soil sensors

Post by pgreenaway »

All sorted, I managed to edit your latest ImportCumulus file to upload my text files so I can get all my data back..
Image
User avatar
mcrossley
Posts: 12686
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Cumulus and soil sensors

Post by mcrossley »

:thumbsup:
Post Reply