Dayfile.txt: Difference between revisions

* [[Cumulus_MX#Optional_Sections|Cumulus MX]] includes the ability to generate SQL to update a database table version of thethis daily summary log.

Of course you do not need to exactly mimic the log file with the schema in your database table, your weather station may not produce solar values so those fields in dayfile.txt need not be columns in your database table, or you may wish to add other values from external sensors or other log files. MX allows you to specify a different schema in the SQL it generates. In my own case, my daily summary table has no solar columns but it does have several additional columns (including the daily increment of chill hours, the cumulative chill hours, the contents of the Weather Diary, the time of the last rain tip, wind bearings as compass characters (e.g. NNW) as well as numerical bearings). When I useused Cumulus 1 so I havewrote written thea PHP script to find all these additional values, for example it reads the [[today.ini]] stored in the end of day backup, but other sources are also used, and I continue to use this script (with some changes as for example the weather diary works differently) now I use MX. In my case I also store the equivalent of what appears on my version of "thismonth.htm" each month in another database table. This monthly summary table allows me to have web pages that compare consecutive months or compare months between years. Again MX hasautomatically thestores ability to storeall end of month figures, a feature that Cumulus 1 and 2 lacked, but as yet it does not actually use this extra data.