Skip to content

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.

Notifications You must be signed in to change notification settings

codingprivacy/Automatic-Remider-System

Repository files navigation

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

About

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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages