Radio Frequency Identification (RFID) based attendance system using NodeMCU Google Sheet in Hindi

RFID with MySQL server
• Radio Frequency identi...
Code: spamlabs.tech/
Radio Frequency Identification (RFID) based attendance system is one of the solutions to address this problem. This system can be used to take attendance for students in school, college, and university. It also can be used to take attendance for workers in working places. Its ability to uniquely identify each person based on their RFID tag type of ID card make the process of taking the attendance easier, faster, and more secure as compared to the conventional method. Students or workers only need to place their ID cards on the reader and their attendance will be taken immediately. With the real-time clock capability of the system, attendance taken will be more accurate since the time for the attendance taken will be recorded.
Here We are going to connect Node MCU ESP8266 and RFID- RC522 with MYSQL Database. So for that first, we should connect our Node MCU ESP8266 Board with RFID Module. By using the RFID Module we are going to scan our RFID card and tag which are allowed or not. And by using our ESP8266 we are going to send that data to our google sheet, and also to MySQL server .
link to download all code and diagram:
Download Code Visit:- spamlabs.tech/
arduino projects, arduino projects hindi, arduino projects for beginners in hindi, rfid sensor with arduino, mfrc522 rfid module, door lock system arduino, door locking system arduino, rfid card arduino tutorial, rfid door locking system, rfid based door access control using arduino, rfid based door locking system, rfid door lock arduino uno, arduino door locking system, easy arduino projects in hindi, easy arduino projects 2019

[@testicloud7683]

sir wonderful explanation video.. so thankful wishes..👌👌👌👌👌👌👌👌👌👏🏻👏🏻👏🏻

[@YPTechDATIA]

Thanks

[@Rahul_._rathod_]

I am getting error telling
"D3 was not declared in this scope "

[@Ammy-bc6bh]

That is a great project. Thank for sharing it

[@attariazeddine6603]

Excellente présentation. Merci et bonne continuation...

[@YPTechDATIA]

Thank you

[@ghulamghous8861]

Great. Thanks for sharing

[@muzaffarhussainsayyed8010]

Supper video hai apne explanation Kiya hai

[@YPTechDATIA]

Thank you

[@naveenbro3495]

sir can you share the link of materials used for this project [for purchasing these materials]

[@user-iz5vn4rs2p]

sir code read nhi kr rha h rfid card reader m
can you help me out?

[@YPTechDATIA]

Mail me [e-mail]

[@01_sohamambekar85]

from where do you buy sensors and chips

[@YPTechDATIA]

Many portals are there , just search and check which is cheaper

[@chaprigamer2744]

Sir Jo code aapna note pad ma write kiya hai usa kaise run karna hai ?

[@YPTechDATIA]

Arduino ide me run karna aur nodemcu me upload mar dena

[@sushmass9917]

Sir I am not able to add data to rfid tag if I am scanning nothing is displaying in serial monitor

[@YPTechDATIA]

First you have to run code to write RFID, once the data will be written in card, then run the second program that read data from rfid

[@marlindolin2779]

sir how can i store much more information on RFID card?

[@YPTechDATIA]

only 128 bits, but why do you need to store more data? since you need to store only tag or metadata, rest data is fetched accroding to tag

[@Rahul_._rathod_]

I am getting error telling
"D3 was not declared in this scope " while writing the data on card

[@YPTechDATIA]

Please check the code carefully. Don't just copy and paste , try to understand the code and write proper syntax .

[@4b5bazishaheed3]

Sir we need to download node mcu,rfid library in aurdino ide ?

[@YPTechDATIA]

Yes install all necessary libraries for nodemcu

[@4b5bazishaheed3]

@@YPTechDATIA thank you so much sir

[@4b5bazishaheed3]

Sir can you help me to complete my project? ESP8266WiFi,ESP8266WiFiMulti
This library files are not showing in library manager 🥲

[@YPTechDATIA]

@@4b5bazishaheed3first download it from github then import zip library option se add kar lo, if you unable to find this , mail me [e-mail]
I will help you

[@4b5bazishaheed3]

@@YPTechDATIA sir i sent mail to your mail id sir plz reply

[@shivankjoshi8363]

Can this rfid reader read 13.56 MhZ as well?

[@YPTechDATIA]

Yes , even I used that type of card in this

[@anishkl]

My project is RFID Door lock system Using Nodemcu and i want to send data to Google spreadsheet, how can I do that Please help me.

[@YPTechDATIA]

I explained process of sending data to google sheet , you can try that code

[@YPTechDATIA]

If you want I will make a video , how to send data to google sheet and my SQL server from nodemcu

[@anishkl]

I have implemented the program for door lock system but I want to add this code which send data to Googlesheet

[@anishkl]

th-cam.com/video/Iwa7R7xYr2Q/w-d-xo.html my project is this

[@anishkl]

Please help me with this.

[@RGuri]

Sir mere pass NFC card reader device hai usko.chlana hai issi trah kiase chlau

[@YPTechDATIA]

I don't have NFC, but I can guide

[@RGuri]

@@YPTechDATIA okay sir please guide me for NFC

[@YPTechDATIA]

See all you have to do is to process the input signal , whether it is from NFC or RFID or any such thing

[@RGuri]

@@YPTechDATIA okay g

[@preetisingh8670]

ismai face identification bhi add krna ho to kese krenge?

[@YPTechDATIA]

You have to run 2 sperate programs , first a peron will scan his id and then he will face the camera . You can see my face recognition attendance system video for this

[@sacheatvellore9932]

Sir i cant find SHA 1 fingerprint in google. It is only showing sha 256 fingerprints. In windows 11

[@YPTechDATIA]

Avoid using this .

[@YPTechDATIA]

Check my code carefully , I didn't use that thing

[@captan8191]

Bro sha 1 fingerprint not showing in browser... Please help as soon as possible... Reply me please

[@captan8191]

How avoid this

[@YPTechDATIA]

Make client insecure

[@iddddd900]

Hi...How to write empty rfid card ?

[@YPTechDATIA]

I shared the method and code in this video

[@shivankjoshi8363]

Sir, It says,
Leaving, Hard resetting via RTS pin...

[@YPTechDATIA]

Means code was uploaded successfully

[@shivankjoshi8363]

@@YPTechDATIA sir it's reading but no updates happening on Google sheet.

[@YPTechDATIA]

Leave it for few minutes if the code is right , entries will be there

[@shivankjoshi8363]

@@YPTechDATIA sir can you please share your what's app number once 🙏

[@YPTechDATIA]

Check your email I shared already

[@adarshcjaneesh2255]

Sir 'D3 was not declared in this scope' problem plz Help me sir......

[@YPTechDATIA]

Type code correctly. Look carefully

[@adarshcjaneesh2255]

@@YPTechDATIA sir i am correctly opened the code but it not working. I am try this so many time but it not working.
What changing do for it.??

[@YPTechDATIA]

Which board are you using?

[@adarshcjaneesh2255]

@@YPTechDATIA sorry sir i forget to infom you its solved
Problem is selection in board manager i selected esp8266 generic.. And find the mistake and changed to another selection now problem is solved and working fine...
A Big Thanks sir for replying & #create a
Detailed explained video 🥰

[@MaddyM-hl5vj]

@@adarshcjaneesh2255 bro which board & programmer(processor) we have to select

[@chaprigamer2744]

Sir aurdino ma code ma d3 pa error Bata raha hai

[@YPTechDATIA]

kya error bata raha hai ?, agar pin change karna hai to code me bhi change kar dena

[@monukumar-no6np]

sir ji is system ko apne wordpress software ke saath kese jode

[@YPTechDATIA]

Iska data aap my SQL par le sakte hai aur word press se GUI par database se data fetch kar k dekh sakte hai report k form me . Data kaise fetch karna hai ye php wali playlist me baataya hai maine

[@monukumar-no6np]

@@YPTechDATIA sir meri aapse request hai ki aap is contant par ek video banaye jis me fully details ho ki ham is device ko easy tarike se kese wordpress ke saath conect kar sakte hai

[@YPTechDATIA]

th-cam.com/video/P2_6nN-67UQ/w-d-xo.html
See this , data of my sql table can be used with wordpress

[@shivankjoshi8363]

Sir, Is this App Script not available on MS office?

[@YPTechDATIA]

Since ms office offline version does not support data from http , it is not possible .

[@YPTechDATIA]

But you can try alternate options for local server like MySQL , watch my another video on this title

[@YPTechDATIA]

th-cam.com/video/P2_6nN-67UQ/w-d-xo.html

[@shivankjoshi8363]

@@YPTechDATIA thanks a lot sir for being so helpful

[@shivankjoshi8363]

@@YPTechDATIA can you please share your contact once sir.

[@murlidewangan4277]

Google apps script me
"Script function not found: doGet"
Show ho rha h

[@YPTechDATIA]

I will help

[@murlidewangan4277]

@@YPTechDATIA sir kya solution ho skta h iska

[@YPTechDATIA]

go to manage deployement and use that url followed by dev

[@murlidewangan4277]

@@YPTechDATIAHow to add more and more people's names in this with the help of rfid card ❓❓

[@YPTechDATIA]

All you need multiple RFID cards , you can write one car at once

[@user-mu7li6js6o]

Hi sir , I am getting error 400 and my data is not upating on google sheet.

[@YPTechDATIA]

1. Set client insecure
2. Leave the project running for a while and try after an hour it will start working .This prob is due to google security and compatibility issue with nodemcu device .

[@YPTechDATIA]

And yes subscribe to my channel also and share it with those who are interested in this .
If you will be unable to make it mail me detailed prob with screenshot [e-mail]

[@MaddyM-hl5vj]

bro which board & programmer(processor) we have to select

[@abhijitpaul1739]

I have follow the same step. But my data in displaying in Serial monitor but not stored in google sheet.
So please sir help me out in this case

[@YPTechDATIA]

share your app script I will make it working

[@abhijitpaul1739]

@@YPTechDATIA function doGet(e) {
Logger.log( JSON.stringify(e) );
var result = 'Ok';
if (e.parameter == 'undefined') {
result = 'No Parameters';
}
else {
var sheet_id = '1tWLh08gQXizPu3Pk6TbVK_0AvklT5FOOW7Y03sTegBw'; // Spreadsheet ID
var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();
var newRow = sheet.getLastRow() + 1;
var rowData = [];
var Curr_Date = new Date();
rowData[0] = Curr_Date; // Date in column A
var Curr_Time = Utilities.formatDate(Curr_Date, "Asia/Kolkata", 'HH:mm:ss');
rowData[1] = Curr_Time; // Time in column B
for (var param in e.parameter) {
Logger.log('In for loop, param=' + param);
var value = stripQuotes(e.parameter[param]);
Logger.log(param + ':' + e.parameter[param]);
switch (param) {
case 'name':
rowData[2] = value; // Employee Name in column C
result = 'Employee Name Written on column C';
break;
default:
result = "unsupported parameter";
}
}
Logger.log(JSON.stringify(rowData));
var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
newRange.setValues([rowData]);
}
return ContentService.createTextOutput(result);
}
function stripQuotes( value ) {
return value.replace(/^["']|['"]$/g, "");
}

[@abhijitpaul1739]

@@YPTechDATIA please sir

[@YPTechDATIA]

@@abhijitpaul1739 everything is looking fine , now share arduino code

[@abhijitpaul1739]

@@YPTechDATIA #include
#include
#include
#include
#include
#include
#include
#include
// Fingerprint for demo URL, expires on June 2, 2021, needs to be updated well before this date
const uint8_t fingerprint[20] = {0xc1, 0x5f, 0x79, 0xdc, 0x2d, 0x3b, 0xbf, 0x56, 0x51, 0x0b, 0x71, 0x98, 0x14, 0x8b, 0xed, 0x95, 0xcb, 0x88, 0xac, 0x42};
#define RST_PIN D3 // Configurable, see typical pin layout above
#define SS_PIN D4 // Configurable, see typical pin layout above
#define BUZZER D2 // Configurable, see typical pin layout above
MFRC522 mfrc522(SS_PIN, RST_PIN); // Instance of the class
MFRC522::MIFARE_Key key;
ESP8266WiFiMulti WiFiMulti;
MFRC522::StatusCode status;
/* Be aware of Sector Trailer Blocks */
int blockNum = 2;
/* Create another array to read data from Block */
/* Length of buffer should be 2 Bytes more than the size of Block (16 Bytes) */
byte bufferLen = 18;
byte readBlockData[18];
String data2;
const String data1 = "script.google.com/macros/s/AKfycbyZUGx3CY8ZpTH8A-5OibTkNpZ-E9EvWQ1ceTG9EH_IAlKpM2zYp7OkUwzvLtF0Q1U/exec?name=";
void setup()
{
/* Initialize serial communications with the PC */
Serial.begin(9600);
// Serial.setDebugOutput(true);
Serial.println();
Serial.println();
Serial.println();
for (uint8_t t = 4; t > 0; t--)
{
Serial.printf("[SETUP] WAIT %d...
", t);
Serial.flush();
delay(1000);
}
WiFi.mode(WIFI_STA);
/* Put your WIFI Name and Password here */
WiFiMulti.addAP("HUAWEI_KIW-L22_7C1C", "abhi1234");
/* Set BUZZER as OUTPUT */
pinMode(BUZZER, OUTPUT);
/* Initialize SPI bus */
SPI.begin();
}
void loop()
{
/* Initialize MFRC522 Module */
mfrc522.PCD_Init();
/* Look for new cards */
/* Reset the loop if no new card is present on RC522 Reader */
if ( ! mfrc522.PICC_IsNewCardPresent())
{
return;
}
/* Select one of the cards */
if ( ! mfrc522.PICC_ReadCardSerial())
{
return;
}
/* Read data from the same block */
Serial.println();
Serial.println(F("Reading last data from RFID..."));
ReadDataFromBlock(blockNum, readBlockData);
/* If you want to print the full memory dump, uncomment the next line */
/*mfrc522.PICC_DumpToSerial(&(mfrc522.uid));*/
/* Print the data read from block */
Serial.println();
Serial.print(F("Last data in RFID:"));
Serial.print(blockNum);
Serial.print(F(" --> "));
for (int j=0 ; jsetFingerprint(fingerprint);
// Or, if you happy to ignore the SSL certificate, then use the following line instead:
//client->setInsecure();
data2 = data1 + String((char*)readBlockData);
data2.trim();
Serial.println(data2);
HTTPClient https;
Serial.print(F("[HTTPS] begin...
"));
if (https.begin(*client, (String)data2))
{
// HTTP
Serial.print(F("[HTTPS] GET...
"));
// start connection and send HTTP header
int httpCode = https.GET();
// httpCode will be negative on error
if (httpCode > 0)
{
// HTTP header has been send and Server response header has been handled
Serial.printf("[HTTPS] GET... code: %d
", httpCode);
// file found at server
}
else
{
Serial.printf("[HTTPS] GET... failed, error: %s
", https.errorToString(httpCode).c_str());
}
https.end();
delay(1000);
}
else
{
Serial.printf("[HTTPS} Unable to connect
");
}
}
}
void ReadDataFromBlock(int blockNum, byte readBlockData[])
{
/* Prepare the ksy for authentication */
/* All keys are set to FFFFFFFFFFFFh at chip delivery from the factory */
for (byte i = 0; i < 6; i++)
{
key.keyByte[i] = 0xFF;
}
/* Authenticating the desired data block for Read access using Key A */
status = mfrc522.PCD_Authenticate(MFRC522::PICC_CMD_MF_AUTH_KEY_A, blockNum, &key, &(mfrc522.uid));
if (status != MFRC522::STATUS_OK)
{
Serial.print("Authentication failed for Read: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
else
{
Serial.println("Authentication success");
}
/* Reading data from the Block */
status = mfrc522.MIFARE_Read(blockNum, readBlockData, &bufferLen);
if (status != MFRC522::STATUS_OK)
{
Serial.print("Reading failed: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
else
{
Serial.println("Block was read successfully");
}
}

[@newpunjab2429]

Sir i am getting fttp error connection how to fix that

[@YPTechDATIA]

Fttp error?? Where ? While uploading the code

[@newpunjab2429]

@@YPTechDATIA no sir when we scan card ।my excel sheet dosnt update and make error fttp error connection

[@newpunjab2429]

I am not able to send you screenshot

[@newpunjab2429]

Kindly share email id to send screenshot

[@YPTechDATIA]

@@newpunjab2429 ok , so there may be authentication problem with your google account. See once the values are coming on serial monitor or not .

[@Engineeeeeer6]

D3 Was Not Declared In Scope
Error Aa Rha he

[@YPTechDATIA]

THODA CODE DEKH KAR TYPE KARO BHAI

[@YPTechDATIA]

BRACKET DEKHO

[@chaprigamer2744]

Sir deploy karna par error dikha raha hai mana bhot bar check karliya id Shai hai

[@YPTechDATIA]

Share error code you got on the serial monitor

[@chaprigamer2744]

@@YPTechDATIA no sir koi serial nahi dikha raha hai

[@YPTechDATIA]

@@chaprigamer2744 how is this possible ??

[@amarnathv8689]

Sir i have the same issue as Abhijith Paul. please help me Sir. ( "I have follow the same step. But my data in displaying in Serial monitor but not stored in google sheet.
So please sir help me out in this case" )

[@YPTechDATIA]

Sure I will

[@abhijitpaul1739]

Have you got your solution

[@himanshumnnitallahabad8655]

sir please provide code link

[@YPTechDATIA]

github.com/yashwantpathakrjit/RFID-based-attendance-system-using-NodeMCU

[@sachinbherde6156]

Sir i need your help in my college project how can i contact you

[@YPTechDATIA]

Mail me at [e-mail]

[@Projectswithmani]

bro wifi se connect nhi ho rha he

[@Projectswithmani]

please solve my problem
that am unable to connect mobail hotspot
i thoroughly followed your tutorial but un able to find the solution

[@YPTechDATIA]

Plz check ssid once again ,may be space or small capital letters , or password is wrong

[@Projectswithmani]

@@YPTechDATIA bro tried still same problem please please solve the problem

[@YPTechDATIA]

Ok I will try by teamviewer

[@YPTechDATIA]

th-cam.com/video/P2_6nN-67UQ/w-d-xo.html

[@siddhant005]

How to add another name with another rfid tag, what to write extra in code

[@YPTechDATIA]

You have to run the code again with different name and write the rfid tag , every time you want to use a new card .

[@YPTechDATIA]

th-cam.com/video/P2_6nN-67UQ/w-d-xo.html

[@ayushthakur7566]

[SETUP] WAIT 4...
[SETUP] WAIT 3...
[SETUP] WAIT 2...
[SETUP] WAIT 1...
Reading last data from RFID...
Authentication success
Block was read successfully
Last data in RFID:2 --> YPTech
Sir maine ye code try Kiya sir mujhe itna he output mil raha hey "http...". Ye ho nahi Raha hey aur excel sheet bhi edit nahi ho rahi hey
Sir please solve this issue as soon as possible .

[@ayushthakur7566]

Sir nodemcu wifi se connect nahi ho raha hey

[@YPTechDATIA]

I need to connect you with the team viewer .

[@ayushthakur7566]

@@YPTechDATIA ok sir

[@prajwalhr7012]

Sir I'm not able to write data into RFID card

[@YPTechDATIA]

Check your RFID reader / writer and it's connection

[@tanviralam6585]

Hi

[@YPTechDATIA]

th-cam.com/video/P2_6nN-67UQ/w-d-xo.html

[@tabletop1819]

👍

[@sachinbherde6156]

Sir plz reply on gmail

[@YPTechDATIA]

Check ur mail plz

[@Rahul_._rathod_]

I am getting error telling
"D3 was not declared in this scope "

[@sabakhan-ji4ll]

👍

[@Rahul_._rathod_]

I am getting error telling
"D3 was not declared in this scope "