This guide will assist you in successfully downloading and importing a list of all registered U Sports athletes from U Sports Central. Follow the step-by-step instructions below to achieve this:
Step 1: Log into U Sports Central
-
Open your web browser and navigate to the U Sports Central website: usportscentral.ca.
-
Sign in using your administrator account credentials.
Step 2: Access Ad-Hoc Queries/Reports
-
After logging in, you will be directed to the U Sports Central dashboard.
-
Locate the "Reports" section on the dashboard and click on it.
-
From the dropdown menu, select "Ad-Hoc Queries/Reports."
Step 3: Create a New Query
-
In the Ad-Hoc Queries/Reports section, click on the option to "New Query."
-
A form will appear for you to configure your query.
- Under the "Data Source" section, choose "Student Athlete Registration."
-
The "Season" field will likely default to the current season (e.g., 23-24).
-
Do not place a check in the box for Season
-
Select Email
-
Under Consent, enter yes for the criteria
-
Do not place a check in the box for Consent
- To save this query for future use, give it a name in the "Report Name" field. This will make it easier to access and rerun the query later.
Note for AUS schools who track the Emergency Contact and Conference Consent items via U Sport Portal - you can do this by adding "Yes" beside the Conference Consent and Emergency Contact to display athletes who have completed this portion
Step 5: Export Query Results
-
Once you have configured the query parameters, scroll down to the bottom of the form.
-
Click on the "Export to Excel" option. This will generate a download of the query results.
-
Save the downloaded file as a CSV (Comma-Separated Values) file on your local system. You can choose a location and a name that makes sense to you.
Congratulations! You have successfully downloaded and imported a list of all registered U Sports athletes from U Sports Central.
Univerus Sport
- Once you have this list, please open the Univerus Sport application in your web browser
- under Integrations select U Sports Import
- Choose your file and select Upload