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.

Saturday, July 6, 2013

Meet Entry Export for TSA Championship or Cary City meet

Here are the steps to create a Hy-Tek compatible meet entry file for invitational meets:

Note this is a premium feature.

Meet creation:
Create a new meet on Championship Saturday or Sunday depending on your team's ranking or Cary City Meet.  Choose "TSA Championship" or "Cary Meet" as your opponent team. Choose Meet type "Other" and check the "Show strokes" checkbox.

Stroke selection:
Notify team members to sign up for this meet. They should also select their preferred strokes for each swimmer for this meet on the Meet selection page.

After strokes are selected, do the auto lineup (Meet->Lineup, etc).  Select 4 for Max events / per swimmer.  The lineup results for individual events only serve as stroke selection, not real lineup for the meet (unless this is for a dual meet), but for the relay teams, they are actual teams.  The seed times are personal best times.  For relay teams, the seed time is the sum of all swimmers' personal best times in the strokes they will swim.

If admin/coach wants to drop a stroke for a swimmer, they can switch into the family's account and make such changes. Another option is to use the pusher list, Meet Setup->pusher list (the 5th icon) for that meet to drop certain strokes.  Red color crossing out a name means a swimmer will NOT swim that stroke.  Don't use the Orange color because it only prevents a swimmer from attending the first heat.  When possible, use the family's Meet selection page instead of the pusher list to make stroke selections.

Meet entry export:
Go to the Meet Setup page and export the meet entry (third icon).  It should be a .ZIP file.  Pay attention to the date of the file to make sure it is just created.  Download the zip file and save it locally.  Send this file to the meet organizer.

Click on the report (6th) icon on the Meet Setup to create the Championship meet report (signup line items and total cost for the team).