Meet result files (.zip, .cl2, .sd3) are always the better option. If you still have them, send those instead. See Onboarding: send your results history. These Top Times exports are how we rebuild your history when the original meet files are gone.
What we need and why
Each report covers something the others miss:
- Top Times By Athletes has most of your swims.
- Top Times By Events (Individuals ONLY) keeps swimmers who’ve left, and keeps other clubs’ times off your record boards.
- Top Times By Events (Relays ONLY) is the only place relays show up. Skip it and your relay records come over empty.
Run every one of them once per course. Most clubs swim short course yards and long course meters, so that’s two of each. If you also have short course meters results, add a third file for each report.
Step 1: Open Time Reports
From the left menu, go to Events & Competition, then under Results & Reports click Time Reports.
Step 2: Top Times By Events, individuals
Click Top Times By Events.
Set the report up like this:
- Meet Filter: set Meet Name to
--ALL--and pick one Course. You’ll come back and repeat this for each course you swim. - Member Filter: leave everything on
--ALL--. Change Status from Active to--ALL--. Skip this and you lose every swim by kids who have left. - Meet Event Filter: set Event to Individuals ONLY, P/F to Best of
Prelims/Finals/Trial and Stroke to
--ALL--. - Display Options: set Show Top to
0. It starts at1, and0means every result, not just the best one. Check Show ID# and Show Birthdate. Leave Show At Most One Athlete per Event unchecked. Set Include Splits to Cumulative (Running). It starts with no splits. - Age Groups: Use Team Defined Age Groups (Recommended) is fine.
Click Report Now!
The report builds on screen. At the top of it, click Save as XLS and keep the file. Then change the Course and run it again, once per course.
Show Top is the setting clubs miss most often. Left at
1, the export only carries one swim per event and the rest of your history never arrives.
Step 3: Top Times By Events, relays
Go back to the same Top Times By Events report and change one thing: set Event to Relays ONLY. Everything else stays as it was.
Click Report Now!, then Save as XLS. Run it once per course, the same as the individual export.
Step 4: Top Times By Athletes
Back on the Time Reports page, click Top Times By Athletes.
Set it up the same way:
- Course: one course per file.
- Status:
--ALL--again. - Event: Individuals ONLY. P/F: Best of Prelims/Finals/Trial.
Stroke:
--ALL--. - Check Show ID# and Show Birthdate. Include Splits: Cumulative
(Running). Show Top:
0. - Output Format: HTML: On-Screen, not PDF. PDF gives you no Excel file to save.
Click Report Now!, then Save as XLS on the report that appears.
Step 5: Send them to us
Upload everything on the Results card of your onboarding page. Count your files before you send:
| Courses you swim | Files |
|---|---|
| SCY + LCM | 6: two by-event individual, two by-event relay, two by-athlete |
| SCY + LCM + SCM | 9: three of each |
Name them so the course is obvious (SCY-individual.xls,
LCM-relays.xls) and we’ll take it from there. We load them, match each
swim to your roster, and your swimmers’ profiles open with their best
times and history already in place.
Common questions
How far back does this go? As far back as SportsEngine has. Show
Top at 0 gets every swim, not just the best one. Status at
--ALL-- keeps swimmers who have left.
We only swim short course. Then you send three files instead of six. Run each report once, for SCY.
The report takes a long time to build. That’s normal for a club with years of history. Leave the tab open and let it finish.
Can we send these and the meet files? Yes, and it’s the best case. Send both and we’ll match them up.