beautypg.com

Retrieving tag names from data log files, Bringing logged dbase iv data into microsoft excel, Retrieving tag names from data log files -4 – Rockwell Automation 9301 Series RSView32 Users Guide User Manual

Page 566

background image

16–4

RSView32 User’s Guide

Retrieving tag names from data log files

For data log models, RSView32 often uses an index file or table for tag
names. The file or table contains a list of all the tags used in the model,
together with an index number for each tag. Other data log files or
tables use the index number rather than the full tag name.

When retrieving information from data log files, you will likely want
the tag names—not the tag index. Therefore, you may have to retrieve
data from more than one file or table. To do this, you have to join the
tables. For information about joining tables, see “Joining tables and
selecting data” on page 16-22.

Bringing logged dBASE IV data into Microsoft Excel

Use the following procedure to bring the information from
dBASE IV log files into Microsoft Excel.

123

1.

Open Microsoft Excel.

45

2.

On the File menu, click Open.

3.

In the List Files of Type field, click dBase Files (*.dbf).

This storage

format

Stores tag information in this file or table

dBASE IV with
short file names

YYMMDDnt.dbf, where the t indicates this is the tag name file.

This file is used for the wide .dbf storage format only if tag names are greater
than 10 characters long.

dBASE IV with
long file names

YYYY MM DD NNNN <Log File Identifier String> Tagname.dbf

This file is used for the wide .dbf storage format only if tag names are greater
than 10 characters long.

ODBC

TagTable

This is the default name for the table. You can change the name. Use of this
table is optional. If this table isn’t used, RSView32 stores the full tag name in
the FloatTable or StringTable.