Teams and games can be imported into Matchtrak by completing various Excel spreadsheets and then sending them to me for import. When you are done with the files please include your region name in the file names themselves so I can identify them better.
It's extremely important that all the data is 100% perfect in the spreadsheets before sending them to me.
TEAM AND GAME FILES BOTH REQUIRED !!
TEAMS - Instructions and Sample File |
Columns of Data
Column |
Required |
Header |
Description |
A |
Yes |
Circuit |
Circuit Name - Section Area Region - Year - Season
Example: Section "11" Area "L" Region "889" would be "S11L889-14-Fall"
Example: Section "11" Area "Q" Region "120" would be "S11Q120-14-Fall"
Example: Section "10" Area "Q" Region "741" would be "S10Q741-14-Fall" |
B |
Yes |
Type |
Circuit Type
Examples: Section, Area, Region |
C |
Yes |
Owner Section |
Owner's Section Name - Used for Security Access
Examples: 1, 10, 11 |
D |
|
Owner Area |
Owner's Area Name - Used for Security Access
Examples: L , E , K , Q |
E |
|
Owner Region |
Owner's Region Name - Used for Security Access
Examples: R889 , R84 , R111 , R1455, R85 , R86 , R87 , R630 , R1422, R41 |
F |
Yes |
Team Section |
Team's Section Name
Examples: 1, 10, 11 |
G |
Yes |
Team Area |
Team's Area Name
Examples: L , E , K , Q |
H |
Yes |
Team Region |
Team's Region Name
Examples: R889 , R84 , R111 , R1455, R85 , R86 , R87 , R630 , R1422, R41 |
I |
Yes |
Division |
Division
Examples: GU08 , GU09 , GU10, BU08, BU10, BU12 |
J |
Yes |
Flight |
Flight ID
Examples: 1, 2 , 3 , 4 , 5 |
K |
Yes |
Group |
Group ID
Examples: A , B , C , Seeding , Medal , North, South |
L |
Yes |
Team ID
Use correct format !! |
Team ID - Area+Region-LastName_FirstInitial
Example: L889-Dlugos_R
Area L , Region 889 , Coach is Robert Dlugos |
M |
|
Team Name |
Team Name |
N |
Yes |
Coach First Name |
Coach First Name |
O |
Yes |
Coach Last Name |
Coach Last Name |
P |
Yes |
Coach Email |
Coach Email |
Q |
|
Coach Phone |
Coach Phone |
R |
|
Asst Coach First Name |
Asst. Coach First Name |
S |
|
Asst Coach Last Name |
Asst. Coach Last Name |
T |
|
Asst Coach Email |
Asst. Coach Email |
U |
|
Asst Coach Phone |
Asst. Coach Phone |
Teams-Import-Sample.xlsx
Note: Standings are determined by separate Divisions + Flights + Groups
GAMES - Instructions and Sample File |
Columns of Data
Please make sure that the Field IDs match the ones already in Matchtrak. This really adds a ton of extra administration time for me if not done right.
Column |
Required |
Header |
Description |
A |
Yes |
Circuit |
Circuit Name - Section Area Region - Year - Season
Example: Section "11" Area "L" Region "889" would be "S11L889-15-Fall"
Example: Section "11" Area "Q" Region "120" would be "S11Q120-15-Fall"
Example: Section "10" Area "Q" Region "741" would be "S10Q741-15-Fall" |
B |
Yes |
Division |
Division
Examples: GU08 , GU09 , GU10, BU08, BU10, BU12 |
C |
Yes |
Game Type |
Game Type
Examples: Seeding, Friendly, Medal |
D |
Yes |
Home Team ID |
Team ID - AreaRegion-LastName_FirstInitial
Example: L889-Dlugos_R
Note: This must match one of the Team ID from the game import file. |
E |
Yes |
Away Team ID
Use #BYE for Bye Games |
Team ID - AreaRegion-LastName_FirstInitial
Example: L889-Dlugos_R
Note: This must match one of the Team ID from the game import file. |
F |
Yes |
Park Field ID
Use #BYE for Bye Games |
Venue & Field #
Example: L889-Foxborough 3 ( Foxborough 3 located in Region 889 - Area L )
Note: This must match the Field ID in MatchTrak !! Double check your fields first here. Add new ones if needed
http://www.matchtrak.com/11/main.nsf/fields-AllAdmin-fields-bySAR?openview&count=500&ExpandView |
G |
Yes |
Date |
Game Date
Format: 09/01/2013 |
H |
Yes |
Time |
Game Time
Format: 9:00 AM , 6:30 PM |
I |
Yes |
HomeLock |
Would you like to prevent refs from other regions reserving this game?
Options: Y , N |
J |
Yes |
Restricted |
Would you like to prevent/block refs from reserving this game?
Options: Y , N
Note: You will need to set this to Y for U5-U7 games typically !! |
K |
Yes |
Report Score |
Would you like a score to be reported for this game?
Options: Y , N
Note: You will need to set this to N for U5-U8 games typically !! |
L |
Yes |
Update Standings |
Would you like the score reported to update the standings?
Options: Y , N |
M |
|
Responsible Team
CENTER |
Optional - Enter Team ID responsible for CENTER covering this game
Note: Must match a Team ID in the team file !! |
N |
|
Responsible Team
AR #1 |
Optional - Enter Team ID responsible for AR1 covering this game
Note: Must match a Team ID in the team file !! |
O |
|
Responsible Team
AR #2 |
Optional - Enter Team ID responsible for AR2 covering this game
Note: Must match a Team ID in the team file !! |
P |
|
Referee |
Optional - Enter Referee Name (Last, First) |
Q |
|
Referee Credit Team |
Optional - Enter Team ID that should get credit for this game followed by the team ( Division )
Example: L889-Dlugos_R (GU14) |
R |
|
AR1 |
Optional - Enter Referee Name (Last, First) |
S |
|
AR1 Credit Team |
Optional - Enter Team ID that should get credit for this game followed by the team ( Division )
Example: L889-Dlugos_R (GU14) |
T |
|
AR2 |
Optional - Enter Referee Name (Last, First) |
U |
|
AR2 Credit Team |
Optional - Enter Team ID that should get credit for this game followed by the team ( Division )
Example: L889-Dlugos_R (GU14) |
Games-Import-Sample.xlsx |