To perform the import from Excel, press the Open button in the menu.
A folder that stores the supplied configurations if the instruments is opened by default. Select the file you need.
The read tags will be loaded into the table.
Select the tags you need and complete the import by pressing the Import button.
You can also select certain tags and press the Save button - in this case, a window appears in which you can specify whether to save all tags or only the selected ones.
This way you can generate a separate Excel file only with the tags you need.
Structure of the Excel file.
The Excel file has the following structure.
Note. The utility binds columns by their names - the order of the columns is not significant. The names have no spaces and fully match the specified ones. You can also use any of the supplied Excel files as a template for making your own file.
Column name |
Description |
Name |
Variable name. Since the names in the utility are displayed in hierarchical order, a period is used as a level separator. |
DataType |
Data type on OPC server. Possible options - double, int32, uint32, string, datetime, etc. |
Access |
Access type. At the moment - ReadOnly, e.i. all the tags are used in read only mode |
Comment |
Tag comment. |
OBIS |
OBIS identifier of tag. |
DlmsType |
Dlms object type. Possible options - Data, Register, Extended Register, Demand Register, Profile Generic. |
Scale |
Multiplier - the value obtained from the device is multiplied by this factor. The field is for reference only and is not imported to ОРС. |
Unit |
Type of the measured parameter |
AttributeIndex |
Object attribute index. For Data и Register - always 2 (can be unspecified) |
CaptureObjectOBIS |
For Profile Generic - capture object. |
Value |
Value read from the device. The field is for reference only and is not imported to ОРС. |