Results CSV import format

The results CSV file has one line per competitor, with columns separated by semicolons. It starts with ten identity columns, then a start time and a finish time for each run of the race. The first line is a header that the import ignores, and each file covers a single race.

General rules

Rule	Value
Separator	semicolon ;
Text delimiter	straight double quote " (optional)
First line	header, always ignored
Races per file	only one, chosen in the Test field when you import
Encoding	UTF-8 (with or without BOM), Windows-1252, UTF-16 or ISO-8859-1
Spaces	removed at the start and end of each value
Ignored lines	lines where both first name and last name are empty

Columns

The header line is ignored, so you can name the columns as you like. The names below are those of the sample file, which uses French headers.

No.	Column	Expected content	Required
1	Prénom (first name)	Text	Column must be present
2	Nom (last name)	Text	Column must be present
3	Sexe (gender)	Homme, Femme, M, F, H, h, f, m or w	Yes, with a recognized value
4	Année de naissance (year of birth)	1992 or a date 14/05/1992	Yes, with a recognized value
5	Club	Text	Can be empty
6	Fédération (federation)	Empty, Aucune (none), or the acronym or name of a federation known to Canicompet	Can be empty
7	Licence (license)	License number	Can be empty
8	Chien nom (dog name)	Text	Can be empty
9	Chien race (dog breed)	Text	Can be empty
10	Chien puce (dog chip)	The dog’s identification number	Can be empty
11	Start time, run 1	Time (see below)	Can be empty
12	Finish time, run 1	Time (see below)	Can be empty
13, 14…	Start and finish of the next runs	One pair of columns per run	Can be empty

In the gender column, Homme, M, H, h and m mean male, while Femme, F, f and w mean female.

The pairs of time columns follow the chronological order of the race’s runs: the first pair is for the run that starts earliest. Each line must have a pair of columns for every run, even if they are empty.

Caution

A federation value that does not match any known federation blocks the import. If in doubt, leave column 6 empty.

Accepted time formats

Format	Example
HH:MM:SS	11:34:21
HH:MM:SS.mmm	11:31:21.192
HH:MM:SS:mmm	11:31:21:192
DD/MM/YYYY HH:MM:SS	12/04/2026 11:34:21
DD/MM/YYYY HH:MM:SS.mmm	12/04/2026 11:34:21.192
HHhMM'SS	11h34'21
HHhMM'SS,mmm	11h34'21,192

Commas are accepted instead of dots for fractions of a second. These are times of day, not durations: the race time is the difference between finish and start.

Example

Prénom;Nom;Sexe;Année de naissance;Club;Fédération;Licence;Chien nom;Chien race;chien puce;Heure départ;Heure d'arrivée
PrénomCoureur1;NomCoureur1;M;2015;club1;;licence1;chien1;Croisé Labrador;123451234512432;11:31:30;11:34:21
PrénomCoureur2;NomCoureur2;F;2011;club2;;licence2;chien2;ESD;123451234512432;11:29:30.181;11:31:21.192

This file suits a race with a single run. The app also offers a sample file to download from Load results.

Matching with entrants

Each line is linked to an entry in the race when the first name, last name and year of birth exactly match an entrant. In that case, the entrant’s details are reused and their category is calculated from their full date of birth. Lines with no match are imported as they are, with a category calculated from the year of birth given in the file.

If the dog columns are empty and the line matches an entrant, the first dog of their entry is used.

What the import does

1. The first pass shows a Preview of the first lines of the file. The app flags dog chip numbers that are not made only of digits with the message “Invalid chip number?”.
2. The second pass imports the file. All results already present for the chosen race are replaced.
3. If there is an error, nothing is imported and the Errors tab shows the Line, the Column and the faulty value.

The full process is described in Import results.