PDA

View Full Version : Postal swims not listed in top times?



smontanaro
October 11th, 2007, 09:18 AM
Rob's response in the "speed guage" thread prompted me to check out the top times page at usms.org. I noticed the postal swim distances (3000/6000 yds, 5000/10000 m) are not listed. Is there some reason why not?

Thx,

Skip Montanaro

Rob Copeland
October 11th, 2007, 10:06 AM
The postal championship results are found at http://www.usms.org/longdist/ldchamps.php

smontanaro
October 11th, 2007, 10:40 AM
Doesn't it sort of make sense to collect all top times in one place?

Skip

mbmg3282
October 11th, 2007, 12:44 PM
The results that appear in the top times section are meets that are run with HyTek's Meet Manager or some program that can produce a SDIF file. The postal swims are often run in excel or some other program. The current meet management programs don't always fit the needs of postal event directors. As an example, they don't have the capacity to display results from the One Hour Swim - our most successful postal event.

smontanaro
October 11th, 2007, 01:02 PM
Thanks. I'll bet I can whip up a Python script to convert CSV files to SDIF if it's some sort of rational format.

Skip

Rob Copeland
October 11th, 2007, 02:04 PM
I'll bet I can whip up a Python script to convert CSV files to SDIF if it's some sort of rational format.

SkipIíll take you up on that bet! Let me know when itís ready and Iíll make it available to the Postal event directors.

mbmg3282
October 11th, 2007, 02:08 PM
Here are the basics of the SDIF format - http://www.usms.org/admin/sdifv3f.txt

david.margrave
October 11th, 2007, 02:41 PM
I'm also a Python coder, maybe I'll take a crack at it too. Is there any sample data in CSV format?

knelson
October 11th, 2007, 03:02 PM
I'm also a Python coder, maybe I'll take a crack at it too. Is there any sample data in CSV format?

David, if you go to the USMS home page, pick "individual results" from the competition tab. Once you pull up an individual's results you can export to a CSV file using the link at the bottom of the page.

osterber
October 11th, 2007, 03:18 PM
It's not a lot of rocket science. The big variable is what your input data looks like. I did something in perl in a couple hundred lines.

-Rick

david.margrave
October 11th, 2007, 05:47 PM
It's pretty straightforward to convert CSV rows to D0 records, but if they need the 'record pyramid' or 'meet pyramid' sequence of records, that's a little more complicated. Anyway, here's the python that just does D0 records. Let's see that perl!

bash-3.00$ ./parse-csv.py SD272809.csv
D02 MARGRAVE, DAVID A 36MM 501 09232007 29.09S 1

D02 MARGRAVE, DAVID A 36MM15001 09232007 21:57.23S 1

D02 MARGRAVE, DAVID A 36MM 503 09232007 41.02S 1

D02 MARGRAVE, DAVID A 36MM 504 09232007 33.08S 1

D02 MARGRAVE, DAVID A 36MM 1005 09232007 1:16.87S 1

david.margrave
October 11th, 2007, 05:51 PM
I couldn't upload a file with a .py extension so here it is as .txt

Leonard Jansen
October 12th, 2007, 01:52 PM
They should redo this to be specified in XML. Lots of tools to get at the data then.

-LBJ

matysekj
October 12th, 2007, 06:06 PM
Leonard, see http://www.usaswimming.org/USASWeb/DesktopDefault.aspx?TabId=547&Alias=Rainbow&Lang=en for info on the XML version of SDIF. Yes, there is such a beast, but I don't believe any (or many) are using it. I could be wrong, but I know that USMS people are not using it, and I don't think that USA Swimming has pushed it either. The meet management tools we use today don't support it. Before you get a chance to say it, yes - we (together with USA Swimming) SHOULD push for it's adoption by informing vendors that as of a certain date, we won't use their software unless they support it. That ought to wake them up.

As you can see, I agree that an XML format would be waaaaaay better. As it stands today, if your name is too long or if you are over 100 years of age, you're out of luck (as a few minor examples).