Bulk Excel Attendance Importer for Odoo 19 – Excel and CSV, Checked Before Import, One-Click Undo
Import attendance from Excel or CSV in four steps: upload, map the columns, check every row, import. Night shifts, time zones, Arabic digits, and a one-click undo of the whole import.
From a spreadsheet to attendance records in four steps
Time clocks, fingerprint devices and spreadsheets all give you the same thing: a list of who came in and when they left. Typing it into Odoo one line at a time takes hours and is full of typos.
Bulk Excel Attendance Importer turns the file into attendance records in four steps: upload, map the columns, check every row, import. Nothing is created until every row has been checked.
Checked row by row
Every row gets a status: Ready, Already in Odoo or Error with the reason
Unknown or ambiguous employees, unreadable dates, check-out before check-in, more than 24 hours, overlaps with Odoo and inside the file
Errors first, in red. Go back, change the columns, check again as often as you like
Importing the same file twice does no harm: identical attendances are skipped
Real files, real problems
xlsx, xls and csv, any sheet, any header row, Arabic CSV encodings (Windows-1256, UTF-16)
Find employees by Badge ID, identification number, work email, name or Odoo ID
Date and time in one column, or separate date and time columns
Night shifts, time zones, daylight-saving changes, day-first or month-first dates
Arabic-Indic digits and Arabic AM/PM, Excel serial dates, times written as 8:05 or 8.05 PM
One-click undo
Every import is kept as a batch. Imported the wrong file? Undo this import removes exactly the attendances it created. The rows that failed come as an Excel file so you correct only those.
Safe and documented
Only attendance administrators can import. Existing attendances are never changed. Illustrated documentation in English and Arabic, an Arabic translation of the module and 33 automated tests.
What's included
taqnix_attendance_import.zip: the Odoo 19 module (with Arabic translation)
Illustrated documentation in English and Arabic (HTML and PDF)
Automated tests, licence file (OPL-1) and changelog
Requirements
Odoo 19.0 with the Attendances app.
What's in the download
The files in the archive you can download after you buy.
Four-step wizard: upload, map columns, check every row, import
Excel (.xlsx, .xls) and CSV including Arabic encodings, any sheet and header row
Employees found by badge ID, identification number, work email, name or Odoo ID
Night shifts, time zones, Arabic digits and AM/PM, Excel serial dates, separate date and time columns
Overlap detection against Odoo and inside the file, batches with one-click undo, error file, Arabic translation, automated tests
Frequently asked questions
Which files can I import?+
Excel .xlsx and .xls, and CSV (comma, semicolon or tab separated; UTF-8, UTF-16 and Arabic Windows-1256). Choose the sheet and the header row.
Is anything created before I confirm?+
No. Step 3 shows every row with its status. Attendances are created only when you press Import the ready rows.
How are employees found?+
By Badge ID, identification number, work email, name or Odoo ID, as you choose. If two employees share the value, the row is refused with a message instead of guessing.
What about night shifts and time zones?+
A check-out earlier than the check-in means the next day (you can turn this off). You choose the time zone of the file; the module converts to UTC and handles daylight-saving changes.
Can I undo an import?+
Yes. Every import is a batch; Undo this import deletes exactly the attendances it created.
What happens to rows with errors?+
They are not imported. You can download them as an Excel file with the reason for each, correct them and import again.
Will it duplicate attendances if I import the same file twice?+
No. Identical attendances are skipped as “Already in Odoo” and overlapping ones are reported.
Does it support Arabic?+
Yes. Arabic digits and Arabic AM/PM are understood, Arabic CSV files can be read, and the module ships an Arabic translation and Arabic documentation.
More from TAQNIX
ModuleNew
Customer Outstanding Balances Widget for Odoo 19 – Overdue Amount Banner on the Sales Order, Both Directions
See what a customer owes you, what is overdue and what you owe them, in a banner at the top of the sales order. Red when the delay is serious. Live from your accounting, Arabic included.
Digital File Sales & Secure Token Downloader for Odoo 19 – Personal Time-Limited Links with Download Counter
Sell PDFs, templates and any file from Odoo. When the sales order is confirmed the customer gets a personal download link by email, valid for N days and N downloads, with a full download log.
Advanced POS Receipt & Invoice Customizer for Odoo 19 – 5 Styles Each, Amount in Words, Barcode
Choose the look of your invoices, quotations and Point of Sale receipts in the company settings: five styles each, accent colour, amount in words (Arabic too), signature boxes, order barcode and small print.
IP Address & Time-Based Login Restrictions for Odoo 19 – Office-Only Sign-In and Working Hours
Let people sign in only from your office or VPN addresses and only at working hours, per user or user group. Covers the login page, the API and open sessions, with a lock-out guard and an off switch.
Customer Outstanding Balances Widget for Odoo 19 – Overdue Amount Banner on the Sales Order, Both Directions
See what a customer owes you, what is overdue and what you owe them, in a banner at the top of the sales order. Red when the delay is serious. Live from your accounting, Arabic included.
Digital File Sales & Secure Token Downloader for Odoo 19 – Personal Time-Limited Links with Download Counter
Sell PDFs, templates and any file from Odoo. When the sales order is confirmed the customer gets a personal download link by email, valid for N days and N downloads, with a full download log.
Advanced POS Receipt & Invoice Customizer for Odoo 19 – 5 Styles Each, Amount in Words, Barcode
Choose the look of your invoices, quotations and Point of Sale receipts in the company settings: five styles each, accent colour, amount in words (Arabic too), signature boxes, order barcode and small print.
IP Address & Time-Based Login Restrictions for Odoo 19 – Office-Only Sign-In and Working Hours
Let people sign in only from your office or VPN addresses and only at working hours, per user or user group. Covers the login page, the API and open sessions, with a lock-out guard and an off switch.