Navigation:  »No topics above this level« Database

The Set Database option builds a database file that is written every X minutes for the Events Database Application to read.  Events will write changes every 12 seconds.  If one sensor is changing more than 1 time before a file is written, Events will write multiple changes of this sensor to the file.

 

Once you are in the edit mode, you can click the appropriate buttons to add the data you want stored in the database.  You can select the Edit menu items to sort the grid, reverse the grid, delete, add or insert rows by pressing a button.  Delete sensors that you do not want stored in your database.

 

After you select the sensors you want in the database, you should go to the setup and press the Make Setup Button.

 

Check the Write Enabled Button after you have MySQL installed and the Events Database Application is configured properly.  Once the Write Enabled button is checked it will begin writing files to your database folder.

 

If you have multiple files when the Events Database Application first starts up, it will take some additional time to read and write these files Events has created.  Once all the initial files have been read and moved, the Events Database Application should be reading  and moving the new database file within 30 seconds after it is written.

 

 

Menu:  Setup | Set Database

 

MySQL Database Setup

 

 

Setup Tab

The database File Path, Database Name, Minute setting, Write Enabled and Make Data Setup.

 

The Database File Path defaults to your project folder\Database.  The Database name should be kept as short as possible since Events adds a unique number to the database name to save a different name for each file.

 

Click Use Settings to save these settings when Events closes.  Events will reopen with these settings and begin writing files automatically.

 

 

Database Output Tab

The Grid shows which sensors have been selected for MySQL inputs.  This grid is not enabled.  You need to be logged onto Events first and then select the edit button to make changes.

 

 

 

Database Output when enabled.   If Modbus or ALERT is not enabled, the buttons to add modbus or ALERT will be disabled.

You must be logged onto Events to add sensors to the Database Grid.

 

 

Set Database | Edit | Set ChangeTo Yes

If you want to write all values to MySQL, you can select Set Change to Yes and then click the Do Database Output.

All Sensors will be written to a new file.  You should see the statusbar at the bottom advise that a file has been

written.  The Database Application will read the file and move it to a folder in the Database application.

If you do not want a file written you can delete the file before it is read by the Database application.

 

 

Important Database Buttons

Select make Data Setup button for Events Database MySQL Setup.

 

1.  Make Data Setup Button:  Press this button after you have selected all the sensors you want to store in MySQL.

2.  Use Settings:  Saves the current settings when Events closes.   Save changes made to your settings.

3.  Do Database Output Button: Writes data that has changed.  You can manually edit the Change column to yes

if you want to write individual sensors to a file.