Page History

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

The utility enables the following actions:

1. Expose Migrate the events protocol in 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 module and its reports subsystem.

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

Image Added

Working with the utlity is as followsTo work with the utility, do the following:

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

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

   Image Added

3. Check Set the Create Protocol database box checkbox (4) if you want to create a separate database for the events protocol. By default, the name of the database isAxxon PSIM PSIM_Protocol, however, it can be changed (4).
4. Check Set the Create revers connect box 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).
5. Check Set the Move events to a new database box checkbox (6) if you want to migrate all entries from the old event protocol table to the new database (6).
6. In the Events moving timeout Timeout on movie events (ms) (7), specify the timeout for transferring entries in milliseconds (if the event transfer setting is enabled). (7)

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

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

   
   

8. Set Check the Add WT synonyms in protocol box 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).

   Info
   title Note
   It is recommended to migrate the events to a new database beforehands.

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

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

Image Added