schedule/OHBM_schedule_to_calendars.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "e4a8778a-8ec0-41c5-b23f-d735db31267f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import icalendar\n",
    "import uuid\n",
    "from datetime import datetime, timezone\n",
    "import pytz \n",
    "import numpy as np, pandas as pd\n",
    "import os\n",
    "\n",
    "def format_timestamp(datetime_obj: datetime) -> str:\n",
    "\n",
    "    return datetime_obj.strftime('%Y%m%dT%H%M%SZ')\n",
    "\n",
    "def create_new_event(start: datetime, end: datetime, event_name: str, description: str, location: str, uid: str) -> icalendar.Event:\n",
    "\n",
    "    event: icalendar.Event = icalendar.Event()\n",
    "    current_time: datetime = datetime.now(timezone.utc)\n",
    "    event.add('transp', 'TRANSPARENT')\n",
    "    event.add('summary', event_name)\n",
    "    event.add('description', description)\n",
    "    event.add('location', location)    \n",
    "    event.add('uid', uid)\n",
    "\n",
    "    event['dtstart'] = format_timestamp(start)\n",
    "    event['dtend'] = format_timestamp(end)\n",
    "    event['created'] = format_timestamp(current_time)\n",
    "    event['last-modified'] = format_timestamp(current_time)\n",
    "    event['dtstamp'] = format_timestamp(current_time)\n",
    "\n",
    "    return event\n",
    "\n",
    "def create_ical_file(ics_file, sparkle_file, input_file, locationprefix=\"\", tmzn=\"\", eventType=\"\"):\n",
    "\n",
    "    df = pd.read_csv(input_file, keep_default_na=False)\n",
    "    cal: icalendar.Calendar = icalendar.Calendar()\n",
    "    df_sparkle = pd.DataFrame(columns = ['location','name','host','description','start','duration','eventId'])\n",
    "    \n",
    "    for index, row in df.iterrows():    \n",
    "        if eventType in row['Location']:\n",
    "            if tmzn in row['TimeZoneBlock']:\n",
    "                start: datetime = datetime.strptime(str(row['Date Start']) + 'T' + str(row['Time Start']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ')                        \n",
    "                start_sparkle: int = int(datetime.strptime(str(row['Date Start']) + 'T' + str(row['Time Start']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ').replace(tzinfo=timezone.utc).timestamp())\n",
    "                duration: str = str(int((datetime.strptime(str(row['Date End']) + 'T' + str(row['Time End']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ') - datetime.strptime(str(row['Date Start']) + 'T' + str(row['Time Start']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ')).total_seconds()/60))\n",
    "                end: datetime = datetime.strptime(str(row['Date End']) + 'T' + str(row['Time End']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ')\n",
    "                event_name: str = row['Title']\n",
    "                # set based on available data:\n",
    "                if row['Speaker'] and row['Moderator']:\n",
    "                    if \"Student and Postdoc SIG Workshop\" in row['Moderator']:\n",
    "                        description: str = row['Categories'] + '\\n' + row['Moderator'] + '\\nSpeaker: ' + row['Speaker']\n",
    "                        description_sparkle: str = row['Categories'] + ', ' + row['Moderator'] + ', Speaker: ' + row['Speaker']\n",
    "                    else:\n",
    "                        description: str = row['Categories'] + '\\nSpeaker: ' + row['Speaker'] + '\\nModerator: ' + row['Moderator']\n",
    "                        description_sparkle: str = row['Categories'] + ', Speaker: ' + row['Speaker'] + ', Moderator: ' + row['Moderator']\n",
    "                elif row['Speaker']:\n",
    "                    description: str = row['Categories'] + '\\nSpeaker: ' + row['Speaker']\n",
    "                    description_sparkle: str = row['Categories'] #+ ', Speaker: ' + row['Speaker']\n",
    "                elif row['Moderator']:                    \n",
    "                    description: str = row['Categories'] + '\\n' + row['Moderator']\n",
    "                    description_sparkle: str = row['Categories'] + ', ' + row['Moderator']\n",
    "                else:                    \n",
    "                    description: str = row['Categories']\n",
    "                    description_sparkle: str = row['Categories']\n",
    "\n",
    "                if row['Speaker'] and row['Moderator']:\n",
    "                    host: str = row['Speaker'] + \", Moderated by \" + row['Moderator']\n",
    "                elif row['Speaker']:\n",
    "                    host: str = row['Speaker']\n",
    "                elif row['Moderator']:\n",
    "                    host: str = row['Moderator']\n",
    "                else:\n",
    "                    host: str = \"\"\n",
    "\n",
    "                location: str = 'https://ohbm.sparkle.space/in/' + locationprefix + row['Location'].replace('-','')\n",
    "                locationName: str = locationprefix + row['Location'].replace('-','')\n",
    "\n",
    "                # set UID for event \n",
    "                if row['UID']:\n",
    "                    uid: str = row['UID']\n",
    "                else:\n",
    "                    uid: str = str(uuid.uuid1())         \n",
    "                df.at[index,'UID'] = uid\n",
    "\n",
    "                if row['EVENTID']:\n",
    "                    eventId: str = row['EVENTID']\n",
    "                else:\n",
    "                    eventId: str = \"\"\n",
    "\n",
    "                df_sparkle = df_sparkle.append({'location': locationName, \n",
    "                                                'name': event_name, \n",
    "                                                'host': host,\n",
    "                                                'description': description_sparkle, \n",
    "                                                'start': start_sparkle,\n",
    "                                                'duration': duration,\n",
    "                                                'eventId': eventId\n",
    "                                               }, ignore_index=True)\n",
    "\n",
    "                event: icalendar.Event = create_new_event(start, end, event_name, description, location, uid)\n",
    "                cal.add_component(event)\n",
    "\n",
    "    df.to_csv(input_file, index=False)\n",
    "    df_sparkle.to_csv(sparkle_file, index=False)    \n",
    "    \n",
    "    with open(ics_file, 'wb') as o:\n",
    "        o.write(cal.to_ical())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "79f7d5fd-ae80-4bbe-8438-19df2d20375d",
   "metadata": {},
   "outputs": [],
   "source": [
    "create_ical_file('calendars/conference/OHBM_Schedule_All.ics', './OHBM2021_schedule_for_sparkle.csv', 'OHBM2021_schedule.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "b2533269-ce37-4c07-8489-bdc57612cee8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('hbm_educational_schedule_2021.csv', keep_default_na=False)\n",
    "TZs = df['TimeZoneBlock'].unique()\n",
    "LOCs = df['Location'].unique()\n",
    "\n",
    "for tz in TZs:\n",
    "    for loc in LOCs:\n",
    "        create_ical_file('calendars/educationalCourses/OHBM2021_EduCourses_Schedule_%s_%s.ics' % (tz,loc.replace('-','')), './hbm_educational_schedule_2021_for_sparkle_%s_%s.csv' % (tz,loc), 'hbm_educational_schedule_2021.csv', locationprefix=\"course\", tmzn=tz, eventType=loc)\n",
    "        \n",
    "create_ical_file('calendars/educationalCourses/OHBM2021_EduCourses_Schedule_All.ics', './hbm_educational_schedule_2021_for_sparkle.csv', 'hbm_educational_schedule_2021.csv', locationprefix=\"course\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "cc417e2b-b121-43b4-910c-9b9f6e6b9cac",
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_ical_file_posters(ics_file, df_poster):\n",
    "\n",
    "    cal: icalendar.Calendar = icalendar.Calendar()\n",
    "    \n",
    "    for index, row in df_poster.iterrows():    \n",
    "        start: datetime = datetime.strptime(str(row['Date Start']) + 'T' + str(row['Time Start']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ')                        \n",
    "        end: datetime = datetime.strptime(str(row['Date End']) + 'T' + str(row['Time End']).zfill(6) + 'Z', '%Y%m%dT%H%M%SZ')\n",
    "        event_name: str = row['Title']\n",
    "        description: str = row['Categories'] + '\\n' + row['Speaker']      \n",
    "        location: str = 'https://ohbm.sparkle.space/in/' + row['Location']        \n",
    "        # set UID for event:\n",
    "        if row['UID']:\n",
    "            uid: str = row['UID']\n",
    "        else:\n",
    "            uid: str = str(uuid.uuid1())         \n",
    "        df.at[index,'UID'] = uid\n",
    "\n",
    "        event: icalendar.Event = create_new_event(start, end, event_name, description, location, uid)\n",
    "        cal.add_component(event)\n",
    "    \n",
    "    with open(ics_file, 'wb') as o:\n",
    "        o.write(cal.to_ical())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "ee287e3f-4e08-4bed-8706-a0cec904af22",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('OHBM2021_schedule_posters_all.csv', keep_default_na=False)\n",
    "PSTRs = df['Submission No'].unique()\n",
    "\n",
    "for p in PSTRs:\n",
    "    create_ical_file_posters('calendars/posters/poster%s.ics' % str(p), df[df['Submission No'] == p])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "329f2bda-ce86-4b33-bc56-af328fca46f1",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}