Making vcfs from the csv file downloaded from google forms
Format of the Google Sheet (column-wise)
- Timestamp (automatically provided by google sheets)
- Email-Address
- Whatsapp Number
- Name
- BITS ID
- Subjects for Registration (Make sure to add space between the codes, ex: ABC F234 and not ABCF234)
Inputs by the user Input has to be the following: Subject Name, Subject Code, Batch Size for each subject. eg: 'ABC', 'CDFG F234', 36
Output
- A csv file containing split students and the contact information
- A separate csv and a vcf file for each subject with their contact
Contact making If the ID number is 1234F5GH7645 and the student has chosen a subject 'CDFG F234', then the contact made will be CDFGF324_A7645, here 'A' will be allotted based on batch size.