Yamuna Nagar Attendance System

Centre-wise Attendance

Select a date range. Download requires the Report Download PIN. The CSV contains each attendee's actual centre plus Main Centre, date/time, counter, operator and entry method.

Preview

Centre Management

You can rename centres, change Main/Attached status, change the parent Main Centre, and change display order. If KHADRI is under BHERTHAL today, simply edit its parent to JAGADHRI tomorrow. Attendance history remains unchanged.

Upload Master CSV

Upload your full CSV whenever you want. Badge No is the unique key. Existing people with the same Badge No are updated; new people are added. Attendance history is not deleted.

Expected columns

Centre names must match the Centre Management names. Unknown centre names are imported but flagged so you can fix them.

Important

Before a live event, take a database backup and test scanning at all 6–8 counters. For true multi-counter live use, deploy this PHP/MySQL version on a server with reliable local internet/Wi-Fi. The next production enhancement can add offline sync if your venue connection is unreliable.

Import Attendance by Badge Number

Use this when attendance is collected in another system/device and you receive a CSV containing Badge Numbers. You MUST select the attendance date before importing.

CSV format

One Badge Number per row. Do not include names or centres in this file. The system finds each Badge No in the master People database and marks that person present for the selected date.

Duplicate Badge Numbers: ignored. Unknown Badge Numbers: not imported and reported. Previous dates: never overwritten.

Recommended Workflow

1. Select the exact attendance date.
2. Download the template if you need it.
3. Put the Badge Numbers in the CSV under the Badge No column.
4. Upload the CSV.
5. Review the import summary before continuing.
6. Open Dashboard/Report for the selected date to verify centre-wise totals.

📘 Feature Guide & Documentation

This portal includes the main operating instructions so staff can use the system without referring to a separate manual.

1. Master People CSV

Upload the complete people list from CSV Import. Badge No is the unique key. Existing Badge Numbers are updated; new Badge Numbers are added.

2. Centre Management

Use Centre Management to rename centres, change Main/Attached status, change the parent Main Centre, and change display order. You can move an attached centre from one Main Centre to another at any time.

3. Live Attendance

Use Attendance for live QR/barcode scanning. If a code does not work, type the Badge No and use Manual Entry. Duplicate attendance for the same person on the same date is blocked.

4. Attendance File Import

Use Attendance File Import when you have a CSV containing Badge Numbers. Select the date first, then upload the file. Only the Badge No column is required.

5. Centre Mapping Template

This template can be used to maintain your Main Centre → Attached Centre mapping outside the portal before entering changes into Centre Management.

6. Reports

Dashboard can be filtered by date. Report downloads use From Date and To Date and require the Report Download PIN. Downloads contain the selected date range and follow your current Main/Attached Centre hierarchy.

7. Security

Centre Management is separately PIN protected. Report downloads are separately PIN protected. Keep these PINs with authorized management staff only. The Admin PIN can be used for master CSV and attendance file imports.

8. Important Rules

• Badge No must be unique.
• Always verify the date before importing attendance.
• Take a database backup before major imports or event days.
• Use HTTPS on the live server.
• Test all counters before the event.

9. Installation / Upgrade

See README.txt and upgrade_attendance_import.sql included with the system package.