Revision as of 19:14, 7 April 2020 (view source) Sfws (talk \| contribs) m (→‎MySQL settings) ← Older edit		Revision as of 19:19, 7 April 2020 (view source) Sfws (talk \| contribs) m (→‎MySQL settings) Newer edit →
''Custom upload - at rollover'' * In the previous option, you have no ability to vary the schema, it will update a column for Total Evaporation even if your weather station cannot calculate that. It will ~~create~~update columns for total hours of sunshine, highest solar radiation level, and the maximum UV in the day even if you cannot measure these. It will not record whether snow was falling or lying, or the depth of snow even if you are recording those. ** MX provides this alternative option, again doing an upload as part of roll over to next day, but here you can specify the schema, and say which columns are to be updated with two options: # A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. # The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. ** Again before you enable this option, there is a facility lower down this setting page (under the heading '''Craetye database table''') where you can type some SQL to be run immediately, that can create the table you want this option to update, (although it could even populate any table with historic data, it is only intended for a small query). *''Monthly log file upload''

Category:Cumulus MX: Difference between revisions

Category:Cumulus MX (view source)

Revision as of 19:19, 7 April 2020