Attendance-Several swipe data import methods

Source: Internet
Author: User

First, the program supports-.txt format (recommended)
Import data manually by using the "time/swipe data/Punch Data Import Wizard" provided by the program.

The characteristics of this mode is simple does not need too large implementation costs, implementers in the early stage for customers to configure the relevant items, personnel only need to credit card data in the format to import.
The disadvantage is that only the data in the. txt format can be imported, and the data exported by the attendance machine is. exe format and requires manual conversion.

Second, EDI Import

Swipe data import is mainly the employee's swipe data in some way into the Htarf table, and finally participate in attendance calculation. And in the original??? Swipe data htarf table The main fields are Timecardid (time card number) and docdate (date), respectively, they are used to identify the employee's corresponding timecard and the date and time of the card. EDI import is primarily extended to other fields through the Dateinfo description information in the Htarf table. Path: Suite/edi and Barcode/data exchange.
1.txt format
Overview: Note The interpreter mode select "Text Interpreter (time dedicated)".

Column settings: This way the main import description information Dateinfo, and then through the extension to complete the attendance card number and the date of writing.

Many people import time and attendance card data re-operation, you may find that the swipe data does not participate in the operation, you need to check the Htarf table in the data format of several fields is correct.

Extended


2.exe Format Overview: Interpreter mode Select Excel interpreter.


Column settings: This is the main import time card number and date. If you want to import only the description information Dateinfo, and then obtain the time card number and date by extension, refer to the above. txt format.

An example of the swipe data in Excel is as follows:

Note, the machine number is mainly used for the existence of multi-time attendance machine, the difference between clock-in data use, if there is no such situation, can be ignored.

Third, timing data exchange

Automatic import of swipe data via "Management/system services/Timed data exchange".
1. Define the EDI template in the "Suite/edi and barcode/data Exchange", see also;
2. Set the automatic execution cycle in the Management/Timer service/Timing data exchange.

Description
1. The source folder is the folder that is stored by the absence data of the system that is not imported, and the format of the file must be the same as defined in the data Exchange template; Dump folder is the path to the document transfer or dump after the attendance data is successfully imported.
2. After the timed data exchange is started, the import is performed automatically if a document exists in the source folder within the start end time range.

Attendance-Several swipe data import methods

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.