Reports and Directories

All reports are stored in the following directory: C:\SPORTSYS\SwimTools

Within the directory each report type has its own sub-directory

“Entries” – Accepted Entries
“HeatSheet” – Heat Start Lists
“Programme” – Meet Programme
“Results” – Meet Results
“Reports” – General Reports

All report have a .trdx extension , they can be edited using the ‘Report Designer’ which can be accessed from the ‘Tools’ menu within SwimTools Desktop.

If you are modifying reports we recommend that you save it with a different filename to avoid any updates overwriting your changes. When saving reports the designer will give you a choice of filetype. Please choose .trdx NOT .trdp . Only .trdx reports will appear within SwimTools Desktop.

When you generate a report in SwimTools, a CSV datafile is generated which is used by the report to present the data. The .CSV which is generated is placed in the report directory.

There is no requirement to change any of the reports as a standard set of reports have already been created for you to use. This information is only provided if you wish to change or customise the reports. Some clubs will only want to add their own club logos or in most cases change nothing and just use the provided reports.

Entries (C:\SPORTSYS\SwimTools\Entries)

Filename

Info

Fields

Swim England – Club – Order by Club + Swimmer.trdx

Accepted Entries report


Entries will be ordered by Club and then Swimmer Name

.CSV File: Entries.csv


<DataColumn Name=”MeetName” />

<DataColumn Name=”SwimmerClub” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”SwimmerYear” />

<DataColumn Name=”EventNo” />

<DataColumn Name=”EventName” />

<DataColumn Name=”Competitor” />

<DataColumn Name=”SwimmerTime” />

<DataColumn Name=”Session” />

<DataColumn Name=”EventTime” />

<DataColumn Name=”Generated” />

<DataColumn Name=”SwimmerDOB” />

<DataColumn Name=”SwimmerAge” />

<DataColumn Name=”Disability” />

<DataColumn Name=”ISDisability” />

<DataColumn Name=”SwimmerTimeSort” />

<DataColumn Name=”NoTime” />

<DataColumn Name=”SessionTime” />

Heat Start List (C:\SPORTSYS\SwimTools\HeatSheet)

Filename

Info

Fields

Swim England – Club Style.trdx


Swim England – Club Style – Inc Team Names.trdx


Swim England – Club Style – Finish Judge.trdx


Swim England – Club Style – Referee.trdx

Standard 2 Column Heat Start List


Standard 2 Column Heat Start List with Team Relay Swimmer Names


1 Column Heat Start Sheet with space for finish judge to write result


1 Column Heat Start Sheet with space for referee to write notes and any DQ information.

.CSV File: HeatData.csv


<DataColumn Name=”MeetName” />

<DataColumn Name=”Session” />

<DataColumn Name=”SessionNo” />

<DataColumn Name=”EventNo” />

<DataColumn Name=”EventName” />

<DataColumn Name=”HeatNo” />

<DataColumn Name=”HeatNew” />

<DataColumn Name=”LaneNo” />

<DataColumn Name=”CompetitorNo” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”Age” />

<DataColumn Name=”Disability” />

<DataColumn Name=”Club” />

<DataColumn Name=”Time” />

<DataColumn Name=”Swimmer1″ />

<DataColumn Name=”Swimmer2″ />

<DataColumn Name=”Swimmer3″ />

<DataColumn Name=”Swimmer4″ />

<DataColumn Name=”Swimmer5″ />

<DataColumn Name=”Swimmer6″ />

<DataColumn Name=”IsDisability” />

<DataColumn Name=”DisabilityCodes” />

<DataColumn Name=”Swimmer1N” />

<DataColumn Name=”Swimmer2N” />

<DataColumn Name=”Swimmer3N” />

<DataColumn Name=”Swimmer4N” />

<DataColumn Name=”Swimmer5N” />

<DataColumn Name=”Swimmer6N” />

Programme (C:\SPORTSYS\SwimTools\Programme)

Note: When the Programme is generated in SwimTools it checks for the competing swimmer report, if it is not present then some fields like DOB and SwimmerSE will not be populated and will be blank.

Filename

Info

Fields

Programme – 2 Column.trdx


Programme – Age Grouped.trdx


Programme – Age Grouped Junior and Senior.trdx


Programme – Age Grouped 11-12 to 17Over.trdx

Standard 2 Column Meet Programme


Meet Programme grouped into age groups – 9/Under | 10 | 11 | 12 | 13 | 14 | 15 | 16/Over


Meet Programme grouped into Junior and Senior 16/Under + 17/Over


Meet Programme grouped in regional format ages – 11/12 | 13 | 14 | 15 | 16 | 17/Over

.CSV File: MeetSheet.csv


<DataColumn Name=”MeetName” />

<DataColumn Name=”EventName” />

<DataColumn Name=”CompetitorNo” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”Age” Type=”Integer” />

<DataColumn Name=”Club” />

<DataColumn Name=”Time” />

<DataColumn Name=”Dots” />

<DataColumn Name=”Session” />

<DataColumn Name=”Disability” />

<DataColumn Name=”Gender” />

<DataColumn Name=”SSEventCode” />

<DataColumn Name=”QTCode” />

<DataColumn Name=”QTTime” />

<DataColumn Name=”SwimmerFirstName” />

<DataColumn Name=”SwimmerSurname” />

<DataColumn Name=”SwimmerDOB” />

<DataColumn Name=”SwimmerSE” />

<DataColumn Name=”SwimmerGender” />

<DataColumn Name=”Type” />

<DataColumn Name=”TimeSort” />

<DataColumn Name=”NoTime” />

<DataColumn Name=”EventNo” />

<DataColumn Name=”FinalOf” />

<DataColumn Name=”SessionDate” />

<DataColumn Name=”SessionTime” />

<DataColumn Name=”SessionAMPM” />

Session – Swimmer Calculator.trdx

Report to show the numbers of swimmers from each club in each age group, both male and female , broken down into each session.


Very useful to decide where to seat swimmers poolside and how much warm up time to allocate each club.


We recommend that you don’t make changes to this complex report.

.CSV File: SwimmerSessions.csv


<DataColumn Name=”Session” />

<DataColumn Name=”Club” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”Age” Type=”Integer” />

<DataColumn Name=”Gender” />

<DataColumn Name=”MeetName” />

Result Reports (C:\SPORTSYS\SwimTools\Results)

Filename

Info

Fields

SE Club Style – Results.trdx


SE Club Style – Medals Table Results.trdx

Standard meet or session result report.


Basic meet or event results, will output either first 3 or 6 results with tick boxes for the medals table when the swimmer has collected the award.

.CSV File: MeetResults.csv


<DataColumn Name=”MeetName” />

<DataColumn Name=”EventNo” Type=”Integer” />

<DataColumn Name=”EventName” />

<DataColumn Name=”EventIsTeam” />

<DataColumn Name=”EventGender” />

<DataColumn Name=”ResultGender” />

<DataColumn Name=”EventIsFinal” />

<DataColumn Name=”EventFinalOfEvent” />

<DataColumn Name=”SwimOff” />

<DataColumn Name=”ResultPlace” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”SwimmerAge” Type=”Integer” />

<DataColumn Name=”SwimmerClub” />

<DataColumn Name=”SwimmerTime” />

<DataColumn Name=”SwimmerTimeSort” />

<DataColumn Name=”Pts” />

<DataColumn Name=”ResultAgeGroup” />

<DataColumn Name=”Para” />

<DataColumn Name=”BDPts” />

<DataColumn Name=”SwimException” />

<DataColumn Name=”LineSplitHeader1″ />

<DataColumn Name=”LineSplit1″ />

<DataColumn Name=”LineSplitHeader2″ />

<DataColumn Name=”LineSplit2″ />

<DataColumn Name=”LineSplitHeader3″ />

<DataColumn Name=”LineSplit3″ />

<DataColumn Name=”Split1″ />

<DataColumn Name=”Split2″ />

<DataColumn Name=”Split3″ />

<DataColumn Name=”Split4″ />

<DataColumn Name=”Split5″ />

<DataColumn Name=”Split6″ />

<DataColumn Name=”Split7″ />

<DataColumn Name=”Split8″ />

<DataColumn Name=”Split9″ />

<DataColumn Name=”Split10″ />

<DataColumn Name=”Split11″ />

<DataColumn Name=”Split12″ />

<DataColumn Name=”Split13″ />

<DataColumn Name=”Split14″ />

<DataColumn Name=”Split15″ />

<DataColumn Name=”Split16″ />

<DataColumn Name=”Split17″ />

<DataColumn Name=”Split18″ />

<DataColumn Name=”Split19″ />

<DataColumn Name=”Split20″ />

<DataColumn Name=”Split21″ />

<DataColumn Name=”Split22″ />

<DataColumn Name=”Split23″ />

<DataColumn Name=”Split24″ />

<DataColumn Name=”Split25″ />

<DataColumn Name=”Split26″ />

<DataColumn Name=”Split27″ />

<DataColumn Name=”Split28″ />

<DataColumn Name=”Split29″ />

<DataColumn Name=”Split30″ />

<DataColumn Name=”TeamS1Name” />

<DataColumn Name=”TeamS1Time1″ />

<DataColumn Name=”TeamS1Time2″ />

<DataColumn Name=”TeamS1Time3″ />

<DataColumn Name=”TeamS1Time4″ />

<DataColumn Name=”TeamS1Time5″ />

<DataColumn Name=”TeamS2Name” />

<DataColumn Name=”TeamS2Time1″ />

<DataColumn Name=”TeamS2Time2″ />

<DataColumn Name=”TeamS2Time3″ />

<DataColumn Name=”TeamS2Time4″ />

<DataColumn Name=”TeamS2Time5″ />

<DataColumn Name=”TeamS3Name” />

<DataColumn Name=”TeamS3Time1″ />

<DataColumn Name=”TeamS3Time2″ />

<DataColumn Name=”TeamS3Time3″ />

<DataColumn Name=”TeamS3Time4″ />

<DataColumn Name=”TeamS3Time5″ />

<DataColumn Name=”TeamS4Name” />

<DataColumn Name=”TeamS4Time1″ />

<DataColumn Name=”TeamS4Time2″ />

<DataColumn Name=”TeamS4Time3″ />

<DataColumn Name=”TeamS4Time4″ />

<DataColumn Name=”TeamS4Time5″ />

<DataColumn Name=”TeamS5Name” />

<DataColumn Name=”TeamS5Time1″ />

<DataColumn Name=”TeamS5Time2″ />

<DataColumn Name=”TeamS5Time3″ />

<DataColumn Name=”TeamS5Time4″ />

<DataColumn Name=”TeamS5Time5″ />

<DataColumn Name=”TeamS6Name” />

<DataColumn Name=”TeamS6Time1″ />

<DataColumn Name=”TeamS6Time2″ />

<DataColumn Name=”TeamS6Time3″ />

<DataColumn Name=”TeamS6Time4″ />

<DataColumn Name=”TeamS6Time5″ />

<DataColumn Name=”Session” />

General Reports (C:\SPORTSYS\SwimTools\Reports)

Filename

Info

Fields

Disability.trdx

Accessed from the Reports Menu within SwimTools Desktop to create a list of Disabilty Swimmers along with thier exemption codes. Sometimes useful to hand to the referee on the day of the meet.

.CSV File: disability.csv


<DataColumn Name=”MeetName” />

<DataColumn Name=”SwimmerName” />

<DataColumn Name=”SwimmerGender” />

<DataColumn Name=”SwimmerDOB” />

<DataColumn Name=”SwimmerClub” />

<DataColumn Name=”DisabilityCodes” />

<DataColumn Name=”DisabilityS” />

<DataColumn Name=”DisabilitySB” />

<DataColumn Name=”DisabilitySM” />