Fingerprint attendance in BYTE: import the punch file, then recompile
A clock device saves its punches to a file. BYTE reads that file, matches each employee number to one person, and writes the punches into the attendance days. It writes only what is new, and it leaves locked months alone.
Last updated: 17 November 2026
What it covers
- A punch file in CSV or text, with any delimiter such as a tab, a comma or a semicolon, in UTF-8 or Windows-1256. An Excel file saved as CSV works, up to 100,000 rows a file.
- The page shows the first rows, and you pick the columns: the employee number, the date and time, and an optional in or out column. Your choice is remembered on that computer.
- Each number is matched to one employee, exactly or by its digits without leading zeros, and only when one employee matches. A number that matches nobody is listed with its row count.
- Punches alternate between in and out by default, so the first punch of the day is in. The file's own in or out column is used only when you choose it.
- A tap within two minutes of the same person's previous tap is a double tap, and it is dropped.
- A punch already on that day is skipped, so importing the same file twice adds nothing.
- Locked months, paid months and months that a payroll run holds are skipped and listed, never unlocked. A date in the future is refused.
- Every import leaves one audit row: who ran it, the file name, the rows read, the punches written, and each skipped count.
- The import writes punches only, and never changes a day's status. A punch on an approved leave day shows a warning.
- After the import, the affected people are recompiled month by month, and the page shows what was written and what was skipped, with a link to the roster.
How it works
- Open Import punches in the HR menu, under time and leave, and choose the file.
- Pick the columns for the employee number, the date and time, and the in or out column if the file has one.
- Read the result: the punches written, the rows skipped and why, and a link to the roster.
- Import a later file when you need to. A punch already on the day is skipped.
A worked example
A file has eight rows from one clock device. The employee number EMP-0042 belongs to one employee. The figures are examples.
| Result | Rows | Why |
|---|---|---|
| Written as punches | 3 | In, out, and in again on the next day |
| Double tap within two minutes | 1 | Dropped |
| Already on that day | 2 | Same time as a punch already on the day |
| Number not matched | 2 | Listed with the row count, and skipped |
| All rows read | 8 | Three written, five skipped |
Importing the same file again writes nothing, because every punch is already on its day. A locked month would be listed and left as it is.
At a glance
Built means the feature is in BYTE's current build. BYTE is coming soon, so ask us for the status of anything you need.
| Area | What BYTE does | Status |
|---|---|---|
| Files | CSV or text, any delimiter, UTF-8 or Windows-1256, up to 100,000 rows | Built |
| Columns | You choose the number, the date and time, and the in or out column | Built |
| Matching numbers | Exact, or the digits without leading zeros, for one person only | Built |
| In and out | Alternating by default; the file's own column only when chosen | Built |
| Repeats | A double tap within two minutes is dropped; a punch already on the day is skipped | Built |
| Locked months | Skipped and listed, never unlocked; future dates refused | Built |
| Audit | One row per import: who, the file name, the rows read and written, and each skipped count | Built |
| After the import | The affected months are recompiled, and the result is shown | Built |
Ask us before you decide
- Ask which clock device you use, and whether it can save its punches to a file.
- Ask who in HR should run the import, and how often.
- Ask which employee numbers your device uses, and whether they match the numbers in BYTE.
Questions about attendance import in BYTE
What is a punch file?
A punch file is the list of clock events a device saves: a person number, a date and time, and sometimes whether it was an in or an out. BYTE reads it from a CSV or text file.
Which file formats does the import read?
CSV or text files with any delimiter, in UTF-8 or Windows-1256. An Excel file saved as CSV works, and a file can hold up to 100,000 rows.
How does BYTE match a number to an employee?
By the employee number: an exact match, or the digits without leading zeros, and only when one employee matches.
What happens if I import the same file twice?
Nothing new is written. A punch already on its day is skipped, and the result shows how many rows were skipped.
Can the import change a locked month?
No. A locked or paid month, or one that a payroll run holds, is skipped, and its rows are listed.
Who can run the import?
A person who may write attendance punches, such as an attendance manager. The import is on the HR menu, under time and leave.