Analyze an attendance device export
analyze_attendance_fileAnalyze a biometric attendance device export (ZKTeco, Hikvision, Dahua, Anviz, Suprema, FingerTec, Matrix COSEC, eSSL and similar; CSV, Excel or text, English or Arabic headers). Returns, per employee: days present, estimated absent days, late days and missing punches, plus the detected column mapping. Free, no account. Limits: 5 MB per file; the free analyzer allows 3 distinct files per 30 days per network address. An encrypted copy of the file is kept for up to 90 days to improve the analyzer, then deleted automatically; a result summary is kept for 7 days behind an unguessable link. Absent days are estimates for review, not confirmed absences. If the file cannot be read the tool returns isError with the analyzer's refusal reason.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | Worksheet name for multi-sheet Excel files. | |
| country | No | Optional ISO 3166 alpha-2 country code of the company (AE, KW, SA, BH, QA, OM). Used only for coarse usage statistics. | |
| calendar | No | Set only if the analyzer asks to confirm the date calendar. | |
| csv_text | No | The attendance export pasted as CSV/TSV text, header row first. Use this OR content_base64. | |
| filename | No | Original file name with extension (.csv, .xlsx, .xls, .txt, .tsv, .dat). Required with content_base64. | |
| holidays | No | Public-holiday dates (YYYY-MM-DD) to exclude from working days. | |
| shift_end | No | Shift end, HH:mm 24-hour. | |
| shift_start | No | Shift start, HH:mm 24-hour. Lateness is measured against it (10-minute grace). | |
| weekend_days | No | Weekly off days as weekday numbers, Sunday=0 ... Saturday=6 (for example [5,6] for Friday and Saturday). | |
| schedule_mode | No | fixed (default): late after shift_start. flex_window: late after flex_window_end. hours_only: only required hours matter. | |
| content_base64 | No | The attendance export file, base64-encoded. At most 5 MB decoded. Use this OR csv_text. | |
| required_hours | No | Required daily hours for the flex modes. | |
| flex_window_end | No | Latest allowed start time (HH:mm) for flex_window mode. |