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

From Swim Wiki
Jump to: navigation, search
(Created page with "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 follo...")
 
Line 2: Line 2:
  
 
The format of this text file has to fullfill the following specification:
 
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 ''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 (''';''').
+
* 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):
 +
 
 +
<nowiki>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
 +
</nowiki>

Revision as of 11:15, 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