|
CSV variable |
|
|
|
|
|
CSV variable |
|
|
|
|
By the help of this variable we can read out the data from a CSV file.
As first step load the CSV file by the help of Browse then Open buttons.
As soon as the system loaded all the rows of the file, align the columns of the file with the suitable identifications (here we define the structure of the table for the system, so that it should know which data to find in which CSV column):
| • | Device name (Data name): In case we have measurement data in the CSV file, here we have to select the column where the device names can be found. It is not sure that actually a device will be assigned, for example in case of connection to a production table, here we select the column presenting the name of the product. |
| • | Time: In case there is a column containing date/time in the file, here we should select that. |
| • | Type name: In case we have measurement or type data in the CSV file, here we can select that column, where the given measurement or type name can be found (e.g.: Energy, Gas measurement, A type products, etc.). |
| • | Measurement unit: In case our table contains measurement unit column, here we should select that (e.g.: kg, m3, V, kWh, €, $, etc.). |
| • | Value: The column for the actual data value. |
It is not obligatory to add these data, but impliedly in lack of this the system will not be able to filter among the data, and to forward the value of the given field.
Filtering:
| • | Based on device: In case there are several device or data name in the table. |
| • | Based on type: In case there are several measurement data or type in the file. |
Setting possibilities:
| • | Name: this will be the name of the variable, as reference in the expression (should be unique in the given group). |
| • | Measurement unit: in can be given manually or can be queried from the resource database. |
| • | Multiplier: number (integral), by which the queried quantity will be automatically multiplied at the time of evaluation. |
| • | Summarizing method: here we can specify by which operation the program will determine the value of the given variable: |
- Consumption: the system calculates a consumption value from the stored data samples (last value - first value)
- First value: the system will give the first data sample of the queried interval as the value of the variable
- Last value: the system will give the last data sample of the queried interval as the value of the variable
- Summary of all the data: addition of all the samples in the given interval
- Average: the average of samples in the given interval
- Sample number: number of samples found in the interval
| • | Hyphen: the character to separate fields in the CSV file |
| • | the file contain column headers: select this check box if there is a header in the first row of our file, not data |
| • | Can have a zero value: in case the system is not able to evaluate the variable for any reason, it will give a 0, or nothing value. |
