Overview: For the sake of efficiency, it is possible to import multiple Teams and their associated Rosters all in one file import.
Required fields: Each Import type has required fields. If these fields are not included the file will not be accepted.
| Fields | Required | Description |
|---|---|---|
|
SN Team ID |
*Updating | Unique ID within SportNinja for that specific row/Team |
| Team Name | *Yes | Team Name |
|
Roster Name |
Yes |
This is the name on the Roster dropdown for this team's roster within a particular season/competition (often the Competition name) |
|
SN Player ID |
*Updating | Unique ID within SportNinja for that specific row/Player |
| Last Name | *Yes | Player Last Name (Surname) |
| First Name | *Yes | Player First Name (Given Name) |
| Jersey Number |
*Yes |
Jersey Number |
| Position | *Yes | Options: Forward, Defense, Goalie, Skater |
| Height | No | Player Height in Meters (eg. "1.73") |
| Weight | No | Player Weight in Pounds (eg. "160") |
| Birth Date | No | Birth Date in Format: YYYY-MM-DD |
| Hometown | No | Player Hometown (City) |
| Homeprov | No | Player Hometown (Province or State) |
| Rookie | No | Is it this Player's Rookie Year? ("Y" or "N") |
| No | Player Email - Recommended | |
| Send Invitation | No |
Response: "Y" or "N". If "Y", the system will email out an invite to each player with an email listed. |
Steps:
- Download: Navigate to your Organizations Team page and Download a copy of the Multi-Team Roster Import Template file. It will download as a ".csv" file.
- Edit: Open the file with an editing tool (eg. MS Excel, Google Sheets, etc). You may want to open it as a .xls, or .xlsx. file to make it easier to edit. Then, Edit the file by adding in your Team names and associated Roster/Player data. (Note: that you should not edit the field names at the top, and you cannot add any extra columns. You can only enter data for the fields in the file.)
- Save: Re-save or download your file as a ".csv" file, as this format is required for import.
- Import: Import your updated file by clicking on the "Multi-Team Roster Import" button, then select your updated .csv file from its saved location.
If your file was successfully imported, the pop-up window will automatically close after a few seconds. (If your file import was not accepted, you will receive error messages suggesting the route of the issue. Review, update the file as necessary and attempt again.)
Visual steps:
1. Download the file template
2. Edit
Find the file in your Downloads folder
Option A - Upload the file to your Google Drive then open it with Google Sheets.
----
Option B - Open the file with your own editing tool (eg. Excel as a .xls or .xlsx)
Update the file with your new Team and Roster data.
(Note: If you do not have an "SN Team ID" or "SN Player ID" leave these fields blank and a new Team or Player will be created. This field is a unique identifier used to match against existing teams and players in the system. If you know their IDs, it's recommended you include them)
3) Save:
Save your file again as a ".csv" file.
4) Import: Go to the "Import Multi-Team Import" button
Navigate to your saved file
The import button will now be highlighted and selectable.
The file will either import successfully, or it will fail with error messages.
If you are still having trouble, review these articles:
Import/Export - Troubleshooting