5,838
edits
m (→MySQL settings) |
m (→MySQL settings) |
||
** If the table already has rows, the upload just creates a new row
*''Custom upload - minutes interval''
** This feature allows you to specify your own SQL for an upload to be repeated every NN minutes. There are 3 items:
*# 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 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.
** 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.
* ''Realtime.txt upload''
|
edits