Process Overview


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.


CSV Creation


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:


Title1,Title2,Title3

athlete1,position1,points1
athlete2,position2,points2

athlete3,position3,points3

...


  1. 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

  1. 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:

Grizzly Cowboy,Forward,500,+100,eventP1foo,eventsP2foo,Currentfoo,Previousfoo,No_comments

Flying Squirrel,Center,250,-50,eventsP1foo2,eventP2foo2,Currentfoo2,Previousfoo2,I love comments

  1. 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  


Excel Users

 

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.
  1. In the Save as type box, choose the text file format for the worksheet.
    • For example, click CSV (Comma delimited).
  2. Browse to the location where you want to save the new text file, and then click Save.
  3. A dialog box appears, reminding you that only the current worksheet will be saved to the new file. If you are certain that the current worksheet is the one that you want to save as a text file, click OK. You can save other worksheets as separate text files by repeating this procedure for each worksheet.

  4. CSV Import


    In the next section, we’ll walk through importing your new .csv file into AMP.

    1. Log into your AMP Sport site.

    2. 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.


    1. 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.


    1. 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.


    1. 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.

       

    2. 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 support@ampsport.com and we would be happy to assist you further.