Timetable: Difference between revisions
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
Delete all rows below the last populated column of the spreadsheet<br> | Delete all rows below the last populated column of the spreadsheet<br> | ||
Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br> | Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br> | ||
Replace , with ; in the CSV file<br> | Replace , with ; in the CSV file<br> | ||
Update date format to yyyy-mm-dd | Update date format to yyyy-mm-dd | ||
Revision as of 18:33, 25 June 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 , 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.