detailScript.js

const csv = require('csv-parser');
const fs = require('fs');
const results = [];

// used for temporary storage of data
const data = [];

// object of the team details
const Team = 
{
	"TA" : [],
	"MAIN" : [],
	"CS" : [],
	"RAS" : [],
	"PES" : [],
	"WIE" : [],
  "PROJECT_COMMITTEE" : [],
	"PUBLICITY_COMMITTEE" : [],
	"PROGRAM_COMMITTEE" : [],
	"EDITORIAL_COMMITTEE" : [],
  "CREATIVITY_COMMITTEE" : [],
	"DESIGN_COMMITTEE" : [],
   "SPONSORSHIP_AND_MEMBERSHIP_DEVELOPMENT_COMMITTEE":[]
}

// form data format case may differ
const form = 
{
  "rank": "",
  "name" : "",
  "email" : "",
  "stream" : "",
  "part" : "",
  "position" : "",
  "linkedin" : "",
  "instagram" : "",
  "resume" : "",
  "image" : ""
}

// read from the csvfile and write into ExeComDetails file
fs.createReadStream('./src/Pages/ExeCom/team.csv')
  .pipe(csv())
  .on('data', (data) => results.push(data))
  .on('end', () => {
    for(let i = 0; i < results.length - 1; i++){
      let res = results[i];
      const part = res["part"];
      const image = res["image"].substring(30);
      res["image"] = `https://drive.google.com/uc?export=view&${image}`;
      Team[part].push(res);
    };
    fs.writeFileSync("./src/Pages/ExeCom/ExeComDetails.json", JSON.stringify(Team), (err) => {
      if(err){
        throw err;
      } else {
        console.log("Results saved successfully");
      }
    })
  });