This evening I released wp-SwimTeam v1.4.573. It can be downloaded from this web site or from the WordPress plugin repository. The plugin auto-update will also update to this release. New and fixed in this release are:
- Fixed bug in Opt-In/Opt-Out e-mail confirmation which duplicated recipients.
- Fixed bug in handling Country when set to US Only.
- Added Club Profile initialization based on State or Province in Team Profile.
- Added E-mail confirmation for Job Assignments.
- Added Job Options tab on Options page to configuring Jobs module.
Make sure you visit the Job Options tab to configure your jobs module. There is still work to be done to report the number of credits a user has signed up for and to flag which users have not met the threshold. Hopefully that functionality will come in the next week or two.
Update: This release had a minor update due to a file missing from the WordPress plugin repository. The missing file prevented the Jobs Options tab from rendering. Other minor tweaks were also made to the Jobs Confirmation e-mails.
A new release of wp-SwimTeam is now available for download. It is also available via automatic update from the WordPress plugin repository. This release fixes a couple of bugs and adds two new features, one of which addresses functionality that was coded but never exposed correctly.
- Fixed bug in wpst_meet_report short code.
- Fixed bug in Add/Update Club Profile due to invalid URL field(s).
- Added showmaplinks option to wpst_meet_report short code.
- Added URL sanitatization to Google Maps and Mapquest URL fields on club profile.
- Added notes to use Google URL shortner for URLs that don’t validate.
I am not sure when it was added but MapQuest now generates “shortened” URLs when mapping an address, I wish Google would do likewise. The URLs that Google Maps generates tend to be a mile long and full of characters. My suggestion is to use Google’s URL shortener to generate a simple URL that can be saved within WordPress easily. That is what I am doing for the MacDolphins web site.
The phpHtmlLib library which wp-SwimTeam depends on has also had a minor bug fix which I found testing URL validation. This plugin can also be updated t v184.108.40.20646 using the WordPress plugin updater or can be downloaded and installed as in the past.
I have just uploaded a new build of wp-SwimTeam which addresses the bugs in the Jobs module I posted about last night. The bug would partially allocate a job but it would fail resulting in incomplete data in the database. The build fixes that bug.
If you had allocated jobs and can’t see them to sign up for them, the database records in the job allocation table may have to be removed manually. If you need help, contact me.
wp-SwimTeam plugin – updated 2/24/2011 @ 17:21
A new release of wp-SwimTeam is now available. This release addresses a number of issues encountered when running on a server with PHP 5.3.5 installed. This release requires the phpHtmlLib plugin to be updated to v220.127.116.1145 or later.
Make sure you backup your database before installing this update. This update also fixes some database table issues, deleting fields and columns which have been deprecated. Please report any issues you find, I have tried to test everything but I may have missed something!
wp-SwimTeam plugin – updated 2/20/2011 @ 18:11
Update: Bad link fixed! 2/21/2011
An update to the phpHtmlLib plugin which wp-SwimTeam depends on is now available. This update addresses a number of issues found running against PHP 5.3.5, the latest release of PHP. There are number of changes between PHP 5.2.x and 5.3.x which were exposed and have been addressed. This update is ABSOLUTELY necessary for anyone running on a server which has PHP 5.3.x installed.
wp-SwimTeam plugin – updated 2/20/2011 @ 18:11
I have encountered a problem running wp-SwimTeam under WordPress 3.0.4 on the MacDolphins web site which causes pages to not load completely. I am not sure what the problem is yet but it seems to be related to another plugin as it doesn’t happen on the wp-SwimTeam Demo site. It is most evident from the Swim Team -> Users tab where the page content is simply blank. I hope to have a resolution to the problem in the next day or two.
A few weeks ago I mentioned that I had started working on a new swim team project. I am calling it Flip-Turn. Flip-Turn is a basic PHP/MySQL web application which allows a swim team or swim association to publish swim results on the web in a format that is easy to navigate and view.
Dealing with results has been the last real big hole in wp-SwimTeam and I’ve started working on it a couple times only to abandon it because I didn’t like where it was headed. Over the winter I had an e-mail dialog where a team was simply looking to store results in a database so they could be easily displayed on a web page. As I started thinking about this I came to the conclusion that it would be an interesting project to work on and would be an easy way for me to find a better way to manage results.
For the last couple weeks I have been working on Flip-Turn as time permits and I now have a basic demo up and running. You can see it here: http://demo.flip-turn.com The demo is pretty simple, it allows a user to upload results in SDIF format and parses the results and stores them in a database. The results can then be queried based on swimmer, event, or swim meet. While pretty basic, it works pretty well.
In its current state Flip-Turn doesn’t deal with relay (E0) records but does handle individual (D0) records correctly. In most cases, what people seem to be concerned with are their individual results so that is what I have focused on. I don’t anything I have done will prevent dealing with relay records at a later date but for now, I don’t plan to address them.
Wile the code seems fairly robust, I am not ready to distribute the code yet as I don’t have a great solution for initializing the database tables or changes to the tables. I need to figure something out there – right now I have an SQL script that needs to be run against the database to create the tables. I used phpMyAdmin to initialize mine.
I fully expect to roll this effort back into wp-SwimTeam as this is something I’ve wanted to do for our swim team for a couple seasons.
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.
This afternoon I posted a new version of wp-SwimTeam. This version adds e-mail confirmation to the opt-in/opt-out process. It now behaves much like registration does, sending a confirmation e-mail to the swimmer’s guardian and to the e-mail address configured to receive opt-in/opt-out notifications.
There were a also a few minor bugs addressed but nothing of any real consequence.