UW Important Dates as Outlook CSV

uw fall 2018 important dates.csv

uw important dates as outlook csv.js

/**
 * This isn't really meant to be re-useable; just a quick script I used but which I made
 * public in case someone wanted to check validity or create a more re-useable script.
 * First you have to inject d3 into your browser console (https://cdnjs.cloudflare.com/ajax/libs/d3/4.13.0/d3.min.js),
 * then run the following code.
 */

var COLUMN = "Fall 2018";
var TABLE_SEL = "table.sticky-enabled";
var MONTHS_PAT = "Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec";
var MONTHS_TO_INT = new Map(MONTHS_PAT.split("|").map((mo,i) => [mo,i]));
var CONTAINER_ELS = new Set(["DIV", "P", "EM", "#text"]);
var $ = document.querySelectorAll.bind(document);

var headers = Array.from($(`${TABLE_SEL} th`)).map(th => th.textContent.trim());
var col_index = headers.findIndex(x => x == COLUMN);

// Parse a date like "Jan 12, 2018" to an array [2018, 1, 12]
function parse_date(str) {
    var [mo, da, ye] = str.split(/[\s,]+/);
    return [
        parseInt(ye, 10),
        MONTHS_TO_INT.get(mo) + 1,
        parseInt(da, 10)
    ];
}

function date_arr_to_date([y, m, d]) {
    return new Date(y, m-1, d);
}

// Increment a [yy, mm, dd] date (inplace)
function incr_date(date) {
    var d = date_arr_to_date(date);
    var new_d = new Date(d.getTime() + 24 * 60 * 60 * 1000);
    date[0] = new_d.getFullYear();
    date[1] = new_d.getMonth() + 1;
    date[2] = new_d.getDate();
}

// Merge adjacent EM (or text) nodes
function collapse_adjacent_ems(parent) {
    function is_mergeable(el) {
        return (el.nodeName == "EM" && el.childNodes.length == 1 && el.childNodes[0].nodeName == "#text") ||
            (el.nodeName == "#text");
    }
    var i = 0;
    while(parent.childNodes.length > (i+1)) {
        if (is_mergeable(parent.childNodes[i]) && is_mergeable(parent.childNodes[i+1])) {
            parent.childNodes[i].textContent += parent.childNodes[i+1].textContent;
            parent.childNodes[i+1].remove();
        }
        else {
            i++;
        }
    }
}

Array.prototype.flatMap = function(transform) {
    return this.map(transform)
    .reduce((acc, cur) => {
        acc.push(...(cur instanceof Array ? cur : [cur]));
        return acc;
    }, []);
}

// Remove "wrapper" els (i.e. single child) matching types in the set types
function remove_wrappers(types, el) {
    if (!el) return el;
    return (el.childNodes.length == 1 && types.has(el.nodeName))
        ? remove_wrappers(types, el.childNodes[0])
        : el;
}

// Remove rows which have "inappliccable" dates for the active `col_index`
function remove_inapplicable(tr) {
    var date_td = tr.children[col_index];
    return date_td.textContent.trim() != "Not applicable";
}

// Create an event object from a row in the table
function event_from_row(tr) {
    var title_td = tr.children[0];
    var title = title_td.childNodes[0].textContent.trim();

    var date_td = tr.children[col_index];
    if (date_td.querySelector('b')) {
        // need multiple events
        return Array.from(date_td.querySelectorAll('b'))
        .map(b => {
            var new_tr = tr.cloneNode(true);

            // add subevent to title
            var title_td = new_tr.children[0];
            var old_title = title_td.childNodes[0].textContent.trim();
            var subtitle = b.innerHTML.replace(/<br>/g, ' ').trim().replace(/:$/, '');
            var new_title = old_title + ` (${subtitle})`
            title_td.childNodes[0].textContent = new_title

            // Update date
            var date_td = new_tr.children[col_index];
            date_td.innerHTML = '';
            date_td.appendChild(b.nextSibling.cloneNode(true));

            return event_from_row(new_tr);
        })
    }
    var date_str = date_td.childNodes[0].textContent.trim();
    var start, end;
    if (date_str.indexOf(" to ") != -1) {
        [start, end] = date_str.split(" to ").map(parse_date);
        if (isNaN(start[0])) {
            start[0] = end[0];
            // Special case for when over a year
            if (date_arr_to_date(start).getTime() > date_arr_to_date(end).getTime()) {
                start[0] = end[0] - 1;
            }
        }
    }
    else {
        start = end = parse_date(date_str);
    }
    end = Array.from(end); // create copy
    incr_date(end);

    var date_notes = null;
    var date_notes_el = date_td.querySelector(".special_notes")
    if (date_notes_el) date_notes = date_notes_el.textContent.trim();

    var desc = null;
    var desc_el = tr.children[0].querySelector(".body");
    desc_el = remove_wrappers(CONTAINER_ELS, desc_el);
    if (desc_el) {
        collapse_adjacent_ems(desc_el);
        desc_el = remove_wrappers(CONTAINER_ELS, desc_el);
        console.log(desc_el);
        desc = CONTAINER_ELS.has(desc_el.nodeName)
            ? desc_el.innerHTML || desc_el.textContent
            : desc_el.outerHTML || desc_el.textContent;
    }

    return {title, start, end, date_notes, desc, tr};
}

var rows = Array.from($(`${TABLE_SEL} tbody tr`))
    .filter(remove_inapplicable)
    .flatMap(event_from_row);

// custom edits
// Online course examination days should be a range
var online_exam_days = rows.find(e => e.title == "Online course examination days");
if (online_exam_days) {
    online_exam_days.end = parse_date(online_exam_days.date_notes.trim());
    online_exam_days.end[2]++; // cause range end needs to be ahead by 1
    online_exam_days.date_notes = null;    
}

function to_outlook_csv(rows) {
    function format_date(date) { return date.join('/'); }

    return rows.map(row => {
        var description = "";
        if (row.date_notes)
            description = "* " + row.date_notes;
        if (row.desc)
            description += (description ? "\n\n" : "") + row.desc;
        return {
            Subject: row.title,
            "Start Date": format_date(row.start),
            "End Date": format_date(row.end),
            "All Day Event": "TRUE",
            Description: description,
            "Show Time As": 3
        };
    })
}

d3.csvFormat(to_outlook_csv(rows));

uw spring 2018 important dates.csv