SDIF Utilities?

I am considering adding some SDIF utilities to wp-SwimTeam.  Just this week I have had to deal with submitting meet entry data to a team who uses Meet Manager.  Ugh.  Everytime I have to do this it reinforces my dislike for the Hy-tek products.

Fortunately Hy-tek now has a demo version of Meet Manager available which while limited to 6 events, is useful for testing in a limited fashion.  For example, I was able to verify that the MM RE1 export from wp-SwimTeam will load in Meet Manager.  I was also able to test quite a few permutations of SDIF E0 and D0 records until I figured out what combination of course and seed times would load successfully.

Now that I know what works I am considering adding a couple utilities that will apply changes to an uploaded SDIF file and send it back for download.  If you have ideas for SDIF manipulations that need to be made, drop a note in the comments and I’ll see what I can do.

The first one I will do will modify SDIF files to include seed times (which are optional per the SDIF specification) when the fields are blank.

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”
  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!