Skip to content

Latest commit

 

History

History
45 lines (43 loc) · 2.09 KB

README.md

File metadata and controls

45 lines (43 loc) · 2.09 KB

Overview

This repository is an automatic reminder application for various documents needed for the international students for our university. A system where students in the institution gets reminders as messages or E-mail, where the students data is to be kept updated in an excel file. Application automatically fetches the data and sends reminders everyday to the selected students.

Instructions

1.The excel sheet must contain following rows with exact names:
    a."name of student" #shows the name of the student
    b."frro 1(rc/rp) start" #gives start date of the rc/rp process
    c."frro 2(rc/rp) start"
    d."frro 3(rc/rp) start"
    e."frro 4(rc/rp) start"
    f."contact number"
    g."email"
2. Names of all the students whose process is going on will be saved in data.json file
3.If any frro row contain no entries ; for the moment make it as 0000-00-00 i.e as a dummy entry

Algorithm

1. Script triggers every day at a specific time
2. Check if database is updated.
3. Fetch the database from excel file from cloud.
4. Take the 'frro student date' from the the database.
5. Start the scheduling for 1,2,3,8,9,10 day for the all the students and will send messages to all those students on those specific days.
6. Make the scheduling for same students on 11th month as the same students will have to do the same process after 11 months.



Libraries needed

    1. schedule
    2. gspread
    3. oauth2client
    4. twilio

Run the program using main_program.py

Developers

    Harsh Patel
    Vatsal Mistry