Dump Access Records to Third-Party Database

The access records of specified resources can be dumped as a CSV file or TXT file and the third-party system will read the dumped file (instead of accessing the database and mapping the table fields) for further applications, such as attendance calculation and pay calculation. You can also configure dump rules for dumping access records. After that, the access records will be dumped to the third-party database according to the added rules.

  1. In the top left corner of Home page, select > Basic Management > System.
  2. Select Third-Party Integration > Data Interchange on the left.
  3. Switch on Data Interchange to enable the data interchange function.
  4. Click Add and select the resource(s) for card swiping records synchronization. Set the direction to In, Out, or Null.
    Note:

    • Setting the direction is only available for card readers. For other devices, Null will be displayed no matter what direction is selected.

    • You can click in the Operation column to delete the resource or click Delete All to delete all added resources.

  5. Select the encoding format of data interchange.
  6. Optional: Check Do Not Push Failed Records.

    The failed records will not be pushed to the third-party system.

  7. Select Access Record Dump.
  8. In the Dump Rule area, click Add and set the required parameters.
    Rule Name

    The name of the dump rule.

    Description

    The description of the dump rule.

    Overwrite File

    If it not checked, you re recommended to regularly view the disk capacity in case the new files cannot be generated if the disk if full.

    File Name

    The name of the CSV file or TXT file which the access records are dumped as.

    Storage Location
    Local Storage

    The access records can be dumped as a file saved in the local disk of the SYS server. Then you need to copy this file from the server to your PC with the third-party system installed to read the dumped file.

    Note:

    • You need to log in to the Web Client running on the SYS server to configure related settings of local storage.

    • You need to set Saving Path, which is the path where the CSV file or TXT file is saved.

    SFTP Storage

    You can access the SFTP server as the storage location for saving the dumped file by setting the SFTP address, port, user name, and password. And you can enter the path to save the dumped file in the folder on the SFTP server or leave it empty to save the file in the root directory.

    Note:

    The third-party system should be installed in the SFTP server to read the dumped file.

    Content

    The display items and data in the dumped file.

    Person Group

    The group of persons. You can select and search for departments in the list.

    Min. Length of Person ID

    For some scenarios, the person IDs need to be dumped as a certain fixed length.

    You can switch it on and set the value of Length. If the length of the person ID is shorter than the value, zero(s) will be added before the ID to make it equal to the value. If the length is longer than the value, the person IDs will be dumped according to the actual length.

    Designated Length of Card No.

    For some scenarios, the card numbers need to be dumped as a certain fixed length.

    You can switch it on and set the value of Length. If the length of the card number is shorter than the value, zero(s) will be added before the card number to make it equal to the value. If the length is longer than the value, the card number will be dumped according to the actual length.

    Content Written Format

    For each HikCentral Professional field, you can configure the written format of dumping card swiping records.

    Generate Table Header

    When the card swiping records are dumped from the system to the local PC, the column names will be included in the dumped file and used as the table header.

    File Format

    Two formats are supported, including CSV and TXT.

    Dump Frequency

    The frequency for dumping card swiping records.

    Dump Time

    The time when dumping card swiping records is started.

  9. Click Add.

    The added rules will be listed in the Dump Rule area.

    Note:

    You can click in the Operation column to delete the rule or click Delete All to delete all added rules.

  10. Click Save.