Beijing University School of Medicine Class Schedule Conversion Wakeup Course Schedule Import

Introduction#

Since the Wakeup course schedule does not support online import of the medical school schedule, I wrote a Python script to complete the conversion and import the medical school schedule into the Wakeup course schedule:

Instructions#

Log in to the Medical School Portal, then select Service Hall - My Schedule, click on List Mode, and then click on Export, Export File List in order to download My Schedule.xlsx.

Download Converter.py, or directly use the following code, move it to the same directory as the schedule file, and then run it.

# -*- encoding:utf-8 -*-
#@Time		:	2022/08/30 02:01:39
#@File		:	converter.py
#@Author	:	Arthals
#@Contact	:	[email protected]
#@Software	:	Visual Studio Code

from openpyxl import Workbook, load_workbook
import os
import re

# wb = Workbook()
# ws = wb.create_sheet('mysheet', 0)
# wb.save('test.xlsx')
# wb.close()

wb = load_workbook('My Schedule.xlsx')
ws = wb['sheet1']

maxRow = ws.max_row
maxCol = ws.max_column


def extractInterger(strin):
    return int(re.findall(r'\d+', strin)[0])


def extractWeek(strin):
    strin = re.sub(r"[周()]", "", strin)
    weeks = re.sub(r",", r"、", strin)
    return weeks


def extractDay(strin):
    dayDic = {
        "星期一": 1,
        "星期二": 2,
        "星期三": 3,
        "星期四": 4,
        "星期五": 5,
        "星期六": 6,
        "星期日": 7
    }
    return dayDic[strin]


courseList = []
for row in range(2, maxRow + 1):
    courseName = ws.cell(row=row, column=2).value
    courseStart = extractInterger(ws.cell(row=row, column=8).value)
    courseEnd = extractInterger(ws.cell(row=row, column=9).value)
    courseWeek = extractWeek(ws.cell(row=row, column=6).value)
    courseDay = extractDay(ws.cell(row=row, column=7).value)
    courseLocation = ws.cell(row=row, column=11).value
    courseTeacher = ws.cell(row=row, column=10).value
    courseList.append([
        courseName, courseDay, courseStart, courseEnd, courseTeacher,
        courseLocation, courseWeek
    ])

# print(courseList)

wb.close()

output = open("mySchedule.csv", "w+")
output.write("Course Name,Day,Start Time,End Time,Teacher,Location,Weeks\n")
for course in courseList:
    for info in range(len(course)):
        course[info] = f'"{course[info]}"'
    print(course)
    output.write(",".join('%s' % id for id in (course)) + "\n")
output.close()

Notes#

In addition to the built-in libraries, this script requires the installation of the openpyxl library to read and write xlsx files. If you encounter an error during the process indicating that this library is not installed, you can use pip3 install openpyxl in the terminal / Windows Terminal to install it.
For how to import the csv file into the Wakeup course schedule, please refer to the official tutorial of Wakeup course schedule here.
The author found that the schedule on the portal is actually slightly different from the schedule in the class group, but I believe this is an issue with the academic affairs office, so I would also like to remind you to check and modify according to the actual situation.
If you have any questions, please feel free to contact the author or leave a comment below this article.