MX Administrative Interface: Difference between revisions

<pre>2020-04-09 10:00:01.047 MySQL: 2 rows were affected.</pre>

 

* 1.''Dayfile.txt upload''

** This section is about uploading to a database table that contains one row for each day.

#At the end of the meteorological day, MX will now automatically run the SQL to add a new row with the daily summary values as mentioned at the start of this section.

 

*2. ''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 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 if you wanted to be recording those.

 

 

**Cumulus starts a new log file for each new month, that is why this is called the monthly log.

**This database table has one row for each line in any monthly log and therefore the same table contains all months.

 

 

*4. ''Custom upload - minutes interval''

** One way you could use this option, is to replace the monthly log file upload if you wanted to change the schema, by leaving out some columns if your weather station is not able to measure all the derivatives included in the standard schema.

**# A drop down for the number of minutes between runs, the default is 10, but if your weather station updates less frequently, maybe you will choose 15, 20, 30, or 60 as the interval out of the 11 available in drop down.

 

*5. ''Realtime.txt upload''

** Cumulus MX can be set to recreate a file called [[Realtime.txt]] on a very frequent basis. The real time interval defines the time from the end of doing one real time update until the start of the next real time update. The file is recreated, in that unlike other log files, MX does not add new rows in each update, the file only ever contains a single line of values.

# Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message.

 

*6. ''Custom upload - seconds interval''

** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. This caters for when you want something like the values in "realtime.txt" but want to specify your own schema (set of column names) or your own interval between updates (independent of what has been selected for real-time interval). Like the other custom options, this might be because you have extra sensors or do not have sensors for all items in standard log file.