Following a discussion with Andy a couple of months back on an event management component I have been off developing a Joomla Component that will better import a Sailwave File. It has just been accepted onto the Joomla Extensions Directory which should make it a bit more visible.
For those of you who don’t know what Joomla is - sorry this post is probably not for you - suffice to say its a website content management system that is a bit like Word Press. As a (biased) Joomla User I’d suggest its better geared to managing websites for clubs etc than WordPress is. The reality is they both came from different places - Joomla a Content Management System, WordPress a blogging platform but are actually both on simillar trajectories. If you have a Joomla based club or event website keep reading this post is for you…
Andy set out a wish list back in 2012 - copied below and I haven’t gone the full route he suggested. Instead I’ve gone for a component that I hope improves on the approach adopted in my previous post a year ago where I offered up a button to include a result in an article. At the moment that button is independent of this but it may well become part of the package in the future…
A proper Joomla component for Sailwave should actually allow for:
- upload of the Sailwave files and then parse the files into the same database as Joomla itself.
Not strictly what I’m doing, rather I’m uploading the HTML file and importing the tables into a Joomla Article.
By doing this, you get a bunch of other advantages, like the ability to link competitor info from Sailwave with Joomla user info,
using a component like Community Builder, for example.
You would if the Sailwave file could identify the Joomla User. Unless the sign-up is on the Joomla site I’m not sure that will happen (certainly not with my race officers who last week managed to record finishing places and not times for a handicap race!)
You also get some pretty nice dynamic control of race data display, so administrators or even site viewers can quickly and easily
add or remove data columns, do additional calculations on the data, etc., without going back to Sailwave and re-generating the
file. I guess if you really wanted to get fancy, you could show histories of competitors. How cool would it be to be able to click on
a competitor from any race result, and get a single page showing things like a photo of his boat, details of his crew, historical
performance over all the races in the database, etc.
Actually - the competitor pages might be possible in the future - Its on the maybe for the future list. But for now my aim was just to get the results relatively seemlessly into Joomla.
There are some other things that getting the result within Joomla does. So my Joomla site uses a variety of extra components that do things for me:
-
Search (so you can now go to my club website, search my name and will see all results where I feature. [That may be the start of the above!!])
-
Newsletter Component that can send all content articles (or at least the intro text) - as we are trying to increase member engagement and involvement
-
FrontPage articles - I wanted to have a small news box showing when new results had been listed
-
We Auto Tweet & Facebook when news is uploaded
All of that needed more than a HTML page in a folder. We could use the “Blog” option in Sailwave. But that means I need to get my ODs to remember their club website passwords and trust that if they can post a result they don’t also post any jibberish etc.
Farther down the wish list would be a way to list all competitors on the Joomla site, check those who are going to compete that #
day, and have Joomla generate a file that could be imported to Sailwave for use by the scorer or on the water.
So this is where Andy and I started the other week - we are booth using JoomDonations Event Booking tool and its exporter of competitors isn’t perfect as you need to manipulate it to get entrants into Sailwave (Name is in Firstname and Surname columns for instance). This is likely to be added to the same component (or maybe one called SailwaveExporter) that will handle it…
···
So what I have created is:
-
You upload to a folder default SailwaveResults in a normal kind of way from Sailwave using FTP. (There is a new template to do that so that the event id from sailwave can be included)
-
Every 5 mins (time set by webmaster) system checks for new results
-
New result is checked for anything dodgy that would harm the site or anything missing like event id.
-
If all is good if its a new event a new Article is created, if its an updated result the original article is updated.
-
Article is posted to a Joomla Content Category of webmaster’s choosing
-
Webmaster chooses the style sheet to apply
-
Article intro includes a paragraph saying “Results have been uploaded for [EVENT NAME].” Says if provisional. Includes notes as intro text to allow OD to post some comments that improve engagement.
-
All automated
I’m still calling this a beta version - we have so far posted 1 event result in a live environment…
Available via:
http://extensions.joomla.org/extensions/extension/sports-a-games/sports/sailwaveimporter
Available free and with GPL v2.0 licence.
Happy to have a link on sailwave website if Colin et al think it would be useful.
(Issues etc reported via the bitbucket site that hosts the code please as I don’t check here enough. https://bitbucket.org/shinysolutions/sre/issues )
On 2012-11-05 15:00, Andy Barrow wrote:
I’d be very interested in a Joomla component. I run several Joomla websites, and generally use Joomla to create new websites for special events.
As the original poster said, the current method is pretty clunky - I usually just designate a directory on the web site where the results need to be, and then point to those individual HTML files. For individual events, I set up dummy html files (or preload competitor lists) with pre-set names, then tell the folks scoring what they need to name their files before uploading.
My personal feeling is that a proper Joomla component for Sailwave should actually allow for upload of the Sailwave files and then parse the files into the same database as Joomla itself. By doing this, you get a bunch of other advantages, like the ability to link competitor info from Sailwave with Joomla user info, using a component like Community Builder, for example. You also get some pretty nice dynamic control of race data display, so administrators or even site viewers can quickly and easily add or remove data columns, do additional calculations on the data, etc., without going back to Sailwave and re-generating the file. I guess if you really wanted to get fancy, you could show histories of competitors. How cool would it be to be able to click on a competitor from any race result, and get a single page showing things like a photo of his boat, details of his crew, historical performance over all the races in the database, etc. Farther down the wish list would be a way to list all competitors on the Joomla site, check those who are going to compete that day, and have Joomla generate a file that could be imported to Sailwave for use by the scorer or on the water.
Been thinking about this a bit! I’m not an expert at PHP (I’ve done a bit…), but I’d be happy to contribute to this effort in any way I can.
Andy
(andy@sailor.nu)