Importing a Schedule from another program

About 30% of our tournaments use their own scheduling systems and we import their schedule in for them. It keeps everyone where they are comfortable. It just needs to be in the format of the XLS sheet attached which has really basic info. Most systems can export this info easily…

You should do everything in the Scheduling Dashboard except for the actual scheduling.

A few rules:
a. No additional info than is asked for. Don’t include team name, coach name.. etc. The TEAM ID (first number in your team export file — attached) will pick that up. Team 1 is the home team ID, Team 2 is the Visitor team ID.. even FINAL games should have team numbers from placeholders (Winner A, Winner B.. see team file)
b. There is NO ERROR CHECKING on import. You re expected to resolve all errors BEFORE the file over.
c. Make sure date field is date format, time filed is time format.. NOT TEXT.
d. Divisons, field codes and venues should be EXACTLY as they appear in your system. BU13WHITE or even BU13_WHITE is NOT the same as BU13_White. Case matters.
e. Once imported, all changes must be made using our editing tools on the site. We will not re-import the file. So, it is always best to hold the schedule as long as you can to make sure it is exactly as you want it. I only takes us about 3 minutes to import, assuming no errors on c and d. (we’ll send it back…)

If the team import is done properly and/or the setup is done carefully, these rules should not be an issue.. most problems are created by simple typos on setup…

Sample Schedule Export File (XLS)