Serial NO :S00315018-EN
Date of Editing : 2023-03-02
Questions : How to export Time Attendance data with single record or two records desperately?
Solution:
701ClientSQL is capable of Time Attendance Data Export Function, 3th party cross-system integration could get transaction log file in specified folder, this document will show you how to export only first and last records in single message or two messages desperately:
In normal setting, the transaction logs will be exported in order by time, listing all transaction logs during assigned interval, and export detail is according to [Item Order]
While selecting [Transfer after Sorting], the transaction logs will be exported in order by user address and only list first and last records desperately, rather than all of card presentation records.
In the setting of [Item Order], first and last records will be two records when [Time] is assigned as the last of parameter items; first and last records will be one single record when [Time] is assigned in the middle of parameter items.
STEP1. 701ClientSQL > [Tools] > [Time Attendance Export Format]
STEP2. Setting export format
(1) Single Record
It is required to tick up [Transfer after Sorting] function firstly, and set [Time] as the last item.
(2) Two Records
This function also required to tick up [Transfer after Sorting] function, and set [Time] in the middle of export item.
STEP3. Select [Save Parameter] > [Transfer Now], and the file will be transfer to specified path.