API for agenda details

For several years, our club has been printing weekly agenda in our own format (no one likes the standard agenda format very much and there appears to be no other option for formatting it otherwise.). It entails a lot of copying and pasting and can take several hours each meeting to prepare an agenda. I started formatting a screen-scraper to collect the various parts that we need and export them to a CSV formatted file, then read them into a document which is better, but still has issues because of the way some of the sections are coded. . It involves having to parse the contents with REGEX. It would have to be redone if and when there is a re-design of or change to the rostertable.
It occurs to me that there are several issues with the website that could be solved if there were an API (or a download option) where we could retrieve a chunk of data (A JSON object or an XML file) with the individual fields separated and identified.

One of the other issues it could potentially solve is the issue of identifying what roles former members performed. Currently, if we look at older agenda through the website, the role is simply designated as "former member". Like many clubs, we occasionally have members who leave, then rejoin, or suspend membership for a period due to various reasons. Reconstructing their history is just more work that could be avoided if the data were complete. We could use data from each week's meeting to update our own web-centric database, format our own agenda, and better track member progress.

I'd also be very interested in a JSON feed for exactly the same reason.


empulse: Could you share your scraper code?

It might be worth, if you aren't already, parsing this page instead as it appears to be far cleaner:

/index.cgi?printagendasignup

I'd also like to see JSON feeds for agendas for the same reason.

Thanks,

Ian

Adding my +1 to this. Our club uses an Excel-based agenda maker that a former member put together some years ago. It works well enough for folks who have Excel, but requires manual input of most agenda items. I'd love to be able to build a platform-agnostic tool to handle this task.

Still working on my scraper code. There are issues in the way that the agenda is coded on the website that make scraping the site extremely difficult.

Regarding printing custom formatted agenda*: I have partially (and probably temporarily) solved the issue for our club by creating a template with Libre Office (also works in Open Office) that makes prepping our agenda much quicker, it does, however, still require some cutting and pasting. The template may work with Microsoft word processing as well but II don't use that software.

Because each club has their own format and often uses slightly different terminology, An API or some other way to access the data stored for agenda is the most flexible option.

I am attaching a zip of my template for anyone who might want to use it as an example. Also attaching a zip of the final PDF.
It is a two column document with a table in each column. The borders serve as a guide when prepping the document but I switch the borders on the right side table off before printing

FYI: Open Office and Libre Office are similar, free, open source and fully-featured office suites. Both will run on MAC, Windows or Linux systems

*(The word "agenda" is the Latin plural of agendum)