- Download Template File
- Remove Sample Data from Template File
- Copy & Paste your game data into the template file
- Save the file & import
How Imports Work
Importing games via a CSV spreadsheet file can be done via the import options provided in the system. You may import up to 10,000 games in one spreadsheet. The larger your file, the longer it will take. This option is only available for administrators and assignors/schedulers on the system and is not available for coaches, athletic directors, general members or any other user types. To access the import page, you would go to Master Game Schedule >> Add Games (top left) >> Import from Spreadsheet.
All imported files must follow our import template format which is available for download on the import page. Files must be saved as a CSV (comma separated values) file which is a simplified version of an Excel spreadsheet. The order and format of your columns will vary, depending on the setup options you have chosen in your System Settings so be sure to start with our template file so you know the column and ordering structure of the import. It is important to note that if you change your System Settings, your template format may change too. We recommend you download a new template file after making any changes to your System Settings.
You can download a template file on the import page in the top right corner using the Download Template File option. The section will also describe to you which columns are required and which are optional, again, based on your System Settings.
Selecting Import Options
The following options can be selected during the import process.
- Import Type
Add New Games
This indicates that you are trying to add new games to the system. Any entries in your spreadsheet will be added to the system as a brand new event.
Update Existing Games
This indicates that you will be providing an edited spreadsheet to update existing games. Edited spreadsheets must contain the system game ID number. Generally, you cannot self-generate spreadsheets for this process and you should be starting with a downloaded spreadsheet of your existing games. See the mass-edit instructions guide for details and instructions.
- Name Format
This indicates whether or not you want to import assignments with your games. In most cases, you'll select "No Names". We do not recommend importing assignments with games as it is treated as a system override. You can see this article for more details.
- Matching Settings
The larger section of settings on the import represents how the system should match and identify your content. These sections begin with "If we cannot match the _________, what should the system do?" When reading the content of your spreadsheet, the system will search through your subscription to identify entries that match the content of your spreadsheet (teams, leagues, game codes, locations, officials, etc.). The system will perform these searches in the following order:
1. Search for an exact match: The system will search for an exact match to the term you entered
2. Search for a partial match: If step 1 is unsuccessful, the system will proceed with trying to locate a partial match
3. Perform the fallback setting you specified: If both step 1 and step 2 are unsuccessful, then this is where your selected setting comes into play. You can instruct the system how to proceed a this point. We recommend leaving the default as "Show error message", but advanced and experienced users can feel free to adjust these settings as desired.
Import Tips & Restrictions
- Up to 10,000 games are permitted per file, however, we recommend importing smaller batches for better system performance.
- Game dates may be no older than the start of your "Current Season" and no later than 2 years in the future from whatever today's current date is.
- Date format will follow your System Settings format which is either mm/dd/yyyy or dd-mm-yyyy, the key formatting difference being slashes vs. hyphens
The format mm-dd-yyyy is not accepted. If you want month-day-year formatting, you must use the mm/dd/yyyy format option with slashes, not hyphens.
The format dd/mm/yyyyy is not accepted. If you want day-month-year formatting, you must use the dd-mm-yyyy format option with hyphens, not slashes.
- Time format may be 12 or 24 hours, both are accepted. The system accepts a wide range of formatting. 3:00pm, 3pm, 15:00, 3 pm are all acceptable values.
- Be sure to carefully read the Preview Page. It's much easier to cancel an import to fix problems than it is to try to fix problems after completing the import.
- We don't recommend importing assignments with your games, but if you're considering this, please see this support article.