Timetable

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

The uploaded file needs to be UTF-8 encoded.

After selecting 'Import timetable / startlist' remember to change event code to correct number in URL, e.g. change from 10 to whatever the competition number is
https://canoesprint.britishcanoeing.org.uk/import/offline/default/10

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.

For non-event entries in the timetable, use the following syntax

;;;;V;2021-09-04;08:00;;;Course Open
;;;;V;2021-09-04;08:15;;;Start Gate Practice at 200m Start
;;;;V;2021-09-04;08:45;;;Course Cleared