Valid date/time formats are determined by your Windows Regional Settings. Settings listed in the documentation conform with United States standards. For users outside of the United States, use the Start Menu : Control Panel : Regional and Language Options command to view valid date/time formats for your locality.
Assignments can be exported, however, referee assignments cannot be imported. Referees must be assigned from within the Referee Assistant program.
Table 5.1. Import Games Field Layout
| Column Name | Description | Format | Required? |
|---|---|---|---|
| Date | The date of the game being played. | m/d/yy or m/d/yyyy, or any valid Excel date format | Yes |
| Time | Kickoff time of the game being played. | h:mm AM/PM, or any valid Excel time format | Yes |
| Field | The location where the game will be played. | Text | Yes |
| GameType | Game Type for the game being played | Text | No |
| League | League for the game being played. | Text | No |
| Home | Home team of the game being played. | Text | No |
| Visitor | Away team of the game being played. | Text | No |
| Age Group | Age Group of the game being played | Text | Yes |
| Gender | Gender of the teams involved in the game | Text. | No |
| System | Number of referees requested for the game | Numeric or text. Incoming values will be mapped to existing systems of control. | Yes |
| Comments | Comments associated with the game | Text | No |
Referee Assistant will match imported values to existing values for the following columns:
Field
Game Type
League
Home/Away (teams)
Age Group
If an pre-existing value is not found in Referee Assistant, the value will be added to the appropriate screen. For example, if Referee Assistant finds that you are importing a game with a Game Type of "U-23B", and there is not an existing game type called U-23B, U-23B will be created as a new Age Group.