beautypg.com

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

Page 583

background image

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