Rockwell Automation 9301 Series RSView32 Users Guide - Manual (Page 257)

Configuring activity logging

8–11
Example: Log file name
The activity log file named 971028bi.dbf was created in the year 97,
month 10, and day 28. The b indicates that this is the second file
created that day. The i indicates that this is an activity log file.
Exporting activity log files to ODBC format
Using the command, ActivityLogSendToODBC, you can export
logged activities from dBASE IV (.dbf) format to an ODBC database.
If the table in the database to which you are attempting to export data
is not ODBC–compliant, the export will fail. If an ODBC–compliant
table does not exist, RSView32 will try to create it. RSView32
supports the following ODBC–compliant databases: Microsoft
Access, Sybase
® SQL Server ™ , Oracle ® , and Microsoft SQL Server.
When you export data to an ODBC table, RSView32 keeps track of
the data that was exported in a control file, Activity.exp. This is located
in the log path where the .dbf files are stored. The next time you
export data, only the newest data will be exported. If the control file is
deleted, all the activity log data in the .dbf file will be exported when
you issue the export command.
If you have set up file management to delete the oldest files when a
new set is started, and you are exporting data to an ODBC database,
make sure you export the data before the oldest files are deleted.
Example: Exporting activity log files to ODBC once a day
To export the contents of the activity log files to an ODBC database
once every day, create an event file that specifies when and where to
export the data. ActivityLogSendToODBC exports only the records
added to the activity log files since the last export.