The server supports the import and export of tag data in a CSV (comma separated variable) file. The CSV functions are only available when a Device or Tag Group is selected. Using CSV import and export, tags can be created quickly in the application of your choice.
Important Note: The easiest way to create an import CSV file is to create a template using File|Export CSV. Define the channels and devices that the project will contain. Next define a tag for each device. Export each device or tag group as a CSV file. Use this template in a spreadsheet application that supports CSV files and modify the file. The resulting CSV file can then be saved to disk and imported back into the server under the same device or tag group or under a new device or tag group.
Exporting a Server Tag List:
This generates a .CSV (comma separated variable) text file that contains a heading record followed by a record for each tag defined under the selected device or tag group. The heading record contains the following fields.
Tag Name - Name of the tag as it will be referenced in an OPC client.
Address - The device location referenced by the tag.
Data Type - The data type used for the tag as shown in the server Tag Data Type drop down list box.
Respect Data Type - This forces the tag to follow its defined data type not the OPC client request.(1, 0)
Client Access - Read/ Write access (RO, RW, WO)
Scan Rate - The rate in milliseconds that the tag address will be scanned when used with most non-OPC clients.
Scaling - Scaling mode (Linear, Square Root)
Raw Low - Low raw value
Raw High - High raw value
Scaled Low - Scaled low value
Scaled High - Scaled high value
Scaled Data Type - The data type used for the tag after scaling is applied.
Clamp Low - Force the resulting scaled value to stay within the limit of Scaled Low.(1, 0)
Clamp High - Force the resulting scaled value to stay within the limit of Scaled High.(1, 0)
Eng. Units - Units string.
Description - Tag description
Each tag record contains the data for each field in a tag record.
Microsoft's Excel makes an excellent tool for editing large groups of tags outside of the server. Once a template CSV file has been exported is can be loaded directly into Excel for editing. A CSV file load in Excel would appear as follows:
Importing a CSV tag list into the Server
Once you have finished editing your tag list it can be imported back into the server using the import CSV function File|Import CSV. This option is available only when you have either a device or tag group selected.
KEPServerEX Features Page »»
|
