Timetable: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
When preparing the timetable for upload, remember to do the following: | 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<br> | |||
Delete all columns to the right of the last populated column of the spreadsheet<br> | - 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 | - The uploaded file needs to be UTF-8 encoded. | ||
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<br> | 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<br> | ||
https://canoesprint.britishcanoeing.org.uk/import/offline/default/10 | https://canoesprint.britishcanoeing.org.uk/import/offline/default/10<br> | ||
<br> | |||
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. | 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. | ||
Revision as of 15:06, 2 April 2023
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