Downloading times

Reply

Don Passenger replied on 10-25-2009 6:49 PM

rated by 0 users

You should probably sell those worthless wireless clocks to me at a significant discount thus saving you the grief associated with the fact that they don't work :-)

I use a higher powered text editor as well.  My software weapon of choice is notetab (free version available from http://notetab.com).  Super easy to craft little "macros" that are called clips in that program.  It does all sorts of amazing things for me -- like build upload files from many different cross country results formats.  It will do your times in no time.

I also suspect that you could create a place to paste times that would clean them up using macros in excel ... but absent your exactl files as examples hard to say.

Reply

Joshua Bowdoin replied on 10-26-2009 2:32 AM

rated by 0 users

Thanks for letting us in on your secret Don!  I've just downloaded NoteTab, and it looks pretty powerful.  Even boggles my mind a bit! :)

Do I understand correctly that others could use the clips you've already created for various formats?  If so, would you be interested in sharing your clips?  We could host them on the uploader, to help people upload other formats.

Reply

Don Passenger replied on 10-26-2009 4:28 AM

rated by 0 users

Notetab is the absolute bomb - seriously processes things!

I can easily share clips -- and better yet, many are really just regular expressions at the core, so if you duplicate the regular expressions in whatever you are using (some micro$oft bit? asp? -- I'm more a perl/php guy myself), you can even create an easy parser and skip notetab completely.

Here is one:

1. Colin Fisher (11) Delta (Ohio) 16:08.7 1
2. Justin Bateson (12) Blissfield 16:34.2 -
3. Elliot Oberneder (12) Delta (Ohio) 16:41.9 2
4. Jacob Simmons (11) Adrian 16:45.5 3
5. John Webb (11) Monroe Jefferson 16:50.5 4
6. Josh Holicki (12) Coldwater 17:08.6 5
7. Kevin Abair (10) Delta (Ohio) 17:08.9 6
8. Blake Garver (11) Napoleon 17:28.2 7
9. Maxx Lackie (11) Delta (Ohio) 17:31.2 8
10. Ricky Perez (11) Adrian 17:33.2 9
11. Michael Becker (11) Wauseon (Ohio) 17:37.4 10
12. Alex Nash (09) Delta (Ohio) 17:41.7 11
13. Gregg Garno (11) Adrian 17:42.2 12
14. Zech Hites (11) Delta (Ohio) 17:45.2 P
15. Calvin Howard (12) Adrian 17:46.5 14
16. Chris Zitke (11) Muskegon Orchard View 17:47.3 15
17. Brian Filter (10) Onsted 17:49.6 16
18. Ryan Regan (10) Monroe Jefferson 17:53.1 17
19. John Ross (12) Michigan Center 18:04.4 18
20. Andrew Turi (11) Delta (Ohio) 18:08.2 P
21. Ahron Gunn (10) Onsted 18:16.3 20
22. Michael Krebill (10) Parma-Western 18:27.2 21
23. Angel Gamon (10) Coldwater 18:30.1 22
24. Adam Klavon (12) East Jackson 18:30.4 -
25. Matt Kemner (09) Manchester 18:34.9 23
26. Chris Beckman (10) Napoleon 18:35.7 24
27. Brandon Bristow (10) Michigan Center 18:36.4 25
28. Dalton Moulton (10) Napoleon 18:37.2 26
29. Jacob Laferriere (10) Parma-Western 18:38.1 27
30. Alexander Bliss (09) Jackson Northwest 18:38.5 28
31. David Powers (10) Michigan Center 18:45.2 29
32. Grant Knierim (09) Wauseon (Ohio) 18:45.6 30
33. David Dheel (10) Blissfield 18:50.3 -
34. Brandon Farthing (10) Napoleon 18:52.0 31
35. Matt Sweet (10) Onsted 18:52.8 32
36. Brad St. Aubin (10) Eaton Rapids 18:55.2 33
37. Spencer Lukasik (10) Michigan Center 19:00.2 34
38. Cody Schutter (10) Jackson Northwest 19:00.9 35
39. Graham Rowe-Bultinck (10) Coldwater 19:01.7 36
40. Cody Witkowski (10) Muskegon Orchard View 19:04.8 37
41. Jared Rohrs (10) Wauseon (Ohio) 19:07.9 38
42. Tyler LaSerra (11) Napoleon 19:09.6 39
43. Ben Heuser (09) Manchester 19:10.2 40
44. Zach Gentner (11) Onsted 19:12.2 41
45. Ryan Fuller (10) Manchester 19:12.4 42
46. Teddy McClelland (12) Coldwater 19:13.1 43
47. Ryan Gentner (10) Onsted 19:13.6 44
48. Jason Jahn (09) Jackson Northwest 19:14.6 45
49. Alec Fisher (12) Wauseon (Ohio) 19:15.1 46
50. Ben Mahan (10) Wauseon (Ohio) 19:16.8 47
51. Jacob Pacifici (10) Brooklyn Columbia Central 19:20.7 -
52. Jacob Hildebrand (12) Napoleon 19:22.2 P
53. Jake Walker (10) Eaton Rapids 19:23.1 49
54. Brennan Furman (11) Michigan Center 19:23.5 50
55. Matt Johnson (12) Manchester 19:23.8 51
56. Walter Bockert (10) Springfield (Ohio) 19:24.9 52
57. Cameron Anderson (10) Onsted 19:27.4 P
58. Tony Morrow (09) Monroe Jefferson 19:28.5 54
59. Joe Torrez (10) Muskegon Orchard View 19:30.9 55
60. Justin Merkel (12) Michigan Center 19:34.8 P
61. Kraig Whitmyer (09) Eaton Rapids 19:36.7 57
62. Ryan Rhodes (10) Monroe Jefferson 19:37.7 58
63. Hugo Juarez (12) Muskegon Orchard View 19:41.0 59
64. Jon Crayne (10) Adrian 19:50.0 60
65. Andrew Benkovsky (11) Eaton Rapids 19:55.0 61
66. Gabe Ojeda (11) Parma-Western 19:57.4 62
67. Anthony Retli (11) Monroe Jefferson 20:00.6 63
68. Zachery Schramm (09) East Jackson 20:03.2 -
69. Alex Snyr (11) Onsted 20:04.3 P
70. Jake Jett (09) Muskegon Orchard View 20:06.6 65
71. Thomas King (10) Parma-Western 20:07.8 66
72. Tommy Calderon (10) Springfield (Ohio) 20:08.2 67
73. Skeeter Parker (11) Muskegon Orchard View 20:12.8 P
74. Chris Seward (12) Parma-Western 20:15.1 69
75. Michael Boyers (10) Wauseon (Ohio) 20:17.9 P
76. Donald J Radtke (12) Parma-Western 20:18.6 P
77. Justin Jeffrey (10) Adrian 20:21.8 P
78. Robert Mason (12) Eaton Rapids 20:23.2 73
79. Austin Wanar (12) Coldwater 20:33.9 74
80. Brock Harvey (12) Michigan Center 20:37.9 P
81. James McCormick (11) Eaton Rapids 20:39.6 P
82. Jon Newsome (11) Adrian 20:46.2 P
83. Joe Mazur (09) Manchester 20:47.5 78
84. Tyler Miller (09) Springfield (Ohio) 20:51.8 79
85. Nick O'Neil (12) Brooklyn Columbia Central 20:57.5 -
86. Chad Brown (11) Springfield (Ohio) 20:58.7 80
87. Bryant Sweet (10) Eaton Rapids 20:59.6 P
88. David Hench (10) Wauseon (Ohio) 21:11.3 P
89. Brandon Hill (09) Monroe Jefferson 21:18.2 P
90. Jordan Laird (11) Parma-Western 21:32.7 P
91. Shae Grooms (09) Springfield (Ohio) 21:33.3 85
92. Dakota West (09) Monroe Jefferson 21:43.1 P
93. Theo Synakowski (11) Jackson Northwest 21:56.9 87
94. Thomas Wenzlick (11) Coldwater 23:18.1 P
95. Brandon Robidoux (9) Blissfield 23:42.5 -
96. Tyler Kolbe (11) Jackson Northwest 24:40.6 89

1. Marin Baird (12) Wauseon (Ohio) 19:48.5 1
2. Katie Ott (10) Springfield (Ohio) 20:11.2 2
3. Mary Lehman (11) Jackson Northwest 20:21.2 3
4. Jesse Maske (09) Jackson Northwest 20:26.7 4
5. Bailey Creager (10) Wauseon (Ohio) 20:30.7 5
6. Becca Schott (9) Coldwater 20:31.2 6
7. Heidi Wobrock (10) Onsted 20:33.6 7
8. Jessi Battaglie (10) Chelsea 20:35.3 8
9. Kassie Bevier (10) Michigan Center 20:36.7 9
10. Liz Timoszyk (12) Manchester 20:37.7 10
11. Jessica Kern (11) Delta (Ohio) 20:42.9 11
12. Tessa Herring (10) Wauseon (Ohio) 20:44.4 12
13. Julia Reaume (10) Monroe Jefferson 20:45.4 13
14. Jenna Chandler (10) Manchester 20:48.1 14
15. Kate Laverty (10) Eaton Rapids 20:51.2 15
16. Kaitlyn Arnold (09) Jackson Northwest 20:52.8 16
17. Emily Haynes (10) Napoleon 20:54.0 17
18. Jaycie Littley (11) Coldwater 20:54.8 18
19. Lauren Yates (11) Blissfield 20:57.0 19
20. Kirsten Fruchey (10) Delta (Ohio) 21:00.1 20
21. Erin Bachler (10) Monroe Jefferson 21:00.6 21
22. Courtney Maher (12) Chelsea 21:01.0 22
23. Jordan Hofer (12) Napoleon 21:08.5 23
24. Danielle Dahl (10) Chelsea 21:14.8 24
25. Kaitlin Truman (10) Eaton Rapids 21:16.9 25
26. Morgan Olson (11) Onsted 21:18.1 26
27. Brandi Bedolla (11) Adrian 21:20.8 27
28. Ciara Metzoian (11) Monroe Jefferson 21:21.6 28
29. Krissie Bevier (10) Michigan Center 21:22.5 29
30. Bree Taylor (10) Michigan Center 21:23.4 30
31. Katrina DeMay (12) Napoleon 21:23.9 31
32. Johnson Elaine (10) Chelsea 21:30.3 32
33. Christy Weidmayer (09) Manchester 21:36.6 33
34. Erika Bayak (09) Muskegon Orchard View 21:40.4 34
35. Julie Beaumont (12) Chelsea 21:47.4 35
36. Corinne Carpenter (11) Chelsea 21:49.4 P
37. Courtney Collins (11) Muskegon Orchard View 21:52.7 37
38. Amanda Dheel (12) Blissfield 21:55.9 38
39. Tiffany Wesley (11) Onsted 21:59.3 39
40. Jackie Timoszyk (10) Manchester 22:08.0 40
41. Mara Pelok (09) Wauseon (Ohio) 22:08.6 41
42. Sam Zajac (11) Monroe Jefferson 22:08.9 42
43. Katelyne VanMourik (10) Jackson Northwest 22:21.0 43
44. Amber Gombash (11) Delta (Ohio) 22:22.8 44
45. Brittany Holdridge (11) Blissfield 22:23.9 45
46. Katelyn Dunn (10) Coldwater 22:25.7 46
47. Hannah Engle (09) Adrian 22:29.1 47
48. Mindy Freeland (11) Parma-Western 22:31.0 48
49. Alexa Howard (09) Adrian 22:35.5 49
50. Taylor Woodruff (12) Parma-Western 22:40.6 50
51. Sam Steinman (11) Monroe Jefferson 22:42.7 51
52. Pennie Winters (10) Jackson Northwest 22:43.4 52
53. Abby Kuntz (10) Wauseon (Ohio) 22:45.4 53
54. Brooke Taylor (10) Michigan Center 22:49.2 54
55. Alicia Price (10) Onsted 22:51.1 55
56. Emma Hofer (10) Napoleon 22:52.3 56
57. Jade Sharrer (11) Michigan Center 22:54.4 57
58. Aldrich Kennedy (09) Chelsea 22:55.0 P
59. Kyler Huss (10) Parma-Western 22:55.6 59
60. Carly Seeman (10) Delta (Ohio) 22:56.4 60
61. Ashley Zamer (12) East Jackson 22:58.6 -
62. Gina Henderson (10) Muskegon Orchard View 23:02.2 61
63. Mandy Harns (10) Eaton Rapids 23:02.5 62
64. Haley Neri (12) Blissfield 23:03.6 63
65. Danielle Wood (10) Napoleon 23:04.1 64
66. Betty Peterson (11) Parma-Western 23:04.6 65
67. Meaghan Gunner (09) Blissfield 23:08.4 66
68. Erica Robinson (09) Delta (Ohio) 23:10.1 67
69. Evelyn Dority (11) Manchester 23:15.3 68
70. Kate Hankins (11) Napoleon 23:16.5 P
71. Amy Stillman (10) Eaton Rapids 23:21.4 70
72. Aqsa Cheema (11) Parma-Western 23:27.6 71
73. Tyler Conley (12) Wauseon (Ohio) 23:29.1 P
74. Lauren Easton (10) Parma-Western 23:29.5 P
75. Jessica Bachman (10) Wauseon (Ohio) 23:30.2 P
76. Morgan Edwards (10) Springfield (Ohio) 23:32.7 75
77. Sania Cheema (11) Parma-Western 23:35.3 P
78. Kylie Sanders East Jackson 23:35.7 -
79. Lyia Abraham (12) Adrian 23:36.2 77
80. Courtney Eisenmann (12) Blissfield 23:37.4 P
81. Alexis Olson (11) Eaton Rapids 23:42.3 79
82. Haley Stadnikia (11) Jackson Northwest 23:43.6 P
83. Katelynn Bailey (10) Onsted 23:43.8 81
84. Sarah Duncan (09) Springfield (Ohio) 23:45.0 82
85. Courtney Goetz (09) Muskegon Orchard View 23:55.3 83
86. Simone Hairston (12) Muskegon Orchard View 23:57.0 84
87. Jennifer Tagsold (12) Blissfield 23:59.5 P
88. Becky Etue (12) Eaton Rapids 24:02.2 P
89. Emily Boller (09) Brooklyn Columbia Central 24:02.9 -
90. Arianna Bardoni (09) Monroe Jefferson 24:05.5 P
91. Meghan Jordon (11) Brooklyn Columbia Central 24:17.7 -
92. Brooke Ostaszewski (12) Michigan Center 24:28.4 P
93. Amy Hemker (12) Coldwater 24:43.5 89
94. Taylor Morse (11) Brooklyn Columbia Central 25:07.6 -
95. Jenny Kempher (11) Manchester 25:13.9 P
96. Brittany Long (11) Adrian 25:16.9 91
97. Marina Ostaszewski (09) Michigan Center 25:21.2 P
98. Katie Auston (09) Delta (Ohio) 25:21.5 P
99. Deidre Roesch (12) Adrian 25:37.8 P
100. Robin Aldrete (11) Muskegon Orchard View 25:47.3 P
101. Sam Mossing (12) Springfield (Ohio) 26:03.1 96
102. Alex Mazur (10) Manchester 26:03.8 P
103. Kaylene Lowe (10) Onsted 26:09.7 P
104. Ashlee Lewis (11) Adrian 26:10.6 P
105. Katie Wedemeyer (10) Onsted 26:16.1 P
106. Kelsey Lamson (10) Brooklyn Columbia Central 26:27.2 -
107. Ashley Branham (10) Muskegon Orchard View 26:35.0 P
108. Vidhi Patel (12) Springfield (Ohio) 27:30.7 102
109. Vivian Klingner (12) Coldwater 27:35.7 103
110. Marena Hickey (09) Coldwater 27:39.4 P
111. Megan Oberneder (09) Delta (Ohio) 27:58.1 P

I get this when I post results to my forum (all multiple spaces in original are reduced to single spaces ... so we have:

Place.[space]FirstName[space]LastName[space](Grade)[space]School[space]Time[space]Score

I want to pick off the bold parts.  I do it with a regex:

Let's see if this comes out right ... all one line:

^ *(\d*)\.* ([a-zA-Z\-\.\']+) ([a-zA-Z\-\.\']+) {0,1}\({0,1}(\d{0,2})\){0,1} (.*) (\d+:\d\d.\d+).*

I use two clips ... first calls the second:

^!Set %D%=^?{Race Division=1|2|_3|4|5|6|7|8|9|10}
^!Set %Gender%=^?{Race Division=_F|M}
^!Menu Modify/Spaces/Single Space
^!Replace "^ *(\d*)\.* ([a-zA-Z\-\.\']+) ([a-zA-Z\-\.\']+) {0,1}\({0,1}(\d{0,2})\){0,1} (.*) (\d+:\d\d.\d+).*" >> "^%D%\t^%Gender%\t$1\t$2\t$3\t$4\t$5\t$6" RAWS
^!Jump Doc_Start
DivId    Gender    Place    FirstName    LastName    Grade    School    Time^%NL%
;15. James Atchison (11) Grand Haven 20:13.4 -

^!Clip "set divisions at each line break"

and

:SetDivID
^!Jump Doc_Start
^!Find "\R{2,}" CIRS
^!IfError End

^!Set %D%=^?{Race Division=1|2|_3|4|5|6|7|8|9|10}
^!Set %Gender%=^?{Race Division=_F|M}
^!InsertText ^%NL%
^!Replace "(\d)\t(M|F)\t" >> "^%D%\t^%Gender%\t" RAS

^!Goto SetDivID

^!Goto End

Create a new clip library in notetab. Right click on the drop down of libraries (F4 toggles the library on and off if you don't see the library pane) and choose new library, call it athletic.net perhaps like I did :-)

Below where there are no clips, you can (after placing one of the two above clips on your clipboard) right click and say add clip from clipboard.  I name my clips with one athlete so I can see the pattern and then match it.  I have five or six of them or more.

Next I'll show you my clip that turns the following into useable athletic.net files:

http://playmakers.com/index.php?option=com_docman&task=doc_download&gid=276

It really is cool stuff.

I can actually make up a dream race in minutes combining results and all sorts of wonderful things.

I do use the pro version of notetab so it's possible that one of my clips may misfire in the light version as I don't test them there.  The biggest feature I have and you don't is multiple levels of undo.  I a pretty sure that the regex engine now matches however which is what is most important ... you do realize we are the only two still excited and reading this post?

Reply

Don Passenger replied on 10-26-2009 4:29 AM

rated by 0 users

That clip came through pretty well ... RAWS is at the end of the replace line after a space ... and it line wrapped it so you need to fix that in the clip when copying.  Otherwise it looks right on my browser.

Reply

Don Passenger replied on 10-26-2009 4:48 AM

rated by 0 users

How bored to you want to be?

Following line simply sets a variable for race id that will be placed at the front of all lines ... we'll later be able to change it for other races in the same set of data provided we separate the data with double return.

^!Set %D%=^?{Race Division=1|2|_3|4|5|6|7|8|9|10}

Following line sets a variable for Gender ... just realized it says Race Division a second time, but that is just the prompt so no matter.  Variables when setting them use the percent sign before and after, but when displaying them are preceded by a ^ as you'll see in a minute

^!Set %Gender%=^?{Race Division=_F|M}

Following line removes ALL double spaces between words (not between lines).

^!Menu Modify/Spaces/Single Space

The following is all one line from ^!Replace through RAWS.  It finds a pattern and replaces it with just parts of the found stuff.  The ( ) in the find are loaded into temporary variables which are then used in the replace so all of the $1, $2 are the found items inside parenthesis on the left.  Stuff found on the left outside parenthesis is discarded on the replace.  RAWS means Regex, All, Whole Document, Silent - it is the conditions of the replace.

^!Replace "^ *(\d*)\.* ([a-zA-Z\-\.\']+) ([a-zA-Z\-\.\']+) {0,1}\({0,1}(\d{0,2})\){0,1} (.*) (\d+:\d\d.\d+).*" >> "^%D%\t^%Gender%\t$1\t$2\t$3\t$4\t$5\t$6" RAWS

The following line simply goes back to the start of the document after processing so we are starting the search on the next line from the start of the document and the titles will be inserted at the top.

^!Jump Doc_Start

The following line inserts the titles at the top of the file.  The ^%NL% is simply a new line so that titles are on their own line and not mixed with the first athlete.

DivId    Gender    Place    FirstName    LastName    Grade    School    Time^%NL%
;15. James Atchison (11) Grand Haven 20:13.4 -

This simply calls another clip ... so the second clip has to be named exactly that or it won't work ...

^!Clip "set divisions at each line break"

This clip is now done and we are on to the next clip.

Reply

Don Passenger replied on 10-26-2009 5:01 AM

rated by 0 users

This clip MUST be named: set divisions at each line break

Reason: it is called by the preceding clip ... if you rename this clip then you need to fix the prior clip to call it by the name you gave it.

Following line is a subroutine label so we can go back here later with a goto if we wish ... and we do.

:SetDivID

The following line simply takes us to the top of the document (we are there already if we just ran the prior clip, but we can also run this clip independent of the prior clip

^!Jump Doc_Start

The following finds any instance of two or more returns in a row ... ie double spaced lines.  When I create my data I put two returns between different races, so I now find them.

^!Find "\R{2,}" CIRS

If there are no double spaces then we don't have any more races ... on NotFound we essentially get an error, so this ends the clip and we are done.

^!IfError End

The following two lines will set the Division ID and Gender for the race(s) below the cursor ... we cheat and set it for all races below the cursor, but then will fix them one race at at time as the clip processes.

^!Set %D%=^?{Race Division=1|2|_3|4|5|6|7|8|9|10}
^!Set %Gender%=^?{Race Division=_F|M}

This one is a little "tricky" because we found two (or more) returns in a row, the found text -- in this case multiple returns in a row -- is selected, so when we insert we replace the found text.  This is important because what I do with this is remove the double return before the race we are now fixing so that the next time through I skip the corrected race and find the next race on the next rendition as this is a looping clip.

^!InsertText ^%NL%

For all races from the cursor position forward, we replace the DivID (\d+), tab (\t), Gender (M or=| F) with the newly set DivID and Gender which are variables.  Note when using a variable we precede it with a ^ so it was %DivID% with no caret a few lines above when we Set it and its ^%DivId% with a caret when we "retrieve and use" the value in the variable.  Little nuance, easy to miss.  Note that search qualifiers are RAS so its Regex, All, Silent but note NO W because we only want to work from the cursor forward, thus not affecting races above the cursor.

^!Replace "(\d)\t(M|F)\t" >> "^%D%\t^%Gender%\t" RAS

The following starts over at the beginning of the clip so we repeat as many times as necessary to get all races corrected.

^!Goto SetDivID

The following line would end the clip if it ever got runaway, but in fact it never ever gets processed ... because the End on ifError above will end this clip.

^!Goto End

Reply

Don Passenger replied on 10-26-2009 5:16 AM

rated by 0 users

Last tip before I leave this hi-jacked thread alone ... how I get my data into notetab.

Open a new tab (control + n).  You now have a blank tab open.  Note it is NOT control + t ... notetab precedes the current tabbed programs -- hopefully this will be cured one day soon but it's control + n to create a new file.

Now hit control + shift + p which will turn the current document into a "paste board".  Now go to your race documents and copy out the parts you want from each race and they will go into that document when you copy (control + c).  They will be separated by a double return -- meaning they are all set for the above clip to work on them.  I am careful to copy them in the order of the DivId's and you'll see the logic.  I can process an entire race in about the same amount of time it takes me to add a race in athletic.net.

As an aside, I have requested that when I am looking at a meet it have an "add this meet to my calendar" link.  I have hit the point where 60% of the meets I am processing are already in the athletic.net system -- no results or only one or two schools results are entered, but the meet exists.  So when you add that (pretty please) it will save 3-4 minutes per meet for adding to calendar.

Reply

Don Passenger replied on 10-26-2009 8:15 AM

rated by 0 users

Paul Swanson:

Update: I've managed to retrieve the data and paste it into my race without red highlights.  The times come in as: Hours:minutes'seconds.tenthshundredths (0:16'45.34).  Does anyone know of a way to globally delete the zero hour's before I copy and paste from excel workbook into the race?

To bring us back on topic, a one line notetab clip will fix your times just fine:

^!Replace "^ *0{0,}:{0,1}(\d+)'(\d+)(\.{0,1}\d*) *$" >> "$1:$2$3" RAWS

input:

0:16'45.34
0:16'50.49
0:16'69.20

output:

16:45.34
16:50.49
16:69.20