Currently, the website can only update resumes of CSE-AI 2020 Batch.
Make a dictionary with folder and sheet IDs of each class, use regex to find which class a roll number belongs to, and then run the function with those sheet and folder IDs.
Sheet and Folder ID may be obtained from respective TNP coords. In case the IDs are unavailable, keep values in the dictionary as "" (NULL)
Roll numbers are of the pattern \d{3}\d{4}\d{4}. Here,
\d{3} = Student roll number
\d{4} = Branch Code
\d{4} = Year of joining
Some Branch Codes for B.Tech -
CSE - 0101
ECE - 0102
IT - 0103
MAE - 0104
DMAM - 1016
CSE-AI - 0117
ECE-AI - 0118
AIML - 0119
Please see where the regex check currently takes place (I think it's in index.html) and change it to the standard format, then extract branch codes and years for folder and sheet IDs.
Bonus: include exception handling for every step and raise errors for invalid inputs
Currently, the website can only update resumes of CSE-AI 2020 Batch. Make a dictionary with folder and sheet IDs of each class, use regex to find which class a roll number belongs to, and then run the function with those sheet and folder IDs. Sheet and Folder ID may be obtained from respective TNP coords. In case the IDs are unavailable, keep values in the dictionary as
""
(NULL)Roll numbers are of the pattern
\d{3}\d{4}\d{4}
. Here, \d{3} = Student roll number \d{4} = Branch Code \d{4} = Year of joiningSome Branch Codes for B.Tech - CSE - 0101 ECE - 0102 IT - 0103 MAE - 0104 DMAM - 1016 CSE-AI - 0117 ECE-AI - 0118 AIML - 0119
Please see where the regex check currently takes place (I think it's in index.html) and change it to the standard format, then extract branch codes and years for folder and sheet IDs.
Bonus: include exception handling for every step and raise errors for invalid inputs