Appendix
2
017-
03
121
12.3
CSV File Structure
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 two 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.
MODBUS Mapping
The files for the MODBUS mapping contain the following columns.
File Structure
The data in the
RegisterType
,
InformationCode
, and
MappingCode
columns is encoded as
described in the tables below.
RegisterType Codes
InformationCode Codes
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"
Exp
ande
d De
vi
ce
Ty
pe Co
de
De
vice Id
IO
-C
ar
d
Ch
an
nel
Lo
ng
T
ag
Re
gi
st
er
Re
gi
st
er
T
yp
e
Inf
orm
at
io
n C
od
e
Ma
pp
ing C
od
e
4 d
igit
s he
x
6 d
igit
s he
x
int deci
mal
int deci
mal
st
ring[32]
int deci
mal
int deci
mal
int deci
mal
int deci
mal
ma
nd
at
or
y
ma
nd
at
or
y
ma
nd
at
or
y
ma
nd
at
or
y
ma
nd
at
or
y
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 (RegisterType Code = 3)