5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→MySQL settings) |
m (→MySQL settings) |
||
| Line 286: | Line 286: | ||
*''Custom upload - at rollover'' | *''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 | ** 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 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: | ** 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. | *# 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. | *# 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'' | *''Monthly log file upload'' | ||