Wednesday, March 31, 2010

FullCalendar integration is sweet!

I was faced with a challenge to integrate a web-based calendar view of scheduled events and I started searching for some existing source code out on the Internet. There were plenty of open source licensed projects and some pay-only software, but one that I ended up choosing really stood out for me. This project is called FullCalendar and is a simple AJAX web calendar tool that utilizes JQuery to pull in event information from JSON structured data sources.

What this project really excels at are the thorough documentation, highly configurable design, outlook like interface (the agenda views), and the fact that it would pull in event data sources from an easily definable source, rather than including its own SQL database that most are tightly reliant on. We ended up writing some PHP code to query our Oracle database and pass URL parameters to generate the appropriate query that generated a JSON structured event data set. This made it really easy to plug in a calendar view to an existing application and configure it to pull the events from the applications own database.

I'd really like to thank Adam Shaw for his contributions and great work on this project. I really learned a lot about JavaScript, JQuery, and JSON from implementing this project as a modular time-oriented visualization application that we can now plug in other data sources as we need.