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
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.