The new sports seasons is just around the corner and it’s time to get your league schedules up. Here are 5 simple steps on how to get your leagues scheduling up and running.
1) Update all your teams in your divisions:
Make sure that all the teams are created in each division and are current. To create/edit teams in each division you’ll want to go to the Settings/Team Management area.
2) Prep your CSV file in Excel:
Once all teams have been updated in all your divisions you can then start creating a CSV file: Here’s how you should format your CSV file:
In your CSV, you’ll essentially have 5 Columns:
- Home Team
- Away Team
One thing to be sure of is that all teams in your CSV appear exactly the same as they do on your list of teams in each division. This will ensure that when you import your CSV file, all teams will be imported correctly.
3) Format the Date and Time Columns
Before importing your CSV file into TeamPages scheduler, be sure to format the date and time columns. To format a column, simply select the column header, right click on a cell and select Format Cells.
The date column format
The time column format
4) Prep your location list
Be sure that the locations for your league games are updated in your location list.
If you have a master list of locations along with addresses that you want uploaded on your entire league site, you can send them over to your TeamPages Account Manager and he/she will have it uploaded for you.
You’ll also want to be sure that the locations in your CSV also appear exactly the same was as they do on your location list in TeamPages to ensure upload successfully.
5) Import your CSV file:
Before uploading your CSV file, make sure that in excel you save the file as a CSV (Comma Delimited). Once it’s saved in proper CSV format, you’re ready to import your CSV file into the league scheduler. You’ll need to define your CSV columns, i.e. home teams are assigned to column 1 etc..
And that’s it! If you see a nasty red check mark after the upload, chances are you may need to verify the format of one of your teams, locations, dates or times as mentioned above. Just double check for typos in the teams/locations fields.
Have a great season!
The TeamPages Fam.