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!

Volunteers progressing

Over the last couple of days I have finally made some visible progress on the Jobs module. I am still not wild about the term “allocate” but it is the best I have come up so I am proceeding with it.

At this point I am able to define jobs, allocate a job and quantity required against a swim meet and make some refinements of the allocation. I also have the beginning of the assignment to a specific user GUI done but not the backend functionality. I am optimistic that I may finish a first pass this weekend.

Making progress on Volunteers

Progress on volunteers has been slower than I thought it would be.  It turns out that jobs, which is how I refer to the various roles that volunteers take on within wp-SwimTeam, is harder than I thought it would be.

The underlying data is fairly easy to manage but how to present the jobs, associate them with a season or swim meet, and then assign people to fill them has been a challenge.  I think the reason I am struggling with this is I am not happy with the terminology I am using.  There are three aspects to the Jobs functionality:

  1. Definition of jobs:  Titles, descriptions, duration, etc. 
  2. Allocation of jobs:  Jobs are allocated to either a season or a swim meet or multiple meets.  The number of positions for each job will vary.  For example, the number of timers needed is dependent on the number of lanes the host pool  has.  You might need four timers one week and then three the next.
  3. Assignment of jobs:  Connecting a name to a particular job.  The Lane 2 timer at meet XYZ will be Betty Jones.  The Announcer at meet ABC will be Tom Burns.

I am ok with the “Definition” of jobs and the “Assignment” of jobs but I don’t like the term “Allocation” but I can’t think of anything better.  If you have a suggestion, drop me a comment!

DocBook to PDF?

I spent some time this afternoon writing some content in DocBook format using a tool called XMLmind XML Editor. I am using the free Personal Edition. I like the editor, it was quick to learn and works as advertized. After writing a couple pages I decided to see how it looked as a PDF file.

It turns out that turning DocBook into PDF isn’t as easy as I thought it would be.  I have yet to find a good solution.  I may have to buy the full version of XMLeditor.

wp-SwimTeam documentation?

Like a lot of projects, documentation for wp-SwimTeam is severely lacking.  It has been on my to-do list for a long time and I have been thinking about it recently.  I was heading down the Wiki route recently and actually got one set up.  I’ve never been a big Wiki fan but I do see their attraction for certain types of projects.

I personally prefer “real” documentation and by “real” I mean something you can print and read away from the computer.  I’ve always like the model that used by Version Control with Subversion has used.  The source is in DocBook format which means it can easily be produced as web pages, a PDF file, or an actual book.

Right now I am leaning toward using the DocBook format.  At a minimum I am going to try it and see how it goes.  Stay tuned!

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.

Ramping back up for Swim Team

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.

Charting Results

As I work on results functionality I have several ideas floating around my head.  One is the ability to chart swimmer results over the course of a season or possibly several seasons.  Charting over several seasons raises some issues (e.g. different age groups, event distances, etc.) but charting results for at least one season would be interesting.

I had thought about using the same functionality that the WordPress.com Stats plugin uses which is Open Flash Chart to plot results.  Today while looking for something else, I may have found something which is a better solution:  pChart – a PHP library for building charts!

Hopefully I will get to try it out in the next few weeks.  I have been sidetracked by a WordPress project for my daughter’s soccer team so Swim Team will have wait a little longer.

New functionality in the works

I haven’t posted much but I have been working on wp-SwimTeam off and on now that the MacDolphins summer season is over.  I haven’t released anything yet but I’ve made some significant improvements. 

Opt-In/Opt-Out

Improvements have been made to the Opt-In/Opt-Out process to make it much less confusing.  The Opt-In/Opt-Out form is now smarter, only presenting the list of strokes to the user when a Partial Opt-In/Opt-Out is selected.  The ability to Opt-In/Opt-Out has also been added to the “My Swimmers” tab to make it easier to find.

Login Redirect

I’ve also added a new option to control what happens when end users login to a site running wp-SwimTeam.  For most users, landing on the WordPress Dashboard page is confusing.  They don’t care about 99% of the stuff presented to them nor should they.  The plugin now allows definition of a login redirect so the user can be sent to either the home page or the Swim Team Overview (which is what I expect to use most of the time) page.  Landing on the Swim Team Overview page makes the most sense for most users since when they login, they are most likely doing some level of interaction with the swim team functionality.

Results Import

Results import is still  in progress, the other two areas mentioned above are complete.  At this point importing results does little more than perform a first pass validation that the supplied file is indeed a SDIF results file.  Now that I have the uploading and validation complete, I need to work on the data model to store results.  Results will be connected to swimmers and meets and events.  Since a new table will be created, results will change the database version when it is released.

Initially I expect to simply report results from a meet and be able to look at results for any given swimmer.  Longer term I want to use Open Flash Chart to plot results on a per swimmer basis over the course of a season or possibly several seasons.  I don’t expect to get to this until much later this year though.

WordPress 2.8.x

I am still working with WordPress 2.7.1 in my development environment.  I haven’t even tried 2.8.4 yet so I have no idea what the impact is.  I will likely do so once I am done with the results.

wp-SwimTeam v0.1.389 released

This evening I uploaded a new version of wp-SwimTeam.  It is available on the download page.  This version introduces a new report for swim meets.  The Swim Meet report’s most important feature is the listing of swimmers who have Opted-In or Opted-Out of a swim meet.  On the MacDolphins we call this a the Scratch List.

A parent can now indicate when their swimmers are participating (for meets defined as opt-in) or not participating (for meets defined as opt-out) on either a full meet or event basis.  The meet report will display a summary of swimmer participation based on the type of meet.

A couple of the options on the Report Form are disabled because they aren’t functional yet.  They will probably work in a day or two.

This release also introduces a new mode for Swimmer Labels – Frozen.  When Swimmer Labels are unlocked, they can be bulk assigned.  When they are locked, Swimmer Labels can be edited on a per swimmer basis but no bulk assigned.  When they are frozen, they can’t be edited at all.  I added this because I inadvertently reassigned the swimmer labels for the MacDolphins yesterday without meaning to.  Whoops.

I fixed a few other minor issues as well but nothing significant, mostly presentation of forms and such.