Index

1. Entering Data Into The SportQuest Database using an Upload Template

A. Do You Have The SportQuest Template?

B. Download The SportQuest Template

C. Entering Data Into The Template

D. Saving Data Into The Upload Template

E. Uploading Data From Template To The SportQuest Database

2. Entering Scores Manually Online

3. Common Uploading Problems

Data from the SportQuest Evaluations can be entered

in to the online system in two ways

1. Entered using an Upload Template

(off-line) and then uploaded all at once (online) at the SportQuest website.  

2. Manually entered online

one score at a time using the SportQuest website directly (scroll down to B. to enter scores manually online)

The first choice is preferred because it doesn’t take up as much internet access time or tie up a phone line.  It is also easier, quicker to save, enter and edit the data and make changes off-line using a template, then upload the whole team at once online.

1. When entering scores into the template, the first 13 columns must be completed or some computer systems may not be able to generate reports (ALL of the scores are dependent on AGE, GENDER, POSITION).
2. ALWAYS use arrow keys when moving between cells because clicking the “ENTER” key over empty cells may cause some computer systems to look for a value in those cells causing an error to occur

If you accidentally fill in a cell(s) that does not require a value:

a) Highlight cell(s) that you want the contents removed

b) Select “CLEAR” from the EDIT menu.

c) Select “CONTENTS” 

 If a player did not perform a test just leave the score (or cell) blank.  Do NOT put a score of 0.00 or 0 etc. Just leave the box empty.

 After entering all data, check to make sure that all the proper columns are filled in and units are correct.  DO NOT ENTER UNITS AFTER THE SCORES.  Only enter the score with proper decimal in each cell (i.e. 300 seconds is a highly improbable amount of time in which to perform an on-ice drill; the number is probably missing a decimal and should have been entered as 3.00).

 All data must be in the units in the brackets (  ) in each column heading 

4. HOW DO I SAVE DATA ON TO THE TEMPLATE?

            How Do I Save A Working Copy Of The Template?

a) How Do I Save A Working Upload Copy Of The Template:
1. After entering all of the data into the template
2. Select "Save As" from "File" Menu.
3. A window will appear asking for a file name. Type in a team name such as: teamname.xls
4. Save as "Microsoft Excel Workbook" (this is your working copy for making changes).
[The Working Copy of this file will have a .xls extension at the end of the file name.]

b) Making Changes to Template:
If you go back and make changes with your Working copy (i.e. Excel Workbook file) be sure to Save the new Working copy again in "Microsoft Excel Workbook format" 

5. UPLOADING DATA FROM TEMPLATE TO THE SPORTQUEST DATABASE

1. Go to http://www.hockeycanada.ca/e/skilltesting/
2. Click on "Take the Test" and then click on "Input Test Results".
3. Enter your "User Logon Name" and "User Password" issued to you by SportQuest then select "Submit".
4. Scroll down to "File for Upload" and click on the "Browse" button and find the Upload Template file that you saved on your hard drive with your player's data. [ Note: select the file with the .xls extension at the end of the file name eg. ****\teamname.xls .]
5. Select or highlight the Upload Template file to upload and then click "Open". The file location and the file to upload should appear in the "File for upload" box. e.g. C:\****\teamname.xls
6. Now click "Upload".
7.  You MUST select an Existing Team to add the players to or enter a new Team Name and League that is common for all of the players to be uploaded. (If these are not common for all of the players to be uploaded then each team/group must be uploaded separately.
8. Data must be entered into the first 10 columns of the template or some computer systems may not work.
9. Click "Submit to check". (click once only) If you see any errors (usually in red), click "Back" on your browser and make any necessary corrections.
10. If there are numerous errors it is A LOT easier to quit out of your browser and make changes on your Excel (.xls) working copy of the Template and resave and then repeat the steps from D. above.
11. If there are no errors, click "Submit to database"
12.  A "Congratulations" screen will appear. Your player(s) have now been successfully uploaded into the SportQuest Database.

From this screen you can also upload a new team.

B. ENTERING SCORES MANUALLY (ONLINE)

1. Go to  http://www.hockeycanada.ca/e/skilltesting/
2. Click on "Take the Test " and then click on "Input Test Results".
3. Enter your logon name and password issues to you by SportQuest
4. Click
5. To enter one player: Scroll down to Enter individual player's data and click on the "Continue with 1 player" button
6. To enter scores for a team: Scroll down to Enter team scores and click on the "Continue with a team" button
7. Enter the New Team Name and League in the boxes provided (or Select an Existing Team from the list of Existing Teams from the drop down menu)
8. Make sure the Test Date is correct or change the "Test Date" to the correct date (mm/dd/yyyy)
9. Enter ALL of the data in to the boxes provided and make sure that you've selected the proper position, shot, gender and division from the drop down menus and entered the correct birthdate in the form of mm/dd/yyyy
10. Click "Submit to check". (click once only) If you see any errors (usually in red on the bottom), click "Back" on your browser and make any necessary corrections. NOTE: if there are a lot of errors see E. 10 above.
11. If there are no errors, click "Submit to database".
12. A "Congratulations" screen will appear. Your player(s) have now been successfully uploaded into the SportQuest Database.

From this screen you can also upload a new team. (Click on appropriate button on this page for your selection.)

C. Common Uploading Problems

To ensure a smooth data upload, use the newest upload templates. The most recent version can be found in the Coach Option section under the link Print Data Sheet called Download Data Sheet. You can also download the template directly from the page http://www.sport-quest.com/skilltesting/upload_template.xls

Be sure that all data is in universally accepted metric measurements (height in cm and weight in kg). If you want to practice uploading a few SAMPLE teams, feel free. However, when you are finished, notify SportQuest via e-mail (support@sport-quest.com) so that the SAMPLE players/teams can be deleted from the database.