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.....!
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..
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
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.
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?
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.
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 ?
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.
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
You're welcome. first, check out this video: ua-cam.com/video/dXZiFx6RP6s/v-deo.html 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.
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.'
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.
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!
hi, i just want to ask. i've tried using 2 rfid one inside and outside of the door for time in and out. but the plaxdaqv2 can't have more than 1 com port in 1pc/laptop.
you can't connect two Arduino with PLX-DAQ. So to solve that use Arduino mega with two RFID modules and set one for Time In and the other one for Timeout then read the tags to send the data to Excel tool but you can use just one RFID module and nodeMCU with a web interface and save all needed data in a Database and make it professional
thank you so much for your answer. i'll give you a feed back after i finished connecting the two rfid's in one arduino UNO by just jumping wires using bread board??.
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
@@ElectronicsTechHaIs I see you added another folder which is RFID_Excel.. but i already have this code. i maybe misunderstanding something, the code at 1:00, is the same which is in RFID_Excel but 'UPDATED' ?
@@ElectronicsTechHaIs 1 more thing, i have the cards ready, but i can't find the ID of them, can you tell me how to find it ? byte card_ID[4]; //card UID size 4byte byte Name1[4]={0x99,0x35,0x72,0xA9};//first UID card byte Name2[4]={0x8B,0x25,0x8F,0xB9};//second UID card i will add 3 more because i have 5 cards but i can't find the id of the cards i have Thanks in advance
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....
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.
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.
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?
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.
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
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, ua-cam.com/video/dXZiFx6RP6s/v-deo.html let me know if you faced any issues.
Hello sir, it is not showing the incoming time after scanning the card second time, The output is below what should be done to show the incoming time also, ID Date Name Number Card ID Time IN Time OUT 1 07-01-2019 Fiveth employee 789101 16217899 12:37:32 PM 2 07-01-2019 Fourth employee 789101 234707899 12:37:44 PM 3 07-01-2019 Third employee 789101 251247799 12:37:57 PM 4 07-01-2019 Second employee 789101 44327899 12:38:12 PM 5 07-01-2019 First employee 123456 1621267899 12:38:25 PM 6 07-01-2019 First employee 123456 1621267899 12:38:30 PM 7 07-01-2019 Second employee 789101 44327899 12:38:49 PM
Hi, I made the code like that because I want the card to be scanned just once to log in and log out so the scanned card will not record the incoming time again after its log out.
@@pallavilambe2503 Ok, Then you should make these changes on the code: if(NumbCard[j] == 1 && statu[s] == 0){ statu[s]=1; NumbCard[j] = 0; and: else if(NumbCard[j] == 0 ){ NumbCard[j] = 1; statu[s]=0;
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.
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
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.
Then use this code bit.ly/RFID_Excel-6Tags and modified it as you want it will send to Excel these parameters "ID,Date,Name,Number,Time IN,Time OUT" i hpoe you got it.
It's very simple just initialize the library with the numbers of the interface pins as you want. like: LiquidCrystal LCD (1, 2, 3, 4, 5, 6); LCD RS pin to digital pin 1 LCD En pin to digital pin 2 LCD D4 pin to digital pin 3 LCD D5 pin to digital pin 4 LCD D6 pin to digital pin 5 LCD D7 pin to digital pin 6
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
Sure as I explain in the video use this updated code follow line 20: github.com/InfinityWorldHI/RFID_Excel/blob/master/RFID_Excel_Loop_save/RFID_Excel_Loop_save.ino
@@ElectronicsTechHaIs Im sorry but I dont exactly know what you meant. Do I have to replace those with my cards own UID cause even after I did that my serial scanner still wont scan the tags.
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
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
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;
There is a specific RFID module with minimum read distance of over 1 meter: 860 ~ 960 MHz. Ultra High Frequency (UHF) Passive RFID Tags but this module has a short distance and you can't upgreud his antenna
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?
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.
ok when i present a tag to the reader i get one line of text in excel. this shows the parameters ive selected as in name, id ,time in and time out, i want to use this to track tooling coming in and out of my workshop from the shop floor. so i need one tag to write multiple lines in excel so i can save the sheet in the tooling folder and track who when and how long the tool has been on the shop floor. but i present one tag i get the time in and time out then i have to press the disconnect icon on plx-daq for the same tag to work again. hope that makes more sense ?
Sorry for being late. I recommended reading the Beginners Guide to PLX DAQ v2 (rev1) to figure out how the process is done, then you can make your own code simply with a particular parameter, bearing in mind you can't do any mathematical operation in the Excel tool automatically. So If you interested in this project I'm going to publish a new version using the internet and nodeMCU as a professional project this weekend. Stay close. Cheers.
I used your code to save and close to excel. İt worked but I couldnt find the excel folder named as 'Names/WorkNames'. Where did it go? Can you help me sir?
Sorry cause I didn't explain it in the source code. "Names" is the folder where the excel file will saved, You have to create New Folder in the same folder where The Excel tool existed and name it "Names". The Excel file Will save by any given name like "WorkNames". You can change it. Here's the basic: Serial.println(“SAVEWORKBOOKAS,Subfolder\Workbookname”); In my case Subfolder : Names Workbookname : WorkNames I hope that was helpful for you.
I see. Another sir. Can i have a copy of your program about professional attendance monitoring system using php and Mysql? Using Node.Thanks in advance sir.
Yes, I know, Just uncomment this line in the new code " Serial.println(CardID); " in order to get the IDs in string format. then copy them into the main code then upload it. you don't need to upload another code to get the IDs.
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.
Electronics Tech ^_^ thanks for the reply I am planning to create a database out of it. and record everytime tberes a scan. And I will incorplrate it to Excel to record.
Ok. you must build a program that record everything come from the Arduino then after analysing the coming data it sends the data to excel sheet. you can use python to build it. It's simple, You need these libraries pyserial (to receive the data from the Arduino) and openpyxl or XlsxWriter(to connect with excel)
Hi there, While connecting with PLX-DAQ, it shows this problem COM Error: Error (53): CommOpen - File not found: kernel32 Can you please help me fix this? I am using mac os
@@ElectronicsTechHaIs how do you get the plx-daq to work in mac. It comes up with the serial port error. My serial port is not a number like COM 1 its a text
Hi It's very urgent can you please help me ? I am working on a project which is quite same as you'd shown in your video except that I have to import this excel data that is updating as I scan my rifd card to MATLAB So, I wanted to know that can this excel file which is in communication with PLX-DAQ can be used for importing data to MATLAB
Yes, you can do that with Matlab. I think. just use the xlsread function in your Matlab code Bearing in mind you must modify the Arduino code to save the excel file once it detects new card and don't forget to determine where the excel file save.
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.
@@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
Hi. Can you help me? My group and I is at our final year. We need to conduct a project. So, we decide to make a project consist of RFID module, Arduino and ethernet shield. We also use MySQL as a database and we will connect all of them to make a key management system. Which is, everytime the key tag and ID card is being scan, all the data will be saved into our database. And also the time and date. If you're understand, will you help us? Cause we really need a tutor.
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 !
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
if you don't want the excel to close just clear these lines from the main code or put them in a comment like this: /*if(n==2){ Serial.println("SAVEWORKBOOKAS,Names/WorkNames"); Serial.println("FORCEEXCELQUIT"); }*/
@@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
I have the same problem , for example i've set tthis UID: 04 8F D3 9A as the 1st card but when i set the second card like this UID: 64 25 CD 9A it still read as the 1st card even though it should be the 2nd.
Hi, I've been trying to fix this bug in the code as you said but in my case, everything works perfectly even with more than 20 cards, So try If you can find the problem.
hello sir, i find this was cool for programming noob like myself. But suddenly i challenge myself built a project similar with time attendance. I was making a device for security guard to tag the card that i already set up on some locations. but i couldn't find some example for my arduino. i'm planning that the device has to record the security IDTag before he could do his patrol to tag the cards. I just needed the name of the security that tag the card locations with date and time. i knew i needed RTC, some LED, SDCARD (to write the records in csv), Speaker, LED's (optional). the big problem i got is...how to write the codes...could you help me with some pointer or examples?
Hi, That's not a big problem my friend, In the next video, I will talk about saving the data on SD card using the SD module and Arduino. Maybe I will make like this project but with SD and RTC. So stay tuned.
@@ElectronicsTechHaIs wow i would appreciate if you could make a project samples. I only manage recording the locations (using idtags), dates and times..but then i realize...this has to be in order. I dont want the security tagging the location twice...they have to tag all the locations first and then the other patrol guys do the next routine. Because i'm quite noob with c++...i couldn't come up with the codes...but thanks anyway...i'm hoping this project could help others too
Hi, my friend. I'm working on a new video about Arduino with RTC, SD card and RFID. So if you have any ideas about that or you want something specific please email me on "electbusinees@gmail.com"
String Name1="Put it here";//first UID card considering the ID is from the same code that will appear when you scan the card, not from another one. Don't forget to uncomment this line //Serial.println(card_ID); in order to let the IDs appear on the Serial monitor
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.
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
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.
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 .
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;
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
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 ;)
String Name1="Put ID here";//1th UID card String Name3="Put ID here";//3th UID card and so on. else if(card_ID==Name3){ Name="Third employee";//user name Number=789101;//user number j=2;//++1 s=2;//++1 } just like that.
it might be broken, So make sure the connections were correctly then uploading an example "ReadUID" and try it. If there nothing on the serial monitor then it's broken.
@@ElectronicsTechHaIs The Reader can't really read my card. what part of the code should I insert my card number or what part of the code should I change? PS. my RFID reader and cards are working fine because I just tried out the examples from the library.
First, uncomment this line //Serial.println(card_ID); in order to make the Card ID appear on the Serial Monitor then upload the code After scanning all your card put the ID here String Name1="Your Card ID as it appears on the serial";//first UID card
Hi sir, I've tested out your code, but I'm having a problem. I've tested five different cards but it seems that once I've tapped a second card, the system registers it as a time out. Also, I've noticed that some of the cards display the same name although I've registered them as different user name. What do you think is the cause of these problems sir? I badly need your help sir, thanks.
Recently, I've tested the code several times using different cards and a different RFID module and everything works perfectly. First, make sure you have the correct ID for your cards and try this code bit.ly/RFID_Excel-6Tags by replacing the ID of the cards with yours. Then check whether Arduino discovers each card correctly by its name and number. The IDs that begin with the same number and character might cause a problem. I hope that helps you.
Thank you for your response sir. I'm sure that the UIDs that I've put when I tested the code were correct because I've used the same test/read code that you've used. By the way, is it possible to change the UID of the cards? Or is there a way to solve this problem (by adding some sort of command or function to the code) so that I can prevent from buying tons of rfid cards and dumping the IDs that have the same first numbers or characters?
Yes, you can change it only if it's a changeable one, you can use a changeUID example in MFRC522 Examples and set a customised UID. I encourage you to try to solve it by your self. I'm working to fix this bug, hoping works.
Thank you sir. I will try to find a solution to this as well. I've got one more question sir, is it possible to display (in excel) only those who are absent using the plx daq?
Hi, Yes you can like using nodeMCU instead of Arduino to connected it the internet and access the website from anywhere, if you're interested check out my video: ua-cam.com/video/dXZiFx6RP6s/v-deo.html I hope that helps you in some way.
Hello please can you make a code where i would like to clock the time in and time out multiple times and with no display LCD or led or buzzer thanks much appreciated
@@ElectronicsTechHaIs can you also help me with clock in and out time and also i dont know how to give name to card so i know who is the owner of card. Thank you
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.....!
okay sir
using fingerprint please
Thank you very much sir!
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..
@@minalhingne1710 Yeah, me too. How to fix this. pls. help
I did this for my project and everyone loved it. Thank you so much ❤❤❤❤ you are such a smart man. Hats off
Glad to hear that
Can you send the project report please
@jacqui How did you get the data updated into the excel sheet please can you help
Bro ??
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
when i try to upload it go denied.. help, also does this work with 400 holes breadboard?
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.
Yes you can do that, Google it
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?
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?
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.
that's a very good question.
Can you help me with the coding?
I really need help because I've chosen this as my thesis paper and I need to make a prototype
@@mrvnmedina0908 what happened to your thesis are you able to make it with a temperature sensor?
we have similar thesis :)
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 ?
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.
Hi, check if you modified the code correctly with your Card IDs.
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.
Oh, nevermind, i found out what's wrong, but thank you for noticing my comment.
Serial monitor is not showing any outputs? The light on arduino uno and rfid module is working, what should I do
Make sure the serial monitor baudrate is set correctly to 9600
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
You're welcome.
first, check out this video: ua-cam.com/video/dXZiFx6RP6s/v-deo.html
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.
can i ask how can you modify the nfc to a specific name?
Good day Sir
Can a use it for :Time in/out ? (Calculate the time between 2 uses of 1 RFID card)
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
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.'
Thanks man, you really save me with this video, thank you so much.
It's my pleasure
I'm glad it was helpful
What are the LCD pins and LED
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.
+1
Send me an E-mail, I didn't get your point clearly.
did your problem solved cause i have the same problem
@@mahmoudswify5407 not yet
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!
hi, i just want to ask. i've tried using 2 rfid one inside and outside of the door for time in and out. but the plaxdaqv2 can't have more than 1 com port in 1pc/laptop.
you can't connect two Arduino with PLX-DAQ.
So to solve that use Arduino mega with two RFID modules and set one for Time In and the other one for Timeout then read the tags to send the data to Excel tool
but you can use just one RFID module and nodeMCU with a web interface and save all needed data in a Database and make it professional
thank you so much for your answer. i'll give you a feed back after i finished connecting the two rfid's in one arduino UNO by just jumping wires using bread board??.
@Electronics Tech I've done it. now for the last question. can i add as many cards as i want?
Of course, you can.
resistors and capacitors are not needed anymore right?
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
Sir please reply we have to submit project by tomorrow
Did you solved this?
Can you please explain how to add the two LEDs and the buzzer?
hai sir, instead of using excel, how to connect to database and view in website?
Hi check out my video:
ua-cam.com/video/dXZiFx6RP6s/v-deo.html
I hope that helps you in some way.
@@ElectronicsTechHaIs Thank you very much sir.
How about from laundry machine to micrsoft excel sir?
What do you mean?
hey. I can not get my No. 2 card up in excel. what could the problem be?
Where is the code at 1:00 in the background? i can't find it in the folders that i downloaded from your link
Recently, I've upgraded it, but I will upload it to the same link(RFID_Excel), So check it: github.com/InfinityWorldHI/RFID_Excel
@@ElectronicsTechHaIs I see you added another folder which is RFID_Excel.. but i already have this code.
i maybe misunderstanding something, the code at 1:00, is the same which is in RFID_Excel but 'UPDATED' ?
@@saltyporo4565 Oh that code doesn't relate to the video, that for my CNC.
@@ElectronicsTechHaIs Oh okay, that confused me for a bit, thank you for replying in time
@@ElectronicsTechHaIs 1 more thing, i have the cards ready, but i can't find the ID of them, can you tell me how to find it ?
byte card_ID[4]; //card UID size 4byte
byte Name1[4]={0x99,0x35,0x72,0xA9};//first UID card
byte Name2[4]={0x8B,0x25,0x8F,0xB9};//second UID card
i will add 3 more because i have 5 cards but i can't find the id of the cards i have
Thanks in advance
Good day! Can we convert the RFID to QR code generated attendance system?
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....
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.
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
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.
this is very helping for us students, thank you!
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?
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.
@@ElectronicsTechHaIs it says that cannot run macro or disabled, how to fix this
I see, After opening the Excel sheet you have to allow running the macro (yellow warning message at the top).
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
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, ua-cam.com/video/dXZiFx6RP6s/v-deo.html
let me know if you faced any issues.
please i have question , if i have arduino mega what ss_pIN and RST_PIN will i use?
thanks in advanced
SS_PIN: 53
RST_PIN: 49
MISO: 50
MOSI: 51
SCK: 52
You're welcome
thanks for your efforts
Hello sir, it is not showing the incoming time after scanning the card second time, The output is below what should be done to show the incoming time also,
ID Date Name Number Card ID Time IN Time OUT
1 07-01-2019 Fiveth employee 789101 16217899 12:37:32 PM
2 07-01-2019 Fourth employee 789101 234707899 12:37:44 PM
3 07-01-2019 Third employee 789101 251247799 12:37:57 PM
4 07-01-2019 Second employee 789101 44327899 12:38:12 PM
5 07-01-2019 First employee 123456 1621267899 12:38:25 PM
6 07-01-2019 First employee 123456 1621267899 12:38:30 PM
7 07-01-2019 Second employee 789101 44327899 12:38:49 PM
Hi,
I made the code like that because I want the card to be scanned just once to log in and log out so the scanned card will not record the incoming time again after its log out.
Thank you for your response, i want to scan the card more than 2 time then, in program where i have to do change
@@pallavilambe2503
Ok, Then you should make these changes on the code:
if(NumbCard[j] == 1 && statu[s] == 0){
statu[s]=1;
NumbCard[j] = 0;
and:
else if(NumbCard[j] == 0 ){
NumbCard[j] = 1;
statu[s]=0;
Pallavi lambe which code did u used for this?
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
Yes, of course you can use NFC, you just need a NFC reader
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.
Hi, the Serial monitor must be closed while opening the PLX-DAQ tool.
How do we add an LCD feature for this
did you find the code?
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
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.
Hi 😂
I followed all the instruction but when it's time to read the NFC tags it doesn't appear it just only "Name,Number, Date, Time"
Then use this code bit.ly/RFID_Excel-6Tags and modified it as you want
it will send to Excel these parameters "ID,Date,Name,Number,Time IN,Time OUT"
i hpoe you got it.
@@ElectronicsTechHaIs How about with LCD? I'm using 16x2 LCD with just 8 wires
It's very simple just initialize the library with the numbers of the interface pins as you want. like:
LiquidCrystal LCD (1, 2, 3, 4, 5, 6);
LCD RS pin to digital pin 1
LCD En pin to digital pin 2
LCD D4 pin to digital pin 3
LCD D5 pin to digital pin 4
LCD D6 pin to digital pin 5
LCD D7 pin to digital pin 6
@@ElectronicsTechHaIs It's not working it just show one letter "f"
because you have to change the RedLed and GreenLed pins to different pins like A0, A1 then reconnect the LCD and it's should work just fine.
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
Hi, what is the error message?
Hello is there by any chance to get the code to use 3 or more cards? I tried changing variables but it wont work
Sure as I explain in the video use this updated code follow line 20:
github.com/InfinityWorldHI/RFID_Excel/blob/master/RFID_Excel_Loop_save/RFID_Excel_Loop_save.ino
@@ElectronicsTechHaIs Im sorry but I dont exactly know what you meant. Do I have to replace those with my cards own UID cause even after I did that my serial scanner still wont scan the tags.
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
Check if the Serial Monitor from the Arduino IDE is open then close it. it should work just fine.
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
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
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;
Electronics Tech thank you very much. Tomorrow I'll try and I'll tell you how it's work 😊
please i have another question ,how can i make it read id from long distance like 80 cm as example ؟
Unfortunately, you can't do that using this RFID module.
even if using external Antenna with it ؟
There is a specific RFID module with minimum read distance of over 1 meter: 860 ~ 960 MHz. Ultra High Frequency (UHF) Passive RFID Tags
but this module has a short distance and you can't upgreud his antenna
thanks
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?
Hello, then use this code: github.com/InfinityWorldHI/RFID_Excel/tree/master/RFID_Excel_Loop_save
@@ElectronicsTechHaIs I cant seem to add my own tags inside. Which line of code would that be?
The same one, replace your IDs in Name1, Name2 and so on.
if i want use a 20x4 display what is the programation?
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.
hi how can i get this to create multiple lines in excel so i don't have to disconnect and re connect each time i swipe the card/tag
sorry I didn't get your question.
ok when i present a tag to the reader i get one line of text in excel. this shows the parameters ive selected as in name, id ,time in and time out, i want to use this to track tooling coming in and out of my workshop from the shop floor. so i need one tag to write multiple lines in excel so i can save the sheet in the tooling folder and track who when and how long the tool has been on the shop floor. but i present one tag i get the time in and time out then i have to press the disconnect icon on plx-daq for the same tag to work again.
hope that makes more sense ?
how do i get it to repeat/reset and start a new line once tag is scanned a second time ?
Sorry for being late.
I recommended reading the Beginners Guide to PLX DAQ v2 (rev1) to figure out how the process is done, then you can make your own code simply with a particular parameter, bearing in mind you can't do any mathematical operation in the Excel tool automatically.
So If you interested in this project I'm going to publish a new version using the internet and nodeMCU as a professional project this weekend.
Stay close.
Cheers.
there's an error when i upload the code, it says it can't open the device "\\. \ COM 1" The system cannot find the file specified.
can someone pls helpp 😭
Select the port properly, also try changing the ports you are connecting
thanks! it worked. but now my problem is that the RFID can't read the card.
I used your code to save and close to excel. İt worked but I couldnt find the excel folder named as 'Names/WorkNames'. Where did it go? Can you help me sir?
Sorry cause I didn't explain it in the source code.
"Names" is the folder where the excel file will saved,
You have to create New Folder in the same folder where The Excel tool existed and name it "Names".
The Excel file Will save by any given name like "WorkNames". You can change it.
Here's the basic:
Serial.println(“SAVEWORKBOOKAS,Subfolder\Workbookname”);
In my case
Subfolder : Names
Workbookname : WorkNames
I hope that was helpful for you.
Thank you bro. I did it thanks to you :)
Hi. I just want to know how to record the time in and time out for this one in the excel?
the time in and time out are recorded when the Arduino sends the Data to the Excel using this line Serial.println("DATA, TIME");
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
Glad to hear that,
You can check out the codes in my github repository, the link in the video description
Sir, it is possible to make the same column in logout? ex. Name1 TimeIn 7:00 TimeOut 11:35 in the same row without appearing another row in logout.
No, you can't update an existing row.
I see. Another sir. Can i have a copy of your program about professional attendance monitoring system using php and Mysql? Using Node.Thanks in advance sir.
Of course, Here you can find all that you need: github.com/InfinityWorldHI/NodeMCU
Thanks so much sir. You and your channel are awesome! 1million thumbs up sir!
My pleasure, thanks
Good to hear that.
The code you are using includes card uids in byte but in the files they are in strings,what should i do?
Yes, I know, Just uncomment this line in the new code " Serial.println(CardID); " in order to get the IDs in string format. then copy them into the main code then upload it. you don't need to upload another code to get the IDs.
Contact me on my facebook page for more information.
Is it possible to close the Excel window while the acquistion goes ahead?
Yes its possible, Check the included PDF.
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
Hi, It isn't that difficult to modify, check google there is plenty of examples about that.
how can i add sd card module for the program to save the information if anything happened in the excel
You need to add SD module and save the data inside it as JSON or as txt file.
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.
Hi, send to this email your problems with the code, and I will help you with it.
electbusinees@gmail.com
is it possible for me to build at database for me to track records through excel file then add new excel page for the next transaction?
Sorry I didn't understand your question
Electronics Tech ^_^ thanks for the reply
I am planning to create a database out of it. and record everytime tberes a scan. And I will incorplrate it to Excel to record.
Ok. you must build a program that record everything come from the Arduino then after analysing the coming data it sends the data to excel sheet.
you can use python to build it. It's simple, You need these libraries pyserial (to receive the data from the Arduino) and openpyxl or XlsxWriter(to connect with excel)
You can check out my video:
ua-cam.com/video/dXZiFx6RP6s/v-deo.html
I hope that helps you in some way.
Hi there,
While connecting with PLX-DAQ, it shows this problem
COM Error: Error (53): CommOpen - File not found: kernel32
Can you please help me fix this?
I am using mac os
Hi,
Check the serial monitor it must be closed.
@@ElectronicsTechHaIs where is the serial monitor?
@@kabirajkhatri5942 In the Arduino IDE.
@@ElectronicsTechHaIs how do you get the plx-daq to work in mac. It comes up with the serial port error. My serial port is not a number like COM 1 its a text
Sir this is amazing project this is owsome 😀♥
You're Welcome.
I'm glad you liked.
@@ElectronicsTechHaIs thanku so much sir
Hi
It's very urgent can you please help me ?
I am working on a project which is quite same as you'd shown in your video except that I have to import this excel data that is updating as I scan my rifd card to MATLAB
So, I wanted to know that can this excel file which is in communication with PLX-DAQ can be used for importing data to MATLAB
Yes, you can do that with Matlab. I think.
just use the xlsread function in your Matlab code
Bearing in mind you must modify the Arduino code to save the excel file once it detects new card and don't forget to determine where the excel file save.
thank you so much...
It's my pleasure.
Should I need to buy the office by microsoft to use the exel sheet .sir please
No you don't have to.
Please i need to know what pins did you used LEDs and how
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.
@@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
Hi. Can you help me?
My group and I is at our final year. We need to conduct a project.
So, we decide to make a project consist of RFID module, Arduino and ethernet shield. We also use MySQL as a database and we will connect all of them to make a key management system. Which is, everytime the key tag and ID card is being scan, all the data will be saved into our database. And also the time and date. If you're understand, will you help us? Cause we really need a tutor.
We really need your help. Cause we think you're the right person to ask for. We're looking forward for your reply. Also thanks in advanced.
You're welcome.
What can I do for helping you?
HI GOOD EVENING. what kind of card did you use?
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
You're Welcome.
They already connected to it.
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 !
One more thing is it possible without using nodemcu
You're welcome, using MYSQLIO or CSV format google them for more information, But using NodeMCU is more effective and functional.
Thank you !
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?
the serial must be closed in order to send data to excel sheet correctly.
does it need to be connect to the system while scanning the RFID tag?
Yes
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
Hello, Please, recheck on the wiring and try to upload an example from the library examples.
when i open excell sheet it takes data of 1 or 2 users and automatically closed..kindly help me about this
if you don't want the excel to close just clear these lines from the main code or put them in a comment like this:
/*if(n==2){
Serial.println("SAVEWORKBOOKAS,Names/WorkNames");
Serial.println("FORCEEXCELQUIT");
}*/
can we also include like the person’s temperature in the excel?
Anything you want.
@@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
Sir i have error saying that expected '}'before"DD" when i enter the uid of my card and sketch it sir
Leave the whole line where the error occurred, please.
@@ElectronicsTechHaIs this is the code where it get error byte Name1[4]={39 DD 0A C2};//first UID card
Hi, thanks for the video, but i have a problem, the code read differents cards like same, help me please
Check if the Card ID's start by the same character this might make a problem .
I have the same problem , for example i've set tthis UID: 04 8F D3 9A as the 1st card but when i set the second card like this UID: 64 25 CD 9A it still read as the 1st card even though it should be the 2nd.
Hi, I've been trying to fix this bug in the code as you said but in my case, everything works perfectly even with more than 20 cards, So try If you can find the problem.
Hello
I fixed the problem in the code.
And it will be available in the weekend
hello sir, i find this was cool for programming noob like myself. But suddenly i challenge myself built a project similar with time attendance. I was making a device for security guard to tag the card that i already set up on some locations. but i couldn't find some example for my arduino. i'm planning that the device has to record the security IDTag before he could do his patrol to tag the cards. I just needed the name of the security that tag the card locations with date and time.
i knew i needed RTC, some LED, SDCARD (to write the records in csv), Speaker, LED's (optional). the big problem i got is...how to write the codes...could you help me with some pointer or examples?
Hi,
That's not a big problem my friend, In the next video, I will talk about saving the data on SD card using the SD module and Arduino. Maybe I will make like this project but with SD and RTC.
So stay tuned.
@@ElectronicsTechHaIs wow i would appreciate if you could make a project samples. I only manage recording the locations (using idtags), dates and times..but then i realize...this has to be in order. I dont want the security tagging the location twice...they have to tag all the locations first and then the other patrol guys do the next routine. Because i'm quite noob with c++...i couldn't come up with the codes...but thanks anyway...i'm hoping this project could help others too
It will be good if you can email me with all the things that you want.
And You're welcome.
@@ElectronicsTechHaIs well..here's my email gonzhilaz@gmail.com
Hi, my friend.
I'm working on a new video about Arduino with RTC, SD card and RFID. So if you have any ideas about that or you want something specific please email me on "electbusinees@gmail.com"
Bro i didn't understand where i put my tag number in RFID_Excel_login please tell bro
String Name1="Put it here";//first UID card
considering the ID is from the same code that will appear when you scan the card, not from another one.
Don't forget to uncomment this line //Serial.println(card_ID); in order to let the IDs appear on the Serial monitor
hi sir, we have a project of RFID based attendance system. can you pleasw help me with that.
What can i help you with?
hi, just want to ask if how many rfid card can 1 arduino handle?
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.
COM Error: Error (5): CommOpen (cresteFile) - Acesso Negado
Como corrigir?
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
Unfortunately, you can't do that because The Time is supported by the excel tool, not the Arduino
is it possible to change from RFID to Biometric?
I have the biometric version of the project here's the link:
ua-cam.com/video/4pQtER8PShw/v-deo.htmlsi=yfJZLvh6PfEIci8j
can we also include thermal sensor in the hardware part?
Of course you can.
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
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.
how to add the liquidcrystal library in the code
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 .
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;
how many I'd data stored in Arduino??
ex: 50 identifications
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
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 ;)
How do I add more people to the system? Thank you in advance.
Check the code and read the comments. Name1, Name2..... and so on. You're welcome.
Sir how can I put third card only two card uplod in to program no third and more card please help?
Check the comments in the code.
hello how do I do the code with 3 cards?? only 2 cards are being detected please help meee
String Name1="Put ID here";//1th UID card
String Name3="Put ID here";//3th UID card and so on.
else if(card_ID==Name3){
Name="Third employee";//user name
Number=789101;//user number
j=2;//++1
s=2;//++1
}
just like that.
RFID Reader can't read the cards. I don't know what is the problem
it might be broken, So make sure the connections were correctly then uploading an example "ReadUID" and try it.
If there nothing on the serial monitor then it's broken.
@@ElectronicsTechHaIs The Reader can't really read my card. what part of the code should I insert my card number or what part of the code should I change?
PS. my RFID reader and cards are working fine because I just tried out the examples from the library.
First, uncomment this line //Serial.println(card_ID); in order to make the Card ID appear on the Serial Monitor then upload the code After scanning all your card put the ID here String Name1="Your Card ID as it appears on the serial";//first UID card
@@ElectronicsTechHaIs Thank you very much for replying sir. It's okay now.
@@kristiankennethallag5328 howwwww pls
why does the code says exponent has no digits if i replace the rfid code with mine
I've upgraded the code to make it simple and more functional, So I hope the new code help you with no problem.
Can i use this idea to school attendance in Somalia
Of course, use it as you want.
i need format to the id card i hot the numbers but i dont know the format please help
The Card ID is in a String format
Hi sir, I've tested out your code, but I'm having a problem. I've tested five different cards but it seems that once I've tapped a second card, the system registers it as a time out. Also, I've noticed that some of the cards display the same name although I've registered them as different user name. What do you think is the cause of these problems sir? I badly need your help sir, thanks.
Recently, I've tested the code several times using different cards and a different RFID module and everything works perfectly.
First, make sure you have the correct ID for your cards and try this code bit.ly/RFID_Excel-6Tags by replacing the ID of the cards with yours. Then check whether Arduino discovers each card correctly by its name and number. The IDs that begin with the same number and character might cause a problem.
I hope that helps you.
Thank you for your response sir. I'm sure that the UIDs that I've put when I tested the code were correct because I've used the same test/read code that you've used. By the way, is it possible to change the UID of the cards? Or is there a way to solve this problem (by adding some sort of command or function to the code) so that I can prevent from buying tons of rfid cards and dumping the IDs that have the same first numbers or characters?
Yes, you can change it only if it's a changeable one, you can use a changeUID example in MFRC522 Examples and set a customised UID.
I encourage you to try to solve it by your self.
I'm working to fix this bug, hoping works.
Thank you sir. I will try to find a solution to this as well. I've got one more question sir, is it possible to display (in excel) only those who are absent using the plx daq?
Of course, you can do that.
Hello, i want to add a counter for every card, is it possible?
Of course, you could
first, you should declare the counter then increased it by one each time a card is detected
IT will be 0 again If i reset the arduino?
Yes, unless you used an EEPROM to store the counter value then the counter will always be saved.
Hello sir, Can it possible to access data online like on google, if possible plz tell me the procedure
Hi, Yes you can like using nodeMCU instead of Arduino to connected it the internet and access the website from anywhere, if you're interested check out my video: ua-cam.com/video/dXZiFx6RP6s/v-deo.html
I hope that helps you in some way.
thanks lot sir
sir plz help me how to make attendance system using MAC address of mobile phone .............
tell me the components required for it.
You want to check-in using just your mobile connection to WIFi?
@@ElectronicsTechHaIs tell me the connection , components and codes
Hello please can you make a code where i would like to clock the time in and time out multiple times and with no display LCD or led or buzzer thanks much appreciated
Yes, I will send the code to your E-mail.
@@ElectronicsTechHaIs thank you but it needs to be on excel
@@ElectronicsTechHaIs can you also help me with clock in and out time and also i dont know how to give name to card so i know who is the owner of card. Thank you