Weather Diary: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search

Weather Diary (view source)

Revision as of 10:17, 10 August 2020

6,412 bytes added ,  10:17, 10 August 2020
m
→‎Cumulus MX implementation
(11 intermediate revisions by the same user not shown)
Line 14: Line 14:


This file can be opened as a text file, but there are database file readers that can open this sort of file and display them in a spreadsheet like format (or even convert them to formats like CSV).  It is possible to upload this file, or a transformed version of it, onto your webspace and write coding to display the contents, see [https://cumulus.hosiene.co.uk/viewtopic.php?p=83883#p83883 Cumulus Weather Diary].
This file can be opened as a text file, but there are database file readers that can open this sort of file and display them in a spreadsheet like format (or even convert them to formats like CSV).  It is possible to upload this file, or a transformed version of it, onto your webspace and write coding to display the contents, see [https://cumulus.hosiene.co.uk/viewtopic.php?p=83883#p83883 Cumulus Weather Diary].
==How to view the contents on a web page==
The php script included in [[File:Cumulus 1 Weather Diary PHP reader.zip]] will read the Cumulus 1 weather diary and output it to a web page.  Although that script is not in English, it is possible to translate the text, and it is possible to modify the script in various ways. For example, in one modification I made it combine the multiple entries possible for one day into a single "worst case" output and in another modification I supply it with a date and it only outputs records for that date as shown below:
<pre>$fh = fopen($snowDiary, 'r');
if ($fh == FALSE)
{
echo 'ERROR - cannot access weather diary';
}else{
if($debug) echo 'Success, database ' . $snowDiary . ' is open' . PHP_EOL;
$data = fread($fh, filesize($snowDiary));
fclose($fh);
$converted = iconv("Windows-1250", "UTF-8//IGNORE", $data);
$xml = simplexml_load_string($converted);
$dayArray = array();
$oldKey = '';
foreach ($xml->xpath('//ROW') as $item)
{
$key = substr($item['EntryDate'],0,4) . '-' . substr($item['EntryDate'],4,2) . '-' . substr($item['EntryDate'],6,2);
if($key > $rowMetDayStamp) break;
$falling = $item['SnowFalling'] == 'TRUE' ? 1 : 0;
$lying = $item['SnowLying'] == 'TRUE' ? 1 : 0;
$depth = $item['SnowDepth'];
if($key == $oldKey)  // update to another record for same day, retain worse boolean for falling and lying
{
$falling = $oldFalling == 1 ? 1 : $falling;
$lying = $oldLying == 1 ? 1 : $lying;
$depth = ($depth - $oldDepth) > 0 ? $depth  : $oldDepth;
}
$Entry = $item['Entry'];
// novel to SPAWS
$oldFalling = $falling;
$oldLying = $lying;
$oldDepth = $depth;
$oldKey = $key;
} // end of loop through XML records
if($key == $rowMetDayStamp)
{
$snowKnown = true;
if ($debug)
{
echo ' ----- Found entry in weather diary for ' . $englishProcessingDate . $lf;
}
goto snowDone;
}
if($debug) echo ' ----- NO entry in Cumulus 1 weather diary for ' . $englishProcessingDate . $lf . '============================' . $lf;
$snowKnown = false;
$Entry = Null; // Other variables were previously set to values appropriate for the lowest temperature
goto snowDone;
}// end snow diary file processing</pre>


==How to edit the contents==
==How to edit the contents==
Line 23: Line 73:
The diary loads displaying the current calendar day.
The diary loads displaying the current calendar day.


This may not be the right day to enter current information as the rollover time for Weather Diary information is configuable using [[Cumulus.ini]]  e.g. ''SnowDepthHour=9'' means everything (not just snow depth) in yesterday's diary entry applies until 9am.
This may not be the right day to enter current information as the rollover time for Weather Diary information is configurable using [[Cumulus.ini]]  e.g. ''SnowDepthHour=9'' means everything (not just snow depth) in yesterday's diary entry applies until 9am.
The SnowDepthHour label applies because the only part of the diary that is converted to a [[Webtag]] is Snow Depth, and the time set is when ''<#snowdepth>'' is updated with the current day's value, until then it shows the value on yesterday's diary page.
 
NOTE: This rollover time is totally independent of any overall 'log rollover' time set in station screen as accessed from Configuration menu.  You may use midnight rollover, but want to go out and record manual observations (including measuring any snow) each morning at 9am (or any other time).
 
== Web tags available for your web site ==
 
For Cumulus 1, the only web tag is <#snowdepth>. Obviously a non-zero value means snow is lying, so it can be treated as a boolean for that.
 
For any more information you need to read the [[Log.xml|Log.xml file]] and process that as indicated on referenced page.
 
= Cumulus 1 and MX diary differences =
 
There are a number of differences between the Cumulus 1 and MX implemenations. Please read more at [https://cumulus.hosiene.co.uk/viewtopic.php?f=36&t=17919&p=139854&hilit=weather+diary#p139854 Weather Diary (C1 and MX Differences)]
 
=MX weather diary =
 
The MX weather diary is stored in a table called '''DiaryData''' in a SQLite3 database in a file called [[diary.db]].
 
== How to edit the MX Weather Diary ==
 
=== Using the admin interface ===
 
#Under the '''Edit''' tab, select '''Weather Diary''' and a calendar based selector appears.
#Click on required date, enter any Comment (stored as "Entry" in the database), tick the boxes for falling, and lying.
#Use the spin selector or type in a snow depth. This field takes decimals (it is labelled as "cm", although you could select a different unit and ignore units shown!).
 
=== Accessing outside MX ===
 
The weather diary is stored in [[diary.db|a sqLite database]] and that can be easily accessed by any ODBC software e.g. Libre Office. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor.
 
Here is an example in a PHP 7.3 (there are changes for PHP 7.4) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format):
<pre>$diary = 'sqlite:' . $snowDiary; // Parameter to identify a SQLite database puts a prefix in front of file path
$dbhandle = new PDO($diary);  // connect to db
if($dbhandle === false)
{
$liteError = sqlite_last_error ($dbhandle );
echo ' Error: ' . sqlite_error_string ($liteError);
}else{
if($debug) echo $lf . '============================' . $lf . 'Success, database ' . $diary . ' is open' . $lf;
$queryRead =  "SELECT ALL *  FROM " . "'DiaryData'";
$statement = $dbhandle -> query($queryRead);
if($statement === false)
{
$liteError = sqlite_last_error ($dbhandle );
echo ' Error: ' . sqlite_error_string ($liteError);
}else{
$jump = false;
foreach ($statement as $row)
{
foreach($row as $key => $value )
{
if($key == 'Timestamp')
{
$keyDate = substr($value, 0, 10);
}
if($keyDate != $rowMetDayStamp) break;
if($key == 'snowFalling') $falling = $value;
if($key == 'snowLying') $lying = $value;
if($key == 'snowDepth') $depth = $value;
if($key == 'entry') $Entry = $value;
$jump = true;
        }
        if($jump)
{
$snowKnown = true;
goto snowDone;
}
}
}
}
</pre>
 
== Web tags available for your web site ==
 
Cumulus MX provides [[Webtags#Today|web tags]] for everything in the weather diary for current day (except the comment). There are no web tags for past days.
 
==How do I change the time a diary day begins/ends?==
 
The diary loads displaying the current calendar day.
 
This may not be the right day to enter current information as the rollover time for Weather Diary information is configurable using [[Cumulus.ini]]  e.g. ''SnowDepthHour=9'' means everything (not just snow depth) in yesterday's diary entry applies until 9am.
The SnowDepthHour label applies because the only part of the diary that is converted to a [[Webtag]] is Snow Depth, and the time set is when ''<#snowdepth>'' is updated with the current day's value, until then it shows the value on yesterday's diary page.
The SnowDepthHour label applies because the only part of the diary that is converted to a [[Webtag]] is Snow Depth, and the time set is when ''<#snowdepth>'' is updated with the current day's value, until then it shows the value on yesterday's diary page.


NOTE: This rollover time is totally independent of any overall 'log rollover' time set in station screen as accessed from Configuation menu.  You may use midnight rollover, but want to go out and record manual observations (including measuring any snow) each morning at 9am (or any other time).
NOTE: This rollover time is totally independent of any overall 'log rollover' time set in station screen as accessed from Configuration menu.  You may use midnight rollover, but want to go out and record manual observations (including measuring any snow) each morning at 9am (or any other time).


=Snow=
=Snow=
The weather station models that Cumulus is programmed for do not include any automated snow measurement.  So Cumulus does not treat Snow the same way as automated measurements (until it melts and any left on top of, or inside, a rain gauge is counted as rain).  Instead Cumulus assumes you will manually insert information.
The weather station models that Cumulus is programmed for do not include any automated snow measurement.  So Cumulus does not treat Snow the same way as automated measurements (until it melts and any left on top of, or inside, a rain gauge is counted as rain).  Instead Cumulus assumes you will manually insert information.


==Entering Snow Information==
==Entering Snow Information==
You can go outside with a ruler and measure the depth of any lying snow.
You can go outside with a ruler and measure the depth of any lying snow.
The option Weather Diary within the ''View'' menu allows you to navigate to the appropriate day (see above) and:
The option Weather Diary within the ''View'' menu allows you to navigate to the appropriate day (see above) and:
Line 41: Line 174:


==Displaying on a customised web page==
==Displaying on a customised web page==
If you understand HTML table syntax, the [[Webtag]] ''<#snowdepth>'' can be inserted on a ( for example the ''todayT.htm'') web template (see [[Customised templates]]) to display the snow depth (updating at time set in [[Cumulus.ini]] as explained above. If you understand JavaScript and HTML, you can arrange to upload a background with a scale on which the script can use ''<#snowdepth>'' to overlay the correct depth as a white blanket for example.  The script would have similarities to the current part of the script provided with Cumulus that plots rainfall as a bar chart.


Some sites use the ''current conditions'' feature (optional box on main screen, plus ability to create a file that is deleted on use - see Cumulus help) to display further snow information.
If you understand HTML table syntax, the [[Webtag]] ''<#snowdepth>'' can be inserted on a ( for example the ''todayT.htm'') web template (see [[Customised templates]]) to display the snow depth (updating at time set in [[Cumulus.ini]] as explained above. If you understand JavaScript and HTML, you can arrange to upload a background with a scale on which the script can use ''<#snowdepth>'' to overlay the correct depth as a white blanket for example.  The script would have similarities to the current part of the script provided with Cumulus that plots rainfall as a bar chart.  If you are using MX some other web tags can be used too.
 
Some sites use the ''current conditions'' feature in Cumulus 1 (optional box on main screen, plus ability to create a file that is deleted on use - see Cumulus help) to display further snow information.


Some sites using Cumulus and updating databases as input for creating pages using PHP do manage to display other information from the diary on their web sites (search the support forum for mentions of snow).
Some sites using Cumulus and updating databases as input for creating pages using PHP do manage to display other information from the diary on their web sites (search the support forum for mentions of snow).
[[Category: Terminology]]
[[Category: Terminology]]
[[Category:Log Files]]
Sfws
5,838

edits

Retrieved from "https://www.cumuluswiki.org/a/Special:MobileDiff/5990...7059"

Navigation menu