Recently I have been working on a new Swim Team related project which at some point I will likely integrate into wp-SwimTeam but for now, it is a standalone application. Pretty regularly I receive e-mail from people who want to post their meet results online in some form or fashion. Most of the time these results come from Hy-tek in the form of a ZIP file or a CL2 file.
Generating or posting a static web page with some results on it is pretty straight forward and most swim software can do this in some form or another. Storing the results in a database and presenting them as part of a web site isn’t something readily available as near as I can tell. It would be nice to be able to upload a season’s worth of results and allow swimmers and parents to review their times and see the trends. This is basically what I am working on.
At this point I can import a SDIF meet results file and extract the meet data from it. I have some other infrastructure complete as well and will begin working on extracting and processing all of the result records in the next day or two.
I’ve based this project on two external PHP libraries. I am using the 2.x thread of phpHtmlLib, which I also use for wp-SwimTeam and ADODB. This is my first time using ADODB and so far, there haven’t been any issues. I decided to use it because I needed a database abstraction layer and phpHtmlLib has a ADODB data source widget which makes it very easy to present data to a user.