Promotic

Data import from CSV text file - configuration window

Description:
The parameters for importing the list of variables from a text file of the CSV type, are set in this window.
Variables on the "Data" tab can be overwritten of newly added.
It is possible to read from the file either everything or only the data from selected columns.
 
This configuration window can be opened by the " > Import from the CSV file" button on the "Data" tab of the data objects PmaData, PmaOpcDaClientGroup, PmaTrendGroup, PmaCommGroup, PmaCommMsg.
Base configurators:
File to loadReference to the disk file whose data have to be loaded
Column names are in the first file rowIf checked, then there are column names in the first row in the file, i.e. the first row doesn't contain data.
Separator of valuesCharacter that separates individual values in the file
Each value in the file is closed by couple of charactersIf any character is set here (option different from not closed), then it is supposed that each value in the file is closed from the left and from the right by this character.
Type of loadingSpecifies whether the list of variables on the "Data" tab will be overwritten, whether variables will be newly added or whether the list of variables will by synchronized with the data from the file.
Column list to loadThe list of columns whose data will be read from the file. Each row refers to any of the columns in the file either by the order or by the column name (if the file has names in the first row, see "Column names are in the first file row" configurator).
Configurators of the window of the button Edit:
Load value from file columnSpecifies which data column will be read (by index, the column name or it will not be read).
Column index in the fileData will be read from the column specified by index
Column name in the fileData will be read from the column specified by its name
Use default valueIf not set the data in the file (e.g. ..;;..) or it is set don't read the value in the "Load value from file column" configurator, then the value set in the "Default value" configurator is used for reading (if this option is checked).
Default valueSee "Use default value" configurator.
Note:
By the Save setting button it is possible to save the setting into the INI file on the disk.
By the Load setting button it is possible to load the setting from the INI file on the disk (created formerly by the button for saving).
If the data are read from the *.CSV file into the "Data" tab of objects, then the data are read into the individual columns - Name, Data type, Value, Note,... On reading to column Data type, it is necessary to ensure that the data in the *.CSV file refer to the strings in the selection window of the data type. Example of the data in the file:
...a2;Integer;a3;...
...b2;Double;b3;...
See also:
- Data export to CSV text file
- Data import from XML text file
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.