Harris Feed

The Feed

09:22a|www@piglet $ crontab -e

# [deletia]
0 */6 * * * /home/www/crons/sundial/harrisUpdate.sh &> /dev/null

What's that do?

#!/bin/bash
curl -s "https://calendar.columbia.edu/sundial/job/harrisUpdate.php"

# [deletia]

The harrisUpdate script is executed from this URL.

This pulls the contents of the Harris XML feed, located here.

These events are assigned a unique ID by Harris, which maps to the Harris_Event_ID table in Sundial and is matched up to a Sundial event ID. ALL entries in the Harris XML file that aren't deletions (indicated by D) are treated as updates (even if Harris says they're inserts).

Basically, we update all fields of the event that appear in the feed, shoehorning them when necessary to meet Sundial validation standards. Unsalvageable events (those that have absurd dates or other missing vital fields) will throw errors and email ccit-dev@columbia.edu, at which point the feed (or Sundial) should be fixed, and the update script should be run again.