jsh-de
commented
1 year ago To clarify regarding the CSV formats here:
-
currently MEOS exports the relay-results with control-splits in a per-athlete format, which is equal to the old OE2003 CSV format.
-
In fact there was, back in the day, a separate splits-CSV format for OS2003, it looked like this:
Stno;Leg;Database Id;Surname;First name;YB;S;Club no.;Club;Cl. no.;Short;Course no.;Course;Combination;km;m;Course controls;Start;Finish;Time;Classifier;Pl;Chip;Start punch;Finish punch;Control1;Punch1;Control2;Punch2;Control3;Punch3;Control4;Punch4;Control5;Punch5;Control6;Punch6;Control7;Punch7;Control8;Punch8;Control9;Punch9;Control10;Punch10;(may be more) ...(note the "may be more" bit is really in the header, and thus later punches don't have a column header!) -
What Tim and I are actually looking for is an additional results-CSV. This format does not contain splits, but it does contain the results, one relay team per line, and with many columns to map each athlete in the team. The OS2003 results-CSV header looks like this:
Stno;Descr;Block;nc;Start;Time;Classifier;Club no.;Cl.name;City;Nat;Cl. no.;Short;Long;Legs;Num1;Num2;Num3;Text1;Text2;Text3;Start fee;Paid;Surname;First name;YB;S;Start;Finish;Time;Classifier;Chip;Rented;Database Id;Surname;First name;YB;S;Start;Finish;Time;Classifier;Chip;Rented;Database Id;Surname;First name;YB;S;Start;Finish;Time;Classifier;Chip;Rented;Database Id;(may be more) ...;Pl(note the "may be more" bit is really in the header, and thus later athletes don't have a column header, plus to make it really weird the very last column is the relay-placing!) -
Why do we want this? Because there is a great little software called CupCalculator (see https://www.openorienteering.org/apps/cupcalculator/) that we wish to feed MEOS CSV files for relays to.
erikmelin
When exporting results of a relay competition the file does not contain data in the respective relay format.