Dump Access Records to Third-Party Database

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 database and mapping the table fields) for further applications, such as attendance calculation and pay calculation.

  1. Click System > Advanced > Data Interchange to enter the Data Interchange page.
  2. Set Data Synchronization switch to on to enable synchronization function.
  3. Click Add and select the resource(s) for card swiping records synchronization.
    Note:

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

  4. Select Access Record Dump.
  5. Set the required parameters.
    File Name

    The name of 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 and saved in local disk of 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 into the Web Client running on 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 SFTP server as the storage location for saving dumped file by setting SFTP address, port, user name, and password. And you can enter the path to save the dumped file in the folder on SFTP server or leave it empty to save that in 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.

    Min. Length of Person ID

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

    You can set the switch to on and set the value of Length. If the length of person ID is short 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.

    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.

  6. Click Save.

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 database and mapping the table fields) for further applications, such as attendance calculation and pay calculation.

  1. Click System > Advanced > Data Interchange to enter the Data Interchange page.
  2. Set Data Synchronization switch to on to enable synchronization function.
  3. Click Add and select the resource(s) for card swiping records synchronization.
    Note:

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

  4. Select Access Record Dump.
  5. Set the required parameters.
    File Name

    The name of 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 and saved in local disk of 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 into the Web Client running on 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 SFTP server as the storage location for saving dumped file by setting SFTP address, port, user name, and password. And you can enter the path to save the dumped file in the folder on SFTP server or leave it empty to save that in 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.

    Min. Length of Person ID

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

    You can set the switch to on and set the value of Length. If the length of person ID is short 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.

    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.

  6. Click Save.