SportsEngine

What is the SportsEngine Schedule Upload Template?

Last Updated: May 08, 2017 04:04PM CDT

The SportsEngine Schedule Upload template allows you to mass import events into your website and also update events after an import has been completed. The Schedule Upload Template must be a .CSV file. Please view the attached template file within this Help Article for a sample.

See the step-by-step instructions below or click here for the on-demand video.

The Schedule Upload tool is located within the Website Tools section of your Admin Control Panel and accepts three types of file formats for importing a file into your website.

  • Legacy MaxSolutionsSchedulewerks (Puck Systems), and Diamond Scheduler file export format. Attached is a guide provided by MaxSolutions on how to create an Export File which can then be imported into your website. If you need further assistance with the MaxSolutions software please contact MaxSolutions.

  • Schedule Template- For users that do not use a third party scheduling software you can create your own file via Excel and then import this via via the Schedule Upload tool.

Once the Template is formatted the next steps will be to Import the Template.

SportsEngine Schedule Upload fields:

Start_Date

  • Format must be: MM/DD/YYYY
Start_Time
  • Format must be: HH:MM or TBD
End_Date
  • Format must be: MM/DD/YYYY
End_Time
  • Format must be: HH:MM

Title

  • Up to 255 characters.

Description

  • Up to 400 characters.

Location

  • Up to 255 characters.

Location_URL

  • A valid url, please be sure to include http:// or https://

All_Day_Event

  • A value of 1 will indicate an all day event, if left blank or set to zero a start and end date will show on the calendar.

Event_Type

  • Field is ignored unless value is "Game".  If Game the additional Team fields are required.

Tags

  • This field is used to map to the codes that are entered in under Edit Team/Division Codes to a page within your website.  If you tag multiple pages, you must use the use the pipe/vertical bar character (i.e. "|") to separate each id. (i.e. 1023|1030|1232|21412).

Team1_ID: Team IDs are Found in the Mapping Codes Section.

  • This field is required if the Event_Type is equal to "Game"

Team1_Division_ID

  • Use this if you would like to create TBD teams (Team field must be blank)

Team1_Is_Home

  • This field is used when Event_Type is equal to "Game". Valid values are 1 for Home Game, 0 for Away Game.

Team2_ID Team IDs are Found in the Mapping Codes Section.

  • This field is required when adding games under a "League" structure and the Team2_ID actually has a team page on your website.

Team2_Division_ID

  • Use this if you would like to create TBD teams (Team field must be blank)

Team2_Name

  • This field is used when no value is provided within the Team2_ID field for Solo Teams that are not within a league.

Event_ID

  • This field is only used if you export the batch that was previously imported, this includes a unique event_id for each row that can be used to update existing events.

Game_ID

  • This field is used when Event_Type is equal to "Game". The field can contain up to 12 characters. The Game ID should be unique within a Subseason. The Game ID is only supported with the SportNgin .csv format (does not apply to Maximum Solutions or ScheduleWerks).

Affects_Standings

  • By default if a value is not provided it will be marked as affects standings. Valid values are 1 for affects standings, 0 for does not affect standings.
Points_Win
  • Standings point override for a win on a single game
Points_Loss
  • Standings point override for a loss on a single game
Points_Tie
  • Standings point override for a tie on a single game
Points_OT_Win
  • Standings point override for a OT win on a single game
Points_OT_Loss
  • Standings point override for a OT loss on a single game
Division_Override
  • Force a game to count for standings purposes for both teams even when they aren’t in the same division

Creating a standard event:

If you wish to create a standard event, i.e. practice, board meeting, try-outs, etc.  
The fields listed below with a (*) are required for creating a standard event:

  • Start_Date*
  • Start_Time*
  • End_Date*
  • End_Time*
  • Title*
  • Description
  • Location
  • Location_URL
  • All_Day_Event
    If you wish to designate the event as All Day enter a value of "1")
  • Event_Type
    This field is ignored and can be left blank when adding a standard event.
  • Tags
    There must be at least one value within this field that maps to a Team/Division code found on the Schedule Upload page.  To tag the event to multiple pages separate each id with a pipe/vertical bar, "|". (i.e. 1023|1030|1232|21412).
Note - keep all columns after Tags on the template. If you are not filling them in, you can keep them blank. These need to remain in the template to successfully upload events.

Creating a Game event:

 
From the SportsEngine file format you can also create games. This will place game events on the calendar and also display games within the "Game Schedule" for the teams attached to the game.   If you are creating a Game that is part of a league you must have a valid Home and Away team.  If you are creating a Game where the opponent team is not within the hierarchy of your website you can simply type in a name for the opposing team. 

Note: At this time we do not provide game schedule functionality for the following sports: Tennis, Golf, Cycling, Track & Field, Wrestling.  If you create a team page and choose one of the above referenced sports, you will need to add your games as a 'Standard Event' using the 'Creating a Standard Event' fields mentioned in the section above.
 
The fields listed below with a (*) are required for creating a Game event:
 
*Start_Date

*Start_Time

*End_Date

*End_Time
 
Title
  • The title of the Game will automatically be built based on the home and away team (i.e. Away Team Name at Home Team Name)
Description
 
Location
 
Location_URL
  • A valid url, please be sure to include http:// or https://.
All_Day_Event
  • This field will be ignored, a Game always has to have a start time and cannot be all day long.
*Event_Type
  • This field must have a value of "Game" in order for a Game event to be created.
Tags
  • Optional, you can add additional tags to the Game event. (i.e. if you want to designate a referee schedule you could tag the event to a referee page. If you want to tag multiple pages, you must use the use the pipe/vertical bar character (i.e. "|") to separate each id. (i.e. 1023|1030|1232|21412) By default both Team1_ID and Team2_ID will be tagged to the Game event.
*Team1_ID
 
*Team1_Is_Home
  • By default if a value is not provided it will be marked as a home game. Valid values are 1 for Home Game, 0 for Away Game.
  • Required when Team1_ID is underneath a league.  You must provide a Team2_ID that is actual team page within the same league. Not required if Team1_ID is not underneath a league.
  • Is required if a Team2_ID is not provided.
Game_ID
  • Up to 12 characters.

Affects_Standings

  • By default if a value is not provided it will be marked as affects standings. Valid values are 1 for affects standings, 0 for does not affect standings.
Points_Win
  • Standings point override for a win on a single game
Points_Loss
  • Standings point override for a loss on a single game
Points_Tie
  • Standings point override for a tie on a single game
Points_OT_Win
  • Standings point override for a OT win on a single game
Points_OT_Loss
  • Standings point override for a OT loss on a single game
Division_Override
  • Force a game to count for standings purposes for both teams even when they aren’t in the same division

Updating an Event via the Schedule Upload

The SportsEngine Schedule Upload tool also provides the ability to update existing events that were previously uploaded.
 
To update existing events use the following export option:
 
On the Schedule Upload page use the Export Schedule box to choose a date range.   This will export a csv file in the Ngin Schedule Upload format that will include values in the "Event_ID" column.
Or, click on a "Result" link to export on of your prior imports.   Upon viewing an previous import click on the "Export as CSV" option to download a file of the valid events you previously uploaded.
Once the file has been exported simply open the file within your spreadsheet software to make edits to the events.
Save the file and proceed back to the Schedule Upload page to import your file
Events within your schedule upload file that have an ID in the event_id column will then be updated.
Game events that have a status of "In-Progress" or "Complete" cannot be updated.  If an update needs to be made to a Game that is "In-Progress" or "Complete" in must be done be editing the individual event.
Help us improve by rating this article:
This article was helpful

Topics

info@uspondhockey.com
http://assets3.desk.com/
sportngin
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
Invalid characters found
/customer/en/portal/articles/autocomplete