I see programmers as inherently helpful people. Given a 57-step flowchart describing the steps some poor soul has to execute manually, most programmers get a little gleam in their eye and set about providing a streamlined solution. Programmers truly love removing those inefficiencies. Meanwhile, the customer stops wrestling with a frustrating system and gets on with his job.

I recently had the opportunity to untangle a complicated little process knot. The technical details are applicable solely to the Columbia community, but I think the story is a reminder that a core engineering duty is to tackle real world inefficiencies.

The Story
Briana, our Communication and Marketing Manager, is responsible for posting events on our CCNMTL website and getting those events into the Columbia calendar. To post the events to the Columbia calendar, she used the university's Sundial event management software. To post events to the CCNMTL website, she used our site content management software and recreated the events, adding links to the Sundial registration system.

Now, Briana has enough to do without managing events in two quite disparate systems. Maurice suggested I leverage the Sundial api to pull events into our CCNMTL site. Briana could create events in a single location and eliminate the redundant efforts.

The Base Technologies
Sundial is a powerful system, handling basic event creation and display plus advanced registration flow including payment, waitlists, cancellations and public and university-only enrollment. Event display can be customized through an online templating interface. As mentioned, Sundial offers a well-developed api to enable custom event retrieval.

Our CCNMTL site relies on MovableType to manage content.

The Architecture
My main goal was to (obviously) streamline event creation, while still giving Briana a great deal of control over the look/feel of the site.

As Movable Type is purely a publishing system, the best approach was to use Ajax to retrieve a list of events given date and event type parameters. The Sundial api would return formatted html based on the branded templates. Briana could edit the templates directly to tweak event display.

Using Ajax meant I was faced with a cross-domain scripting problem. Ajax allows requests only to the page's domain, e.g. foo.com can make calls to foo.com but not to sundialapi.com. Luckily, JSONP now provides a workaround. jQuery integrates this solution into its getJSON call. Sundial does not offer a JSON return format, so I also needed a simple.php script to provide a JSON wrapper for the Sundial server response.

Here's all the pieces:
eventList.html, eventDetail.html - onload() call the Ajax event retrieval interface and slot resulting html into the appropriate div.

sundial.js - Ajax script to retrieve events from events.php based on page parameters.

function loadEvents() {
   var url = "jsoncallback=?';
   var allParams = getUrlVars();

   var queryParams = {};
   queryParams['start'] = allParams['start'];
   queryParams['end'] = allParams['end'];
   queryParams['type'] = allParams['type'];
   queryParams['viewType'] = 'list';
   queryParams['keyword'] = allParams['keyword'];
   queryParams['eventFilter'] = allParams['eventFilter'];

   $.getJSON(url, queryParams,
             function(data, textStatus) {
                if (data.events) {
                   $("#eventList").html(unescape(data.events));
                } else
                   $("#eventList").html("There are presently 
                       no events to display. Please check again soon.
");
                
                var title = allParams['title'] ? unescape(allParams['title']) 
                      : "Upcoming Events";
                $("#eventListTitle").html(title);
                
                });
}

events.php - shim .php script to retrieve events from the Sundial server and return a JSON response to MovableType. My code is almost a duplicate of the sample.php code provided by Sundial.

";

$criteria = array("dateStart"   => $_GET['start'],
                  "dateEnd" => $_GET['end'],
                  "maxEvents" => "30",
                  "viewType"  =>$_GET['viewType'],
                  "sponsor" => "ccnmtl",
                  "typeFilter" => $_GET['type'],
                  "eventFilter" => $_GET['eventFilter'],
                  "brand" => "",
                  "keyword" => $_GET['keyword'],
                 );

if (strlen($criteria["dateEnd"]) <= 0) {
   $criteria["dateEnd"] = "R60";
}

foreach ($criteria as $key => $value) {
   $url .= "&" . $key . "=" . urlencode($value);
}

$result = file_get_contents($url);

if (stripos($result, "No Records") > 0) {
   $result = "";
}

$arr = array ('events'=> mb_convert_encoding($result, 'utf-8'));

echo $_GET['jsoncallback'] . '(' . json_encode($arr) . ');';

?>

Customized Templates - Sundial interface. Requires authorization from the Sundial folks. I overrode the Event Listing and Event Detail to control the event presentation. While I was at it, I overrode the Child Header, Child Footer, No Records, , Registration Status, Registration Form and Registration Cancel pages to add CCNMTL-specific branding.

Limitations
I've run into a few limitations with Sundial. A minor pain point has been dynamically categorizing events. Sundial provides an eventType filter with a predefined list of events. We've used eventType to slot our events into high-level categories like "Academic: Conference." Sundial also provides a keyword filter -- a single word, no phrases -- that searches the name, summary and description fields, which is great for a search interface. However, Briana requires something akin to a subEventType, so workshops can be categorized into things like Courseworks or Wikispaces. Ideally, these subEventTypes would be dynamic, so I could create and query them without any help from Sundial. Short-term hack, I'm using the keyword feature as a workaround but I'm worried about picking up events that just happen to have "Courseworks" in their description.

Another minor problem is the event titles. On the Columbia calendar, we want a very descriptive title for some events, e.g. CCNMTL Faculty and Instructor Workshop. On the CCNMTL site, we can drop this prefix as the CCNMTL affilitation and Workshop type is already clear. Maybe additional event attributes such as eventHeader could be added to resolve this issue.

Finally...
I was casting about for a quote to bring this all full circle, and found a great one from Dijkstra:

"The lurking suspicion that something could be simplified is the world's richest source of rewarding challenges."

If you find yourself executing some mind-numbing task over and over and over, give your local programmer a call today.