Timetable: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Download the data file first and deliver to Cathy as an Excel file | |||
Identify events to merge | |||
Merge events in the system | |||
Re-run the data file | |||
Colour up to differentiate events | |||
When preparing the timetable for upload, remember to do the following: | When preparing the timetable for upload, remember to do the following: | ||
Revision as of 21:25, 17 April 2018
Download the data file first and deliver to Cathy as an Excel file Identify events to merge Merge events in the system Re-run the data file Colour up to differentiate events
When preparing the timetable for upload, remember to do the following:
Delete all columns to the right of the last populated column of the spreadsheet
Delete all rows below the last populated column of the spreadsheet
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc
Replace 2000 with 200 in Events
Replace 5000 with 500 in Events
Replace , with ; in the CSV file
Update date format to yyyy-mm-dd
After selecting 'Import timetable / startlist' remember to change event code to correct number in URL
Work through each error one by one, generally they relate to a difference between the Event name [Discipline] stated on the upload file compared to the Event name in the system. Correcting the latter allows you to progress. The error codes state the line number on the CSB file.