Migrating iFIX Alarms and Events collector

About this task

The following procedure describes how to migrate iFIX Alarms and Events collector data into your Historian database.

Procedure

  1. Locate and double-click the ifixalmmig.exe file in the C:\Program Files (x86)\GE\iFIX\Local directory.
  2. Set up the alarm source options:
    1. From the Options menu, choose Alarm Source. The Alarm Source Options window appears.
    2. Configure the ODBC Login information.
    3. Enter the table name for the database, and select 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. Select OK.
  4. Set up the Alarm Destination options:
    1. From the Options menu, choose Alarm Destination. The Alarm Destination Options window appears.
    2. Configure the Historian Server Options.
    3. Configure the Logfile.
    4. Configure the Time Options.
  5. Select 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. Select OK. The window closes, and migration commences.
    Activity is logged to both the page and the log file configured in the Alarm Destination Options window.
  9. Update the datasource name of your migrated alarms to match collected alarms.