THIS PROJECT HAS BEEN MOVED HERE.
An attendance logging/tracking app for schools.
- MySQL
- Python 3.6+
- MySQL Workbench (optional)
- A Working Camera
- Run the following queries in the MySQL prompt:
CREATE DATABASE IF NOT EXISTS `visitorwiz`;
CREATE TABLE IF NOT EXISTS `visitorwiz`.`attendance` (
`ID` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`face` LONGBLOB NOT NULL,
`date` DATE NOT NULL,
`status` VARCHAR(255) NOT NULL,
`attendanceTime` VARCHAR(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `visitorwiz`.`attendance_old` LIKE `visitorwiz`.`attendance`;
- Save the students' faces as JPG images in a new
tests
folder in the project root.
source .venv/bin/activate
python main.py
.venv\bin\activate.bat
python main.py
- It may take a while for the program to set up.
- When the setting up is complete, A window with the camera will open.
- When your face is recognized, the name of the student will be displayed.
- Some details like date, attendance time, etc. will be saved in the database.
- To exit the program, press
q
. - The data will be stored in a database called
visitorwiz
. It it recommended to access the database with a tool like MySQL Workbench.
- The database is called
visitorwiz
.- There is a table in it, called
attendance
.- All the attendance of the current day will be stored in this table.
- The table has the following columns:
ID
: The primary key.name
: The name of the student.face
: The face of the student.date
: The date of the attendance.status
: The status of the student.attendanceTime
: The time of the attendance.
- Another table, called
attendance_old
, is used as a log for the previous days attendance (and attendance that is marked before that).- It has a similar structure to the
attendance
table.
- It has a similar structure to the
- There is a table in it, called