Endress+Hauser WirelessHART Fieldgate SWG70 - 17 CSV File Formats; Structure of the CSV Files; Modbus Mapping CSV Files

CSV file formats WirelessHART Fieldgate SWG70
124 Endress + Hauser
17 CSV file formats
Note!
• This section on "CSV file formats" is only relevant for Fieldgate versions with Modbus. The
"Modbus" function is only available on WirelessHART Fieldgate models with the version
"SWG70-xx-1-xx-xx". See Chapter 2.3 "Ordering information" on page 11.
17.1 Structure of the 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.
17.2 Modbus Mapping CSV files
The files for 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
Expanded
Device
Type Code
Device ID IO-Card Channel Long Tag Registers Register
Type
Information
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)