Introduction: Attendance System Using Raspberry Pi and NFC Tag Reader

Picture of Attendance System Using Raspberry Pi and NFC Tag Reader

With my new toy Raspberry pi I've done several testing projects from
instructables, adafruit etc. But after a while it became boring and I've started looking for something actually useful for me. My previous playground was my new phone several weeks ago which came with new feature NFC reading. Thought and thought together gave me idea for attendance system for our small (family) company using NFC tags. The additional kick was my interest in those systems before, but discovering the cheapest are for around $750 I decided it is too much for such small company as 6 employees.
As I don't have any experience with "mature" attendance systems, I've decided only to implement basic features. These consist of logging incoming people, outcoming people, start and end of a break and deleting last inserted action (in case of mistype during logging).
All these actions are logged into local MySQL database from where I can display it and manipulate with my front-end application. Because the SD card is not such safe data medium, especially when loosing power unexpectedly, I'm uploading all data daily to my local server, where I keep backup in case of corruption of the SD card.
During normal operation of the logging station, display shows current date and time and calls for action selection. When you choose appropriate action on the keyboard, display shows selected action and calls for attaching the TAG to the reader. Also the LED under display also turns on.
When the TAG is read, the LED turns off and beep signal comes out the speaker. For a brief moment display shows action and name of the owner of the card. Then everything returns to the default state waiting for another entrance.

For foot notice, this whole project including source codes is licensed under Beer-ware licence as follows:

Jakub Dvorak wrote this file. As long as you retain this notice you can do whatever you want with this stuff. If we meet some day, and you think this stuff is worth it, you can buy me a beer in return.

Step 1: Materials List

Picture of Materials List
Everything you need for this project can be bought on E-Bay or in many Chinese e-shops like dealextreme etc.
For this project you'll need following items:
  1. Raspberry Pi model B
  2. 16x2 display
  3. Mifare RFID Reader
  4. USB numeric keypad
  5. LED diode holder
  6. Red LED diode
  7. Active 3V buzzer
  8. Small breadboard and various F-F and M-F jumper cables
  9. Box
  10. Various screws and/or glue gun, LED resistor, display 10k potentiometer

I recommend Raspberry Pi model B, because of the integrated LAN and two USB ports. That way you can use either LAN+USB keyboard or USB keyboard and USB WiFi dongle.

You can use any display, but I used HD44780 (the same display as found on adafruit), because it has well documented usage and uses only few pins from Raspberry.

I've chosen 13.56 MHz RFID reader and tags, because I've already got few tags with this technology from my experimenting with my cellphone. I've also found good How To (http://fuenteabierta.teubi.co/2013/07/utilizando-el-lector-nfc-rc522-en-la.html) and with a little help of Google translator modified given source to my needs.

Any numeric keypad can be used. Those with high buttons might be better due to thickness of the box. For installation just remove any extra buttons with small knife or screwdriver.

LED and LED holder are pure extra which are not needed for the device to be operational, but are good as extra indicator of actions.

The same is with the buzzer. I felt such a device should have it's own voice for letting people know it is working.

Breadboard and jumpers are for interconnection between each device because several pins (3.3V, GND,...) are used for more than one part. You can of course use soldered board, but I wanted to be able to replace each part easily and just glued it together with glue gun.

You'll also need few screws and/or glue gun for attaching all the pieces together. For LED you'll need small resistor. For my red LED I've used 68 ohm one which should limit current to around 19 mA. Depending on your LED you can calculate value for the resistor for example on this address. Maximum GPIO current is discussed on several forums but I wouldn't go over 20mA. Potentiometer is for contrast adjustment of the display.

Step 2: Wiring It Together

Picture of Wiring It Together

On the picture from Fritzing above you can see connections between each element. You can find the fzz file as download link down the page.

For troubleshooting of display connection you can refer to nice manual on adafruit website.

Connection is pretty straightforward so there shouldn't be any trouble.

I've cut holes in the lid of the box for display, LED and keypad, NFC reader remains under the lid for safety and it has strong enough signal to read tags through the plastic.

I used glue gun for the alignments in the box and it holds every component firm enough. And after testing even the wires are glued to the connectors to prevent accidental disconnecting during operation.

Also don't forget to drill holes for power and network cable (or just one hole, if you use WiFi dongle or PoE).

As final touch, mark spot on the outside of the lid where NFC reader is for easier reading.

Step 3: The Software

The software for this project is mixed from several tutorials and HOWTOs so there might be some leftovers from that, but it works for the time being and I might will fix that later (AKA never ;) )

First of all you need default Raspbian image installed on your raspberry (LINK and HowTo).

After that we need few adjustments to enable correct function:
First of all we install files needed by the NFC reader as follows on previously mentioned page (http://fuenteabierta.teubi.co/2013/07/utilizando-el-lector-nfc-rc522-en-la.html)
1. Enable SPI device by editing file /etc/modprobe.d/raspi-blacklist.conf and comment the line blacklist spi-bcm2708 so it will read as follows:
# blacklist spi and i2c by default (many users don't need them)
# blacklist spi-bcm2708
blacklist i2c-bcm2708
2. Then download SPI-Py package to enable SPI communication for Python
git clone  https://github.com/lthiery/SPI-Py
and install it via
sudo python setup.py install

If you are missing python-dev and the setup script exits with error, install the package first

sudo apt-get install python-dev

We will also need the MFRC522 package from https://github.com/mxgxw/MFRC522-python but I had to edit it a little bit, so it's already in the source folder of this project.


The last think to get it work is installing GPIO for Python (if you wish, update the number in package version to the newest one):
wget https://pypi.python.org/packages/source/R/RPi.GPIO-0.5.4.tar.gz
tar zxf RPi.GPIO-0.5.4.tar.gz cd RPi.GPIO-0.5.4 sudo python setup.py install

After that we can download the source code for this project
git clone  https://github.com/Yimbo/attendance
Create table in your MySQL Database and upload structure to that database from file mysql.sql.
Next update file mysql.py according to your settings (server, username, password and database name).

After this step you should be able to run the program:
sudo python attendance.py

Step 4: Automatization

Now you should have fully functioning system for reading NFC tags and storing information about them in MySQL database.
For daily usage your should be ready to accept power failures, data errors etc. To avoid power failures you can use UPS, but your raspberry might still get rebooted from time to time. Also you want to use the integrated keyboard instead of the keyboard from console where you run program from.
First of all change your attendance file attributes so it can run without external calling python:
chmod +x attendance.py
In next step enable autologin on TTY1. This will automatically login your first console after reboot as root.
First install mingetty:
apt-get install mingetty
Then edit the file /etc/inittab and find line
1:2345:respawn:/sbin/getty --noclear 38400 tty1
and update it to:
1:2345:respawn:/sbin/mingetty --autologin root --noclear tty1
Then you need NumLock activated everytime system logs onto console tty1, so create file leds.sh with following content (note it probably won't affect the actual LEDs on the keypad, but it will turn Numlock ON anyway):
setleds -D +num < /dev/tty1
and change its permissions to executable:
chmod +x leds.sh
Then you want to create watchdog for your python script so even if it crashes, this watchdog will start it again. Go to your home directory and create file runattendance.sh with following text:
while [ 1=1 ];
do if [ ! "$(pgrep attendance.py)" ]; then /root/leds.sh && cd /root/Attendance/ && /root/Attendance/attendance.py fi sleep 10 done
and change it's permissions to be executable the same way as before.

After that go to your root home folder (/root/) and update file .bash_profile and add following line:
[[ $(tty) == '/dev/tty1' ]] && /root/runattendance.sh
This will run runattendance.sh every time system logs into first console (which is now automatically after booting).

If you finished all those steps, you can now reboot your raspberry and after successful boot, display should light and attendance system should work.

Comments

JayE42 (author)2017-09-18

May I ask how to solve importerror: No Module named onScreen? Please? Looking forward for your response. Thank you

vince0314 made it! (author)2015-04-28

Hi.. i had connect the RPi_rev2(pins40) with RFID-RC522 module...there are a few error during run the attendance.py..the errors as the attachment ...

pepijnn1 (author)vince03142017-06-06

i has the same problem.

how has you fixed it?

GavinD24 (author)pepijnn12017-08-08

was this error ever fixed

rudolfpi (author)2015-09-09

This Instructable is incomplete. A lot of steps are not mentioned by the author.

awesomegamer235 (author)rudolfpi2016-12-06

I guess it's time to use my brain lol?

awesomegamer235 (author)2016-12-06

can this be done with the pi 3 as well?

PaulS417 (author)2016-08-07

Hi, can you do this with fingerprint scanner too?

NicolásG32 (author)2016-01-28

Hello, how did you program the cards?

roaldh made it! (author)2015-09-10

Your instructable showed me exactly what I needed to know about connecting an RFID-reader to a Raspberry Pi! I really like your instructable...

Ukshil (author)2015-04-01

When I'm trying to install setup.py of SPI-Py folder, it shows an error as: command 'gcc' failed with exit status 1..

Help me to solve this. Please!!

JamesS88 (author)Ukshil2015-08-11

To fix the GCC error you need to run this command first: sudo apt-get install python-dev

KarstenM (author)2015-06-14

Hey! I've got a question for the wiring part of the RFID RC522. I have connected everything to the right pins (Got raspberry pi 2) but no led lights on the rc522 turn on and the chip gets hot as hell. Do you know how I can solve this? Many thanks for your help!

wasim.ahmed.7568596 (author)2015-03-22

hi i love ur project it is similar to my project can u share idea wit me wasimahmed9415@gmail.com thank you

sirion (author)2014-10-28

Hi, it seams that the beeper module is not supplied on the github page

File "/home/pi/src/attendance/attendance.py", line 23, in <module>
import beeper
ImportError: No module named beeper

after commenting this out the only thing i get is something like this

attendance.py:178: RuntimeWarning: No channels have been set up yet - nothing to clean up! Try cleaning up at the end of your program instead!
GPIO.cleanup()
29.10.2014 06:44:43
29.10.2014 06:44:44
29.10.2014 06:44:45
29.10.2014 06:44:46
29.10.2014 06:44:47
29.10.2014 06:44:48
29.10.2014 06:44:49

But no readings, i can confirm that when i use the

MFRC522-python-master/Read.py i get readings so my connections are ok..

please help

cholbing (author)sirion2015-03-06

The GPIO.cleanup() isn't successfully clearing the channels. I'll see what I can do.

cholbing (author)cholbing2015-03-06

Also I must mention; use the terminal command 'ps aux | grep python' and close running python processes. Compiling the script over and over can throw off your channels, you gotta kill processes before.

derp1992 (author)sirion2015-02-02

hi there, as you go through the code you see the following

if(actions==(specified action))

this actually are unprintable ascii characters and ttys, where 49 is called upon pressing 1 key on the numpad,50 on 2 ,51 on 3 and so on

so the terimnal is showing the timing's as you have stated above, you actually need to press 7 on the numpad in order to read the uid from the rfid reader which corresponds to 55 in unprintable ascii, i believe the author chose this way of accepting choices in order to run the code at boot(this is what i think may be something else, not sure). you can inbox me if need further information regarding this

stoneschan (author)sirion2014-12-09

sirion ,were you ever able to figure this out?

sirion (author)stoneschan2014-12-09

No, never had an reply to this problem...

cholbing (author)2015-03-05

So has anyone got this thing working. I looked through the Code, and there are a lot of instructions missing. An enitre module is no-where to be found...

PC_Payn3 (author)2015-02-17

Hi Everyone, i have a project at home where i can control my lights and water features etc via relays which can be controlled over the internet but i have now ordered and received a 2 in 1 RFID Reader & Keypad "Image Below" that id like to use as a gate entry that either you can enter a certain code or use the RFID to enter which will turn off a relay, when the relay is turned off the magnetic lock will release and then after a few seconds the relay powers on again and locks.

CAN ANYBODY HELP !!!

I have a 2 in 1 RFID & Keypad, the sticker that shows what the wires are but it isnt very clear and i dont know where to wire them to. (Which pins on the Rasp Pi) I understand the Red And black are to go to a 12v power supply.

Also i have seen so many people using different code, but does anyone have any that would help me at all?

The wire picture isnt that clear but it shows:

Colour:Details:

BlackGND

RedVCC +12V

WhiteD1 / TX / 4R -

YellowBUZZER

BlueLED

GreenD0 / RX / 4R +

Grey26 /34

I have a Raspberry PI Model B running raspian, i have the following pins available:

1,3,4,5,8,9,10,14,17,19,20,21,23,24,25

Look forward to hearing from you Callum

zacy5000 (author)2014-03-17

This is great! Exactly what I have been looking for! Thanks so much. Im going to be getting my NFC reader from hong kong soon. I got it for £2.50 so its going to be fun. Thanks.

stoneschan (author)zacy50002014-12-09

Did you ever get this going?

BartoszB (author)2014-11-27

In the header of attendance.py there's a "import beeper", but there's no standard library like this and no file is included. Can you help me?

stoneschan (author)BartoszB2014-12-09

Did you ever get this working? Im having the same issue. This "instructable" is missing a bunch of the steps... The author may as well should have never published it......

khor.w.jie (author)2014-12-01

how to create a mysql database and import it to Raspberry Pi?

TonyD3 (author)2014-11-20

Im getting ImportError: No module named MySQLdb when trying to run attendance.py. I have set up a database with mysql and i can even see it with phpmyadmin.

BartoszB (author)TonyD32014-11-27

You have to install MySQLdb lib on your RPi before you can run it. :)

LinuxUnux (author)2014-10-30

Hi,

I am having the same issue as Sirion, and also I am having import issues in <module> for the onScreen and NFC imports.

Just wondering if you could give any help

jjjdz (author)2014-10-07

hmm.. when running attendance.py

File "/home/pi/RPi.GPIO-0.5.7/attendance/MFRC522.py", line 11, in <module>

import spi

ImportError: No module named spi

install RPi.GPIO-0.5.7.tar.gz

SébastienJ (author)2014-08-21

Other skill with PNEV512R :

http://domotique-info.fr/2014/08/passerelle-domotique-nfc/

asadkundi (author)2014-04-25

Quotation Required of Tags Attendance system.

audreyobscura (author)2014-01-02

Good idea! I am just starting to noodle around with NFC, nice project, and thank you for sharing.

About This Instructable

215,858views

162favorites

License:

More by Yim:Attendance system using Raspberry Pi and NFC Tag reader
Add instructable to: