{"id":16,"date":"2018-09-11T18:29:50","date_gmt":"2018-09-11T18:29:50","guid":{"rendered":"http:\/\/users.utu.fi\/ijthun\/?p=16"},"modified":"2018-09-11T18:47:45","modified_gmt":"2018-09-11T18:47:45","slug":"how-to-copy-lecture-information-from-hops-to-google-calendar","status":"publish","type":"post","link":"https:\/\/users.utu.fi\/ijthun\/2018\/09\/11\/how-to-copy-lecture-information-from-hops-to-google-calendar\/","title":{"rendered":"How to copy lecture information from opas.peppi.utu.fi to Google Calendar"},"content":{"rendered":"

Hello,<\/p>\n

If you found this page you probably have also missing feature from peppi.utu.fi i.e. way to get the lecture dates to your calendar. I wrote small program to do the job. The code is a little hack, not very nice one so I instruct you how to do your own..<\/p>\n

I chose Python 3 as programming language. I wrote the app in Windows environment but should work also in Linux without problem. ActivePython can be found from\u00a0https:\/\/www.activestate.com\/activepython\/downloads<\/strong>. Select the Python 3 version.<\/p>\n

In Python it is easy to do user interface using PyQt3. Once you have the ActivePython installed, install PyQt3 from command line:<\/p>\n

pip3 install PyQt5<\/pre>\n
I used Google Calendar API as I am using Gmail. The API instructions for Python can be found from<\/p>\n
https:\/\/developers.google.com\/calendar\/quickstart\/python<\/strong><\/p>\n
In order you to use Calendar API follow the instructions on that page.. find the ENABLE THE GOOGLE CALENDAR API<\/strong> button. You’ll figure out the details (I hope).<\/p>\n
Behind that button you should get Client ID<\/strong> and Client Secret<\/strong>, you need this in your Python code.<\/p>\n
\n
Before going to the UI part, let’s check the lecture information here:<\/p>\n
https:\/\/opas.peppi.utu.fi\/en\/course\/DTEK8103\/9933<\/p>\n
You’ll see the header “DTEK8103 Software Design and Architecture”, that is the one you probably want to see in the calendar (atleast I did). Also I would like to see the lecture counter current\/max ..meaning this format.. first lecture out of 4.<\/p>\n
(1\/4) DTEK8103 Software Design and Architecture<\/p>\n
Then under Implementations header there is lecture times under “Teaching” header (on some other pages there can be more lecture times under some button).<\/p>\n
\n
02.10.2018 14:00-16:00 XIV, Natura luentosali XIV<\/div>\n<\/div>\n
\n
09.10.2018 14:00-16:00 XIV, Natura luentosali XIV<\/div>\n<\/div>\n
\n
16.10.2018 14:00-16:00 XIV, Natura luentosali XIV<\/div>\n<\/div>\n
\n
23.10.2018 14:00-16:00 XIV, Natura luentosali XIV<\/div>\n<\/div>\n
<\/div>\n
so.. Our program should input the header of the course and the schdule. It should be able to parse those rows, to get the times out. For parsing we use regular expression. You can try regular expressions in online services like this:\u00a0https:\/\/regex101.com\/<\/div>\n
The format of the row is<\/div>\n
dd.mm.yyyy hh:mm-hh:mm text<\/div>\n
where dd can be between 01-31, mm between 01-12, year >=2018, hh between 00-23, mm between 00-59 and text is just free text. To parse the line using regex we can use this:<\/div>\n
<\/div>\n
# day month year start hh start mm end hh end mm course location\r\n# 1 2 3 4 5 6 7 8 9 \r\nlecture = re.compile('([0123][0-9])\\.([01][0-9])\\.([0-9]{4})\\s+([012][0-9]):([012][0-9])-([012][0-9]):([012][0-9])\\s+(\\S+),\\s+(.*)')\r\n\r\n<\/pre>\n
so.. what we have done this far..<\/p>\n