Skip to main content

How to Import a Fixture

On this page

    This guide will show you how to use Volleyball Competition Management System to import a fixture.


    Step A: Set-up the Competition
    Step B: Prepare the Import File

    Step C: Perform the Import


    STEP A

    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 stage type can be found below:


    Round Robin Stage - here


    Knock Out Stage - 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 Volleyball Club' in the import file, the team name in the system must be spelled the same; 'Town City VC' wouldn't be recognized.



    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 "Matches" tab.




    3. Populate Teams


    Select on Team Grid and populate teams to specific slots, which will be used later in the import template file.




    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.




    STEP B

    4. Download Fixture Import Template CSV. file


    Template files can be found attached to the bottom of this page. Also, you can download the template directly from Volleyball Organizer: While located within the Matches tab of a stage, click on the (+) Fixture button located on the far right side of the screen, then click on Download CSV Template.




    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...
    • 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).
    • Pool: Depending on the stage type there could be several pools, type the one correspondent. 
    • Home team:  Is the name of the teams that have been added to the competition. Each team name must be spelled identically to the team names added to that competition. 
    • Away team:  Is the name of the teams that have been added to the competition. Each team name must be spelled identically to the team names added to that competition.
    • Venue:  If including Venues as part of Import, the Venue Name must be spelled identically to what is listed in the Competition Management System.
    • 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.


    Excel date management:

    • Use the apostrophe before entering the date, for example '2021-09-30 15:00

    • Use a formulae that refers to the REAL date value, for example =Text(Cell reference,"yyyy-mm-dd hh:mm"), then copy paste values in the correct column

    • Highlight column D and force it to be a TEXT column before the dates are entered




    STEP C

    6. Import Fixture

    While located within the Matches tab of a stage, click on the (+) Fixture button located on the far right side of the screen, then click on Import. Now 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.