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
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.
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.
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
