check_circle

Matched

Records found

cancel

Unmatched

Device code missing

list_alt

Total Rows

In CSV file

calendar_month

Unique Dates

Date range

people

Employees

Unique codes

help_outline

SmartOffice Export Steps

CSV / Excel

SmartOffice → Import/Export → Export Attendance Logs → Date Range select karo → Excel / CSV format ma export karo.

CSV file ma EmployeeCode (Device Code) and Date, InTime columns hova joie. Niche column names customize karo.

CSV file drag & drop karo ya browser karo → Apply to Attendance click karo.

Device Code ↔ Employee deviceCode match na thay to "Unmatched" list show thashe. Employees page ma deviceCode set karo.

upload_file

Import SmartOffice CSV

📋 CSV Column Names (Match your file)

Employee Code *

Date Column *

In Time

Status Column

cloud_upload

Drop CSV File Here

or click to browse · .csv / .txt supported

storage

SmartOffice SQL Server Direct Connect

Node.js Bridge server → Browser → SQL Server

Disconnected

⚙ One-Time Setup

1. smartoffice-server/ folder copy karo
2. npm install → node server.js run karo
3. DB_CONFIG update karo → Test Connection click karo

Bridge Server URL

Table Name

Date Range

link

Employee Device Code Mapping

0 Employees editEdit Employees

check_circle

Device Code Set

warning

Missing Device Code

Employee Name	Emp ID	Device Code	Department	Designation	Status