MatchTrak
AYSO Section 11
Game Scheduling and Referee System




Data Importing Details

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.xlsxTeams-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.xlsxGames-Import-Sample.xlsx




Server: Sinistar / Anonymous

$$WebClient - [Anonymous]