Tips and Tricks for Troubleshooting Schedule Imports

Getting stuck trying to import your schedule? Here are a few tips and tricks to help:

Use the Right Template

There are two schedule import templates available for the Club & League TeamSnap app. If you are importing games and events for more than one team, you will want to import under the organization Schedule tab and use the Import Schedule for Sports Organizations guide and template. If you are importing schedules to a single team at the team level, you will want to import under the team Schedule tab and use the Import a Team Schedule Guide and Template. These templates are not interchangeable, and must be in a CSV format to import.

Warning: It is very difficult to maintain a Full Organization Schedule View with a team-level schedule import. Team schedule imports can generate opponents and team-controlled locations, and also can not be reversed. 

Check Your Headings

Your headings should be exactly the same as in the CSV template. Your import tool can not read approximate headings, so any change in the order or phrasing of your column headings can result in an import error. For best results, start with a clean template and plug in your information. Schedule imports can not be customized with added columns. Only the columns in the templates are supported.  

Separate Games and Events

Your Games and your Events should be imported as separate files. When importing Events, delete the 'Away Team' column, and only include the 'Home Team' column for that file.  

Before You Import Your Organization Schedule

 Your organization schedule import can generate games and events for all teams across your organization! It can not generate teams, divisions, opponents, or locations. Before you import, make sure to check that you have done the following:

  • All divisions/teams have been set up
  • Any outside (non-league) opponents have been entered - To do this go to each team’s schedule tab and click on the Edit Opponents button. If no games have been entered on the team’s schedule yet, click on the Schedule Your First Game button, then on Edit Opponents. When importing events that do not have an opponent (e.g. practices), just leave the Away Team column blank.
  • All locations have been entered in the league level schedule tab

Review for Typos and Formatting Requirements

 The most common cause for an import error is the dreaded typo. Be exact! Imports are sensitive, even to spaces and punctuation.

  • Team names, outside (non-league) opponent names, and location names in the import file match exactly to how they are spelled in TeamSnap and they are case sensitive. If your team name is listed as PANTHERS in TeamSnap if you enter the team name as Panthers on the import, it won't find a match. 
  • Any blank rows or columns have been deleted
  • There are no spaces before/after and of the data in each cell
  • Formatting requirements: Date: MM/DD/YYYY (Unless you change your organization Settings > Site Prefs to Use international dates (DD/MM/YYYY)), Start/End Time: HH:MM AM/PM 
  • Arrival Time: Minutes prior to start time (for example, 30)
  • Tip: At this time, schedule imports can have trouble with symbols such as % , @ , # , * etc. 

Include Required Information

The following organization template columns can be deleted, if you do not need them. All other columns are required.  

  • End Time
  • Away Team (For event import files only.) 
  • Event Type
  • Location Details
  • Arrival Time
  • Short Label

Happy importing! 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.