...
Navigate to Teams > Browse Seasons.
Next to any Season, click “View”.
Click “Import Fixtures”.
Click “Sample file with comments” to download the file.
Importing Your Fixtures File
Navigate to Teams > Browse Seasons.
Next to the appropriate Season, click “View”.
Click “Import Fixtures”.
Click “Choose File”.
Selected Worksheets: Choose the worksheets from your file that you want to import from.
Select Data: Choose how much of the data you want to include from the selected worksheets.
Load all data from worksheet(s): This is the most common option. This will load all rows from every worksheet selected from your file.
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.
Load using configuration: Load using the saved mappings saved from a previous import.
Map Import Fields: Click to proceed with the data selected.
Assign Fields: This section allows you to match up the columns of data being imported with the fields in myClubhouse it needs to go they should be saved to.
Input CSV Field: The header from each column from of your import file.
myClubhouse Field: Select which field in myClubhouse that the field from your import file should feed in to.
Mapping Option: Where appropriate, select the format that your data is in. This
⚠️ Important! Forgetting to set this field is a common area that is not checked which can cause errors with the import.cause of import errors!Sample Value: This shows the value values from the your first row to show what the data looks like , as an example to help completing the other fields in this sectionyou select the correct options.
All or nothing: If checked, if an error occurs on a single row, none of the rows of data will be imported. This is recommended as it can be tricky to reimport just the rows that didn’t cause errors without accidentally causing duplicates.
Treat "NULL" as no value: If checked, cells with “NULL” in them will be treated as if they were blank.
Save Import Mappings: You can save the import mappings for when importing fixtures in the future.
Complete the wizard:
Name: Name the mapping configuration.
OK: Once happy with the details, click “OK” to save the mappings.
Import: Once happy with all the mappings, click “Import” to start the import.
Related articles
...