Saturday, July 27, 2013

Meet result in CSV file format and import a meet result file

The feature to import meet results is for teams not using Hy-Tek or don't have internet access at the pool and want to enter data into a file for later upload to TSTM when internet is available.

There are two formats you can use to enter meet results in a CSV file.

1. By event number:

The file has a header line (only the first line) as the following:
Event,SwimmerId,Time

Starting from the second line, you should enter a TSA event number in the first column, swimmer's ID or number in the second column and the time in the third column.

TSA event numbers are in this TSA document:
http://tsanc.org/documents/XLS/EventSheets.xls

The event column can be left empty if it continues the same event from the previous line.  It is only required if the event is different from the previous line.

The time column can be entered in any of the following formats.

Example: the time is 1:23.45
The valid time strings are:
12345
1:23.45

2. By stroke:
The file has a header line (only the first line) as the following:
Stroke,SwimmerId,Time

Starting from the second line, you should enter one of the 4 strokes as the following.
Example for stroke column:
Free or Fr or fr or 1
Back or Bk or Ba or bk or ba or 2
Breast or Br or br or 3
Fly or Fl or fl or 4

The stroke column can be left empty if it continues the same stroke from the previous line.  It is only required if the stroke is different from the previous line.

The second and third columns are the same as described in "By event number" above.

There are two template files for the two types of csv file at the following location.  You can download and save them as a .csv file.

http://www.tsaswimteam.com/MeetResultByEvent.csv
http://www.tsaswimteam.com/MeetResultByStroke.csv

To upload result from a .CSV file (or Hy-Tek .zip or .cl2 meet result file), go to the admin menu Meet->Manage results.  On the new page, select the meet you want to import.  Then click on the import meet result icon (the first icon on the right side of the meet dropdown box).  On the new import window, click on the Browse or Choose File button and look for the .csv file on your system.  Click the Ok button to import.  Note that if you use CSV format, the file name extension must be .csv.

No comments:

Post a Comment