5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→MySQL settings) |
|||
| Line 272: | Line 272: | ||
'''Optional Sections''' | '''Optional Sections''' | ||
The remaining 6 drop-down sections are optional, you choose which you want to use, they appear on the screen in a different order to how I explain them below. | The remaining 6 drop-down sections are optional, you choose which you want to use, they appear on the screen in a different order to how I explain them below. | ||
*Dayfile.txt upload | *''Dayfile.txt upload'' | ||
** This feature is to upload the line added to this log file at the end of the day, into a new row in a database table | ** This feature is to upload the line added to this log file at the end of the day, into a new row in a database table | ||
** The database table is created, if it does not already exist using the following SQL | ** The database table is created, if it does not already exist using the following SQL | ||
| Line 282: | Line 283: | ||
*# 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. | ||
*Monthly log file upload | *''Monthly log file upload'' | ||
** This feature allows you to upload the file that Cumulus creates each month to log measurements on a regular basis, it has just two items: | ** This feature allows you to upload the file that Cumulus creates each month to log measurements on a regular basis, it has just two items: | ||
*# A tick box, where you tick if you want a standard table structure to be used to reflect the fields in the [[Monthly_log_files|detailed log file]] | *# A tick box, where you tick if you want a standard table structure to be used to reflect the fields in the [[Monthly_log_files|detailed log file]] | ||
| Line 290: | Line 291: | ||
* Realtime.txt upload | * ''Realtime.txt upload'' | ||
** This feature allows you to upload the file that Cumulus recreates on the most frequent basis. | ** This feature allows you to upload the file that Cumulus recreates on the most frequent basis. | ||
*There are 3 items for this option: | *There are 3 items for this option: | ||
| Line 297: | Line 298: | ||
*# A text box where you enter a retention string in format '''retainVal=NNN retainUnit=XXXX''' where NNN is a number from 1 to 3 digits long, and XXX is a time unit like "days" | *# A text box where you enter a retention string in format '''retainVal=NNN retainUnit=XXXX''' where NNN is a number from 1 to 3 digits long, and XXX is a time unit like "days" | ||
*Custom upload - seconds interval | *''Custom upload - seconds interval'' | ||
** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. There are 3 items: | ** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. 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. | *# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | ||