Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Attendance: daily register, alerts, devices and check-in/Lesson 9

    Import a punch log CSV

    For terminals that only export a log file (eSSL eTimeTrack, Matrix, Realtime): preview the CSV, then import it against a device so the punches are processed like live ones.

    Open /attendance/devices/importRecording script
    5 min3 stepsOwner, Admin, PrincipalDemo: sign in as Owner

    Before you start

    Finish first: Map device user ids to people and resolve unmatched punches

    • A device exists to import against (create one such as "eSSL export" if the terminal is not connected).
    • The export saved as CSV (Excel files must be saved as CSV first).

    Steps

    0 of 3 done
    1. You should see: Two cards: 1. File (with Device, CSV file and …or paste) and 2. Preview & import. The description says "CSV only — save Excel exports as CSV."

      Open /attendance/devices/import
    2. You should see: The preview card reads "N punches detected in <file> · columns: user = Emp Code, time = Punch Time, status = Status" and shows the first eight rows with User id, Local time and Direction. Lines that could not be read are listed under "N lines skipped".

      Column headers are matched loosely: UserID / PIN / Emp Code / Enroll No / Card No for the id; DateTime / Punch Time, or separate Date and Time columns; Status / Direction for in/out.

    3. You should see: An alert "Imported: N new punches · M marked · K already known" followed by duplicates, outside-window and unmatched counts, with "resolve them under Unmatched" when needed.

    What you have now

    • The log file's punches are in the register, with any unknown ids waiting under Unmatched.

    If something goes wrong

    "Add a device first" empty state
    Create a device under the Devices tab; imports are stored against a device so its mappings apply.
    "No punches found in the file."
    The header row was not recognised. Rename the columns to Emp Code, Punch Time and Status, or split into Date and Time.
    Times are off by hours
    The device's Timezone is used to read the file. Set it to match the software that produced the export.

    Related guides

    • Map device user ids to people and resolve unmatched punches
    • Marking rules and the auto-absent sweep
    Map device user ids to people and resolve unmatched punchesNext: Marking rules and the auto-absent sweep