The Pinebox offers a possibility to create the table structure from the process data.
To create the data, a valid IODD file needs to be present for the port. In the web interface, the section for the database control is in the process data section of the port page. To create a new table structure, hit the “Create structure for process data” button:
The data consists of the elements for the process data and additionally, minimum and maximum values since the last request (numeric values only). It also adds a column for the timestamp.
If data is present, or you wish to delete the existing structure, this can be also performed in this section.
The “View/edit data” button will take you to the database frontend (see chapter 5.1 Database Frontend).
The database control section also offers the possiblilty to export data from the SQLite database for the port in CSV format. The data will be restricted to the date range given in the input boxes.