Converts your course excel timetable to a nice calendar. Can be used for Office and Google Calendar Get your course codes from (Bennett DigiiCampus)
- Ensure your excel file is
.xlsx
and not.xls
. Fix Here - run
pip install -r requirements.txt
- Run the
main.py
file without any parameters. - Select the correct excel file with your timetable.
- Follow prompts
- Ensure your courses exist in
course_codes.txt
- Add your course codes to
your_courses.txt
. For best results remove all other course codes from the file.
- Ensure your courses exist in
- Program generates
TimeTable Baron.ics
- Add the file to your calendar. How to add calendar to Office 365.
Open the .xls
file excel and save as .xlsx
(Excel Workbook)
Known Issue: Does not work for all as different layout throughout years. Dumb
Generate your course registration slip from CollPoll.
Open Dev Tools and run the following code in the console window.
// Amatuer JS Codes.
table = document.childNodes[1].childNodes[1].childNodes[1].childNodes[0].childNodes[0].childNodes[4].childNodes[2].childNodes[9].childNodes[1].childNodes[1]
f=''
for(var i=2; i < table.childNodes.length-2; i+=2) {
f += table.childNodes[i].cells[1].innerText + '\n'
}
console.log(f)
- Create a new blank calendar.
- Click on Upload from file and upload the
.ics
file. - Add it to the newly created blank calendar.
- Done.
- Test with other courses, branches and years
- Add more courses.
- Check issues.