5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→MySQL settings) |
m (→MySQL settings) |
||
| Line 262: | Line 262: | ||
=== MySQL settings === | === MySQL settings === | ||
Cumulus MX includes functionality not in Cumulus 1, and this is one example of a new feature. It was developed from [[ImportCumulusFile|this script]] for Cumulus 1. | Cumulus MX includes functionality not in Cumulus 1, and this is one example of a new feature. It was developed from [[ImportCumulusFile|this script]] for Cumulus 1. If you want to insert historic data (i.e. from before you first use this feature in MX), the script just referenced can be used, or you can write your own SQL. | ||
| Line 284: | Line 284: | ||
*# A tick box that you tick if you want the schema shown above to be used to store lines from [[dayfile.txt]] in a database table | *# A tick box that you tick if you want the schema shown above to be used to store lines from [[dayfile.txt]] in a database table | ||
*# A text box where you can change the default table name to one that suits you better. Do not leave this blank, SQL requires a table name. | *# A text box where you can change the default table name to one that suits you better. Do not leave this blank, SQL requires a table name. | ||
*''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 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. | |||
*''Monthly log file upload'' | *''Monthly log file upload'' | ||