Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Navigate to Teams > Browse Seasons.

  2. Next to any Season, click “View”.

    Image RemovedImage Added
  3. Click “Import Fixtures”.

  4. Click “Sample file with comments” to download the file.

...

  1. Navigate to Teams > Browse Seasons.

  2. Next to the appropriate Season, click “View”.

    Image RemovedImage Added
  3. Click “Import Fixtures”.

  4. Click “Choose File”.

    Image RemovedImage Added
  5. Selected Worksheets: Choose the worksheets from your file that you want to import from.

  6. Select Data: Choose how much of the data you want to include from the selected worksheets.

    Image RemovedImage Added
    1. Load all data from worksheet(s): This is the most common option. This will load all rows from every worksheet selected from your file.

    2. Load selected data from worksheet(s): If you choose this option, you can select the Header row and any Constant Fields. Constant fields can be used where a field is the same for all fixtures being imported. For example, if all fixtures being imported are for the same Team, you can select a constant field that will be applied to every row.

    3. Load using configuration: Load using the saved mappings saved from a previous import.

  7. Map Import Fields: Click to proceed with the data selected.

  8. Assign Fields: This section allows you to match up the columns of data being imported with the fields in myClubhouse they should be saved to.

    1. Input CSV Field: The header from each column of your import file.

    2. myClubhouse Field: Select which field in myClubhouse the field from your import file should feed in to.

    3. Mapping Option: Where appropriate, select the format that your data is in.
      ⚠️ Important! Forgetting to set this field is a common cause of import errors!

    4. Sample Value: This shows the values from your first row, as an example to help you select the correct options.

  9. All or nothing: If checked, if an error occurs on a single row, none of the rows of data will be imported.

    Image RemovedImage Added
  10. Treat "NULL" as no value: If checked, cells with “NULL” in them will be treated as if they were blank.

  11. Save Import Mappings: You can save the import mappings for importing fixtures in the future.

    Image RemovedImage Added

    Complete the wizard:

    1. Name: Name the mapping configuration.

    2. OK: Once happy with the details, click “OK” to save the mappings.

  12. Import: Once happy with all the mappings, click “Import” to start the import.

...