Migrating iFIX Alarms and Events

About this task

The following procedure describes how to migrate iFIX alarm and event data into your Historian database.

Procedure

  1. Locate and double-click the ifixalmmig.exe file in the C:\Dynamics directory.
  2. Set up the alarm source options:
    1. From the Options menu, choose Alarm Source. The Alarm Source Options dialog box appears.
    2. Configure the ODBC Login information.
    3. Enter the table name for the database, and click on Fetch Columns.
      The table's associated columns appear in the SQL Column Name and iFIX Field Name table. For more information, refer to the Database Configuration .
    4. Configure Severity Mapping.
  3. Click OK.
  4. Set up the Alarm Destination options:
    1. From the Options menu, choose Alarm Destination. The Alarm Destination Options dialog box appears.
    2. Configure the Historian Server Options.
    3. Configure the Logfile.
    4. Configure the Time Options.
  5. Click OK.
  6. From the File menu, choose Migrate Alarms.
  7. Select a start and end time for the alarm migration.
    Note: If the ODBC driver does not support the CAST function, It is recommended that you create the DATETIME data type filed in your Alarm ODBC table and update the field by combining The ALM_DATELAST and the ALM_TIMELAST using a concatenation and cast or convert function. If the data source does not include a native time, the start and end times will be disabled, and the entire table will be queried. This may result in an "out of resources" state.

    See your Alarm ODBC backend Data Base documentation for more information.

  8. Click OK. The dialog box closes, and migration commences.
    Activity is logged to both the screen and the log file configured in the Alarm Destination Options dialog box.
  9. Update the datasource name of your migrated alarms to match collected alarms.