🚨 If you’re looking to learn how to import officials from a spreadsheet, check out this article.
There are two ways to add Games to your site:
- In Bulk. By importing games from a CSV (Excel) spreadsheet.
- One at a time. By adding games one-at-a-time from the Games screen.
To add games to your site from a Spreadsheet, follow these steps:
Step 1: Format your Spreadsheet.
First, let’s make sure you have your spreadsheet in the correct format.
1. Column Headers. Your first row should be your Column Headers, or titles, reflecting what information is in the rows underneath it.
2. One row per game. Each game must be on a single row of your spreadsheet.
3. Required Fields. You have the ability to import several different kinds of fields into the system (more info on those fields below!), but the following fields are required for each game:
a. Date — the date of the game.
b. Start Time — the time the game starts.
c. Venue — the location where the game is played.
d. Age Group — determines the level of play; controls the game fees; and controls whether an official should be assigned to the game based on the official’s ability page.
e. Home Team — one of the teams playing the game.
f. Away Team — the other team playing the game.
4. CSV. Save your spreadsheet as a CSV file.
Here’s an example of what a properly-formatted spreadsheet looks like:
Now that you have your spreadsheet ready to go, it’s time to actually import it into your site!
Step 2: Import your Spreadsheet.
To import your spreadsheet, follow these steps:
- Select the Games menu, then select All Games.
- Select Import a Spreadsheet (CSV).
- File Type → Games.
- Select Choose File.
- Select the CSV spreadsheet of games you wish to upload.
- Select Open.
- Select Upload File.
- Choose a Default Pattern from the dropdown. (You can learn more about Officiating Patterns here, and in the FAQs below!).
- Map each Column Header that you wish to upload with the system’s corresponding field.
- Select Submit.
That’s it! Well done. 👏
Learn how to publish your games, add officials to your site, and assign officials to games next!
What other fields can I import, besides the required fields?
While you don’t have to, you’re more than welcome to include any/all of the following fields in your spreadsheet.
Keep in mind, you’ll need to map each of these fields to their corresponding system fields before selecting Submit, to ensure that the information is added to that game!
- Sub-Venue — A specific location within the main venue of a game. For example, Field 6, Court 3, or Main Gym.
- League — If you have League Conflicts set up, you can use the League section to ensure certain official(s) that have conflicts with certain league(s) do not get assigned to those league's games.
- Game Type
- Game ID — The game ID can be anything (alphanumeric), but must be unique among all of your games.
- Notes (Visible to All) — These notes are visible to anyone that can view that game, including officials assigned to it.
- Assignor Notes — These notes are visible internally, to assignors only.
- Pattern — The officiating pattern, which determines the number and type(s) of officials assigned to this game. Learn more about how to import various Patterns below.
- Status — A game can have one of three statuses: Active, Canceled (no pay), or Canceled (with pay). New games default to being active. When Canceled (no pay) is selected, billing and payroll reports will automatically set the pay rate to zero. If the status of an existing game changes from active to cancelled, or vice versa, assigned officials will be notified.
- Paid by — The entity responsible for paying the officials. This field will only be shown when using the Financial Module or paying officials via Direct Deposit.
What if not all of my games have the same Pattern?
If the games you’re importing have different Officiating Patterns, you’ll want to create a separate Pattern column in the spreadsheet you upload. (Whereas if the patterns are all the same, you can simply select the Default Pattern from the import screen).
In your Patterns column, include the corresponding Pattern of each game. This will override the Default Pattern you’ve selected on your import screen.
💡 The values in your Patterns column must exactly match the names of the existing Patterns in your site. Otherwise, the Default Pattern will be used.
Happy uploading! Let us know if you run into any questions as you do this. 🙂
P.S. Here's a video that shows how this process works: