Creating data log models, Creating data log models – 5 – Rockwell Automation FactoryTalk View Site Edition Users Guide User Manual
Page 583

22
•
S
ETTING
UP
DATA
LOGGING
22–5
•
•
•
• •
22
•
Pla
ceho
lde
r
Format for ODBC tag table
Creating data log models
In the Data Log Models editor, you can create data log models that specify:
Which log file format to use.
Where to store data log file sets (primary or secondary paths).
When to create and delete log files.
Which actions will trigger logging.
Which tag values will be logged.
Status
Blank if communications are working properly.
E if a communication error occurred while
FactoryTalk View was trying to acquire the tag
value.
S if the tag value is stale; that is, if the value has
been acquired before, but has not been updated.
U if the tag is uninitialized.
SQL_VARCHAR, or
SQL_CHAR
1
Marker
Internal tag marker.
SQL_VARCHAR, or
SQL_CHAR
This column
Contains
SQL data type
Length
TagName
The tag name.
SQL_VARCHAR, or
SQL_CHAR
255
TagIndex
The index number assigned to the tag name.
SQL_SMALLINT, or
SQL_INTEGER
2 or
4
TagType
The tag type:
2 for Analog tag
3 for Digital tag
4 for String tag
SQL_SMALLINT
1
TagDataType
The tag data type:
-1 for Integer
0 for Long
1 for Float
2 for String
SQL_SMALLINT
2
This column
Contains
SQL data type
Length