Documentation for ACFA PSIM 1.3.

Previous page Starting and working with the UpdateDB Utility  Appendix 1. Description of the Access Manager interfaces Next page

The Remote Protocol Connector utility is used to improve the system performance by optimizing the work with the database when generating general and Worktime reports by event protocol, both in the Time and Attendance subsystem and in the Axxon PSIM WEB Report System.

The utility enables the following actions:

  1. Migrate the events protocol into a separate database.
  2. Create a protocol database.
  3. Transfer data from the old protocol table to a new one in a separate database.
  4. Delete the old protocol table.
  5. Create synonyms for a new protocol database, which will enable the work of the Time and Attendance subsystem.

The utility is located in the /Axxon PSIM/ Tools folder.

Attention!

Before starting to work with the utility, Axxon PSIM must be shut down.

To work with the utility, do the following:

  1. In the Database connection string field (1), specify the path to the Axxon PSIM database.

  2. In the Protocol connection string field (2), specify the path to the events protocol table.
    The Config button (3) for both fields enables automatic generation of connection strings to the database and to the protocol table. When you click the button, the connection settings window opens, where you can select the server name and the name of the database or table.

  3. Set the Create Protocol database checkbox (4) if you want to create a separate database for the events protocol. By default, the name of the database is PSIM_Protocol, however, it can be changed.
  4. Set the Make revers connect checkbox (5) if you want to keep the old event protocol table, but associate it with the new database that will be created by the utility.
  5. Set the Move events to a new database checkbox (6) if you want to migrate all entries from the old event protocol table to the new database.
  6. In the Timeout on movie events (ms) (7), specify the timeout for transferring entries in milliseconds (if the event transfer setting is enabled).

  7. Set the Delete old protocol checkbox (8) if you do not want to save the old event table.

    Note

    It is recommended to migrate the events to a new database beforehand.

  8. Set the Add WT synonyms in protocol checkbox (9) if you want to transfer the links of the old event protocol table to the other Time and Attendance tables to the new database.

  9. Click the Start button (10) to run the utility.

The migration progress and possible errors will be displayed in the field below the settings panel.

  • No labels