wp-SwimTeam v1.0.514 available for download

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 v2.6.2.3545 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
[download#7#image]

phpHtmlLib v2.6.2.3545 available

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
[download#8#image]

Bug found – PHP 5.3.x incompatibility

The problem which I suspected was due to a plugin conflict turns out to be a PHP 5.3.x incompatibility.  I don’t have a solution yet because I don’t fully understand what changed but I am working on it.  There is no potential of database corruption, the bug simply fails to load the GUI on any of the Swim Team pages except the Overview page.  This bug only affects sites running on PHP5.3.x, sites running on PHP 5.2.x or PHP 4.4.x are not affected and will operate correctly.

UPDATE

I have identified and fixed the problem.  There is a change in PHP 5.3 which affects how objects of a child class can call methods in the parent class.  The syntax which has worked fine until PHP 5.3 occurs in both the wp-SwimTeam plugin and in the phpHtmlLib plugin so both will need to be updated.  I have found several places where the code needs to be updated to the new syntax requirements but still need to do further testing to make sure I have found them all.

Preparing for a new release

I’ve been working on wp-SwimTeam over the past couple days and fixed a lot of minor issues and a couple of bigger ones and one critical one in phpHtmlLib.  The change in phpHtmlLib is absolutely required to support WordPress 3.0 and later so it will be necessary to update the phpHtmlLib plugin in addition to the latest update.

This upcoming release of wp-SwimTeam is ONLY being tested against WordPress 3.0.x (3.0.4 in my case).  It may work fine with 2.9.x but I do not plan to test it.  This upcoming release also tweaks the database, dropping columns that are no longer used.  This is primarily an issue with the Users and Swimmers table where there were some remnants left from the previous implementation of optional fields.  Make sure you backup your database prior to installing!

The release should be available in the next day or two.

Flip-Turn – swim results management

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.

wp-SwimTeam v0.2.500 now available

The MacDolphins summer swim season ended this past Tuesday but there are few things I wanted to fix while they are still fresh in my mind.

Our volunteer coordinator had asked me if I could make it so she could export the Job Assignment Report to Excel.  When I got into it I realized that the approach I was taking with the original Job Assignment Report was based on an old report and I really should have based it on the Users report.

Since the Job Assignment Report leverages the User information, I was able to base the new Job Assignment Report on the classes for the User reports.  This was absolutely the right decision as it saved me from writing a bunch of new code which would be similar to. if not exactly the same as, the code for the User Report.

This release fixes a couple of minor nits but mainly it introduces a new Job Report which can be exported as a CSV file which is easily manipulated with Excel.  The report can also be generated as a HTML table and allows the user to specify which fields are to be included in the report.

wp-SwimTeam v0.2.496 available

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.

wp-SwimTeam v0.2.488 – bug for scratches

There was a bug in the scratch process where if you started on the Meets tab when the Scratch action was selected, there was not a list of swimmers presented for the user to scratch.  When starting on the Roster page and selecting a swimmer to scratch did work properly.  The bug has been fixed and v0.2.488 is now available for download and both paths, starting with a meet or starting with a swimmer, now work correctly.  The same bug would have affected Opt-In meets as well.

wp-SwimTeam v0.2.486 now available

A couple of new features have been added to wp-SwimTeam.

  1. It is now possible to export a single swimmer’s record to CSV of SDIF.  When a single swimmer is selected, the exported file will contain the information for just that swimmer.  When no swimmers are selected, the entire roster will be exported.  Single swimmer SDIF export is useful for importing late additions into WinSwim which is something I’ve had to do a few times this week.
  2. The LSC Registration Pyramid (SDIF) can now be generated using the Age Group Age (computed base on cut off date) instead of the swimmer’s true age.  By default the real age is exported which is what wp-SwimTeam has done traditionally.  If you want to use the computed Age Group Age, change the setting on the SDIF Profile tab from the Options menu.

A new version, v0.2.486, of wp-SwimTeam is available for download from the Download page.

Jobs module is almost done

This past week I have made quite a bit of progress on the jobs module.  Everything seems to be working, I just have some polish and testing to finish up before I will release it.  The basic job work flow works like this:

  1. Define a job – title, description, duration, etc.
  2. Allocate a job to a season or to one or more swim meets.  This action connects a job to a specific season or meet and defines the number of positions required.
  3. Assign job ownership.  This can be done by either the administrator or by end users themselves.  End users cannot assign themselves jobs which are already assigned to another user.  An administrator can change the assignment of a job from one person to another.  Job assignment can be performed in couple different ways:
    • Full or Partial Season long jobs can be assigned from the Seasons tab.
    • Full or Partial Meet long jobs can be assigned from the Swim Meets tab.
    • A specific job can be assigned from the Jobs tab.

The Swim Meet Report has been enhanced to include a Job Assignment section and a new short code has been defined to allow a meet specific job report to be added to a page or post easily.  The wp-SwimTeam demo site will be updated shortly to show some of the new features.