WirelessHART Fieldgate SWG70, Operating Instructions Manual

Page: 101 / 124

WirelessHART Fieldgate SWG70 B Appendix: CSV File Formats
Hauser 99
B Appendix: CSV File Formats
B.1 Structure of CSV Files
When creating or editing CSV files for import into Fieldgate SWG70, the following rules apply:
• Use a semicolon ";" as separator for the values in the CSV file. If a value already contains a
semicolon you must put the value into quote signs. If the value already contains quote signs,
put the entire value into quote signs and replace the original quote signs with double quote
signs.
Example!
The value - this is a "long tag" that contains quote signs - must be entered like this:
"this is a ""long tag"" that contains quote signs"
• Avoid special characters. They can easily be corrupted or they can cause the whole data row
to be skipped during the import of the CSV file.
• Avoid leading blanks, trailing blanks, and tabs, especially for integer or hexadecimal values.
• Respect the data type of each column.
• If a mandatory column is missing, the whole file is rejected and nothing is imported.
• If a mandatory value is missing, the corresponding data row is skipped.
B.2 Modbus Mapping CSV files
The files for the MODBUS mapping contain the following columns
The data in the RegisterType, InformationCode, and MappingCode columns is encoded as described
in the tables below.
Register Type Codes
Information Code Codes
Note that the Mapping Code codes depend on the Information Code code, see Table overleaf.
Expanded
Device Type
Code Device ID IO-Card Channel Long Tag Register Register
Type Informatio
n Code Mapping
Code
4 digits hex 6 digits hex integer integer string [32] integer integer integer integer
– – – – mandatory mandatory mandatory mandatory mandatory
Value Description
1 Discrete Input
3 Input Register
Value Description
0 HART Status (RegisterType Code = 3)
1 CMD 48 Status (RegisterType Code = 3)
2 Device Variables (RegisterType Code = 3)
3 MODBUS Status (RegisterType Code = 3)
4 Discrete Variables LSB (RegisterType Code = 1)
5 Discrete Variables MSB (RegisterType Code = 1)
6 Network Statistic (RegisterType Code = 3)