About a week ago one of the volunteers inadvertently registered (Opt-In) our entire rosters for a swim meet. An Opt-In will supercede any existing Opt-In or Opt-Out information so we lost our entire scratch list for our meet this past Tuesday. I was out running errands getting my son ready to go on a mission trip when I started seeing numerous registration e-mails coming across my phone. Yikes – what happened? Initially I thought someone had gotten administrative access to our database and was playing games.
As it turns out the mistake our volunteer made was an honest one and I tracked it down by examining the Opt-In/Opt-Out records in the database. I have always logged the user ID for the user who submitted an Opt-In/Opt-Out request but never displayed it as I never had a need. It would have been really useful last weekend – imagine digging through your database using phpMyAdmin on an iPhone which is how I found it because I wasn’t anywhere near a computer at the time.
As a result of this exercise I have enhanced the Swim Meet Report on the Report menu to optionally show the user detail for the user who submitted the request. I also changed the Time Stamp so it can be shown if desired. Both of these options are on by default.
This release also addresses a bug where Opt-In/Opt-Out email confirmations were being sent to the Registration e-mail address. For a lot of teams this is probably same address but for the MacDolphins it is not. The result was our Accountant was being flooded with Opt-In/Opt-Out email confirmations and has been for the past three years! She never mentioned it to me until recently. Oops!
The release is now available from the Download page but has not been committed to the WordPress Plugin Repository yet because WordPress changed all of their passwords last week. While I can login to WordPress.com without any problems, I cannot get access to the plugin repository. Hopefully I will get this sorted out soon and then it should appear as an automatic update from the WordPress plugin repository shortly.
Update: I finally got my WordPress.org password issue straightened out and have committed the latest set of changes. The automatic update process should proceed within a couple hours.
There is definitely an issue with the Swim Meet Report, particularly the opt-in/opt-out list, produced by the wpst_meet_report short code. It produces different results depending on whether or not a user is logged in to the web site and what WordPress capabilities the user has. I hope to have a solution this morning as it is causing a fair amount of confusion with my own team!
WordPress 3.2 beta is out for testing and with it comes several requirements. The two notable requirements are PHP 5.2.14 or newer and MySQL 5.0 or newer. I will likely move to 3.2 for wp-SwimTeam development once it is released and I’ve done some testing with it. I’ve been running under PHP5 (5.2.14 and 5.3.x) for a while now so I don’t see this as an issue but it might be for people running on older web hosts.
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.
WordPress has a nice built in feature to update plugins when there is a new version available. Because wp-SwimTeam isn’t hosted in the official WordPress plugin repository, I haven’t been able to take advantage of this feature.
I have set up projects in the official WordPress plugin repository for both wp-SwimTeam and phpHtmlLib. I am working on a process where the plugin updater will work by adding the code into the WordPress repository when Iam ready to release it.
Currently the version of the code in the WordPress repository is the same as what is available for download although the version number reported is wrong (1.0.553 vs 1.2.553). The “553” is the critical part of the release number because it represents the Subversion commit number (build number) that the release is based on.
If you see a “plugin out of date” message within the WordPress Dashboard, it is because I am working on this process. The latest and greatest release will likely be available first as a download on this site but when I reach what I consider a “stable” release, I will also make it available through the WordPress plugin repository. Stay tuned as this flushes out.
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.
I have finally had some time to do testing against WordPress 3.0.1 and in the process, I have ran into a couple bugs that I need to fix. So far I haven’t found any issues running against WP 3.0.1 itself, the things I’ve run into would be an issue with any version of WordPress. These are known issues:
- Critical: Adding a Season will fail with an error regarding an Unsupported Action. This failure is due to a typo in a constant. I am not aware of a work-around.
- Critical: The Users tab on the Manage menu yields a blank screen. The cause is unknown and I am not aware of a work-around.
I hope to have these bugs fixed later this week and fully qualify WordPress 3.0.1.
I just uploaded a minor update to wp-SwimTeam. This release adds enhancements to the reporting for jobs and the opt-in/opt-out system. A new field called “Notes” was added to the Jobs definition. This field is reported when viewing the Job Assignments for a swim meet.
The time stamp for opt-in/opt-out is now included when generating a swim meet report. The time stamp can also be displayed via the short code by adding “timestamp=’y'” to the short code. Reporting the time stamp will allow you to easily see exactly when users submitted their request.
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.
I have not done much work on wp-SwimTeam over the past few months but about a week ago I dusted off my virtual machine (have I ever mentioned how much I love VMware Workstation?) in preparation for the upcoming season. Since I last worked on the project there have been numerous patches for Windows XP (my development area is an XP VM) and WordPress has moved from 2.7 through the 2.8.x releases and is now on 2.9.1.
All new work will be done against 2.9.1 (for now) so I have upgraded WordPress and the plugins that I use in conjunction with wp-SwimTeam. There are two areas where I will focus on immediately – importing results which I never finished last year and volunteer management. I’ll probably finish the portion of results I am working on right now and then move on to volunteer management since we’ll need that functionality in March when the MacDolphins do registration.