What is the flow for scheduling?

1. Make sure the Field file is present and formatted correctly; upload the file to the 'fields' asset directory.
2. Update the Teams file with the new teams; upload the file to the 'schedules' asset directory.
3. Create the Games file; upload the file to the 'schedules' asset directory.

Setting up the file

The Teams CSV file requires 5 fields. Required fields are "FieldID", "FieldName", "ShortName", "FieldAddress", and "PhysicalLocation". The first rown in the file should contain the names of the required fields, as above. Do not use quotation marks around any text within the file. If you use Excel to edit the file, make sure to save as CSV; the schedule page cannot use an Excel file.

Naming the file

The naming convention used for the fields file is: fields.csv.

Updating the file

To avoid issues, duplicate the old field file and then rename the duplicate file on the server by adding an underscore and the date at the end. For example, fields.csv would become fields_7-30-2023.csv. This will make sure we all have access to the old information if we need it, and also allow us to update the fields.

Previewing the Venues

You can view the table of Fields/Venues below.

FieldID as Game Venue

The FieldID will be used in the Schedule under the venue column. One caveat is that the FieldID must be unique to each venue. If you duplicate them, only the last field with the duplicate ID will be used. The rest of the data can be duplicated.

Columns explained

FieldID is explained above, but identifies which field the game will be played at. Use this value in the "Venue" column of the game schedule.

FieldName is the name we have given the field. It is shown on the Schedule and on the Fields page.

ShortName is used as a ToolTip on the Fields page and is required.

FieldAddress is the USPS address of the park.

PhysicalLocation is the Lattitude and Longitude of the field. This is used to show exact locations of each field. You can get this value by adding a pin to Google Maps, right clicking and copying the numbers at the top of the context menu.

Setting up the file

The Teams CSV file requires 4 fields. Required fields are "Team Number", "Team Name", "Coach Name", and "Coach Email". The first rown in the file should contain the names of the required fields, as above. Do not use quotation marks around any text within the file. If you use Excel to edit the file, make sure to save as CSV; the schedule page cannot use an Excel file.

Naming the file

The naming convention used for the teams file is: {division}_teams.csv. Replace {division} with the approporiate division. For example, the U6 Division Teams should be named as u6_teams.csv. For Scooter Shooters, name the file u5_teams.csv>.

Updating the schedule

To avoid issues, download the old schedule and then rename the old Team schedule on the server by adding an underscore and the date at the end. For example, u5_teams.csv would become u5_teams_7-30-2023.csv. This will make sure we all have access to the old information if we need it, and also allow us to update the teams.

Setting up the file

The Schedule CSV file requires 8 fields. Required fields are "Date", "Time", "Venue", "Home Team", "Visiting Team", "Complete", "Needs Rescheduling", and "Rescheduled From". The first rown in the file should contain the names of the required fields, as above. Do not use quotation marks around any text within the file. If you use Excel to edit the file, make sure to save as CSV; the schedule page cannot use an Excel file.
When adding the venue, use the ID of the field from below.

Naming the file

The naming convention used for the schedule file is: {division}_schedule.csv. Replace {division} with the approporiate division. For example, the U6 Division Schedule should be named as u6_schedule.csv. For Scooter Shooters, name the file u5_schedule.csv>.

Updating the schedule

To avoid issues, download the old schedule and then rename the old schedule on the server by adding an underscore and the date at the end. For example, u5_schedule.csv would become u5_schedule_7-30-2023.csv. This will make sure we all have access to the old information if we need it, and also allow us to update the game schedule.