Section 11 - Active Gaming Circuits |
| | | | ID
| | | Circuit
| | | | Season
| | | | Games
| |
| Section 11 |
| |
| |
| Section 11 / Area K |
| |
| |
| Section 11 / Area Q |
| |
| |
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.
Instructions and Sample File - TEAMS |
Columns of Data - NO Commas IN ANY VALUES
Column | Header | Description |
A | Circuit | Circuit Name - Region-Year-Program
Examples: S11-13-Fall , A11L-13-Fall , R889-13-Fall |
B | Type | Circuit Type
Examples: Section, Area, Region |
C | Area | Area Name
Examples: L , E , K , Q |
D | Region | Region Name
Examples: R889 , R84 , R111 , R1455, R85 , R86 , R87 , R630 , R1422, R41 |
E | Division | Division
Examples: GU08 , GU09 , GU10, BU08, BU10, BU12 |
F | Flight | Flight ID
Examples: 1, 2 , 3 , 4 , 5 |
G | Pool | Pool ID
Examples: A , B , C , D , E |
H | Team ID
Use correct format !! | Team ID - AreaRegion-LastName_FirstInitial
Example: L889-Dlugos_R |
I | Coach AYSO ID | Coach AYSO ID |
J | Coach First Name | Coach First Name |
K | Coach Last Name | Coach Last Name |
L | Coach Email | Coach Email |
M | Coach Phone | Coach Phone |
N | Asst Coach AYSO ID | Asst Coach AYSO ID |
O | Asst. Coach First Name | Asst. Coach First Name |
P | Asst. Coach Last Name | Asst. Coach Last Name |
Q | Asst. Coach Email | Asst. Coach Email |
R | Asst. Coach Phone | Asst. Coach Phone |
Teams-Import-Sample.xlsx
Instructions and Sample File - FIELDS |
Fields are managed directly from within the MatchTrak administration area. You will need to create these directly on the website. Your field names must match the field names provided in the games spreadsheet in order for map links to work properly.
Instructions and Sample File - GAMES |
Columns of Data - NO Commas IN ANY VALUES
Column | Header | Description |
A | Circuit | Circuit Name - Region-Year-Program
Examples: S11-13-Fall , A11L-13-Fall , R889-13-Fall |
B | Type | Circuit Type
Examples: Section, Area, Region |
C | Division | Division
Examples: GU08 , GU09 , GU10, BU08, BU10, BU12 |
D | Flight | Flight ID
Examples: 1, 2 , 3 , 4 , 5 |
E | Pool | Pool ID
Examples: A , B , C , D , E |
F | Team ID (Home)
Use correct format !! | Team ID - AreaRegion-LastName_FirstInitial
Example: L889-Dlugos_R
Note: This must match one of the Team ID from the game import file. |
G | Team ID (Away)
Use correct format !! | Team ID - AreaRegion-LastName_FirstInitial
Example: L889-Dlugos_R
Note: This must match one of the Team ID from the game import file. |
H | Park/Field
Must use a field in matchtrak. If it's not there you must first create it! | Game Park / Field
Note: This must match the park / field name in MatchTrak.
http://www.matchtrak.com/11/main.nsf/fields-byregion?openview&count=50 |
I | Date | Game Date
Format: 9/1/2013 |
J | Time | Game Time
Format: 9:00AM , 6:30 PM |
K | HomeLock | Would you like to prevent refs from other regions reserving this game?
Options: Y , N |
L | Restricted | Would you like to prevent refs to reserving this game?
Options: Y , N
Note: You will need to set this to Y for U5-U7 games typically !! |
M | 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 !! |
Games-Import-Sample.xlsx
Instructions and Sample File - REFEREES |
Columns of Data - NO Commas IN ANY VALUES
Column | Header | Description |
A | Last Name | Referee Last Name |
B | First Name | Referee First Name |
C | AYSO ID | Referee AYSO ID
Example: 1234567 |
D | Email Address | Referee Email Address |
E | Phone (not required) | Referee Phone Number |
F | Area | Referee Area
Example: L, Z, K, E, Q |
G | Region | What Region is the referee from?
Example: R889, Q96, K117 |
H | Youth | Is this a youth referee?
Options: Yes , No |
I | Safe Haven | Have you confirmed they are save haven?
Options: Yes , No |
J | Mentor | Can this referee mentor games?
Options: Yes , No |
K | Highest Cert | What is the highest level of certification this referee has?
Options: U08, Regional, Intermediate, Advanced, National, National 2 |
L | Area&Section-Level-Boys | What is the highest division they can CENTER on AREA & SECTION Extra boys games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
M | Area&Section-Level-Girls | What is the highest division they can CENTER on AREA & SECTION Extra girls games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
N | Area&Section-Level-AR | What is the highest division they can AR on all AREA & SECTION Extra games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
O | Region-Level-Boys | What is the highest division they can CENTER on regional boys games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
P | Region-Level-Girls | What is the highest division they can CENTER on regional girls games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
Q | Region-Level-AR | What is the highest division they can AR on all regional games?
Options: N/A, U08 , U10, U08, U10, U12, U14, U16, U19 |
Referees-Import-Sample.xlsx |