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

6–32

RSView32 User’s Guide
Example: Log file name
The log file named 19971028bl.dbf was created in the year 1997,
month 10, and day 28. The b indicates that this is the second file
created that day. The l indicates that this is an alarm log file.
Exporting alarm log files to ODBC format
Using the command, AlarmLogSendToODBC, you can export logged
alarms from their native 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, Alarm.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 alarm 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 alarm log files to ODBC once a day
To export the contents of the alarm log files to an ODBC database
once every day, create an event file that specifies when and where to
export the data. AlarmLogSendToODBC exports only the records
added to the alarm log files since the last export.