Difference between revisions of "Meet Manager:Entries CSV File Format"

From Swim Wiki
Jump to: navigation, search
Line 14: Line 14:
  
 
Test meet for CSV Entries;Berne;SUI;SCM;15.05.2009
 
Test meet for CSV Entries;Berne;SUI;SCM;15.05.2009
NUMBER;RELAYCOUNT;DISTANCE;STROKE;LASTNAME;FIRSTNAME;GENDER;BIRTHDATE;CLUBCODE;CLUBNAME;NATION;ENTRYTIME;LASTNAME1;FIRSTNAME1;GENDER1;BIRTHDATE1;LASTNAME2;FIRSTNAME2;GENDER2;BIRTHDATE2;LASTNAME3;FIRSTNAME3;GENDER3;BIRTHDATE3;LASTNAME4;FIRSTNAME4;GENDER4;BIRTHDATE4
+
NUMBER;RELAYCOUNT;DISTANCE;STROKE;LASTNAME;FIRSTNAME;GENDER;BIRTHDATE;CLUBCODE;CLUBNAME;NATION;ENTRYTIME;
 +
LASTNAME1;FIRSTNAME1;GENDER1;BIRTHDATE1;LASTNAME2;FIRSTNAME2;GENDER2;BIRTHDATE2;
 +
LASTNAME3;FIRSTNAME3;GENDER3;BIRTHDATE3;LASTNAME4;FIRSTNAME4;GENDER4;BIRTHDATE4
 
1;1;400;FREE;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;4:59.99
 
1;1;400;FREE;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;4:59.99
 
31;1;200;MEDLEY;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;2:01.01
 
31;1;200;MEDLEY;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;2:01.01
 
38;4;100;MEDLEY;;;F;;GLX;GeoLogix Team;SUI;4:01.02;Kaufmann;Christian;M;01.02.2001;Marino;Franco;M;01.01.1999;Angeli;Ricardo;M;01.01.1988;Roth;Manuel;M;01.01.1992
 
38;4;100;MEDLEY;;;F;;GLX;GeoLogix Team;SUI;4:01.02;Kaufmann;Christian;M;01.02.2001;Marino;Franco;M;01.01.1999;Angeli;Ricardo;M;01.01.1988;Roth;Manuel;M;01.01.1992

Revision as of 11:17, 20 April 2012

Beside the common formats like Lenex, SDIF, German DSV you may import entries from common text files with Meet Manager.

The format of this text file has to fullfill the following specification:

  • On the first line you have the meet identification with the fields meet name, meet city, meet nation, course and meet date. All fields have to be separated with a semicolon (;).
  • On the second line you have the column names, all uppercase, separated with a semicolon (;).
  • From the third and all following lines you have the entries, one entry per line.

A valid entry file needs at least these columns:

  • LASTNAME:


Here is an example with three entries (two individual, one relay entry):

Test meet for CSV Entries;Berne;SUI;SCM;15.05.2009 NUMBER;RELAYCOUNT;DISTANCE;STROKE;LASTNAME;FIRSTNAME;GENDER;BIRTHDATE;CLUBCODE;CLUBNAME;NATION;ENTRYTIME; LASTNAME1;FIRSTNAME1;GENDER1;BIRTHDATE1;LASTNAME2;FIRSTNAME2;GENDER2;BIRTHDATE2; LASTNAME3;FIRSTNAME3;GENDER3;BIRTHDATE3;LASTNAME4;FIRSTNAME4;GENDER4;BIRTHDATE4 1;1;400;FREE;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;4:59.99 31;1;200;MEDLEY;Kaufmann;Christian;M;01.02.2001;GLX;GeoLogix Team;SUI;2:01.01 38;4;100;MEDLEY;;;F;;GLX;GeoLogix Team;SUI;4:01.02;Kaufmann;Christian;M;01.02.2001;Marino;Franco;M;01.01.1999;Angeli;Ricardo;M;01.01.1988;Roth;Manuel;M;01.01.1992