Stacks Image 2021

Ares files Import/Export

AiguaTiming2 can import meet start information and export results from/to Ares files. These must be copied into AiguaTiming2 by means of the iTunes File Sharing feature as described in this Apple Guide.

Nevertheless the Ares is a simple CSV (comma-separated values) file format that can be generated by hand or personal scripts if so required.

Below is an overview of the files as used by AiguaTiming2 and some template files to get you started. Some files may contain more columns than shown below, in which case AiguaTiming2 will ignore the extra columns on import.

If you have any questions please don’t hesitate to contact us at support@johncode.com.

You can download all the files below here: MeetImport.zip.

lststyle.txt
This file contains the styles of the races and can be reused for any set of races.

This file is required when importing a meet.

Columns
idStyle: Identifier of the style, used on other files to refer to it.
style: Full name of the style.
abrevStyle: Abbreviated name of the style.
Sample Content
idStyle;style;abrevStyle
0;"NONE";"X"
1;"FREESTYLE";"FR"
2;"BREASTSTROKE";"BR"
3;"BUTTERFLY";"FL"
4;"BACKSTROKE";"BK"
5;"INDIVIDUAL MEDLEY";"IM"

lstlong.txt
This file contains the lengths of the races and can be reused for any set of races.

This file is required when importing a meet.

Columns
idLength: Identifier of the race length, used on other files to refer to it.
length: Name of the lenght for display purposes.
mLength: Numerical value of the length.
relays: Number of relays for this race length.
idLength;length;mLength;relays
0;"50m";50;1
1;"100m";100;1
2;"200m";200;1
3;"400m";400;1
4;"800m";800;1
5;"1500m";1500;1
6;"4x50m";200;4
7;"4x100m";400;4
8;"4x200m";800;4

lstcat.txt
This file contains the categories of the races and can be reused for any set of races.

This file is required when importing a meet.

Columns
category: Full name of the category.
abrevCat: Abbreviated name of the category, used on other files to refer to it.
category;abrevCat
"BOYS 9 YEARS";"B9"
"BOYS 10 YEARS";"B10"
"BOYS 11 YEARS";"B11"
"BOYS 12 YEARS";"B12"
"BOYS 13 YEARS";"B13"
"BOYS 14 YEARS”;”B14"
"GIRLS 9 YEARS";"G9"
"GIRLS 10 YEARS";"G10"
"GIRLS 11 YEARS";"G11"
"GIRLS 12 YEARS";"G12"
"GIRLS 13 YEARS";"G13"
"GIRLS 14 YEARS”;”G14"

lstround.txt
This file contains the possible rounds of races and can be reused for any set of races.

This file is required when importing a meet.

Columns
idRound: Identifier of the round, used on other files to refer to it.
title: Full name of the round type.
roundAbrev: Abbreviated name of the round type.
idRound;title;roundAbrev
0;"None";""
1;"Heat";"H"
2;”Semi Final";"SFI"
3;”Final";"FI"
4;"Consolation";"CON"

lstrace.txt
This file contains the details of the races on a meet.

This file is required when importing a meet.

The dates must be in DD/MM/YYYY format, and the times in HH:MM 24 hour format.

Columns
even: Identifier of the event, used on other files to refer to it.
idRound: Reference to the round id from the lstround.txt file.
nbHeat: Number of heats for this event.
idLength: Reference to the length id from the lstlong.txt file.
idStyle: Reference to the style id from the lststyle.txt file.
abrevCat: Reference to the category id from the lstcat.txt file.
date: Date of the event (currently unused).
time: Time of the event (currently unused).
event;idRound;nbHeat;idLength;idStyle;abrevCat;date;time
1;1;2;1;1;”B12";"25/01/2015";"16:00"
3;1;2;4;2;"G14";"25/01/2015";"17:00"

lstconc.txt
This file contains the swimmers that will participate on all the races on the meet.

This file is required when importing a meet.

Columns
id: Identifier of the swimmer, used on other files to refer to it.
bib: Unique identifier of the swimmer from your club’s records or sports association.
lastName: Last name of swimmer.
firstName: First name of swimmer.
id;bib;lastName;firstName
1;"010020033";"RIOS";"DEBRA"
2;"020030044";"WHITE";"NAOMI"
3;"020040067";"JOSEPH";"DANIELLE"
4;"030100551";"DIAZ";"SOPHIE"
5;"030200651";"PITTMAN";"SUSAN"
6;"030105517";"NORTON";"MANDY"
7;"020120061";"RAMSEY";"GINA"
8;"021100001";"MILES";"JUANITA"
9;"050100021";"WALKER";"TARA"
10;"050140033";"POPE;"ROGER"
11;"050000041";"TERENCE";"JAMES"
12;"060100307";"WOOD";"MARC"
13;"060100308";"WHEELER";"FRANK"
14;"044100001";"NEWMAN";"IRVING"
15;"044100002";"PHILIP";"BRADLEY"
16;"044100003";"HENDERSON";"BRIAN"
17;"080000701";"PATTERSON";"TONY"
18;"080000721";"EDWARDS";"CLARK"
19;"101004410";"BROWN";"HENRY"
20;"101603410";"WALTON";"KENNY"

lststart.txt
This file contains the start lists for every race and heat on a meet.

This file is required when importing a meet.

This file may be modified by AiguaTiming2 during the exporting of the results if the heat participants have been modified during an event.

Columns
even: Reference to the event id from the lstrace.txt file.
idRound: Reference to the round id from the lstround.txt file.
heat: Number of the heat for this race.
lane: Lane number for this swimmer.
relay: Relay number for this swimmer (unused, multiple relay start list are currently unsupported).
idSwimmer: Reference to the swimmer id from the lstconc.txt file.
event;idRound;heat;lane;relay;idSwimmer
1;1;1;2;0;11
1;1;1;3;0;12
1;1;1;4;0;13
1;1;1;5;0;14
1;1;1;6;0;15
1;1;1;7;0;16
1;1;2;3;0;17
1;1;2;4;0;18
1;1;2;5;0;19
1;1;2;6;0;20
2;1;1;2;0;1
2;1;1;3;0;2
2;1;1;4;0;3
2;1;1;5;0;4
2;1;1;6;0;5
2;1;1;7;0;6
2;1;2;3;0;7
2;1;2;4;0;8
2;1;2;5;0;9
2;1;2;6;0;10

lstrslt.txt
This file contains all the meet’s results and is available after the Export option in AiguaTiming2 has been used once the meet is finalised.

This file will be generated when a meet has been completed and it’s results are exported.

This file may included during import of a meet was only partially completed and you want to import old results to continue the meet. In this case the file will be modified during the exporting of the new results.

It is recommended that this file is not edited by hand as it requires time calculations that if done incorrectly may corrupt the file.

Columns
even: Reference to the event id from the lstrace.txt file.
round: Reference to the round id from the lstround.txt file.
heat: Number of the heat for this race.
lap: Lap number considering this is for only one side split races.
lane: Lane number for this split time.
idStatus: This value will be 128 for a disqualified swimmer, 0 otherwise.
rank: Rank of this lane swimmer within the race at this split.
time: Split time in 1/1000 of a second.
result: Text version of the split time for display puposes.
mod: Modified time code, will be “B” if the backup time is used, it will be “E” if a manual time has been entered.
btime: Backup split time in 1/1000 of a second.
bresult: Text version of the backup split time for display puposes.
bmod: Modified time code, will be “B” if the backup time is used.

The first line for any event will be a special line with lap, lane, and lane with zero values.
This line will contain the event’s start time on the time and result columns. 
event;round;heat;lap;lane;idStatus;rank;time;result;mod;btime;bresult;bmod
1;1;1;0;0;0;0;79864746;" 22:11:04.75";" ";0;"";"";
1;1;1;50;2;0;1;32120;"       32.12";" ";31450;"       31.45";" "
1;1;1;50;3;0;2;32530;"       32.53";" ";31630;"       31.63";" "
1;1;1;50;5;0;3;33340;"       33.34";" ";31750;"       31.75";" "
1;1;1;50;6;0;4;33820;"       33.82";" ";31920;"       31.92";" "
1;1;1;50;7;0;5;34330;"       34.33";" ";32100;"       32.10";" "
1;1;1;50;4;0;6;34820;"       34.82";" ";33620;"       33.62";" "
1;1;1;100;2;0;1;64730;"     1:04.73";" ";64060;"     1:04.06";" "
1;1;1;100;3;0;2;65550;"     1:05.55";" ";64650;"     1:04.65";" "
1;1;1;100;5;0;3;66140;"     1:06.14";" ";64550;"     1:04.55";" "
1;1;1;100;6;0;4;67330;"     1:07.33";" ";65430;"     1:05.43";" "
1;1;1;100;4;0;5;68290;"     1:08.29";" ";67090;"     1:07.09";" "
1;1;1;100;7;0;6;69110;"     1:09.11";" ";66870;"     1:06.87";" "
1;1;1;150;2;0;1;97690;"     1:37.69";" ";97020;"     1:37.02";" "
1;1;1;150;6;0;2;98890;"     1:38.89";" ";96980;"     1:36.98";" "
1;1;1;150;5;0;3;99470;"     1:39.47";" ";97880;"     1:37.88";" "
1;1;1;150;3;0;4;100160;"     1:40.16";" ";99260;"     1:39.26";" "
1;1;1;150;4;0;5;100820;"     1:40.82";" ";99620;"     1:39.62";" "
1;1;1;150;7;0;6;101420;"     1:41.42";" ";99180;"     1:39.18";" "
1;1;1;200;4;0;1;129640;"     2:09.64";" ";128440;"     2:08.44";" "
1;1;1;200;6;0;2;130670;"     2:10.67";" ";128770;"     2:08.77";" "
1;1;1;200;3;0;3;131840;"     2:11.84";" ";130940;"     2:10.94";" "
1;1;1;200;5;0;4;132690;"     2:12.69";" ";131100;"     2:11.10";" "
1;1;1;200;2;0;5;133190;"     2:13.19";" ";132520;"     2:12.52";" "
1;1;1;200;7;0;6;134440;"     2:14.44";" ";132210;"     2:12.21";" "
1;1;2;0;0;0;0;80059236;" 22:14:19.24";" ";0;"";"";
1;1;2;50;3;0;1;33350;"       33.35";" ";32880;"       32.88";" "
1;1;2;50;5;0;2;33770;"       33.77";" ";33010;"       33.01";" "
1;1;2;50;6;0;3;37580;"       37.58";" ";36580;"       36.58";" "
1;1;2;50;4;128;4;36870;"       36.87";" ";35620;"       35.62";" "
1;1;2;100;6;0;1;67030;"     1:07.03";" ";66030;"     1:06.03";" "
1;1;2;100;3;0;2;68030;"     1:08.03";" ";67560;"     1:07.56";" "
1;1;2;100;5;0;3;69290;"     1:09.29";" ";68540;"     1:08.54";" "
1;1;2;100;4;128;4;71780;"     1:11.78";" ";70530;"     1:10.53";" "
1;1;2;150;5;0;1;103320;"     1:43.32";"B";102570;"     1:42.57";"B"
1;1;2;150;3;0;2;102620;"     1:42.62";" ";102150;"     1:42.15";" "
1;1;2;150;6;0;3;106400;"     1:46.40";" ";105400;"     1:45.40";" "
1;1;2;150;4;128;4;105420;"     1:45.42";" ";104170;"     1:44.17";" "
1;1;2;200;3;0;1;137340;"     2:17.34";" ";136870;"     2:16.87";" "
1;1;2;200;5;0;2;142270;"     2:22.27";" ";141520;"     2:21.52";" "
1;1;2;200;6;0;3;144140;"     2:24.14";" ";143130;"     2:23.13";" "
1;1;2;200;4;128;4;139890;"     2:19.89";" ";138640;"     2:18.64";" "