New: League Schedule - Export/Import using Excel

For Section League Coordinators ONLY: A new setting has been created at the section level to allow schedules to be exported via excel by league and/or flight. You can change the settings by clicking on the league section name within the league tree . The league settings will pop up on the right and reflect the below options. Make sure to select the option you want, then Save. 



League Coordinators now have the option to maintain their schedules in Excel and import/export them by clicking the Import/Export button in the League New Scheduler area. Please follow the below steps on how to do so. 

To export a league schedule:

The Section Admin must have set the option to allow the schedules to be exported by League, Flight or “Either League or Flight”. All of the scheduled flights or sub-flights in the League will be exported, if no errors.

Note: To export, a flight schedule(s) they must already be generated (does not have to be published).

1. Navigate into League Tree
2. Drill down to desired league
3. Right click on league or (sub)flight
4. Select League New Scheduler (at league level) or New Flight Scheduler (at flight level)
5. Click Match Listings tab
6. Click Excel Import/Export Schedule
7. Click Export Schedule to Excel

The Messages section will give you league/flight info regarding what can and cannot be exported (the below screenshot is exporting at the League level, so it lists all flights with the specific league).

 

To import league schedule:

 Note: If the schedule is already published, you will have to delete the schedule, generate and export it again before exporting it and making any schedule changes in the export file. Then import the file. 

1. Follow the above steps 1-5
2. Under Import Excel Schedules, click Choose File 
3. Select Browse
4. Locate excel file
5. Click Upload File

If there are errors in the import file, a new excel file will be generated indicating the specific errors. 



Notes:

• If there are errors in the import file, you only have to reimport the matches that were in the error file. Make sure the errors are corrected prior to reimporting.
• Do not change any data in row 1 when importing the file back into the league tree. 
• If you type 'Yes' in the Delete column and import, the match will be deleted. 
• File must be in .CSV format to import.
• You can type TBA in the facility column for a match if the facility is not yet established, and you must also enter "0" for the facility ID.
• if you change the team to another team in the same flight, you must change both the Team name and Team ID