RFID Attendance System using ESP8266 and Google Sheets Version 4
HTML-код
- Опубликовано: 9 мар 2023
- Looking for an efficient and reliable way to manage attendance in your workplace or organization? Look no further than our RFID Attendance System using ESP8266 and Google Sheets Version 4, which features advanced capabilities including time-in, time-out, and multiple gate entry options.
Using Google Sheets and Nodumcu, our system provides real-time tracking and monitoring of attendance data, making it easy for you to stay on top of attendance management. And with our user-friendly LCD display, checking attendance status is simple and straightforward.
Whether you're a school, business, or any organization in need of a comprehensive attendance management system, our RFID attendance system version 4 is the perfect solution. So why wait? Watch our video now to see just how easy it is to implement this system and streamline your attendance management today!
--------------------------------------------------------------------------------------------------------------------
Parts List
--------------------------------------------------------------------------------------------------------------------
1. NODE MCU - amzn.to/3Zzm1bJ
2. MFRC522 Reader Module - amzn.to/3ytuFMU
3. LCD Display Module 16X2 - amzn.to/3ZTsMET
4. Breadboard - amzn.to/3ysOvHX
5. Jumper Wires - amzn.to/3YRafs5
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
RFID Attendance System Version 3
• Version 3 - RFID Atten...
RFID Attendance System Version 2
• Advanced RFID Based At...
RFID Attendance System Version 1
• RFID Attendance System...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs/
RUclips:
ruclips.net/user/ahmadlogs?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/rfid-att...
--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.
Warning: I will use High Voltages which if incorrectly or improperly used could result in serious injuries or death. So be careful of what you are doing because I will take no responsibility for any of your actions.
Warning: In some countries it is required to register GSM module from govt authorities before using it. So, get proper understanding of govt laws related to GSM technologies.
#nodemcu #rfid #googlesheets
thank you so much, you saved our capstone for research. godbless
شكرا أخ أحمد ،بارك الله فيك، واصل
In the coming days, we hope that this project will be using QR code esp32 cam......thanks
THANK YOU SO MUCH!
Welcome back
Miss your videos
👍👍👍
Thank you for the warm welcome!
Man keep doing this awesome explanation. You did perfect bro
thanks
@@AhmadLogshi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?
Thank you sir for these useful videos, I enjoyed a lot
welcome
Very cool Ahmad! I don’t have a project yet for RFID but I’ll think of something.
thanks
greetings from Turkey. the system is very nice. My advice to you is to add a buzzer and batteries to the system. display the battery status on the screen. maybe you should just store the data on the sd card :))
Thanks for the tips!
THANK YOU! I’ve been looking for something like this!
Enjoy!
Super ahmed its wonderful ❤️🤩
Thanks for liking
Thank you 💝
I will try it.
Love from Bangladesh.
Hope you enjoy
@@AhmadLogs all work fine but time is not working.
In time zone i put "asia/dhaka"
But not match.
What can I do?
@@sohailulhannan you might try to change time zone from google sheet GUI
@@AhmadLogs i changed it.
But still no outcome 😔
@@sohailulhannan hmmmm. have you watched my this video. it might be helpful ruclips.net/video/M9Sci4nsTEk/видео.html.
@AhmadLogs I was able to add a relay to the system and am now looking to reference and display the First and last name rather than student ID when displayed on the LCD when it registers and logs a card. Advice?
HI Ahmad thank you for a good eplanation of the project. Do you know why LCD screen is blinking? It occurs when blue led of nodemcu is blinking rapidly
hello my friend, it's been a long time since you've been away, I hope you're well!!
thank you for the videos, thank you for being there!!
Thank you for your comment and for checking in on me! I took a bit of a break from creating and uploading videos to focus on some personal matters, but I'm back now and excited to start creating content again. Thank you for your support and for being a part of this community!
@@AhmadLogs ooh, the pleasure is shared, we learned a lot from you, thank you for being there and with great pleasure
@@kamalkamel7559 thanks a lot
Hi Ahmad, I am currently having trouble with my network credentials when attempting the project. Are you using your own network Wi-Fi? I am trying to use a mobile hotspot for the module to connect to however it doesn’t seem to work when I attempted it several times. I would use my college’s network however the college network is private so really no chance of getting those credentials.
Hi Ahmad, I am currently having trouble with my network credentials when attempting the project. Are you using your own network Wi-Fi? I am trying to use a mobile hotspot for the module to connect to however it doesn’t seem to work when I attempted it several times. I would use my college’s network however the college network is private so really no chance of getting those credentials.
Nice bro
Welcome again...
thanks
Hey Ahmad,,,, in this video you using the esp8266,,,,but im using esp32 for the same project as you,,,,,did you have any code for esp32?
Add a keypad and 4x3 keypad and use it for menu navigation and stuff
You Will Add The Buzzer Also
And Plz Add The Lecturer Wise Attendance Means IF The Lecturer Start 10 The Attendance File Only 10 to 10.15
15 Minutes For The Attendance
And Then Again Same Process For Next Lecturer
hi, the time of entry should not only be the time but the date too, and the time of return should not only be the time but also the date too, because if when you return home the date is a different day then the data will not be correct in calculating the time.
hi is this possible if we add faace recognation on this project?
hi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?
Thank's for this object. It is very helpful for me. But i have a question can you answer? I want to change RFID by Fingerprint sensor the code how about? Thanks a soon answer...
can you show me how to input the data like first name and last name, im kinda new in this kind of thing
@Ahmad Logs what language you use in this video?
Great work :) Is it possible to ad a keyboard so you can enter a code when you forgot your rfid tag?
Está super genial tu canal, estaria super un proyecto similar pero que puedas denegar el acceso por ejemplo si pagas una membresia mensual y despues de cierta fecha si no pagas que no te de acceso 😮
mejor di que quieres venderlo 😂
@@frankespirituvalera8035 De hecho realicé uno 😉
sir after scanning the data is not properly storing for example the student is not updating
and also the please secify on how to set timezone
please reply sir
please make a project including sms alert.
thank you for this tutorial. I have tried to store data on RFID tags, however the message appears authentification failed. what maybe the possible cause?
for writing data on rfid you need to check version 2
please check why lcd liquid blank, no text why...
Hi Brother How are You, I have one doubt, when out punch is detected i want out date. I mean in time in date and out time out date. Kindly help me Brother
Super bro.
Thank you
super project i really like you
thanks
@@AhmadLogs Im very much inspire from this project and i have few questions for the prototype i have build can you help out?
Query:
how to check particular student_ID using If else block.
@@harshulrathod1548 can you give me some more details for your query.
Error compiling for board NodeMCU 1.0 (ESP-12E Module).
how to resolve this isssue
what are the wires did he use?
❤Dear Ahmed...
Make An RGB P10 or P5 Clock...
With Arduino UNO...
It Is Most Difficult For Most People
I am getting this error:
Reading last data from RFID...
Authentication failed for Read: Timeout in communication.
Authentication failed for Read: Timeout in communication.
Authentication failed for Read: Timeout in communication.
Authentication failed for Read: Timeout in communication.
Authentication failed for Read: Timeout in communication.
Publishing DataPlease Wait...Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": ",,,,,Flag1"}
Error with request. Response status code: 500
Error while connecting
Failed.[TEST] delay(5000)
I want to use esp01 insted of nodemcu please give me tutorial on that
Hi brother I have tested the google sheet url in google brower there comes script not found error would you please solve the error.
Ahmad, any interest on developing a system like this for a small work based transportation program so that the scan would capture name, date, time, and location when getting on and off the bus, and calculating the number of miles transported as well as the amount of time each passenger rode? If you are interested, how much would something like that cost?
i faced this erroe
( library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s).)
kindly give solution of it. i follow all step sir
You can do this things in next update.
* We can take output of specific student in pdf format.
*Send automatically in/out message through whatsapp or sim.
definitely I will try to add these features in version 5.
@@AhmadLogs hey Recently purchased all modules but while uploading the code is shows ('D3' was not declared in this scope) , please help me out
@@BrillianceTutorials I think there is not any D3 pin in the code. you must use #define RST_PIN 0, which is the pin D3.
@@AhmadLogs thanks and fixed this , can we add more data on it , like father name and all , tried it but showing error Bad control character in string literal in JSON at position 64, any other social media handle to contact you .: ) thanks
@@BrillianceTutorials check version 3 for more detail. ruclips.net/video/Bgs_3F5rL5Q/видео.html
tambien se puede hacer con un esp32
once data is written in tag how to erase the data?
bro, can i save the success message returning from the google sheets and display it on the 16*2 display?
if yes, can u tell me how to do so
@Ahmad Logs how to change time?
Thanks ahmad, i will try this for thesis
Have fun
sir how to add buzzer sound when a scan card ... please modify your code
sir yhe attandance output is not showing on google sheets what i do/
Please also add gsm sim800l in this project to send the attendace time to the employees automatically when they scan an rfid tag.
great idea. will add in version 5
Where have you been because I have been waiting for part four for a long time I hope you are doing fine.
Thank you for your comment and for checking in on me! I took a bit of a break from creating and uploading videos to focus on some personal matters, but I'm back now and excited to start creating content again. Thank you for your support and for being a part of this community!
hi your project is nice but mine say failed try again many times even though i activate the card
Does anyone know how I’d go about adding a solenoid and/or buzzer to this system?
I have added a buzzer in version 3. you may check that.
in this project, how to connect to ggole sheet please
Hi Ahmad, I am currently having trouble with the network credentials part. I am trying to use my mobile hotspot on my phone to act as my “Connecting to Wi-Fi” however the connection is not going thru. Do I need a personal home wifi connection or is there a way I may use a private wifi solution, such as my college wifi?
In order to connect the ESP8266 to a Wi-Fi network, you need to provide the network credentials (SSID and password) in the code. This network can be a personal home Wi-Fi connection or a public Wi-Fi network, such as your college Wi-Fi, as long as you have the necessary credentials to connect to the network.
If you are having trouble connecting to the Wi-Fi network using your mobile hotspot, there are a few things you can try to troubleshoot the issue:
1. Check that your mobile hotspot is turned on and that the network name (SSID) and password are correctly entered in the code.
2. Ensure that the ESP8266 module is within range of the Wi-Fi network and that there are no physical obstacles or interference that could block the signal.
3. Verify that the Wi-Fi network you are trying to connect to is not using any advanced security protocols or network settings that may be incompatible with the ESP8266 module.
4. If you are still unable to connect to the Wi-Fi network using your mobile hotspot, you can try connecting to a different Wi-Fi network, such as a personal home Wi-Fi connection or a public Wi-Fi hotspot.
hello bro i made this project which is working but the data is not publishing am getting
failed try again please help
Please version 5
how to top up the card?...
can you help me?
WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s)
this WARNING not effect the functionality of the project
how to ADD buzzer
Enter Last Name, ending with #
Authentication failed for Write: Timeout in communication.
Authentication failed for Read: Timeout in communication.
I get error like this,How to overcome this
Using fingerprint
can we use moblie hotspot either wifi
plz relay soon
i dont have l2c module in my 16*2 display what should i do
then you might use SPI
Current time not displayed sir. What can i do? It displayed only 5 hours late time in and out. Please give a Sugition sir
hi, can i ask? why i didn't have Board "NodeMCU 1.0 (ESP-12E Module)" at Tools area
because you did not install the esp8266 board. so just install the esp8266 board from BoardManager
@@AhmadLogs this is help me a lot, but this is now my currently problem shows (WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s). What is the problem?
@@protobelt9001 this warning message does not necessarily mean that your code will not work. It is possible that the library may work without any issues on your esp8266 board.
if you still want to remove this compile warning. You can do it by doing the following:
1. Navigate to your Arduino/libraries/LiquidCrystal_I2C library.
2. Edit the library.properties file with a text editor.
3. Change the architecture line from "architecture=avr" to "architecture=avr,esp8266".
If something bad happens, please let me know!
LCD is not turning on, why?
i have set time zone to asia/kolkata for india but the time showing is 5:30 hours apart from the actual time what to do next
check this for time zone related issues
ruclips.net/video/M9Sci4nsTEk/видео.html
@Ahmad Logs what is the timezone when I'm in the Philippines what is asia/manila? How to input proper time on my current country? Please help me!
Yes asia/manila po
Sir All thinks is done work perfectly i can see it on the serial monitor but nothing is showing in lcd.. What is the problem.. What solution fir it..
test your lcd separately. There might be some connection issues.
@@AhmadLogs ok sir
yeah 1st day sheet 1 will store the attendance. if i want to store the 2nd day attendance in sheet 2 and so on.. what should i do
just change the sheet name in the script file. I think it will work
@@AhmadLogs
I need auto update bro... like if day changed , sheet will changed automatically...
@@guruchethan4731 hmmmm. will try soon
@@AhmadLogs thank you so much 😊
Why there is a problem in uploading ?
Hello I tried this it works Good, but along with attendance I need to add extra columns for the same row which can store components taken by student (components with separate RFID tag ) is it possible?
yes it is possible you need to store the component information in RFID tag. then you append this information in the queryString in sketch file. you also need to update the code for google script
@@AhmadLogs thank you, now I have completed it, can we further make this project such that where to write the information to tag we must use a key pad and write it directly using a switch by changing the program to writing mode, and make it free from all the time going to Arduino ide,?
What do i put in Command and Insert_row or Append_row in?
nothing to change. just change the sheet name if required
@Ahmad Logs what's server you use in this RFID v4?
please explain a bit
Hi Ahmad...., great project. still have problem with timezone. i'm from Indonesia, any suggestion to solved this problem?
check this
davidkeen.com/blog/2017/01/time-zone-conversion-in-google-sheets/
Error....
**Card Detected**
Card UID: 03 5D 9E 0D
PICC type: MIFARE 1KB
---------------------------------------
Enter Student ID, ending with #
Authentication failed for Write: Timeout in communication.
Authentication failed for Read: Timeout in communication.
Hello Ahmad, i already followed all your steps, but i have a problem for the lcd, it doesn't even turning on, can you please help me solve this problem?
Use different library versions , adjust the potentiometer in the back, make sure pins are correct
what if someone give their card to other employee to mark attendence anyyy option for that rather than fingerprint?? ?cameraa??
if someone give their card to other employee to mark attendence it is possible. fingerprint or face recognition is better choice if you want make it batter.
@@AhmadLogs can you make something which recognizes face and rfid for attendence ot takes a photo everytime a card scanned
@@drabtechs Yes I can make, but I don't have hardware such as esp32 cam or fingerprint module right now
@Ahmad Logs I don't see the esp8266 in latest version of Arduino, how to solve that or I download your version of Arduino in this video so I can find the esp..
1. have you added the esp8266 link in the preferences?
2. What version of IDE you are using?
@@AhmadLogs latest version of ide
@@AhmadLogs how to add esp866?
Regards, very good job, friend. How can I set the time zone of Venezuela? I can't change the time.
check version 2 for this, where I have discussed it in detail.
ok i solved it, thanks
a query, I can add mad additional cards after having already added 5,
how to correct the time? it's 4 hour advance pls help
hi, I love your video, but could I use arduino uno and NodeMCU V3 at same time? because I use arduino uno with RC522 to perform the lock, at same time, I want to have this google sheets function. How can I fix it? Thank you
this project work on internet, but arduino uno cannot connect to the internet itself. so you need to connect esp01 wifi module to the arduino to fix it
@@AhmadLogs oh I see. Thank you to reply my question. I will check your other videos and see what can I learn from you. Thanks 🥇🥇🥇
hi Error with request. Response status code: 500
Error while connecting
[TEST] delay(5000) i get this problem can you solve? please
It is a server side issue. just try again it will solve
Reading failed: A buffer is not big enough showing in serial monitor and also entering wrong details in gsheets
Hi Ahmad! Can we add one more feature, like if an employee comes late a message should display on the screen "You are Late"...
noted. will add in version 5.
library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s).
getting this warning and no text is showing
@@iamtheantony it is not an error it is just warning but the code will work fine. There must be some other issue with your lcd
@@AhmadLogs thanks it's working, but how can we add buzzer with LCD? as D2 is already connected with LCD
@@iamtheantony you can use any unused pin instead of D2
Hi,I have problem my led display is not working properly.it is just glowing..
rotate the potentiometer on the back side of the lcd to adjust the contrast.
Is it okay to not use breadboard, just directly connect it ?
Yes
hello sir can you teact me on how to use the lcd
Has the time out issue been fixed? Great project!
Not yet! it is the server side issue. and I did not find any solution for this. it is very complex
@@AhmadLogs Thank you sir for your great work.
I am getting this error and the lcd i2c 16X2 display is not working, please HELP.!
WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s).
Based on the error message, it seems like there is a syntax error in your code related to a missing binary operator before the token "(".
The error message specifically points to a file called "IRTimer.hpp" in the "IRremote" library, indicating that the issue may be related to that library.
One possible solution is to make sure that the "IRremote" library is properly installed and up-to-date. You can try removing the library and re-installing it from the Arduino Library Manager.
this is not an Error. It is just a warning message and it will not effect the overall working of the project
can you please do one project , my requirement is rf id receiver should connected with arduino's interrupt pin. if rf id card found it should trigger the controller and do some interrupt function(exit the loop and do the interrupt function and back to the loop and continues the loop function).
it is possible.
@@AhmadLogs actually I have tried bro. But it will not triggered. Instead of rf id I have used push button. It will work
@@guruchethan4731 hmmm. can you share your code?
@@AhmadLogs sure bro can I have your social media id?
@@guruchethan4731 I have GitHub
Thanks for your Video! I'm facing a problem with the code. After publishing the data, I can see it in my Google Sheet, but the loop seems to be stuck. In the Serial Monitor, I can see the JSON payload, but nothing happens after this. Hope you can help!
hmmm. have you installed esp32 core version 2.0.6?
please give me some more detail about the error. check serial monitor for more detail.
@@AhmadLogs In the serial monitor there is nothing after the payload is printted. It does get published, as I can see the data in my Google Sheets, but it seems the POST function is stuck, and doesnt return anything, so the loop doesnt continue.
@@AhmadLogs Hi again, I updated to the newest version of esp32, and it works now! Thanks so much
@@WobbleStoneMedia glad it works
@@WobbleStoneMedia hmmm. I will try to update the code.
How to connect sim800l to blynk server with nodemcu controller?
you need to send http post request from sim800l
i have no 8266 but have esp32 dev can you help with pinouts as i have no I2C but dont think i need ?
I think you need to change the entire code. I never tested it for esp23
@@AhmadLogs I will have a go lol.... 🙏
Dear Vai please help me.
When I punch a card, time deferent 6 hour less in Bangladesh time.
Bangladesh time-18: 25pm
Show-12:25pm
Sir, how to do this project using esp32
how to change time zone or how to write the corrected time xone
@AhmadLogs
WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s). This is my current problems, can i ask how to fix it?
it is not the issue. it is just a warning and does not cause any issue with the project
@@AhmadLogs its not diplaying anything bro
@@saikirang317 just test it with arduino
@@AhmadLogs can i ask this is my final problem?
Reading last data from RFID...
Authentication success
Block was read successfully
Authentication success
Block was read successfully
Authentication success
Block was read successfully
Authentication success
Block was read successfully
Authentication success
Block was read successfully
Publishing data...
{"command": "insert_row", "sheet_name": "Sheet1", "values": ",,,,,Gate1"}
Error with request. Response status code: 404
Error while connecting
[TEST] delay(5000)
@@protobelt9001 let me check.
The 404 error told that the resource that you request is not found. it means your sheet url might me wrong
Can we add a buzzer to indicate that the RFID has been scanned?
Yes
@@Projectswithmani give me the code bro
@@captan8191just use ai