This article will teach you the proper way to import game or event schedules to your LeagueApps site. Follow these steps to get your schedule into your LeagueApps site.
First, choose which type of schedule you want to import:
Regular Game Schedule
(download template)
Pool Play (Tournament) Schedule
(download template)
Event Schedule
(download template)
Important steps to complete before Importing:
- Locations and sub location must be created in advance.
- Teams you wish to assign games or events to during the import will need to be created and in the program before the import.
- Troubleshooting/Common mistakes (see bottom of article)
Importing a Regular Game Schedule
Step 1: Download & Open the Template
Download the Template here: LeagueApps_Schedule_Import_Template.csv
Step 2: Input Schedule Information
SUB_PROGRAM | You can leave this blank unless you are importing a schedule that has games for multiple sub-programs within the same master program. When in doubt, leave it blank. | |
HOME_TEAM | * | Name of the Home Team (hint: you can leave these as "Team 1, Team 2, Team 3" and choose which team will be which when you import and map the teams) |
AWAY_TEAM | * | Name of the Away Team (hint: you can leave these as "Team 1, Team 2, Team 3" and choose which team will be which when you import and map the teams) |
DATE | * | MM/DD/YYYY (This can be edited in Microsoft Excel by highlighting the cells that have dates and click "Format" > "Cells" > "Date" > and selecting the correct layout of MM/DD/YYYY.) |
START_TIME | * | Military Time (20:30 instead of 8:30pm) |
END_TIME | Military Time (20:30 instead of 8:30pm) | |
LOCATION | Optional, if left blank, will default to TBD. | |
SUB_LOCATION | Optional | |
TYPE | * | Options are: REGULAR_SEASON, PLAYOFF, CHAMPIONSHIP, TEAM_PRACTICE, SCRIMMAGE, QUARTERFINALS, SEMIFINALS, FINAL, FRIENDLY, TOURNAMENT |
NOTES | Optional |
* = required
Save it as a .CSV file
Step 3: Import the Schedule
Navigate to the schedule/calendar tab within the desired program. Click Import Schedule.
Click Choose File and select your saved .CSV file. Once it is loaded in click Update & Validate
Step 4: Map your Import
Be sure to select the correct program from the Programs drop-down menu.
Then match up each team and location from your schedule. If the teams are not spelled 100% correct, the tool will allow you to select the proper team from the dropdown list of teams.
If you have Program Grouping enabled (learn more about Program Grouping), you are able to select the appropriate sub-program within each main program. In the example below, you can select the 11U sub-program underneath the main program titled Registered Teams Test Tournament.
Once everything is correctly matching you can click Next in the top right corner.
Step 5: Review and Accept your Schedule
Here you will want to review your schedule and if everything looks correct you can click Accept
Note: You can edit details of the schedule after it is imported.
After reviewing your schedule you can check on the Publish Games or Publish Events box depending on what type of schedule you imported.
Congrats on importing your schedule!
Pool Play Schedule
Step 1: Set up a pool play Tournament
- Create a Tournament using a Grouped Program
- Name the Master Program using the name of the Tournament (ex: Dodgeball 2020 Tournament)
- Create and name sub-programs for each Division (ex: Dodgeball 2020 Tournament: 9U is a sub-program) This lets you set different prices per division or age group.
Step 2: Accept Team Registration
- Allow teams to register to a division and then you can manually move teams into pools once registration is complete.
Step 3: Create Pools & Move Teams
- From the Master Program navigation bar click on Teams > Pools
- Choose a Division and add a pool
- Move available teams into the pool by checking the box next to the team name and clicking ADD TO POOL
- To remove teams from pools, check the box for the team and click REMOVE FROM POOL
Step 4: Export Team List
- Click on Teams > Team List from the Master Program navigation bar
- Export the Team List to CSV
Step 5: Build your schedule
- The LeagueApps Schedule Generator currently works for Round Robin and Single Elimination tournaments only.
- For Pool Play schedule generator we recommend you use whichever method works best for your organization.
- Here is a the LeagueApps Pool Play Schedule Import template; or you can download it from the Management Console by navigating to the Master Program Schedule and click Import Schedule. There will be a button to Download Import Template.
Step 6: Import schedule
- Click on Schedule from the Master Program navigation bar
- Click the Import Schedule button
- Select the .CSV file and click the Upload & Validate button
Step 7: Validate schedule
- Select the appropriate program from the Program drop-down
- Confirm that each imported field is mapped to the accurate corresponding field for SUB PROGRAMS, TEAMS, and LOCATIONS
- When you are done making changes click the NEXT button and then ACCEPT
Step 8: Publish
- Control if Games are published for each Division using the toggle switches on the left side of the page.
Step 9: Enter Scores
- From the schedule click on the trophy icon
- Enter points scored for each team
- Optional: exclude a specific team's game score from standings calculations (for example, if you need a team to play an extra 4th game because of an unbalanced schedule, you may only want to count their first 3 game scores towards standings.)
Importing an Event Schedule
Step 1: Download & Open the Template
Download the Template here: LeagueApps_Schedule_Import Event Template.csv
Step 2: Input Schedule Information
SUB_PROGRAM | You can leave this blank unless you are importing a schedule that has games for multiple sub-programs within the same master program. When in doubt, leave it blank. | |
NAME | * | Name of the event |
TYPE | * | Type of Event (this can be Game, Tournament, Scrimmage, Practice, Meeting, Class, Camp, League, Training or Other ) |
START_DATE | * | MM/DD/YYYY (This can be edited in Microsoft Excel by highlighting the cells that have dates and click "Format" > "Cells" > "Date" > and selecting the correct layout of MM/DD/YYYY.) |
START_TIME | Military Time (20:30 instead of 8:30pm) | |
END_DATE | MM/DD/YYYY (This can be edited in Microsoft Excel by highlighting the cells that have dates and click "Format" > "Cells" > "Date" > and selecting the correct layout of MM/DD/YYYY.) | |
END_TIME | Military Time (20:30 instead of 8:30pm) | |
TEAM | ||
LOCATION | Optional, if left blank, will default to TBD. | |
SUB_LOCATION | Optional | |
LOCATION_NOTE | Optional | |
DESCRIPTION | Optional |
* = required
Save it as a .CSV file
Step 3: Import the Schedule
Navigate to the schedule/calendar tab within the desired program. Click Import Schedule.
Click Choose File and select your saved .CSV file. Once it is loaded in click Update & Validate
Step 4: Map your Import
Be sure to select the correct program from the Programs drop-down menu.Step 5: Review and Accept your Schedule
Here you will want to review your schedule and if everything looks correct you can click AcceptNote: You can edit details of the schedule after it is imported.
After reviewing your schedule you can check off the Publish Regular Schedule? box and click Apply
Troubleshooting/Common Mistakes
If you see the following error message (pictured below), make sure to check both of the following things on your Excel Document with the schedule.
- Make sure the year of the date is in four digit format, instead of two digit. (Example: 4/12/2019)
- Make sure that if the program is NOT a Grouped Program, that the SUB_PROGRAM column is blank.