Skip to main content

Build & Import Schedules

Preet Jain avatar
Written by Preet Jain
Updated yesterday

This video walks you through how to build and import schedules in TeamLinkt. You’ll learn how to import an existing schedule using a CSV file, including how to ensure teams, locations, and event details match what already exists in your system. It also covers how to create schedules from scratch using the practice and game schedule builders, where you can set divisions, teams, locations, availability, game duration, blackout dates, and scheduling rules.


You can also follow along with the video using the transcript provided below :

[00:00:00] Welcome to TeamLinkt Scheduling. When it comes to your sports organization, there may be a variety of reasons why you could take different routes when it comes to your scheduling. The first might be that you already have a schedule built outside of the system on an Excel sheet or CSV. If that's the case, you will likely want to import that schedule

[00:00:21] keep in mind, from a data standpoint, we need to make sure that the data in your CSV file matches what exists within the TeamLinkt system. For example, the teams that are being utilized for scheduling their names must match the locations that you're utilizing for scheduling. Those must match

[00:00:36] for example of what, already exists within your TeamLinkt system. You can go to add, import on the events page, go to import events, and this will bring up a sample spreadsheet that you can utilize as a reference point for the structure you're gonna be utilizing for your import.

[00:00:53] Within here we have date time type of event, which if you double click, you'll be able to see the different types of event that we support. Here you have the option for home division, home tier home team, and so on,

[00:01:04] So all your locations that you have entered in the locations area on the left hand side will feed into this. You need to make sure that these data points match what exists within the TeamLinkt system. You can always add locations, but if you just want a sample spreadsheet to work off of.

[00:01:21] You can click import file and go to download sample spreadsheet. This will download to your computer A CSV file that you can use to build your schedule and then import it into the system. If you are looking to build a schedule from scratch, back in the events page, we have our, schedule builders that you can utilize.

[00:01:41] So click on builders. There is a, builder for building a practice schedule. There's also one for building a game schedule. Both of these have a wizard that will walk you through each of the parameters that you need to set in order to generate a schedule from scratch. This is an AI powered tool that will get you a schedule created based on the parameters that you give it.

[00:02:01] In some cases, this can't build a schedule. To the absolute maximum if you have any customization that you need on your schedule. However, it can get you very close and you can make some manual tweaks if needed. In this case, we'd be selecting the division and tier that we want to include teams from. We can select all the teams that we want to include.

[00:02:23] We will then select the locations that we want to use for this schedule, and set availability so perhaps Madison Square Garden is available on Mondays from 10:00 AM to 10:00 PM but Rockefeller Center is only open Tuesdays and maybe at a shorter timeframe. We could go 11:00 AM until 6:00 PM This will allow the system to take preset parameters and build based on what it's given.

[00:02:51] We will flag anything if any information is missed. For example, I missed putting in T-Mobile Arena. I need to set an availability date for that day. You can create exceptions for the location availability. If certain days are different from what you have set.

[00:03:05] As a general parameter, you can also set home preferred locations, for each of the teams that exist here, if. They have a specific team that can only play at Rockefeller Center. You can set that This is preferred, so it will schedule around this if the system is limited, but it will try to prioritize it

[00:03:23] next, it'll ask you when your schedule is going to start and for how many weeks we will get to some game settings a little bit later, but this is just a preliminary part of this process. If you do have any bi-week, you can add them in here. You'll also wanna set your game duration.

[00:03:38] So in this case, I have one hour games and a 15 minute buffer Between games, you can eliminate the buffer entirely. It really doesn't matter whether you have the entire game duration of 75 minutes with a time between game of zero in my case. But this will reflect on the app in terms of how long the event is listed.

[00:03:58] If you only set it to 60 minutes, the event will show us 60 minutes and the next game won't be scheduled for 15 minutes after that. You could prioritize certain days based on your availability. This is just a slider and it will prioritize based on your preferred scheduled days.

[00:04:15] You can set blackout dates if you have holidays that are falling within your schedule time and you wanna work around them, and then you could set how many games you are seeing per week. So in this case, if I had a seven week schedule, maybe each of my teams are supposed to play twice that week, you could set that to two game days in that week

[00:04:32] you can edit this further where you may allow double headers, triple headers, or some sort of custom scenario in which you're gonna have, in this case, two games per team. Maybe we're gonna change matchups to each game, but maybe we need at least one game rest, but no more than three games.

[00:04:47] Rest. This is just further customization on the schedule. When you click finish, it will generate a schedule for you and it will flag any unscheduled events. If there are any events that are unscheduled, you can click troubleshoot to get feedback on why you might not have a full schedule

[00:05:03] this is likely due to not having enough. Time or availability on the prioritized days. You can always adjust these and republish to create a new schedule in this case, because I allowed for, two game days a week, I likely just don't have enough.

[00:05:18] Schedule availability to support that many games in a seven week period.

Did this answer your question?