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.

wp-SwimTeam v0.2.484 available

A new version of wp-SwimTeam has been posted.  This releases fixes a couple minor bugs which prevented display of swim meet information in certain situations when scratching or registering from a swim meet.  This version also introduces two new features:

  1. Open or Close the registration system. When the registration system is open, users can register their swimmers for the current season.  When the registration system is closed, only an Admin or Editor can register swimmers.  This setting appears on the Registration tab from the Options sub-menu.
  2. Enable or disable user sign ups for jobs. When the job system is set for user sign ups, a user can sign up for any open job.  When the job system is set for admin sign up, users with either Admin or Editor roles can sign users up for jobs.  This second mode is good for teams where a paper or Excel list is used for job sign ups.  This setting appears on the Swim Team tab from the Options sub-menu.

wp-SwimTeam v0.2.482 released!

This afternoon I uploaded v0.2.482 of wp-SwimTeam.  This release introduces the new Jobs module (aka Volunteers).  Please back up your database before upgrading as this version changes the structure of one of the tables and introduces two others.

Please let me know if you have any problems with this version.  I’ve done a fair amount of testing and I have it up and running on the MacDolphins web site.

The jobs module introduces two new short codes:

  • wpst_job_descriptions
  • wpst_meet_job_assignments

Example usage of these two new short codes can be found on the wp-SwimTeam demo site here and here.

There is also a new release of the phpHtmlLib plugin which wp-SwimTeam requires available.  This build addresses a minor issue exposed in WordPress 3.0 beta testing.

Hopefully the new Jobs module will be helpful for your team, I know it will be helpful for mine!

Export Roster to Meet Manager

If you have followed my posts on this blog you know that I have been frustrated by Hy-Tek Team Manager and Meet Manager along with Hy-Tek customer support.

While I may not care for Hy-Tek or their products, the fact is they have a dominant market share and a lot of teams use Team Manager, Meet Manager, or both.   I was  contacted this week by a high school coach who was looking for some SDIF assistance in getting his roster into Meet Manager.  Now I don’t have access to Meet Manager but I do have pretty good understanding of the SDIF specification so I was able to help him out with some example SDIF files.

In the process of helping him out I came across an old e-mail regarding importing a roster into Meet Manager.  At the time I was interested in Team Manager so didn’t give it a lot of thought.  Looking at the old e-mail I realized that if it worked, I could export the file format very easily from wp-SwimTeam.  I went ahead an implemented it, now I am looking for someone to try it out.

Sample Reports

Download Sample Exports Version v1

The zip file above contains three versions of the same roster – CSV, SDIF (.sd3), and Meet Manager Registration (.re1).  Extract the Meet Manager Registration file from the zip file.  It is an ASCII file that contains swimmers records, one per line with the following fields delimited by semicolons:

  1. Registration number
  2. Last name
  3. First name
  4. Middle initial
  5. Sex
  6. Birthdate
  7. Club abbreviation
  8. Club name
  9. Preferred first name
  10. ?? – unknown what this last field is; it’s always “N” in the examples provided

To import the file into Meet Manager, follow these steps:

  1. Set up a new meet database.  You only need to go through the first setup screen, the one where you put in the meet name, date, and length of course.  To make my particular file work, select “USA Swimming” for the ID format.  If you have something other than USA Swimming numbers for swimmer labels, select “Other”.  Normally, for a kids’ meet, you’d select “USA Swimming” for the ID format or “Other” if you are not using USA Swimmer numbers for simmer labels.
  2. From the main Meet Manager menu, select “FILE”
  3. Select “IMPORT”
  4. Select “REGISTRATION FILE”
  5. Locate and choose the .RE1 file that contains the roster.

After completing these steps, go to the “Athletes” screen in Meet Manager.  The swimmers contained int he RE1 file should bYou should see all of the athletes’ names that you saw in the RE1 file.

If this works for you, please leave a comment!

Current Known Issues

Here is a list of known issues with the current (v0.1.450) release:

  • Roster CSV export does not work. Fixed in v0.1.455.
  • Scratch/Register lists all meets instead of only meets for active season.
  • There a couple of debug strings still displayed. Fixed in v0.1.455.
  • Global Update does not include Status.
  • Scratch and Registration reports look at current season for swimmer labels instead of the season the meet was created for. Fixed in v0.1.456.

wp-SwimTeam v0.1.450 now available

This morning I completed phase 1 of some new functionality that I have referred to as “Global Update”.  The Global Update functionality allows all of the Optional Swimmer Fields that have been defined to be changed in mass from their current value to another value.

If you are using an Optional Swimmer Field (OSF) to track something like “Fees Paid” as a “Yes-No” field, you can use the new Global Update to reset them all to the “No” state.  This functionality may be applied to Optional User Fiends (UOU) as well but right now it is limited to only OSF fields.  Additionally, the “Results” field currently is displayed but changing it has no effect.

There are a few other changes that I fixed as I run into things and I also fixed the situation with the Swim Team Profile labels Michael Hale ran into recently.  The issue there was if the label was only numeric it was invalid HTML for the field name.  There is now a check to ensure that whatever text is specified for the label will now be valid for an HTML attribute.

This version also changes how the Status field is determined.  It is now derived based on the Active Season.  There is an issue sorting on the Status field on the All Swimmers tab so it is currently disabled.

You can find v0.1.450 on the Download page.  I strongly recommend backing up your database before installing this version.

Heat Sheet Builder Excel Workbook v1.1

When our coaching staff constructed their heat sheet by hand they always wrote it up as a matrix with the heats on the vertical axis and the lanes on the horizontal axis.  This style of heat sheet matches the layout of the pool and the way the kids line up as they get ready to swim.

Now that we are doing all of our seeding using WinSwim, we no longer have the matrix style heat sheet and many of our parents have asked if we can get the heat sheet in that format.

After playing around with Crystal Reports for a while I concluded that it would easier to develop an Excel workbook to construct the heat sheet than it would be to get Crystal Reports to do it.  I am sure CR can do it but I don’t know how and I needed something this season!

image

The Excel workbook I developed consumes the output of the Custom Report Meet Heat Sheet by Event (CSV) that I developed and posted previously (make sure you download the update as I changed the report recently).

The workbook requires Excel 2007 to run.  It will actually run in Excel 2003 if you load the Office 2007 compatibility pack for Office 2003 however the sorting functions are disabled so you’ll have to do your own sorting.

There are some controls over the width and height of the cells that comprise the heat sheet and page breaks will be inserted after every three events.  They can be adjusted using Excel’s standard page break functionality.

Heat Sheet Buildervv1.1, last updated on 2009-07-06

Download a sample heat sheet which was generated with Heat Sheet Builder.

Heat Sheet Builder Samplev07-05, last updated on 2009-07-06

Download the collection of Custom Reports for WinSwim.

WinSwim Custom Reportsv07-05, last updated on 2009-07-06

This Excel workbook is free to download – there is sample data included in it, before using it I would suggest looking at the Heat Sheet CSV tab to see the format of the data once it is imported from the CSV file.

wp-SwimTeam v0.1.417 – Meet Report Shortcode

I posted wp-SwimTeam v0.1.417 this afternoon to the download page.  This update adds new functionality and fixes a few minor things which have bothered me as I found them during the season.

The big new feature is a new shortcode – wpst_meet_report.  This shortcode allows a the contents of a meet report to appear in a post or a page like this example on the wp-SwimTeam demo site.

The reports also now support hiding first and last names by only showing the initial as well as the ability to override the first name with a nickname if the swimmer’s profile has one.  The missing ability to display a map on the swim meet report has been added so the checkbox on the form is now enabled.  The reports can now display opt-in and opt-out information chronologically in the order they were added to the system as well as the previously available by name and by swimmer label.