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

From Swim Wiki
Jump to: navigation, search
Line 3: Line 3:
 
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 (''';''') The columns can be in any order.
 
* From the third and all following lines you have the entries, one entry per line.
 
* From the third and all following lines you have the entries, one entry per line.
  
 
A valid entry file needs at least these columns:
 
A valid entry file needs at least these columns:
* '''LASTNAME''':  
+
* '''BIRTHDATE''': The  athlete’s  birthdate. Just leave the field empty for relay results. See also column YOB.
 +
* '''CLUBCODE''': The official club code or number. Please only use official values allocated by  the  club’s  national federation here. DO NOT attempt to invent any codes if you do not know the official ones!
 +
* '''CLUBNAME''': The club name.
 +
* '''CLUBNATION''': The  club nation. If this column is missing  or empty,  the  club nation  is supposed to be found in the field NATION.
 +
* '''DISTANCE''': The distance of the event (50, 100, 200, 400, 800, ...). For relay results, this is always the distance for a single athlete.
 +
* '''ENTRYTIME''': The entry time in the format MM:SS.ZZ or SS.ZZ.
 +
* '''FIRSTNAME''': The athlete’s first name.
 +
* '''GENDER''': The  athlete’s  gender  or, in the case of relay results,  the gender of the relay. Allowed values are F (female) or M (male).
 +
* '''LASTNAME''': The athlete’s last name (family name).
 +
* '''NATION''': The athlete’s nationality. If this value differs from his/her club nation, fill in
 +
the column CLUBNATION as well.
 +
* '''STROKE''': The stroke of the event. Allowed values are FREE, BACK, BREAST, FLY or MEDLEY.
 +
* '''YOB''': The  athlete’s  year of birth.  You may use this column  rather than BIRTHDATE if you do not have full birthdates available. The year of birth should be entered with 4 digits (e.g. 1987).
 +
 
 +
 
  
  

Revision as of 11:23, 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 (;) The columns can be in any order.
  • From the third and all following lines you have the entries, one entry per line.

A valid entry file needs at least these columns:

  • BIRTHDATE: The athlete’s birthdate. Just leave the field empty for relay results. See also column YOB.
  • CLUBCODE: The official club code or number. Please only use official values allocated by the club’s national federation here. DO NOT attempt to invent any codes if you do not know the official ones!
  • CLUBNAME: The club name.
  • CLUBNATION: The club nation. If this column is missing or empty, the club nation is supposed to be found in the field NATION.
  • DISTANCE: The distance of the event (50, 100, 200, 400, 800, ...). For relay results, this is always the distance for a single athlete.
  • ENTRYTIME: The entry time in the format MM:SS.ZZ or SS.ZZ.
  • FIRSTNAME: The athlete’s first name.
  • GENDER: The athlete’s gender or, in the case of relay results, the gender of the relay. Allowed values are F (female) or M (male).
  • LASTNAME: The athlete’s last name (family name).
  • NATION: The athlete’s nationality. If this value differs from his/her club nation, fill in

the column CLUBNATION as well.

  • STROKE: The stroke of the event. Allowed values are FREE, BACK, BREAST, FLY or MEDLEY.
  • YOB: The athlete’s year of birth. You may use this column rather than BIRTHDATE if you do not have full birthdates available. The year of birth should be entered with 4 digits (e.g. 1987).



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