Xylem CHATTER Notification System configuration guide - Manual (Page 48)

MANUAL
GB CHATTER NOTIFICATION CONFIGURATION 1303
48
Spredsheet for object names
General
As it is rather difficult to type all this information directly into the table in the database by hand, the data can be
imported to the table. The data for this table starts as a Microsoft Excel spreadsheet. MJK Automation ApS supplies a
pre-formatted Microsoft Excel spreadsheet in Microsoft Excel 2003 format. You can find the spreadsheet here:
CNS\Server2008R2\ScadaObjects
cnsSCADAobjects.xls
The supplied spreadsheet contains sample data which are NOT intended for
practical use. Be sure to delete the content of rows 2 to 32 before exporting data
from the spreadsheet!
Each row contain the data needed for one object in an SCADA-system. The spreadsheet columns contains data as
described below.
Columns in the spreadsheet
Column Description
Column A This column must exist but it also must also contain no data. It acts as a
Column B This column contains the names of the objects or tags in a SCADA-system. A
guide to establishing a consistent naming scheme is
here .
Column C - IGSS only This column contains the name of the area in 7-Technologies IGSS32 on which
The column may be left blank if you don't use <%IGSS%
Column D - IGSS only This column contains information about the data types supplied to the object in 7-
Technologies IGSS32. Three different data types are available:
Value Description
VALUE Use this if the object in 7-Technologies IGSS32 will
receive a number, ie a measurement value. Modbus-,
Logger will deliver data of the data type VALUE
STATE Use this if the object in 7-Technologies IGSS32 will
receive a digital value. Digital inputs in a MJK
STATE
STRING Use this if the object in 7-Technologies IGSS32 will
receive a text string. Data elements as
LOGTIME
will deliver data of the data type STRING
The column may be left blank if you don't use 7-Technologies IGSS32.
Column E This column contains the ID for the plug-in which delivers data to this object Two
different plug-in's will deliver data to a SCADA-system:
Value Description
1 Data will be coming from the SCADA plug-in
2 Data will be coming from the STORMFLOW plug-in
Column F
data to this object.
39
39