5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→ASIDE) |
m (→MySQL settings) |
||
| Line 713: | Line 713: | ||
* 1.''Dayfile.txt upload'' | * 1.''Dayfile.txt upload'' | ||
** This feature takes the set of values that MX has just used for the line added to this [[dayfile.txt|log file]] at the end of the day, and soon afterwards inserts those same values into a new row (with columns named as per SQL example below) in a database table | ** This feature takes the set of values that MX has just used for the line added to this [[dayfile.txt|log file]] at the end of the day, and soon afterwards inserts those same values into a new row (with columns named as per SQL example below) in a database table | ||
#If you don't have a table in your database for this upload, first | |||
#* Choose Table name - the default table name is "Dayfile", but you can choose any other name | |||
#*Now move down the screen and click the '''Save''' button, and wait for MX to pop up '''Settings Saved''' message | |||
# Now find "Create database table" section below the Save button and click '''Create Dayfile'''. | |||
#Now you have a table in the database. Also continue here if you already | |||
** There are 3 items to use, 2 in this section and below all the option sections a Save button: | ** There are 3 items to use, 2 in this section and below all the option sections a Save button: | ||
**# Enable - tick here when you are ready for this action [using the schema (set of column names) in the SQL quoted below] to happen at end of day | **# Enable - tick here when you are ready for this action [using the schema (set of column names) in the SQL quoted below] to happen at end of day | ||
**# Save - a button after all option sections, until you click it any changes you make in this section have no effect | **# Save - a button after all option sections, until you click it any changes you make in this section have no effect | ||
** Before you reach the end of day that will use this option you do need to create the required database table, and you will find the necessary option lower down on the setting page '''Create Dayfile'''. Do not use the Create action until you have chosen a table name in the upload section (if you don't want default table name) and have clicked Save to tell MX to use your chosen name. Once you have done that, click this Create Dayfile option and it will create the table using the following SQL (here using default table name): | ** Before you reach the end of day that will use this option you do need to create the required database table, and you will find the necessary option lower down on the setting page '''Create Dayfile'''. Do not use the Create action until you have chosen a table name in the upload section (if you don't want default table name) and have clicked Save to tell MX to use your chosen name. Once you have done that, click this Create Dayfile option and it will create the table using the following SQL (here using default table name): | ||