RFID-RC522 with Excel using Arduino (As a attendance system)
Hi, everyone.
In this video, I'm going to show you how to interfacing
RFID-RC522 with Arduino UNO and saving the information about cards in Excel file.
Login system or Attendance system.
For example to ensure all employees in the company come
in time every day and saved the Excel file where the names and each unique number stored when all employees had come.
The Excel file saves Login and Logout time.
Note: The card will detect only once and show you a message if the card already detected and saved.
-----------------------------------------------------------------------------------------------------------
Some guys told me that they have a problem while scanning the Cards
that problem was the Arduino detect many cards as the same with the same name even these cards had different IDs.
So I fixed the problem and Here's the new code,
Using this code you don't have to upload another code to scan the card's ID just upload this code then open the Serial monitor and scan your tags then replace yours with the other in the code.
I hope everything goes as you want.
Please read the comment in the code to better understanding.
Everything you need is here:
https://github.com/InfinityWorldHI/RFID_Excel
-----------------------------------------------------------------------------------------------------------
If you want to use LCD 16x2 with this project and make it more interesting. You can use this code
Arduino code with LCD:
http://bit.ly/DownloadRFID-Excel-Log
The diagram with the LCD driver and without it:
http://bit.ly/Download_RFIDlcd
Note: I used this LCD driver: https://youtu.be/JJTpvh_dm6E
with only 1 wire using SPI Protocol and Shift Register.
The reason why I used this method because RFID uses SPI protocol and
we could use his pins for another device using the same protocol and
save more pins to use them.
Check it out.
-----------------------------------------------------------------------------------------------------------
If you want to buy the components:
Arduino UNO: https://www.gearbest.com/boards-shields/pp_226716.html?lkid=10141361
RFID-RC522: https://www.gearbest.com/development-boards/pp_142896.html?lkid=10141361
-----------------------------------------------------------------------------------------------------------
In the new video, I've made a professional login system using nodeMCU and RC522 with a web interface and save everything in Database using MySQL.
You can know more information about it in this video, Check it out if you're interesting:
https://youtu.be/dXZiFx6RP6s
-----------------------------------------------------------------------------------------------------------
Music: Fredji - Happy Life (Vlog No Copyright Music)
-----------------------------------------------------------------------------------------------------------
If you like this video don't forget to Like and Share.
Don't be a stranger, hit the Subscribe button, It will be awesome having you here.
Comment if you have any questions.
Thanks for watching.
Видео RFID-RC522 with Excel using Arduino (As a attendance system) канала Electronics Tech
In this video, I'm going to show you how to interfacing
RFID-RC522 with Arduino UNO and saving the information about cards in Excel file.
Login system or Attendance system.
For example to ensure all employees in the company come
in time every day and saved the Excel file where the names and each unique number stored when all employees had come.
The Excel file saves Login and Logout time.
Note: The card will detect only once and show you a message if the card already detected and saved.
-----------------------------------------------------------------------------------------------------------
Some guys told me that they have a problem while scanning the Cards
that problem was the Arduino detect many cards as the same with the same name even these cards had different IDs.
So I fixed the problem and Here's the new code,
Using this code you don't have to upload another code to scan the card's ID just upload this code then open the Serial monitor and scan your tags then replace yours with the other in the code.
I hope everything goes as you want.
Please read the comment in the code to better understanding.
Everything you need is here:
https://github.com/InfinityWorldHI/RFID_Excel
-----------------------------------------------------------------------------------------------------------
If you want to use LCD 16x2 with this project and make it more interesting. You can use this code
Arduino code with LCD:
http://bit.ly/DownloadRFID-Excel-Log
The diagram with the LCD driver and without it:
http://bit.ly/Download_RFIDlcd
Note: I used this LCD driver: https://youtu.be/JJTpvh_dm6E
with only 1 wire using SPI Protocol and Shift Register.
The reason why I used this method because RFID uses SPI protocol and
we could use his pins for another device using the same protocol and
save more pins to use them.
Check it out.
-----------------------------------------------------------------------------------------------------------
If you want to buy the components:
Arduino UNO: https://www.gearbest.com/boards-shields/pp_226716.html?lkid=10141361
RFID-RC522: https://www.gearbest.com/development-boards/pp_142896.html?lkid=10141361
-----------------------------------------------------------------------------------------------------------
In the new video, I've made a professional login system using nodeMCU and RC522 with a web interface and save everything in Database using MySQL.
You can know more information about it in this video, Check it out if you're interesting:
https://youtu.be/dXZiFx6RP6s
-----------------------------------------------------------------------------------------------------------
Music: Fredji - Happy Life (Vlog No Copyright Music)
-----------------------------------------------------------------------------------------------------------
If you like this video don't forget to Like and Share.
Don't be a stranger, hit the Subscribe button, It will be awesome having you here.
Comment if you have any questions.
Thanks for watching.
Видео RFID-RC522 with Excel using Arduino (As a attendance system) канала Electronics Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Arduino | Arduino to Excel Communication (PLX-DAQ) | Combination with RFID RC522RFID RC522 Based Attendance System Using Arduino with Data LoggerWhat's the difference? Arduino vs Raspberry PiHow to Make a CNC Drawing Machine at homeESP RFID: Google Sheets as a database for rfid cardsProfessional attendance system using NodeMCU with a website and a Database.RFID DOOR LOCK - with 3D printed caseRFID Demo with Excel, USB Reader and RFID CardsRFID Module RC522 Interfacing with Arduino Uno/Mega || RFID Module Arduino Tutorial + Code 2020Arduino And Rfid Based Attendance System With Data Logger | Smart Attendance System | ArduinoProjectArduino RFID Sensor (MFRC522) TutorialArduino Based RFID Door Lock - Make Your OwnHow RFID Works and How To Make an Arduino based RFID Door LockHow safe is contactless payment? || How does RFID & NFC work? || EB#40Visual Basic .Net | Arduino RFID RC522 with VB Net Interface using MySQL Database | CodingHow To Make RFID Card Based Attendance System. RFID Based Entry System, RFID Security SystemRFID Based Attendance System using NodeMCU with Website and DatabaseArduino to excel Communication ✔10 Arduino Projects with DIY Step by Step TutorialsConnect RFID to PHP and MySQL Database with NodeMCU ESP8266