Hello! I'm currently working on a project, The project is smart attendance. The main idea of the project is that we are going to to be using RFID and Goggle Sheet. Like for example a student use their card to scan the RFID sensor when they enter the classroom and whenever the student leave the RFID will catch it and record their ins and outs to the google sheet.
The problems is i kept getting error code 200 and i am using NodeMCU V2 for the system and i hope anyone can help me solve this problem.
Arduino IDE:
/*
* Download Resources
* ------------------------------------------------------------------------
* Preferences--> Aditional boards Manager URLs :
* For ESP8266 and NodeMCU - Version 3.0.2
* http://arduino.esp8266.com/stable/package_esp8266com_index.json
* ------------------------------------------------------------------------*/
#include <SPI.h>
#include <MFRC522.h>
#include <Arduino.h>
#include <ESP8266WiFi.h>
#include <ESP8266HTTPClient.h>
#include <WiFiClient.h>
#include <WiFiClientSecureBearSSL.h>
//-----------------------------------------
#define RST_PIN D3
#define SS_PIN D4
#define BUZZER D2
//-----------------------------------------
MFRC522 mfrc522(SS_PIN, RST_PIN);
MFRC522::MIFARE_Key key;
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 card_holder_name;
const String sheet_url = "(Insert Sricpt URL)exec?studentID=";
//-----------------------------------------
const uint8_t fingerprint[32] = {
0x56, 0x19, 0x03, 0xED, 0xE6, 0x03, 0x38, 0x9D,
0xB5, 0xAE, 0x77, 0x17, 0xDE, 0x94, 0x8A, 0x2C,
0x1B, 0xFC, 0xED, 0x79, 0x6F, 0x58, 0x16, 0x7B,
0xA1, 0x29, 0x47, 0xA3, 0x20, 0xA6, 0x6E, 0xEB};
//-----------------------------------------
#define WIFI_SSID "(Insert SSID)"
#define WIFI_PASSWORD "(Insert Password)"
//-----------------------------------------
/****************************************************************************************************
* setup() function
****************************************************************************************************/
void setup()
{
//--------------------------------------------------
/* Initialize serial communications with the PC */
Serial.begin(9600);
//Serial.setDebugOutput(true);
//--------------------------------------------------
//WiFi Connectivity
Serial.println();
Serial.print("Connecting to AP");
WiFi.begin(WIFI_SSID, WIFI_PASSWORD);
while (WiFi.status() != WL_CONNECTED){
Serial.print(".");
delay(200);
}
Serial.println("");
Serial.println("WiFi connected.");
Serial.println("IP address: ");
Serial.println(WiFi.localIP());
Serial.println();
//--------------------------------------------------
/* Set BUZZER as OUTPUT */
pinMode(BUZZER, OUTPUT);
//--------------------------------------------------
/* Initialize SPI bus */
SPI.begin();
//--------------------------------------------------
}
/****************************************************************************************************
* loop() function
****************************************************************************************************/
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; j < 16; j++)
{
Serial.write(readBlockData[j]);
}
Serial.println();
//--------------------------------------------------
digitalWrite(BUZZER, HIGH);
delay(200);
digitalWrite(BUZZER, LOW);
delay(200);
digitalWrite(BUZZER, HIGH);
delay(200);
digitalWrite(BUZZER, LOW);
//--------------------------------------------------
if (WiFi.status() == WL_CONNECTED) {
//--------------------------------------------------
std::unique_ptr<BearSSL::WiFiClientSecure> client(new BearSSL::WiFiClientSecure);
//--------------------------------------------------
client->setFingerprint(fingerprint);
// Or, if you want to ignore the SSL certificate
//then use the following line instead:
// client->setInsecure();
//--------------------------------------------------
card_holder_name = sheet_url + String((char*)readBlockData);
card_holder_name.trim();
Serial.println(card_holder_name);
//--------------------------------------------------
HTTPClient https;
Serial.print(F("[HTTPS] begin...\n"));
//--------------------------------------------------
if (https.begin(*client, (String)card_holder_name)){
//--------------------------------------------------
// Send HTTP GET request and store the response code
int httpCode = https.GET();
// Check the response code and handle accordingly
if (httpCode > 0) {
// HTTP header has been sent and Server response header has been handled
Serial.printf("[HTTPS] GET... code: %d\n", httpCode);
// Handle the response based on the code
// For example, you can read the response body using https.getString()
// or perform other actions based on the response
} else {
// If httpCode is negative, an error occurred during the request
Serial.printf("[HTTPS] GET... failed, error: %s\n", https.errorToString(httpCode).c_str());
}
https.end(); // End HTTP connection
delay(1000);
} else {
Serial.printf("[HTTPS} Unable to connect\n");
}
}
}
/****************************************************************************************************
* ReadDataFromBlock() function
****************************************************************************************************/
void ReadDataFromBlock(int blockNum, byte readBlockData[])
{
//----------------------------------------------------------------------------
/* Prepare the key 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");
}
//----------------------------------------------------------------------------
}
Card Holder: By Tauseef Ahmad
/* ------------------------------------------------------------------------
* Created by: Tauseef Ahmad
* Created on: 23 Feb, 2022
*
* Tutorial: https://youtu.be/aNjkNmHRx4o
* ------------------------------------------------------------------------
* Download Resources
* ------------------------------------------------------------------------
* Preferences--> Aditional boards Manager URLs :
* For ESP8266 and NodeMCU - Version 3.0.2
* http://arduino.esp8266.com/stable/package_esp8266com_index.json
* ------------------------------------------------------------------------*/
#include <SPI.h>
#include <MFRC522.h>
//-----------------------------------------
constexpr uint8_t RST_PIN = D3;
constexpr uint8_t SS_PIN = D4;
//-----------------------------------------
MFRC522 mfrc522(SS_PIN, RST_PIN);
MFRC522::MIFARE_Key key;
//-----------------------------------------
/* Set the block to write data */
int blockNum = 2;
/* This is the actual data which is
going to be written into the card */
byte blockData [16] = {"Ahmad_Logs"};
//-----------------------------------------
/* Create 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];
//-----------------------------------------
MFRC522::StatusCode status;
//-----------------------------------------
void setup()
{
//-----------------------------------------
//Initialize serial communications with PC
Serial.begin(9600);
//-----------------------------------------
//Initialize SPI bus
SPI.begin();
//-----------------------------------------
//Initialize MFRC522 Module
mfrc522.PCD_Init();
Serial.println("Scan a MIFARE 1K Tag to write data...");
//-----------------------------------------
}
/****************************************************************************************************
* Writ() function
****************************************************************************************************/
void loop()
{
//------------------------------------------------------------------------------
/* 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;
}
//------------------------------------------------------------------------------
/* 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;}
//------------------------------------------------------------------------------
Serial.print("\n");
Serial.println("**Card Detected**");
/* Print UID of the Card */
Serial.print(F("Card UID:"));
for (byte i = 0; i < mfrc522.uid.size; i++){
Serial.print(mfrc522.uid.uidByte[i] < 0x10 ? " 0" : " ");
Serial.print(mfrc522.uid.uidByte[i], HEX);
}
Serial.print("\n");
/* Print type of card (for example, MIFARE 1K) */
Serial.print(F("PICC type: "));
MFRC522::PICC_Type piccType = mfrc522.PICC_GetType(mfrc522.uid.sak);
Serial.println(mfrc522.PICC_GetTypeName(piccType));
//------------------------------------------------------------------------------
/* Call 'WriteDataToBlock' function, which will write data to the block */
Serial.print("\n");
Serial.println("Writing to Data Block...");
WriteDataToBlock(blockNum, blockData);
//------------------------------------------------------------------------------
/* Read data from the same block */
Serial.print("\n");
Serial.println("Reading from Data Block...");
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.print("\n");
Serial.print("Data in Block:");
Serial.print(blockNum);
Serial.print(" --> ");
for (int j=0 ; j<16 ; j++){
Serial.write(readBlockData[j]);
}
Serial.print("\n");
//------------------------------------------------------------------------------
}
/****************************************************************************************************
* Writ() function
****************************************************************************************************/
void WriteDataToBlock(int blockNum, byte blockData[])
{
//------------------------------------------------------------------------------
/* Authenticating the desired data block for write 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 Write: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
//------------------------------------------------------------------------------
else {
Serial.println("Authentication success");
}
//------------------------------------------------------------------------------
/* Write data to the block */
status = mfrc522.MIFARE_Write(blockNum, blockData, 16);
if (status != MFRC522::STATUS_OK) {
Serial.print("Writing to Block failed: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
else
{Serial.println("Data was written into Block successfully");}
//------------------------------------------------------------------------------
}
/****************************************************************************************************
* ReadDataFromBlock() function
****************************************************************************************************/
void ReadDataFromBlock(int blockNum, byte readBlockData[])
{
//------------------------------------------------------------------------------
/* 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");
}
//------------------------------------------------------------------------------
}
Google Scripts:
ar ss = SpreadsheetApp.openById('(Insert Spreadsheet ID)');
var sheet = ss.getSheetByName('Sheet1');
var timezone = "Asia/Singapore";
function doGet(e){
Logger.log(JSON.stringify(e));
if (typeof e === 'undefined' || typeof e.parameter === 'undefined') {
return ContentService.createTextOutput("Received data is undefined");
}
var currDate = new Date();
var currTime = Utilities.formatDate(currDate, timezone, 'HH:mm:ss');
var studentID = e.parameters.studentID ? stripQuotes(e.parameters.studentID) : "Unknown";
// Check if it's a time in or time out request
var timeType = determineTimeType(studentID);
var nextRow = sheet.getLastRow() + 1;
// Record the entry
sheet.getRange("A" + nextRow).setValue(studentID);
sheet.getRange("B" + nextRow).setValue(currTime);
sheet.getRange("C" + nextRow).setValue(timeType);
sheet.getRange("D" + nextRow).setValue(currDate); // Date
return ContentService.createTextOutput("Student ID and time recorded successfully");
}
function stripQuotes(value) {
if (typeof value !== 'undefined') {
return value.toString().replace(/^["']|['"]$/g, "");
} else {
return ""; // or handle the undefined case in whatever way is appropriate for your application
}
}
function determineTimeType(studentID) {
var data = sheet.getDataRange().getValues();
for (var i = data.length - 1; i >= 1; i--) {
if (data[i][0] == studentID) {
return data[i][2] === 'in' ? 'out' : 'in';
}
}
return 'in'; // Default to 'in' if no previous entry found
}
function doPost(e) {
var val = e.parameter.value;
if (e.parameter.value !== undefined){
var range = sheet.getRange('A2');
range.setValue(val);
}