Start Clock and O Checklist can now import start lists directly from Excel (.xlsx) files. CSV start lists continue to be supported, but Excel is now the recommended format for new start lists.
// Start Clock and O Checklist: Import of CSV file (comma-separated values).
//
// Layout:
// The CSV file contains one participant per line. Each line must have the following fields,
// separated by commas, in the following order:
//
// Name*, Club, Class*, Bib, StartTime, Card, StartName
//
// * = mandatory field, other fields can be empty (but keep the commas).
//
// Formatting:
// - StartTime format is hh:mm:ss, for example, 09:10:00 or 13:14:30
// - If a field contains a comma, the field must be quoted: GREEN, Emma => "GREEN, Emma"
// - Participants/classes can be in any order in the file.
// - Comment lines start with // and are ignored.
// - Blank lines are ignored.
//
// File considerations:
// - Filename must end with extension .csv (lower case).
// - File should be in UTF-8 format (best for åäöæøüáóñéèù…).
//
// Frequently Asked Question:
// Q: Must there be a headline in the CSV file?
// A: No, the headline is for convenience only.
// If there is a headline in the CSV file, make sure that it is a comment line.
// Otherwise, the app will try to import the headline, which will be reported as
// an error in the time format.
//
//
// Example CSV file:
// Name*, Club, Class*, Bib, StartTime, Card, StartName
Jade Martin, Saint Étienne, Femmes, 1, 10:00:00, 314159,
Louise Bernard, Havre, Femmes, 2, 10:02:00, 271828,
Emma Thomas, Toulon, Femmes, 3, 10:04:00, 662607,
Alice Petit, Grenoble, Femmes, 4, 10:06:00, 138065,
Ambre Robert, Dijon, Femmes, 5, 10:08:00, 964853,
Léo Richard, Angers, Hommes, 101, 10:01:00, 910938,
Gabriel Durand, Nîmes, Hommes, 102, 10:03:00, 167262,
Raphaël Dubois, Villeurbanne, Hommes, 103, 10:05:00, 160218,
Arthur Moreau, Saint Denis, Hommes, 104, 10:07:00, 109737,
Louis Laurent, Aix en Provence, Hommes, 105, 10:09:00, 567038,
Lina Simon, Mans, Enfants, , 10:01:00, ,
Jules Leroy, Annecy, Enfants, , 10:02:00, ,
Rose Michel, Brest, Enfants, , 10:03:00, ,
Adam Roux, Tours, Enfants, , 10:04:00, ,
Chloé Lefebvre, Amiens, Enfants, , 10:05:00, ,
Maël David, Limoges, Enfants, , 10:06:00, ,