Field Formats: The system expects the following data to be in specific formats on Import.
- Date Format: 2022-07-08
- Timezone Format: America/Vancouver
- Time Format: 10:30:00 PM
- Home/Visitor: Must match exactly with Team Name in the system.
- Location: Must match exactly with Location Name in the system.
- Facility: Must match exactly with Facility Name in the system.
- Game Type: Must be one of the following 8 types: (preliminary, exhibition, regular season, final, consolation final, playoff, quarterfinal, semifinal)
- Hierarchy: Must indicate the existing hierarchy with the “>” sign in between (eg. Conference > Division)
When importing a schedule you can get errors due to the formatting of the cells in the CSV. This can happen due to the set up of your excel cells. Seen below the original set up of the dates on the right and the adjusted dates on the left.
If you are having an issue getting the dates or times into the right format you can adjust these by highlighting the cells then clicking on the formatting above to adjust them. In the example above the year was on the far right but after adjusting the format it moved the year to the left.
Error Messages: If you receive Error Messages upon Import, it is often something you can correct.
- Review the errors received and update the file as needed.
- Attempt re-import. And repeat as needed.
- Consider removing the first column “SN_ ID”. Unless you are updating existing games/teams/rosters. This is a unique ID field. If you are adding/importing new data, the system will NOT accept this field as blank.
Error Message Examples:
Minimum Required fields: Each Import type has a minimum required fields. If these fields are not included the file will not be accepted.
Roster Import: Minimum required fields
|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)|
|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|
Team Import: Minimum required fields
SN Team ID
|*Updating||Unique ID within SportNinja for that specific row/Team|
Abbreviation for Team Name (not displayed or required)
|Placeholder||No||Yes or No response. Only enter "Yes" for a dummy/placeholder team (often added as temporary, used for scheduling purposes)|
|No||Team Email (if applicable)|
|Website||No||Team Website (if applicable)|
|Phone Number||No||Team Phone Number (if applicable)|
|Sport||No||(eg. Hockey, Soccer, Basketball)|
Competition Import: Minimum required fields
|SN Game ID||*Updating||Unique ID within SportNinja for that specific row/game|
Player Jersey Number
|Location||*Yes||Location of the event (ie. Arena's name in the system)|
|*Yes||Surface (eg. Rink A)|
|Game Type||*Yes||8 Options: preliminary, exhibition, regular season, final, consolation final, playoff, quarterfinal, semifinal|
|Hierarchy||*Yes||Often it's just your Season or Division name. OR, if there's a hierarchy then list as "Conference > Division".|