Uploading Games via CSV

If you have a large number of games to add, you can upload them all at once using a CSV file instead of entering them one by one. ASM's dynamic import tool validates your file, shows you the data in a spreadsheet-like editor, and lets you fix any issues before importing.

Accessing the Import Tool

1. Go to Administration → Master Schedule
2. Select your group from the region dropdown at the top
3. Click the Import button in the toolbar (calendar import icon)

Preparing Your CSV File

Your CSV file needs column headers in the first row. ASM recognizes headers in both English and French and will automatically detect which language your file uses.

Required Columns

These four columns must be present and filled in for every row:

If any required column is missing from your file entirely, the import tool will flag it with a warning and add the missing column to the spreadsheet so you can fill it in manually.

If a required column exists but individual rows have blank values, those cells will be highlighted in red. You must fill them in before the import will proceed.

Accepted Date Formats

The import tool is flexible with date formats. All of these work:

• YYYY-MM-DD (recommended) — e.g., 2026-05-15
• DD/MM/YYYY — e.g., 15/05/2026
• MM/DD/YYYY — e.g., 05/15/2026
• DD/MM/YY — e.g., 15/05/26
• YY/MM/DD — e.g., 26/05/15

Dates are normalized to YYYY-MM-DD after upload, so you can verify them in the editor before importing.

Accepted Time Formats

• HH:mm (24-hour, recommended) — e.g., 19:00
• H:mm — e.g., 9:30
• h:mm AM/PM — e.g., 7:00 PM

Optional Columns

These columns can be included for more complete game data. If omitted or left blank, ASM will use default values where applicable.

Game Type Values

The Game Type column accepts the following values (English or French):

• Game / Match — regular season game (this is the default)
• Playoff / Séries éliminatoires — playoff game
• Exhibition / Hors Concours — exhibition game
• Practice / Pratique — practice session

If the column is left blank or not included in your file, games will default to Game (regular season). This is useful when most of your schedule is regular-season games — you only need to specify a game type for the exceptions.

Crew Type Defaults

When crew type columns are blank, ASM uses your group's default crew configuration. For example, if your group is set up with a 3-man crew for officials and 1-man for scorekeepers, those defaults apply to any row where the crew type is not specified.

The editor shows default values as greyed-out italic hints (e.g., Default: 3-person) so you can see what will be used without having to set it explicitly.

If a particular role (scorekeepers, supervisors) is not enabled for your group, the crew type for that role will show as N/A.

Position Columns (Pre-assigning Officials)

You can also include columns for specific positions to pre-assign officials during import. The column header should match the position name as configured in your group's sport. Common examples:

• Referee, Linesman, Linesman 2, etc. (hockey)
• Plate, Bases, 3rd Base, etc. (baseball)
• Head Ref, Trail Ref, Center Ref (basketball)
• Position 1 through Position 8 (generic)
• Scorekeeper, Scorekeeper 2, Scorekeeper 3
• Supervisor, Supervisor 2, Supervisor 3

The value in each position cell should be the official's username. The import editor provides autocomplete from your group's member list.

Fine/Adjustment Columns

You can include fee adjustments by adding columns named Fine1, Fine2, etc. The value format is:

username:amount:comment

For example: john.smith:15.00:Travel bonus

Most groups won't need this during import — adjustments are typically added after the fact from the Master Schedule.

Uploading the File

1. Make sure a group is selected in the region dropdown. The import tool needs to know which group to validate leagues, locations, and teams against.
2. Drag and drop your CSV file onto the drop area, or click Upload Files to browse.
3. ASM will validate the file. This takes a moment — the tool checks headers, required columns, and data formats.

The Spreadsheet Editor

After validation, your data appears in a spreadsheet-like table where you can review and edit everything before importing.

What You Can Do in the Editor

• Edit any cell — click on a cell to type or select a value
• Smart dropdowns — League, Team, Park, Crew Type, and Game Type columns show dropdowns with valid options from your group
• Autocomplete — Team, Park, and official position columns offer type-ahead search
• Date/time pickers — Date and Time columns have calendar and clock picker icons
• Tab navigation — press Tab to move between cells, Shift+Tab to go back, Enter to move down
• Visual validation — cells with errors are highlighted in red with tooltip explanations

Understanding Warnings and Errors

• Orange warning badges at the top indicate missing required column headers. The column will be added to the table so you can fill it in.
• Red error badges indicate rows with missing required values or invalid data (e.g., a league ID that doesn't exist in your group).
• Red highlighted cells are the specific cells that need attention. Hover over them to see what's wrong.

The import button will not proceed until all required values are filled and all validation errors are resolved.

Default Value Hints

For columns like Game Type and Crew Type, blank cells show a greyed-out hint indicating what default value will be used. For example:

• A blank Game Type cell shows Default: Game — meaning it will be imported as a regular season game
• A blank Crew Type cell shows Default: 3-person — meaning your group's default crew size will apply

You only need to fill these in when you want something different from the default.

Importing

Once everything looks good:

1. Click the Import button at the bottom-right
2. ASM runs final validation, then imports all the games
3. A success notification appears and the Master Schedule refreshes with your new games

The imported games appear as draft entries on your master schedule, ready for further editing or assignment.

Tips

• Export first to get the format right — if you already have games on your schedule, use the Master Schedule Export button to download a CSV. This gives you a perfectly formatted template with the correct column headers and IDs for your leagues and locations.
• IDs vs names — League ID and Park ID must be the actual system IDs, not display names. The easiest way to find them is by exporting your current schedule or checking the league/location settings.
• Start simple — for your first import, just include the four required columns (League ID, Date, Time, Park ID). You can always edit games after import to add teams, comments, and assignments.
• Bilingual headers — if your group works in French, you can use French column headers (e.g., ID de la ligue, Date, Heure, ID du terrain). ASM detects the language automatically.
• Reuse your file — if you import games regularly (e.g., weekly schedule updates), keep your CSV template and just update the data rows each time.