Appearance
Import File Format
The import file may either be a Microsoft Excel file (.xlsx or .xls) or a CSV (Comma Separated Values) file.
The columns in the file are described below:
DIVISION, DATE, TIME, FIELDNAME, TEAM1, TEAM2, PUBLISH, GAMETYPE
Where
DIVISION is the name of the division
DATE is the date of the game in format MM/DD/YY or YYYY-MM-DD
TIME is the time of the game in format HH:MM
FIELDNAME is the name of the field (must match what was created in the Manage Fields section)
TEAM1 is the name of the home team. TEAM1 must be in the division in order for the system to be able to find the team. In the event you want to do a cross-division type of game you may use the team number instead of the name (e.g. 35010). Team numbers can be found by looking at the team registration page.
TEAM2 is the name of the visiting team. TEAM2 must be in the division in order for the system to be able to find the team. In the event you want to do a cross-division type of game you may use the team number instead of the name (e.g. 35010). Team numbers can be found by looking at the team registration page.
PUBLISH is 0 or 1 where 1 signifies to publish the game so it is publicly viewable.
GAMETYPE is pool, semi or final where pool signifies a league/pool game, quarter is a quarterfinal game, semi is semifinal game, final a final game, friendly is a friendly game, and consolation is a consolation game.
Note: PUBLISH and GAMETYPE may optionally be left off and thus will be defaulted to 1 for PUBLISH and pool for GAMETYPE.
Note: To input a quarter-final, semi-final, final game, friendly, consolation, or to input an unknown team, TEAM1 or TEAM2 may optionally be one of:
TBD
1st A, 2nd A, 3rd A, 4th A, 5th A, 6th A, 7th A, 8th A
1st B, 2nd B, 3rd B, 4th B, 5th B, 6th B, 7th B, 8th B
1st C, 2nd C, 3rd C, 4th C, 5th C, 6th C, 7th C, 8th C
1st D, 2nd D, 3rd D, 4th D, 5th D, 6th D, 7th D, 8th D
Wildcard
Winner Quarter 1
Winner Quarter 2
Winner Quarter 3
Winner Quarter 4
Winner Semi 1
Winner Semi 2
Loser Semi 1
Loser Semi 2
Loser Quarter 1
Loser Quarter 2
Pool Winner with Most Points
Pool Winner with 2nd Most Points
Pool Winner with 3rd Most Points
Pool Winner with 4th Most Points
Winner Pool A
Winner Pool B
Winner Pool C
Winner Pool D
Winner Pool E
Winner Pool F
Winner Pool G
Winner Pool H
An Excel file example is below:
Note: there should not be a header row in the import file. Notice the double forward slash marks in the unwanted rows. The double slash comments out those rows and they are not read during the import.
A csv file example is below:
U9/10 Coed,10/22/2011,10:00 AM,2,TOCA FC,Butterfly's
U9/10 Coed,10/22/2011,10:30 AM,1,K.C.U.Shark Attack,Toca FC U9 MLS 1
U9/10 Coed,10/22/2011,11:00 AM,1,K.C United Brass,Toca FC U9 MLS 2
U9/10 Coed,10/22/2011,12:00 PM,1,Toca FC U9 MLS 2,K.C.U.Shark Attack
U9/10 Coed,10/22/2011,12:30 PM,1,TOCA FC,Toca FC U9 MLS 1
U9/10 Coed,10/22/2011,12:30 PM,2,K.C United Brass,Butterfly's
U9/10 Coed,10/22/2011,1:30 PM,2,K.C.U.Shark Attack,TOCA FC
U9/10 Coed,10/22/2011,1:30 PM,1,Butterfly's,Toca FC U9 MLS 2
U9/10 Coed,10/22/2011,2:00 PM,2,Toca FC U9 MLS 1,K.C United Brass
U9/10 Coed,10/22/2011,3:00 PM,2,1st A,1st B,1,final