AMP Sport allows you to create custom forms for evaluating your athletes and tracking performance. The following tutorial will guide you through the basic creation of a comma separated value (or .csv) file and how to import this data directly into AMP when tracking performance of athletes on custom forms.
Please note: You must already have an active AMP Sport user account in order to access AMP.
To begin, we'll go through a few steps to make sure that you have created a proper .csv file.
The general rule for csv creation is this: separate each field or column of data with a comma and each row of data with a new line.
Here's an example:
The first line of your new csv file should only contain the headers of the form you are importing data into. Please note the column names in the image below.
The first line of your csv file should only contain the column headers and be written exactly like:
Athlete,Position,Points,Change,Events P1,Events P2,Current Period,Previous Period,Comments
From this point, the second, third, and all subsequent lines should include the Athlete's name (as written in AMP) in the first position, with all other data afterwards. Your second and third lines of the csv file for this sample form might look like this:
Flying Squirrel,Center,250,-50,eventsP1foo2,eventP2foo2,Currentfoo2,Previousfoo2,I love comments
Use File > Save As to give your file a name and to make sure your file is saved with the extension .csv after it. The resulting file should look similar to this: MyData.csv
You can convert an Excel worksheet to a .csv file by using the Save As command.
Click the File tab, and then click Save As.
- The Save As dialog box appears.
- For example, click CSV (Comma delimited).
the next section, we’ll walk through importing your new .csv file into
Log into your AMP Sport site.
Click on Performance Track tab and select Add Data button of the performance tracking form you wish to use. You may also use the Create New Performance Tracking Form button to create new custom forms.
For this example, we've chosen to use the “ITU Points List” performance tracking form. Now click “choose file” and browse to and attach your csv file.
Once the csv file is selected, if all column header names line up, use should see the view change to something like this:You're almost there! Now click Load CSV and your data will be imported into the form.
Please review the imported data for any errors. Any fields that are highlighted in red need a little more attention before continuing. In the screenshot below, the Position data needs to be changed to a proper value that matches with your organization. Also, please note that all entries beyond Athlete name and Comments are expected to be numerical, not text. These small changes may be made directly on the screen by double clicking into one of the highlighted boxes and overwriting the entry.
Once any edits to the data are made and the evaluation is ready to be saved as in the image below, click Publish to share this form with others in your organization.
If you need any further assistance with this solution, please email firstname.lastname@example.org and we would be happy to assist you further.