Import a schedule for every team
One file for all your teams, from a league, a spreadsheet or a calendar file, checked line by line, that updates what’s already there and can be undone.
When a league sends the season for all your teams, or you keep the club’s schedule in a spreadsheet, import it in one go from the calendar. Part of the Organization plans, for the people who schedule every team. One team at a time works on the Team plan: see Add events from a list.
Importing
- Open Calendar and choose Import….
- Paste the rows, or Choose a file: a CSV, or a calendar file (.ics) from a league or another app. Download a sample shows the shape.
- Choose a Team for lines without one, if the file is for one team (a calendar file usually is).
- Check the file. Every line shows its team and what happens: New, Changes, Cancels it, No changes, Already on the schedule, Already happened, Left out or Fix this line, with the reason.
- Import N changes. Tick Add the new ones as drafts to check them before families see them.
Up to 300 lines at a time, in your organization’s time zone. Lines with problems are left out; fix them in the file and check again.
Which team each line is for
- A Team column names it. Your team’s name works with or without your organization’s in front (“12U AA”, “Northgate Hockey Club 12U AA”).
- With Home and Away columns, it’s whichever team is yours, and the other is the opponent. A game between two of your teams goes on both schedules (and isn’t a clash).
- A name that isn’t one of your teams (“12U AA Black”) is listed to match once: choose the team, or Not one of our teams to leave its lines out. It’s remembered for the next file.
The other columns are the same as for one team’s list (Date, Time, End or Length, Type, Opponent, Place, Notes…), plus a Sheet and a Part (“Half A”) for your own places. “Northgate Arena · Rink 2” in the Place column finds the sheet too.
Updating what’s there
Tick Update what’s already there when the league sends the schedule again. A line already on a schedule changes it instead of being skipped. Lines are matched in this order:
- The ID column of your calendar’s own spreadsheet.
- The file’s own game ID (a Game ID column, or a calendar file’s event IDs).
- The same team and start.
- For games, the same team, day and opponent (a new time).
Only what the file gives changes: blank cells leave what’s there, so notes and arrival times you added stay. Cancelled in a Status column (or a calendar file’s cancelled event) cancels it. Families of the teams with changes get one email each listing them.
Tick Take off what the file leaves out too and, between the file’s first and last day, its teams’ events it doesn’t list are cancelled (drafts deleted). Tournament and league games stay.
Your calendar’s Spreadsheet imports back the same way: download it, change times or sheets, and import it with Update what’s already there. Bookings and tournament games in it are left out.
Undo
Made a mistake? Import… shows your last import and Undo this import… for 7 days, until the next one. What it added comes off (cancelled, with families told, once anyone answered), what it changed goes back, and what it cancelled or deleted comes back. Anything someone changed since the import stays as it is.
Calendar files
A calendar file’s events come with their time zone, place and description (as notes). “vs Valley Wolves” and “Lakers @ 12U AA” become games with the opponent and home or away; anything else takes its type from its name or the type you chose. All-day and repeating events in the file aren’t added: add the first one here and repeat it in SeasonLane.
A league’s calendar link
If the league publishes its games as a calendar link, add it once in League calendars… and SeasonLane brings it in every night like this import, updating what’s there. See Bring in a league’s calendar every night.
See Change many things at once and Your organization’s calendar.