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:

1. Locations and sub location must be created in advance.
2. Teams you wish to assign games or events to during the import will need to be created and in the program before the import.
3. 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 (Note: File size must be 2mb or smaller)
 

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

 

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.
 

1. Make sure the year of the date is in four digit format, instead of two digit. (Example: 4/12/2019) 
2. Make sure that if the program is NOT a Grouped Program, that the SUB_PROGRAM column is blank.