SOYAL TECHNOLOGY CO., LTD

Membership Center
0
Browsing Records
How to export Time Attendance data with single record or two records desperately?
2021-01-19
No. S00315018-EN

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.

Related Tag
Browsing Records
Go Top