RFID-RC522 with Excel using Arduino (As a attendance system)

  Рет қаралды 152,559

Electronics Tech

Electronics Tech

6 жыл бұрын

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:
github.com/InfinityWorldHI/RF...
-----------------------------------------------------------------------------------------------------------
If you want to use LCD 16x2 with this project and make it more interesting. You can use this code
Arduino code with LCD:
bit.ly/DownloadRFID-Excel-Log
The diagram with the LCD driver and without it:
bit.ly/Download_RFIDlcd
Note: I used this LCD driver: • Making LCD 16x2 driver...
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: www.gearbest.com/boards-shiel...
RFID-RC522: www.gearbest.com/development-...
-----------------------------------------------------------------------------------------------------------
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:
• Professional attendanc...
-----------------------------------------------------------------------------------------------------------
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.

Пікірлер: 574
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hi everyone. Recently, There was a problem in the Arduino code while detecting the cards and read many cards as the same. So I tried to fix that problem and everything went well. If you're interested, now the code is available to download from this link: github.com/InfinityWorldHI/RFID_Excel If you want to ask about something you can email me: " electbusinees@gmail.com " or send a message on my facebook page: facebook.com/ElectronicsTechHaIs/ Stay close. Cheers.....!
@markkevinvillanueva2981
@markkevinvillanueva2981 5 жыл бұрын
okay sir
@hazzanawarafik6100
@hazzanawarafik6100 5 жыл бұрын
using fingerprint please
@garbojames2271
@garbojames2271 5 жыл бұрын
Thank you very much sir!
@minalhingne1710
@minalhingne1710 5 жыл бұрын
hi, i used this code but still code not detecting the card and not showing the card number on serial monitor. please give me suggestion what can I do..
@kristiankennethallag5328
@kristiankennethallag5328 5 жыл бұрын
@@minalhingne1710 Yeah, me too. How to fix this. pls. help
@jacqui6954
@jacqui6954 Жыл бұрын
I did this for my project and everyone loved it. Thank you so much ❤❤❤❤ you are such a smart man. Hats off
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Glad to hear that
@tanishq9716
@tanishq9716 Жыл бұрын
Can you send the project report please
@tanishq9716
@tanishq9716 Жыл бұрын
@jacqui How did you get the data updated into the excel sheet please can you help
@tanishq9716
@tanishq9716 Жыл бұрын
Bro ??
@4camilo07
@4camilo07 6 жыл бұрын
Thanks man, you really save me with this video, thank you so much.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
It's my pleasure I'm glad it was helpful
@TyroneM113
@TyroneM113 4 жыл бұрын
Heya. Thanks for the amazing video your build was the best for us compared to the other setups we have seen. We are building a system for our practical and I have 2 questions. 1) Is it possible for the time in and out to display on the same line instead of separate entries? and 2) We are trying to integrate a system that will take the total time worked and work out the employees wage. What would the best way to achieve this be? Would it be adding extra code or stuff in the excel sheet?
@addilalatif4410
@addilalatif4410 5 жыл бұрын
this is very helping for us students, thank you!
@addilalatif4410
@addilalatif4410 5 жыл бұрын
but why everytime i wanna use excel to open "cannot run the macro"PLX-DAQ-V2.11.XLSM". the macro may not be available in this work book, how to fix this?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Check if the Excel office is already installed on your PC. sometimes "PLX-DAQ-V2.11.XLSM" isn't stable and might cause a problem while using it, because of that I made a new version with more feature.
@addilalatif4410
@addilalatif4410 5 жыл бұрын
@@ElectronicsTechHaIs it says that cannot run macro or disabled, how to fix this
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
I see, After opening the Excel sheet you have to allow running the macro (yellow warning message at the top).
@minlalvaiphei7162
@minlalvaiphei7162 3 жыл бұрын
Very helpful and good informative. I would like to know more about the code for multiple Card& Tag in a single Arduino RFID reader. Thanks you
@ElectronicsTechHaIs
@ElectronicsTechHaIs 3 жыл бұрын
Glad to hear that, You can check out the codes in my github repository, the link in the video description
@jerickmanlangit6653
@jerickmanlangit6653 5 жыл бұрын
Very much Thank you sir!
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
My pleasure.
@qurt_san
@qurt_san Жыл бұрын
when i try to upload it go denied.. help, also does this work with 400 holes breadboard?
@ryanbarrera2595
@ryanbarrera2595 5 жыл бұрын
I want to make this project..Thanks for the upload.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're Welcome. I'm glad you liked it.
@habeebsahily244
@habeebsahily244 3 жыл бұрын
Arduino: 1.8.13 (Windows Store 1.8.42.0) (Windows 10), Board: "Arduino Uno" Sketch uses 6562 bytes (20%) of program storage space. Maximum is 32256 bytes. Global variables use 281 bytes (13%) of dynamic memory, leaving 1767 bytes for local variables. Maximum is 2048 bytes. An error occurred while uploading the sketch This report would have more information with "Show verbose output during compilation" option enabled in File -> Preferences. i have checked the upload box in show verbose output during compilation and still error
@ahmedalkurdi6966
@ahmedalkurdi6966 3 жыл бұрын
Can you please explain how to add the two LEDs and the buzzer?
@habeebsahily244
@habeebsahily244 3 жыл бұрын
HI can you please help i have my bachelor thesis topic i have picked rfid and i have tried what you instructed in the video however i cannot find rfid_serial_personal data i have only dump serial any advice how to find the solution please ?
@Oirelis
@Oirelis 11 ай бұрын
can i ask how can you modify the nfc to a specific name?
@samehbouhafs7259
@samehbouhafs7259 4 жыл бұрын
Good day Sir Can a use it for :Time in/out ? (Calculate the time between 2 uses of 1 RFID card)
@ivangamboa613
@ivangamboa613 3 ай бұрын
Hello can I add gsm module for text message so it can be use for rfid attendance with database through excel with text message to parents
@Producthuntvideos
@Producthuntvideos 5 жыл бұрын
Sir this is amazing project this is owsome 😀♥
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're Welcome. I'm glad you liked.
@Producthuntvideos
@Producthuntvideos 5 жыл бұрын
@@ElectronicsTechHaIs thanku so much sir
@Buuraley
@Buuraley 5 жыл бұрын
What are the LCD pins and LED
@kei-floboy
@kei-floboy 6 ай бұрын
hello sir, i want to ask if i need to connect it to a pc to get the real time data or can i just store the data in sd card and retrieve it later? thank you!
@amnaabdalwhab7679
@amnaabdalwhab7679 6 жыл бұрын
thanks, it Amazing project.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
Thanks I'm glad it was helpful
@expressmoonenjoyer3667
@expressmoonenjoyer3667 2 жыл бұрын
can we added things like address and city?
@TiffyKambowe
@TiffyKambowe Жыл бұрын
how to add the liquidcrystal library in the code
@rubbensboisguene4921
@rubbensboisguene4921 5 жыл бұрын
Great tutorial !. I have Few questions: What if I want to extend it functions to open a door (using a relay for example). I am using NodeMCU. I would like it to read from a preexisting excel ( that will be stored on an sd card or online ( on a server) and then authenticate the cards ( if the scanned card is registered on the server, it will turn on the relay and record the exact time and record success, if not it will still record the card with failed, but not turn on the relay. So the node MCU will have an sd card module with two files ( the predefined with all authorized card numbers, and the blank one to record the data). Sorry for that long text, but your help will be very apreaciated
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're welcome. first, check out this video: kzbin.info/www/bejne/mom9mnmua7eDbNU to give you some knowledge on how RFID module works with NodeMCU. You can modify the website code as you want in order to make the nodeMCU execute your command like turn on a relay. By this way, you can save every change that happens on your system and check it from anywhere plus it's easy to use. In the next video, I will make a project using SD card to store the data. stay close.
@amierasycap4870
@amierasycap4870 5 жыл бұрын
U earn New subscriber and 👍 for Help other people project
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Thanks, I'm glad you liked my videos, Everyone deserves the help My pleasure,
@franceezlianneacosta6852
@franceezlianneacosta6852 3 ай бұрын
Good day! Can we convert the RFID to QR code generated attendance system?
@runebgh8521
@runebgh8521 3 жыл бұрын
hey. I can not get my No. 2 card up in excel. what could the problem be?
@Producthuntvideos
@Producthuntvideos 5 жыл бұрын
sir i have one problem please help me ot sir ......... i want to scan the card more than 2 time sir what can i do sir?
@technicalsaikat3502
@technicalsaikat3502 5 жыл бұрын
thanks for share friend
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're Welcome. I'm glad it was helpful.
@agilkrishna
@agilkrishna 5 жыл бұрын
great idea sir ...can i know ho to connect led and buzzer parallely with this connection and codes for the time to blink red and green led
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're Welcome. They already connected to it.
@H3llbo7
@H3llbo7 3 жыл бұрын
how can i add a led or a buzzer
@damiengabrielllego3196
@damiengabrielllego3196 4 жыл бұрын
HI GOOD EVENING. what kind of card did you use?
@conanthebarvarian
@conanthebarvarian 2 жыл бұрын
When i restart the arduino or reconnect the plx-daq the save data also deleted. How can i solve this? I want to save data even the arduino restart
@zamcoronacion9760
@zamcoronacion9760 Жыл бұрын
Com error 5 shows up when i open the excel sheet How can i fix that?
@panavpatel8623
@panavpatel8623 Жыл бұрын
Serial monitor is not showing any outputs? The light on arduino uno and rfid module is working, what should I do
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Make sure the serial monitor baudrate is set correctly to 9600
@naznor1165
@naznor1165 5 жыл бұрын
hello sir..could you plz send final code of the project with LCD + diagram connection Arduino Uno+RFID + LCD because the links in the description for lcd part are not working thanks in advance
@TheNthGenGaming
@TheNthGenGaming Жыл бұрын
How to connect 3 cards? Pls help
@sabahlarhlid5639
@sabahlarhlid5639 5 жыл бұрын
Arduino : 1.5.6-r2 (Windows 7), Carte : "Arduino Uno" 'MFRC522' rfid_read_personal_data:110: error: 'STATUS_OK' is not a member of 'MFRC522' rfid_read_personal_data:112: error: 'class MFRC522' has no member named 'GetStatusCodeName' quoi faire dans ce cas please.'
@learnthebasicchannel8394
@learnthebasicchannel8394 6 жыл бұрын
great project dude..thanks for sharing .just wanna ask if the employee is going out then need to tap his/her card again .sa exel need again the time and of his/her entry .how can i do it ?will i use loop for that in code?im making RFID door lock system and this vid save me of monitoring the time of entry .
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
You're welcome. As I understood from your question You need to make the Excel save each entry to the same card. Thus, you have to modify the code in line 84 next statu[s]=1; add NumbCard[j] = 0; and in line 105 next NumbCard[j] = 1; add statu[s]=0;
@kamalgondaliya3488
@kamalgondaliya3488 Жыл бұрын
how many I'd data stored in Arduino?? ex: 50 identifications
@govindaagrawal816
@govindaagrawal816 Жыл бұрын
how to get uid for rfid cards?
@ozan1781
@ozan1781 4 жыл бұрын
I have a question about the system. Students' names will initially write in the excel file. Then when a student reads his / her card, an 'X' will be placed next to the student's name. How can I do that. Please help me.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Yes you can do that, Google it
@pavlygeorge9569
@pavlygeorge9569 2 жыл бұрын
how can i add sd card module for the program to save the information if anything happened in the excel
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
You need to add SD module and save the data inside it as JSON or as txt file.
@bernardbyrne8808
@bernardbyrne8808 3 жыл бұрын
Hi, i was just wondering do i have to manually put a if statement for every id i add, as in i get i have to the uid but is there a way of writing the if statement for all uid i add (i have 200 to add ) thanks even if u could point me in the right direction that would help
@ElectronicsTechHaIs
@ElectronicsTechHaIs 3 жыл бұрын
Hello, since you have 200 cards then its better to have the system as a website on a server rather than using this version of the project, which that will make managing the cards easier and handy, so you can check my another video on how to make it with website and database, kzbin.info/www/bejne/mom9mnmua7eDbNU let me know if you faced any issues.
@FreyFreyFreyFrey
@FreyFreyFreyFrey Жыл бұрын
I kinda need an asnwer asap CAN I USE NFC CARDS INSTEAD OF RFID??? Just label the Nfc chips as someones id and then use it in the program
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Yes, of course you can use NFC, you just need a NFC reader
@agilkrishna
@agilkrishna 5 жыл бұрын
what changes i should make ,if i want to set time in so that if the student comes in the class in time green led shoud blink otherwise red pls help me sir....
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
you should use A real-time clock (RTC) module with the Arduino and modify the code to check the time in when the card scanned with your set time in. After checking the time in you should make an if condition to turn the LEDs as you want.
@peterkylegingo336
@peterkylegingo336 3 ай бұрын
How do I add an LCD module? Please send me the code
@s.k.plastics8881
@s.k.plastics8881 Жыл бұрын
does it need to be connect to the system while scanning the RFID tag?
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Yes
@adibagapor6198
@adibagapor6198 5 жыл бұрын
Hello, may i ask.. What if im doing a project that detects paper then send the notification to excel? Is it possible? Im using laser for the detection
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Of course you can by replacing the parameters (Card ID, Name, Number) in the code with any parameters you want. Bearing in mind you can't send a notification to Excel.
@pcibra5401
@pcibra5401 6 жыл бұрын
Amazing project. Thanks pro. Can i use it with SD card instead using Excel ? please tell me how .
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
PC ibra yes you can. I will talk about it in next videos
@internetexplorer5792
@internetexplorer5792 5 жыл бұрын
Hey brother please make a attendance recorder with RFID+Fingerprint Scanner and GSM module
@marlonbarnuevo1431
@marlonbarnuevo1431 2 жыл бұрын
can we also include thermal sensor in the hardware part?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
Of course you can.
@julianalejandro2175
@julianalejandro2175 5 жыл бұрын
if i want use a 20x4 display what is the programation?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Nothing changes only lcd.begin(20,4) in the setup() section. lcd.begin(total columns, total rows) This function is used inside the setup() to initialize the size of the LCD you're using.
@lucainnocenti6723
@lucainnocenti6723 4 жыл бұрын
Is it possible to close the Excel window while the acquistion goes ahead?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Yes its possible, Check the included PDF.
@kyrren
@kyrren 4 жыл бұрын
Hello can you add a line code where the attendance can be saved through an sd card with an rtc module inside a text file?? thanks please
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Hi, It isn't that difficult to modify, check google there is plenty of examples about that.
@maisarahhaniff1160
@maisarahhaniff1160 4 жыл бұрын
hello, i can scan the rfid tag already, and changed the name of the card also, but then when i upload the code at arduino, i receive message error on how port com3 couldt complete sketch. please help me
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Hi, what is the error message?
@MrChsreeharsha
@MrChsreeharsha 5 жыл бұрын
hello sir, great project may i know that how can i store data like name employee number and other details and if a RFID is read then that information is seen in excel sheet. thank you
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hi, Thanks good to hear that. If you want to know more about how the process works you can check the Beginners Guide to PLX DAQ v2 (rev1) PDF that was included with the Excel tool.
@mrvnmedina0908
@mrvnmedina0908 3 жыл бұрын
Hi Electronics Tech! We know that our world is in a world pandemic as of now. Is it possible to have this RFID Attendance System but it also includes the person's temperature? Thank you for your kind response.
@jaadul8695
@jaadul8695 3 жыл бұрын
that's a very good question.
@mrvnmedina0908
@mrvnmedina0908 3 жыл бұрын
Can you help me with the coding?
@mrvnmedina0908
@mrvnmedina0908 3 жыл бұрын
I really need help because I've chosen this as my thesis paper and I need to make a prototype
@expressmoonenjoyer3667
@expressmoonenjoyer3667 2 жыл бұрын
@@mrvnmedina0908 what happened to your thesis are you able to make it with a temperature sensor?
@marlonbarnuevo1431
@marlonbarnuevo1431 2 жыл бұрын
we have similar thesis :)
@jk7172
@jk7172 5 жыл бұрын
Hello, I am having trouble adding more information. I have added the Card ID already, yet i do not understand how to add more informations on it. I tried adding an else if after the second card yet it doesn't work. What should I do? and if you have an email, might you check whats wrong with the code I added? Thanks in advance.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hi, send to this email your problems with the code, and I will help you with it. electbusinees@gmail.com
@princemiro7241
@princemiro7241 5 жыл бұрын
i need format to the id card i hot the numbers but i dont know the format please help
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
The Card ID is in a String format
@norsyafiqah1823
@norsyafiqah1823 5 жыл бұрын
Hi. I just want to know how to record the time in and time out for this one in the excel?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
the time in and time out are recorded when the Arduino sends the Data to the Excel using this line Serial.println("DATA, TIME");
@jeanieelorde17
@jeanieelorde17 11 ай бұрын
How about from laundry machine to micrsoft excel sir?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 10 ай бұрын
What do you mean?
@Buuraley
@Buuraley 5 жыл бұрын
Should I need to buy the office by microsoft to use the exel sheet .sir please
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
No you don't have to.
@nathaliamariano2284
@nathaliamariano2284 3 ай бұрын
COM Error: Error (5): CommOpen (cresteFile) - Acesso Negado Como corrigir?
@mostafaabdelraheem5448
@mostafaabdelraheem5448 5 жыл бұрын
sir i want to use two RFID with one Arduino uno actually i was connect between first and second RFID to Arduino in Same pin but in this case two RFID didn't work but if i connected all pin in same without connect SS_pin "pin 10 in Arduino" , and connect first RFID SS_pin to Arduino pin 10 in this case the only first RFID will work and that is same with second if i connected SS_pin to Arduino pin 10 but if i connected SS_pin from first and second RFID to pin 10 in Arduino in same time the first and second RFID didn't work how i can change in your code to add another SS_pin from second RFID to Arduino to work the first and second RFID in same time
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
First, you have to define each SDA pin something like this MFRC522 A(A_PIN, RST_PIN); MFRC522 B(B_PIN, RST_PIN); A.PCD_Init(); B.PCD_Init(); Google it you will find something useful.
@aqeelashraf3020
@aqeelashraf3020 2 жыл бұрын
How can we the Excel like for the putting something else pls help me
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
Read the comments inside the code.
@jhoxa5618
@jhoxa5618 Жыл бұрын
hi where is the video adding the led and buzzer
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Not shown in the video, you can add them easily
@BLASIOTEAM
@BLASIOTEAM 6 жыл бұрын
Hi, thank you for share your project. Can I register in the same excel session more than one "in time" and one "out time" for an card ? Thank you
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
You're welcome. yes you can do that By modifeing the code in line 84 next statu[s]=1; add NumbCard[j] = 0; and in line 105 next NumbCard[j] = 1; add statu[s]=0;
@BLASIOTEAM
@BLASIOTEAM 6 жыл бұрын
Electronics Tech thank you very much. Tomorrow I'll try and I'll tell you how it's work 😊
@tanujatanu4249
@tanujatanu4249 5 ай бұрын
Sir I did the connections and well bulit is showing only Read personal data on a MIFARE PICC: till it was showing correctly but that Rfid card is not scanning by the scanner
@tanujatanu4249
@tanujatanu4249 5 ай бұрын
Sir please reply we have to submit project by tomorrow
@jaiakash4416
@jaiakash4416 5 ай бұрын
Did you solved this?
@pinkswan48
@pinkswan48 5 жыл бұрын
Hello. why my plx daq can't connect to port . "COM Error: Error (5): CommOpen (CreateFile)- Access is denied. but my arduino already connect and i can scan my rfid card. Help mee pleaseee
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Check if the Serial Monitor from the Arduino IDE is open then close it. it should work just fine.
@deveshkedia2548
@deveshkedia2548 3 жыл бұрын
Can you give the PCB design of the rfid shield
@ElectronicsTechHaIs
@ElectronicsTechHaIs 3 жыл бұрын
I just used the testing shield without making a PCB,
@shyh175
@shyh175 4 жыл бұрын
thanks alllooooootttt
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
My pleasure, Glad you liked it.
@user-sq4ly3xk5b
@user-sq4ly3xk5b 3 жыл бұрын
Hello .. I have an Arduino uno and i connected every thing probably but it didn’t work !! may be the arduino is the problem, may be because it’s not a genuine one ... or what could be the problem ? @Electronics Tech
@ElectronicsTechHaIs
@ElectronicsTechHaIs 3 жыл бұрын
Hello, Please, recheck on the wiring and try to upload an example from the library examples.
@expressmoonenjoyer3667
@expressmoonenjoyer3667 2 жыл бұрын
can we also include like the person’s temperature in the excel?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
Anything you want.
@expressmoonenjoyer3667
@expressmoonenjoyer3667 2 жыл бұрын
@@ElectronicsTechHaIs sir, the code you made is amazing and it worked, the problem is we changed the numbers "123456" to other number but it won't show in the serial monitor and excel
@Buuraley
@Buuraley 5 жыл бұрын
Please i need to know what pins did you used LEDs and how
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Excuse me, I missed your previous comment, The pins are LCD RS pin to digital pin 7, Enable pin to pin 6, D4 pin to pin 5, D5 pin to pin 4, D6 pin to pin 3, D7 pin to pin 2( LiquidCrystal lcd(7, 6, 5, 4, 3, 2); ). Then you need to change the LED and Buzzer pins to A0, A1, A2.
@naznor1165
@naznor1165 5 жыл бұрын
@@ElectronicsTechHaIsTech regarding the project using LCD .could you plz send to me (nnor93496@gmail.com)the full Arduino code beside the diagram connection with LCD +arduino+RFID-RCM522 because of the Links(for LCD part) in the description are not working any more..thanks
@suetrexd2024
@suetrexd2024 4 жыл бұрын
Hello, i'm having trouble with the serial monitor, after uploading the code, the serial monitor only displayed string name 1,2,4,5 while 3 and 6 are not.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Hi, check if you modified the code correctly with your Card IDs.
@suetrexd2024
@suetrexd2024 4 жыл бұрын
Hello, I already checked them, but nothing's happening, 3 and 6 won't show up. Can i email you the code? So you can check it.
@suetrexd2024
@suetrexd2024 4 жыл бұрын
Oh, nevermind, i found out what's wrong, but thank you for noticing my comment.
@zarafurqan1544
@zarafurqan1544 4 жыл бұрын
Sir how can I put third card only two card uplod in to program no third and more card please help?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
Check the comments in the code.
@wafarazali8771
@wafarazali8771 6 жыл бұрын
how i want to make sum total item ? i do smart shopping trolley. but i dont know how to write the code for addition. can u help me ? at least show me an example and what instruction that i can put the code for addition. thankyou
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
First, you must define a variable that saves the total price like(float total_price = 0;), this variable will update when you add a new item(float item_price;) in code:( total_price = total_price + item_price ;)
@thouhidsm8845
@thouhidsm8845 10 ай бұрын
Do we need any addins to do this
@ElectronicsTechHaIs
@ElectronicsTechHaIs 7 ай бұрын
Yes, you can find it in the code folder
@prathamkhand5048
@prathamkhand5048 5 жыл бұрын
Hello sir I need to save this scanned code to sql database can u help me with this?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hi, check my another video here: kzbin.info/www/bejne/mom9mnmua7eDbNU
@sjokes5612
@sjokes5612 4 жыл бұрын
hi sir ,i have some problem.when i tap the card i can not get any data in the excel or serial .can you plz tell what is my problem?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
the serial must be closed in order to send data to excel sheet correctly.
@hungcaomanh6753
@hungcaomanh6753 Жыл бұрын
Can I use a fingerprint sensor instead of cards?
@ElectronicsTechHaIs
@ElectronicsTechHaIs Жыл бұрын
Yes, of course, but you need to modify the code
@jeromeromana1426
@jeromeromana1426 2 жыл бұрын
hi can i make an rfid with SMS notification and excel
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
You have to use a GSM module like SIM800L in order to send SMS message.
@urvashipawar5372
@urvashipawar5372 5 жыл бұрын
I have made this project. It is working properly. Every card is getting detected.on first time detection it is showing data in excel sheet and on second time detection it is not adding data in excel sheet. But i want to modify project like on second time detection,data should not display on excel if we are scanning card for second time within 1 minute after scanning for first time. After 1 minute if i scan same card then it should display data. Is it possible!? Please help me ASAP sir.
@rushanddie2350
@rushanddie2350 5 жыл бұрын
+1
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Send me an E-mail, I didn't get your point clearly.
@mahmoudswify5407
@mahmoudswify5407 5 жыл бұрын
did your problem solved cause i have the same problem
@urvashipawar5372
@urvashipawar5372 5 жыл бұрын
@@mahmoudswify5407 not yet
@amnaabdalwhab7679
@amnaabdalwhab7679 6 жыл бұрын
please i have question , if i have arduino mega what ss_pIN and RST_PIN will i use? thanks in advanced
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
SS_PIN: 53 RST_PIN: 49 MISO: 50 MOSI: 51 SCK: 52 You're welcome
@amnaabdalwhab7679
@amnaabdalwhab7679 6 жыл бұрын
thanks for your efforts
@prakharawasthi6953
@prakharawasthi6953 5 жыл бұрын
Thank you so much for this project it is working properly .... But if I want to upload the data ( name ; uid ; time in; time out ) in a MySQL server what should I do ! Please help !
@prakharawasthi6953
@prakharawasthi6953 5 жыл бұрын
One more thing is it possible without using nodemcu
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You're welcome, using MYSQLIO or CSV format google them for more information, But using NodeMCU is more effective and functional.
@prakharawasthi6953
@prakharawasthi6953 5 жыл бұрын
Thank you !
@Buuraley
@Buuraley 5 жыл бұрын
Can i use this idea to school attendance in Somalia
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Of course, use it as you want.
@tanmaybairagi7227
@tanmaybairagi7227 5 жыл бұрын
Please help me Sir, there is a problem while putting port=3 and baud=9600 in PLX-DAQ for excel. A popup comes and says- "COM Error: Error (5): CommOpen (CreateFile) - Access is denied. Aborting! " this is the complete problem. Please help me Overall code is running fine on serial moniter, Thank you for this.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hi, the Serial monitor must be closed while opening the PLX-DAQ tool.
@peterkylegingo336
@peterkylegingo336 3 ай бұрын
How do we add an LCD feature for this
@RobertoRuiz-st4qn
@RobertoRuiz-st4qn 3 ай бұрын
did you find the code?
@jimieejaimey4056
@jimieejaimey4056 3 ай бұрын
can someone please help? it somehow can't read the card. i don't know how to fix this problem 😭
@loveofmylife050711
@loveofmylife050711 6 жыл бұрын
hi, just want to ask if how many rfid card can 1 arduino handle?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
The Arduino can handle How many cards you want, I think. I advise you to make a program in any language you know to manage the whole process (Save data, Validation, Adding,.....) I mean the Arduino just detect the Cards then the program takes the rest.
@sarojgauli418
@sarojgauli418 4 жыл бұрын
hi sir, we have a project of RFID based attendance system. can you pleasw help me with that.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 жыл бұрын
What can i help you with?
@RohitKumar-ov5dz
@RohitKumar-ov5dz 6 жыл бұрын
Sir tell me that how we can setup log in time limit....so that log in entry should be done in that much time and same for log out....Sir plzz tell me
@ElectronicsTechHaIs
@ElectronicsTechHaIs 6 жыл бұрын
Unfortunately, you can't do that because The Time is supported by the excel tool, not the Arduino
@brahhhhh1296
@brahhhhh1296 5 жыл бұрын
sir, nice project and easy to understand. Can give other link for the PLX-DAQ for excel, i cant open the link Ty for sharing this project
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
I'm glad it was helpful. Here's another link to download: bit.ly/PLXDAQv2
@brahhhhh1296
@brahhhhh1296 5 жыл бұрын
@@ElectronicsTechHaIs ty very much bro
@brahhhhh1296
@brahhhhh1296 5 жыл бұрын
hey bro , need help . It said this when i trying to upload the code into RFID read personal data . warning: 'MFRC522::MFRC522(byte)' is >deprecated: use MFRC522(byte chipSelectPin, byte resetPowerDownPin) [-Wdeprecated-declarations] MFRC522Extended(uint8_t rst) : MFRC522(rst) {};
@tyaowei
@tyaowei 5 жыл бұрын
Hi, I need some advice on how can i edit the codes so that i am able to scan the tags multiple times even after scanning out? And how do i go about changing the user number?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Hello, then use this code: github.com/InfinityWorldHI/RFID_Excel/tree/master/RFID_Excel_Loop_save
@tyaowei
@tyaowei 5 жыл бұрын
@@ElectronicsTechHaIs I cant seem to add my own tags inside. Which line of code would that be?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
The same one, replace your IDs in Name1, Name2 and so on.
@katrieldimailig3316
@katrieldimailig3316 4 ай бұрын
is it possible to change from RFID to Biometric?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 4 ай бұрын
I have the biometric version of the project here's the link: kzbin.info/www/bejne/aqG0pXiIbbWGntksi=yfJZLvh6PfEIci8j
@jiayulai2666
@jiayulai2666 2 жыл бұрын
Do this also can use for esp32 controller?
@ElectronicsTechHaIs
@ElectronicsTechHaIs 2 жыл бұрын
Check out this video kzbin.info/www/bejne/aqG0pXiIbbWGntk
@johndagpin3001
@johndagpin3001 5 жыл бұрын
why does the code says exponent has no digits if i replace the rfid code with mine
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
I've upgraded the code to make it simple and more functional, So I hope the new code help you with no problem.
@semitronicsgroup3583
@semitronicsgroup3583 5 жыл бұрын
How to connect led and buzzer
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
You can find how in: bit.ly/RFID-UNO-Mega
@badamgaravorgilbayar5539
@badamgaravorgilbayar5539 3 жыл бұрын
What should change if I can't read my card
@ElectronicsTechHaIs
@ElectronicsTechHaIs 3 жыл бұрын
Check the RFID wiring, use an example from the examples to test it.
@tmtnsbro
@tmtnsbro 5 жыл бұрын
How do I add more people to the system? Thank you in advance.
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Check the code and read the comments. Name1, Name2..... and so on. You're welcome.
@leeenrickcaminade5965
@leeenrickcaminade5965 5 жыл бұрын
Hi . i use mega is it ok that the pin of arduino uno . i used to mega 2560 ? thanks your video is good
@ElectronicsTechHaIs
@ElectronicsTechHaIs 5 жыл бұрын
Yes, you can use Arduino mega by connecting the RFID-RC522 to it like this: SS_PIN: 53 RST_PIN: 49 MISO: 50 MOSI: 51 SCK: 52 You're welcome
ESP8266 RFID Attendance System with Google Sheets
9:39
Viral Science - The home of Creativity
Рет қаралды 12 М.
How to use RFID  (RC522) with Arduino - Easy Tutorial
13:38
Enjoy Mechatronics
Рет қаралды 65 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 25 МЛН
Arduino RFID Card Reader with OLED Display
3:33
Nudge Me
Рет қаралды 21 М.
RFID RC522 Based Attendance System Using Arduino with Data Logger
10:01
How To Electronics
Рет қаралды 90 М.
RFID DOOR LOCK -  with 3D printed case
15:12
Electronoobs
Рет қаралды 87 М.
RFID Card Attendance System with Arduino
5:13
AG Mix - Arnav Gupta
Рет қаралды 9 М.
8 Товаров с Алиэкспресс, о которых ты мог и не знать!
49:47
РасПаковка ДваПаковка
Рет қаралды 178 М.
Ba Travel Smart Phone Charger
0:42
Tech Official
Рет қаралды 1,2 МЛН
Запрещенный Гаджет для Авто с aliexpress 2
0:50
Тимур Сидельников
Рет қаралды 1 МЛН
Хакер взломал компьютер с USB кабеля. Кевин Митник.
0:58
Последний Оплот Безопасности
Рет қаралды 2,3 МЛН