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
Also about a years data before I started uploading to mysql.