Documentation for ACFA PSIM 1.3.

Previous page Appendix 2. The UpdateDB Utility  Appendix 3. Working with the Remote Protocol Connector utility Next page

Starting the UpdateDB Utility

You can start the UpdateDB Utility by right-clicking the Worktime tab in the Access Manager interface window.

As a result, the UpdateDB Utility window will open.

Working with the UpdateDB Utility

You can work with the UpdateDB Utility as follows:

  1. The Triggers area (1) displays triggers. If necessary, e.g., when upgrading to a newer version of ACFA PSIM, you must update the triggers by clicking the Update Triggers button (2). The progress will be displayed in the area (3). To cancel the action, click the button (4).

  2. To update the database, click the Update DB button (7). Both triggers and stored procedures, required for the correct operation of the subsystem, will be updated. You need to do this once when connecting the Time and Attendance subsystem. The progress will be displayed in the area (3). To cancel the action, click the button (4).

  3. If it is necessary to take into account the passes made before configuring the Time and Attendance subsystem, after starting theTime and Attendance subsystem in Axxon PSIM, re-account the database using the Re-account by Protocol (5) and Re-account by Region Pass (6) buttons. The progress will be displayed in the area (3). To cancel the action, click the button (4).

    Attention!

    It is strongly not recommended to use the re-account buttons without recommendations of AxxonSoft technical support specialists!

    When you click the Re-account by Protocol button (5), the dbo.Region_Enter_Exit table is completely cleared and filled out again depending on the pass information currently contained in the dbo.protocol table. 

    When you click the Re-account by Region Pass button (6), the dbo.Region_Enter_Exit table is completely cleared and filled out again depending on the pass information currently contained in the dbo.Region_pass table.

    Attention! Because of the different depth of the event archive of these tables, there is a risk of data loss when clearing the dbo.Region_Enter_Exit table.


  4. If the update (re-account) succeeds or fails, the corresponding message appears: about success in the first case and failure in the second case:


  5. Click the OK button in the message window.

  6. To close the UpdateDB Utility window, click the button in the top right corner of the form.

Working with the UpdateDB Utility is complete.

Note

By default, only the passes that were made after the installation and configuration of the Time and Attendance subsystem are taken into account.

  • No labels