This guide will show you how to use Football Competition Management System to import a fixture.
Step A: Set-up the Competition
Step B: Prepare the Import File
Step C: Perform the Import
1. Select Competition
After logging into the system, select Competitions on the left-hand side and go through the steps to create a competition.
User Guides on each Competition type can be found below:
Round Robin Competition - here
Group Stage Competition - here
Knock Out Competition - here
When creating a competition, it is important that the team names in the import file are spelled exactly the same as the team names listed in the system. For example, if a team is called 'Town City Football Club' in the import file, the team name in the system must be spelled the same; 'Town City FC' wouldn't be recognised.
Ensure Stage Status remains set to 'Draft'. A Fixture Import is not able to be performed if the Stage Status is changed to 'Scheduled'.
2. Select Stage of Competition to Import
Select the stage where you want to import those fixtures, then select the Fixtures tab.
3. Populate Teams
Select on Team Grid and populate teams to specific slots, which will be used in a template.
Import will not work if Team Grid (Step 3) is not completed. Don't worry about how the fixture is displayed once completed, as the import will override the fixture created by the platform.
4. Download Fixture Import Template file
Template files can be found attached to the bottom of this page.
You are also able to adjust a copy of an import file that you have successfully used previously (be careful to ensure that Excel does not automatically change the format of the dates if you are opening a .csv file).
5. Complete Fixture Import file
The Import file you use must be populated with data that complies with the following requirements:
Match number: This should be a different number for each match, in sequence order for example 1, 2, 3, 4, 5 ...
Round number: If teams play each other twice you would have only '1' and '2' in this column, example 1 for the first round and 2 for the second round
Match Day number: If there are 18 Match Days/Weeks, you would list them 1 to 18
Match date time: Format must be "yyyy-mm-dd hh:mm" (24 hour format)
Home team: This must be spelled identically to what is listed in Competition Management System under 'Team Name'
Away team: This must be spelled identically to what is listed in Competition Management System under 'Team Name'
Home team slot number: Populated with a number matching the slot that the team was assigned to in the Team Grid (Step 3 above) [this can be left blank if the Team Names have been added]
Away team slot number: Populated with a number matching the slot that the team was assigned to in the Team Grid (Step 3 above) [this can be left blank if the Team Names have been added]
Venue: If including Venues as part of Import, the Venue Name must be spelled identically to what is listed in the Competition Management System
Venue ID: This can be ignored as part of the import (this would be populated in this file if you had performed an 'Export' of a Competition with assigned Venues) [this can be left blank if the Venue Names have been added]
The Import file must be converted to CSV type file (using UTF-8 encoding) (from Excel 'Save As', then change 'File Format')
The column headings must be in English (as contained in the attached examples)
The Home Team and Away Team fields can be left blank if you are creating a fixture for an upcoming competition where it is still unknown which specific teams will be filling certain slots (e.g. World Cup fixtures, including venue and kick-off time, are set before all Teams qualify and are drawn into groups).
Please ensure the completed file is saved as a CSV type file (using UTF-8 encoding).
If you have additional setting options when saving the file, ensure that the file delimiter is the comma ( , ) character.
6. Import Fixture
Within the Competition select the Import button. Here you can select to upload the file saved in Step 5 and select to import again.
Ensure that you have ticked 'I want to import fixtures with team names'
If you do not get any error messages your fixtures are successfully imported.
If the outcome of the import is not as you anticipated, you are able to make adjustments to the import file and perform the import again; it will overwrite the previous import.
Import File Templates
Please find the following files attached below:
- Fixture Import - Blank Template.xlsx - please download and enter your fixture details as per the requirements described in Step 5 above. Remember to save a copy as a .csv file to import when you are done.
- Fixture Import - Example.csv - to refer to as an example of a completed import file for a 15-team round-robin competition.