When creating a schedule for an event, you have the option to upload a file (.csv) to add games, rather than building them in the Schedule Admin. You have the option to do this for both round-robin schedule blocks as well as bracket play.
The first thing to do is ensure a Schedule Block has been created. You can find information on how to create a schedule block and other general information about the Schedule Admin here.
Navigate to the Event Admin Menu > Schedule. Set the number of teams for the Event. Ensure that at least one Schedule Block has been created either through the Schedule Wizard or Manual Setup. Inside your desired Schedule Block, click Add Games and then Upload a Schedule.
For brackets, create the new schedule block then click the Upload Games button. Then click 'choose file' and locate the file on your computer.
Note: Uploading brackets is currently activated on a site-to-site basis (uploading pool play games is available on all sites). If you would like to utilize this feature, please contact our support team.
Schedule Format
Schedules should be uploaded in .csv (comma separated value) format for display on your site.
Files should have the .csv extension. You can save as this format in standard spreadsheet programs, such as Microsoft Excel or Google Sheets. The variables written <like this> are the columns for your spreadsheet (each value exists in its own cell). Do not include the column names in the .csv file.
<home team name>,<away team name>,<start date>,<start time>,<end date>,<end time>,<field name>,<field number>
- One game per line.
- The only required fields are <home team name> and <away team name>. Every other field may be left blank.
- <start date> and <end date> must be in mm/dd/yyyy or dd/mm/yyyy format, whichever your site uses.
- <start time> and <end time> must be HH:MM (24-hour format).
- Team names and field names containing commas must be placed inside quotes.
- If teams are not yet known for this portion of the schedule, you can use the team placeholder instead. For example: "Pool A, Seed 3". Use the exact text from the pools edit page, that's what the system will look for.
Frisbeetarians,Discologists,11/30/2020,18:00,11/30/2020,19:30,Polo Fields,2
This would schedule a game between team Frisbeetarians (home) and team Discologists (away) on field number 2 of the Polo Fields field on November 30th, 2020 from 18:00 (6pm) to 19:30 (7:30pm).
Uploading is additive and does not overwrite past weeks. For example, you can upload additional games or weeks of pool play without affecting the rest of the schedule.
See the CSV attached at the bottom of this article for an example of a pool play upload.
Uploading Bracket Games
Uploading brackets to an existing schedule uses more or less the same format that is used when uploading games to a pool play portion of the schedule, except there is one extra column at the beginning that indicates the game "letter" as it reads in the bracket editor.
As you did with Pool Play, create a bracket schedule block and map out the general format, either via the Schedule Wizard or the Add Schedule Block button.
Once you're finished, there is a button on the Schedule Admin screen, that says “Upload Games”.
After clicking the upload games button you will be taken to a screen where you can select a prepared CSV file to upload.
The CSV file should be in the same format that is listed above under Schedule Format, however, there is an additional column at the beginning to map the game row to the game "letter" identifier in your bracket. For example, the following screenshot shows games with the identifiers A, B, and I.
The team names should be in the format Poolname, Seed.
A, Frisbeetarians,Discologists,11/30/2020,18:00,11/30/2020,19:30,Polo Fields,2
This would schedule a game in bracket slot A between team Frisbeetarians (home) and team Discologists (away) on field number 2 of the Polo Fields field on November 30th, 2020 from 18:00 (6pm) to 19:30 (7:30pm).
See the attached CSV for an example of a bracket upload that creates two 16-team brackets.