Import Games (Schedules)

Once Locations and Surfaces have been added, you can then add Games to the system. There are a variety of methods available to expose game dates on Team Pages, the Mobile App, or the Referee Management System. This article covers the import process. 

Importing Games (Schedules)

To ensure a successful import, check the following settings before starting the process:

  1. First ensure your season has at least one division defined. This can be reviewed in Seasonal Structures > Edit Season > Structure Depth. 

  2. If your structure contains Age Groups, it is best practice to ensure they are first defined properly in your Seasonal Structure. Age groups can be set up and defined per seasonal scope for consistency in the Seasonal Structures > Settings view. 

  3. Ensure all locations and surfaces are available in your Locations directory. Only existing locations and surfaces can be imported. 

To begin your import:

  1. Navigate to Schedules > Settings > Import Schedules and select your Competition and Season

  2. A template will automatically generate when your Season is selected. When downloading the .CSV template, column headers will dynamically change to include the selected season’s structure depth level names. (See screenshots below for example)   

 

  1. Fill in the template as follows:

    1. External ID: Enter a unique game ID per row. Duplicate game IDs in the file will result in an error message. Games with empty game ID values will not be imported.

    2. Date: Date is required. Format must be MM/DD/YYYY

    3. Time: Time is required. Format must be 00:00 AM/PM

    4. Duration: Numerical Values Only

    5. Location name: Must match existing location name exactly 

    6. Surface name: Must match existing surface name exactly. 

    7. Divisions (Custom per season): Enter the corresponding Division Name as defined in your Seasonal Structure per column.

      1. Division names must match exactly.

      2. Division columns can not be left blank.

      3. If you are entering in games for teams that have differing division structures, you must first place all teams at the lowest level division For example:

        1. Teams A-F are under division: Travel > Co-ed > U19 > D2

        2. Teams G-P are under division: Travel > Girls > U16

        3. The Teams for G-P must first be placed in the lowest level division before you can import - for example, place Teams G-P under division: Travel > Girls > U16 > All Skill Levels

      4. You may enter new divisions and teams into the import file to have the divisions created by the import process as long as the all levels are defined in the .csv file. 

        1. For example, your current Season Structure is defined as: Season > Gender > Age > Skill Level. New divisions will only be created if all levels are defined. 

    8. Home Club:

      1. If you are a member of an association/league system: Use the exact name of the club you are importing into.

      2. If you are not importing game events into a League/Association system - Skip

    9. Home Team UUID:

      1. Importing Games for New Teams: Leave blank

      2. Importing Games for Existing Teams: Copy and paste the Team ID for existing Teams. If you do not have the ID, ensure the Home Team name is an exact match. 

    10. Home Team:

      1. Importing Games for New Teams: The new Team Name will be created upon import

      2. Importing Games for Existing Teams: Copy and paste the exact Team Name

    11. Away Club:

      1. If you are a member of an association/league system: Use the exact name of the club you are importing into.

      2. If you are not importing game events into a League/Association system - Skip

    12. Away Team UUID:  

      1. Importing Games for New Teams: Leave blank

      2. Importing Games for Existing Teams: Copy and paste the Team ID for existing Teams. If you do not have the ID, ensure the Away Team name is an exact match. 

    13. Away Team

      1. Importing Games for New Teams: The new Team Name will be created upon import

      2. Importing Games for Existing Teams: Copy and paste the exact Team Name 

  2. Once your file is ready, save the file locally on your computer. You can then drag your .csv file to the blue upload area on the import screen or click the target area to select from your computer's files.

  3. Click Next to review your data to be imported. You will be able to correct some errors directly on this view depending on the type of issue identified. If errors can not be amended on this view, they must be corrected on your file and then re-uploaded.  

  1. Once the import is complete, you will receive an email confirmation. Your schedules can now be opened for access to Team Staff/Team Members when you are ready.