MilesefFire Safety & Security
Knowledge Base / Overview

eSSL eTimeTrackLite — Internal Knowledge Base

Everything Milesef needs to run the biometric attendance system: fixing the empty-report problem, every common error, full feature usage, and a sorted library of video + blog references.

Why this exists

One place to solve attendance & device problems

eTimeTrackLite is powerful but unintuitive — most "broken" reports trace back to a missing shift, an un-processed log, or a database driver. This guide turns those into 5-minute fixes with step-by-step instructions and verified tutorials, so anyone on the team can resolve it without waiting on support.

10Common issues documented with fixes
9Feature areas with full usage steps
20+Curated video tutorials, sorted
12FAQ entries with solutions

Jump in

Tip: Use the filter box in the sidebar to jump straight to a topic. Each error page links the exact video that demonstrates the fix.
Start Here / The Attendance Issue

Logs download, but the report shows no attendance

The exact problem Milesef hit: both devices reported ~1039 logs downloaded, yet the Monthly Status Report came back mostly Absent / blank for the month.

Root cause in one line

Downloading logs ≠ computing attendance

"Logs Downloaded: 1039/1039" only means punches reached the DeviceLogs table. Marking Present/Absent is a separate computation into AttendanceLogs, and it only runs when punches are processed, every employee has an assigned shift, and device User IDs match the software Emp Codes.

Fix in order

1 · Assign a shift to every employee most likely cause

Without a shift the engine has no IN/OUT window, so it can't decide what counts as Present. A shift assigned for a single day produces the classic "P on day 1, blank after" pattern.

  1. Open Masters → Employees, pick the employee, go to the Shift tab, assign a shift (e.g. General 09:00–18:00), Save.
  2. For everyone at once use Masters → Employee Shift or set a Fixed Shift in Master Settings.
  3. Confirm the schedule covers the whole month, not just one date.
Create Shift & Assign to Employeesyoutube.comWatch ▸ Assign a Fixed Shift to ALL Employeesyoutube.comWatch ▸

2 · Re-calculate / reprocess the punches

Logs downloaded before shifts were set were already skipped. Force a recompute for the date range.

  1. Open Utilities → Re-Calculate Attendance (in some builds under Admin).
  2. Set range 01–30 of the month, all employees, run.
  3. If no such option, re-download logs after shifts are assigned.
  4. Re-open the Monthly Status Report.
View Attendance Logs & Recordsyoutube.com · confirm raw punches existWatch ▸

3 · Check Emp Code mapping (device vs software)

If device User IDs don't match the software Emp Code exactly, punches land as "unknown user" — in DeviceLogs but never linked to a person.

  1. Open Reports → Device Logs for the month.
  2. Punches present but report still blank → mapping issue.
  3. In Masters → Employees confirm each Emp Code matches the device User ID, then re-calculate.
Update Employee Details & Codesyoutube.comWatch ▸

4 · Generate the report

  1. Reports → Monthly Status Report → set month → Generate.
  2. Verify P/A/WO marks populate, then export to Excel/PDF.
Generate Attendance Reports in eSSLyoutube.com · Loxyo TechWatch ▸
Start Here / Triage

60-second triage

Run the Daily Attendance Register / Punch Report for the month first — what you see points straight to the cause.

What you see in Punch ReportWhat it meansGo to
Punches present for all daysProcessing or shift problemSteps 1 & 2 of the Attendance Issue
No punches at allEmp Code / device mapping issueStep 3 of the Attendance Issue
Punches only on day 1Shift assigned for one day, or device clock / duplicate logsStep 1 (roll shift forward)
Can't even open the reportMenu disabled or DB driver error"Menus greyed out" / "ACE.OLEDB" pages
Fastest first move: assign a Fixed Shift to all employees, re-calculate the month, regenerate. That clears the majority of empty-report cases.
Common Issues / Empty report

Logs OK, monthly report blank

The headline issue — fully covered on its own page with ordered fixes and videos.

Common Issues / Device connection

Device won't connect / "Unable to connect"

The software can't reach the biometric terminal, so logs never download. Often shows as Error code -2.

CAUSE

Network, comm key, or unregistered device

"Unable to connect device" · Error code -2 Fix
  1. Ping the device IP from the server PC; confirm both are on the same subnet and the LAN cable/Wi-Fi is live.
  2. In Device Management → Device Details verify the device IP, port (4370) and Comm Key match what's set on the terminal (Menu → Comm → Ethernet / Security).
  3. Temporarily disable Windows Firewall / antivirus to rule out a blocked port.
  4. If everything matches but it still fails, the device serial may be missing from eSSL's registration database — share the serial number with eSSL support to have it registered.
Legacy units (e.g. X990): repeated failures despite correct settings are usually the un-registered-serial case above.
Solve "Unable to Connect Device" — Step by Stepyoutube.com · 2026Watch ▸
Fixing ESSL X990 Connection Error

Real case where the fix was registering the device serial with eSSL backend.

techad.in ↗
Common Issues / Login crash

"Unhandled Exception" on login

Software crashes at the login screen, often citing System.Web 4.0.0.0.

CAUSE

Missing / outdated .NET Framework

Unhandled Exception · Could not load assembly System.Web 4.0.0.0 Fix
  1. Install Microsoft .NET Framework 4.0 (or repair the existing install) and reboot.
  2. Run eTimeTrackLite as Administrator.
  3. If it persists, reinstall from the official eSSL setup rather than an old copy.
Unhandled Exception Login Error — Solvedyoutube.comWatch ▸ Unhandled Exception in Device Management (Class not registered)youtu.beWatch ▸
Common Issues / Database driver

"Microsoft.ACE.OLEDB.12.0 provider not registered"

The software can't open its Access/Excel database because the OLEDB driver is missing or the bitness (32/64) doesn't match.

CAUSE

Missing Microsoft Access Database Engine

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Fix
  1. Install the Microsoft Access Database Engine (AccessDatabaseEngine).
  2. Match the bitness: a 32-bit eTimeTrackLite needs the 32-bit (x86) engine even on 64-bit Windows. Use the /quiet switch if a conflicting Office install blocks it.
  3. Reboot and relaunch.
15 Regular Errors & Solutions (incl. ACE.OLEDB)youtube.comWatch ▸ ACE.OLEDB Fix — Windows 8 / 8.1 / 10youtu.beWatch ▸ ACE.OLEDB Fix — Windows 7 64-bityoutu.beWatch ▸
ACE.OLEDB.12.0 Error Fix — full write-up

Why it happens (32 vs 64-bit) and the exact driver to download.

joypum.com ↗
Common Issues / Read-only DB

"Read-only database" error

Writes fail because the database file or its folder has no write permission, or sits in a protected path.

CAUSE

Permissions / protected install path

Cannot update / Database is read-only Fix
  1. Find the database folder; right-click → Properties → Security and grant the Windows user Full control.
  2. Uncheck the folder's Read-only attribute.
  3. If installed under C:\Program Files, move the DB to a non-protected path (e.g. C:\eSSL\) and re-point the software, or run as Administrator.
Read-only Database Error — Fixyoutu.beWatch ▸
Common Issues / Date error

"Date is not valid" in Device Management

A mismatch between the device's date format and Windows regional settings breaks log download.

CAUSE

Regional date-format mismatch

Date is not valid Fix
  1. Set Windows Control Panel → Region short date to dd-MM-yyyy (or match what the software expects).
  2. Correct the date & time on the device itself (Menu → System → Date/Time).
  3. Restart the software and retry the download.
"Date is not valid" — Device Management Fixyoutube.comWatch ▸
Common Issues / Report viewer

Report viewer / "Microsoft Visual Basic" error

Reports refuse to render, throwing a VB / report-viewer runtime error.

CAUSE

Missing report-viewer / VC++ runtime

Microsoft Visual Basic error · Report viewer failed Fix
  1. Install/repair the Microsoft Report Viewer runtime and Visual C++ Redistributables bundled with the eSSL setup.
  2. Confirm .NET 4.0+ is present (see Unhandled Exception page).
  3. Run as Administrator and regenerate the report.
Microsoft Visual Basic / Report Viewer Error — Fixyoutube.comWatch ▸
Common Issues / Greyed menus

Utilities / Reports menus greyed out

After login, key menus are disabled — usually a user-permission (role) setting, occasionally a corrupted install.

CAUSE

Insufficient role permissions or corrupt files

Fix
  1. Log in as Admin and check Admin → User Management / Role Management; grant the user rights to Utilities & Reports.
  2. If menus are disabled even for Admin, a program file may be missing — reinstall from the official setup (back up the DB first).
Before reinstalling: always run Utilities → Backup Database so attendance history is safe.
Common Issues / Auto-download

Logs not downloading automatically

Manual download works, but punches don't flow in on their own through the day.

CAUSE

Schedule Downloader not configured / service stopped

Fix
  1. Open Device Management → Schedule Downloader and set the interval (e.g. every 30–60 min).
  2. Ensure the eTimeTrackLite background service is running and the PC isn't sleeping.
  3. For push/cloud devices, confirm the device's server IP/domain points to this machine.
Connect Device + Auto Log Download (Web)youtube.comWatch ▸
Common Issues / Duplicate punches

Duplicate or odd punches skewing attendance

Employees punching twice in quick succession create messy IN/OUT pairs and wrong work-hour totals.

CAUSE

"Minimum difference between punches" too low

Fix
  1. In Masters → Master Settings set Minimum difference between two punches (e.g. 1–2 min) so a repeated punch within that window is discarded.
  2. Enable Consider only First and Last Punch if you only need IN/OUT, not every swipe.
  3. Re-calculate attendance for the affected dates.
Shift, Night Shift & Overtime / Punch Settingsyoutube.comWatch ▸
Features / Masters

Masters & Company setup

The foundation: company details, global attendance rules, and users/roles. Configure these before anything else.

Company & users

  • Company Details — name, short name, email, website, address. "Visible to All" controls who sees the company.
  • Role & User Management Admin → Roles / Users — create operators with limited rights (e.g. HR can view reports but not edit shifts).
  • Mail / SMS Settings — optional alerts for new punches or absentees.

Master Settings (the rules engine)

SettingWhat it does
Attendance Year starts onDefines the month/date the attendance cycle begins.
Min. difference between punchesDiscards a repeated punch within X minutes (stops duplicates).
Punch Begin durationMax time allowed before shift start to count as IN.
Grace TimeIgnores late/early by X minutes.
Auto Shift / previous-day shiftWhat to do when an employee has no assigned shift.
Weekly Off 1 & 2Sets weekly off days.
Auto BackupPeriodic DB backup to a path (MS Access DB only).
Features / Employees

Employees

Add staff, keep Emp Codes matched to device IDs, and move users between software and devices.

Add & edit

  1. Masters → Employees → Add — set Emp Code (must match device User ID), name, department, designation, category, employment type.
  2. Assign the default shift on the Shift tab.

Bulk import / export

Use Utilities → Import / Export Employees to load many employees from a template file — far faster than manual entry.

Sync with devices

  • Upload Users — push software employees (and fingerprints/faces) to a device.
  • Download Users — pull users already enrolled on a device into the software.
Add New Employee (software + machine)youtube.comWatch ▸ Import & Export Employees in 3 Stepsyoutube.comWatch ▸
Features / Shifts

Shifts & Calendar

Shifts define the IN/OUT window the engine uses to decide Present, Late, Early, OT. Get this right and reports just work.

ToolUse it for
Shift DetailsCreate a shift: begin/end time, breaks, OT rules, late/early grace.
Shift GroupsBundle multiple shifts for rotating patterns.
Shift Calendar / RosterSchedule which shift applies on which dates (rotation).
Employee ShiftAssign a shift to one or many employees over a date range.
Fixed ShiftOne shift for everyone — disables roster/calendar (simplest setup).
Most common Milesef setup: a single Fixed Shift (e.g. General 09:00–18:00) assigned to all. Quick, and it prevents the empty-report problem.
Create Shift & Assign to Employeesyoutube.comWatch ▸ Assign Employee Shift & Departmentyoutube.comWatch ▸ Night Shift & Overtime Settingsyoutube.comWatch ▸
Features / Leave

Leave types & holidays

Define leave categories and company holidays so the report shows L / H instead of false Absent marks.

  • Leave Types Masters → Leave Types — CL, SL, PL, LWP etc., with quotas.
  • Public Holidays — add the holiday calendar so those days mark as H, not A.
  • Leave Entries — assign leave to one or many employees for a date range (full/half/¾/¼ day).
  • Out Door (OD) Entries — mark official outside-office duty so it isn't counted absent.
Features / Manage Attendance

Manage Attendance

Day-to-day corrections: schedule shifts, enter leave/OD, and fix missing punches by hand.

  • Schedule Shift — assign/adjust shifts for employees over dates.
  • Assign Leave / OD Entries — bulk apply leave or outdoor duty.
  • View Log Records / Add Manual Entry — add a missed punch (needs Direction + Date/Time). You can edit/delete only manually-added logs.
Add a Manual Punchyoutube.comWatch ▸ View Attendance Logs & Recordsyoutube.comWatch ▸
Features / Device Management

Device Management

Everything to do with the biometric terminals: connecting, downloading logs, syncing users, and scheduling.

FunctionPurpose
Device DetailsAdd a device by IP, port (4370), Comm Key; test connection.
Download LogsPull punches from device → DeviceLogs.
Upload / Download UsersSync employees & biometrics between software and devices.
Schedule DownloaderAuto-pull logs at set intervals.
Upload / Delete user on multiple devicesManage one employee across all terminals at once.
Connect Device / Fix Connectionyoutube.comWatch ▸ Connect Device to Web Server + Reportsyoutube.comWatch ▸
Features / Utilities

Utilities & Backup

Housekeeping that keeps the system fast and your data safe.

  • Backup Database — save a copy before any reinstall, upgrade, or big change. Do this regularly.
  • Backup & Clear Old Logs — archive old punches to a .bck file and optionally clear them to keep the DB lean.
  • Restore Old Logs — bring archived punches back from a .bck file.
  • Import / Export Employees — bulk manage staff (see Employees page).
  • Parallel Database — run a secondary DB copy.
Discipline: set Auto Backup in Master Settings and keep a copy off the server PC. A single drive failure otherwise wipes all attendance history.
Features / Re-Calculate

Re-Calculate Attendance

The single most useful "fix-it" button — rebuilds AttendanceLogs from raw punches for a date range.

Use it after you change shifts, fix Emp Codes, add manual punches, enter leave, or whenever the report looks wrong.

  1. Open Utilities → Re-Calculate Attendance.
  2. Set From/To dates; optionally filter by company/department.
  3. Run, then regenerate the report.
Remember: downloading logs does not recompute attendance. This is the step that actually marks P/A/WO.
Features / Reports

Reports & Registers

Where finished attendance turns into something you can file, share, or run payroll from.

ReportShows
Daily AttendancePer-day IN/OUT, late, early, work hours.
Monthly Status / PerformanceThe P/A/WO/L grid for a month (the main HR report).
Yearly AttendanceAnnual summary per employee.
Leave Summary / Leave EntriesLeave taken & balances.
OT RegisterOvertime hours.
Log RecordsRaw punches (best first diagnostic).
Matrix / Graph / MemoVisual summaries & absentee memos.
CSV / Excel / PDF ExportHand off to payroll or archive.
Generate Attendance Reports (Loxyo Tech)youtube.comWatch ▸ Download / Export Report (Hindi)youtube.comWatch ▸ Generate eSSL Report (Web software)youtube.comWatch ▸
Library / Videos

Video library

Every tutorial referenced here, sorted by category. Use the filters to narrow down.

All Setup Shifts Reports Errors
Library / Blogs

Blogs & written guides

Reference articles and the official manual for deeper reading.

Fixing ESSL X990 Connection Error

A real troubleshooting case — the fix was registering the device serial in eSSL's backend.

techad.in ↗
Fix Microsoft.ACE.OLEDB.12.0 Login Error

Why the OLEDB / database driver error occurs and the exact engine to install.

joypum.com ↗
ESSL Device Not Connecting — Step by Step

Device-side menu steps to make the terminal reachable from the software.

jugadtech.com ↗
eTimeTrackLite Overview & Features

Feature summary: shifts, leave, PF/ESI/OT compliance, payroll, self-service portal.

atss.in ↗
Official eTimeTrackLite Desktop Manual (PDF)

The full vendor manual — every menu, setting, and report explained.

etimetracklite.com ↗
Library / FAQ

Frequently asked questions

Quick answers with links to the matching video where useful.

Downloading only fills DeviceLogs. You must assign a shift to every employee, then Utilities → Re-Calculate Attendance for the date range. See the full page under "The Attendance Issue." Shift video ↗
Set a Fixed Shift in Master Settings, or use Masters → Employee Shift and select all. Fixed-shift video ↗
Check IP/port 4370/Comm Key match, ping the device, disable firewall. If still failing, the serial may be unregistered with eSSL — contact support to register it. Connection video ↗
Install the Microsoft Access Database Engine matching the software bitness (usually 32-bit). Fix video ↗
Install/repair .NET Framework 4.0 and run as Administrator. Video ↗
Their shift was assigned for one date. Re-assign the shift across the whole month and re-calculate.
Manage Attendance → View Log Records → Add Manual Entry with Direction (IN/OUT) and Date/Time, then re-calculate. Video ↗
Add Public Holidays and Leave Entries in Masters so those days mark H / L instead of A, then re-calculate.
Install/repair the Report Viewer runtime + VC++ redistributables and .NET 4.0. Video ↗
Configure Device Management → Schedule Downloader and keep the service running / PC awake.
Utilities → Backup Database to a safe path (ideally off the server PC). Also enable Auto Backup in Master Settings.
Set "Minimum difference between two punches" and/or "Consider only First & Last Punch" in Master Settings, then re-calculate.