Start Lists: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
When importing the Start Lists in csv format into Excel, remember to add the suffix to the first line of csv file with 12 semi-colons | |||
;;;;;;;;;;;; | |||
this allows all the C4 and K4 paddler records to be imported to Excel | |||
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd | |||
When preparing the start list file for upload, remember to do the following: | When preparing the start list file for upload, remember to do the following: | ||
Revision as of 21:04, 19 June 2022
When importing the Start Lists in csv format into Excel, remember to add the suffix to the first line of csv file with 12 semi-colons
this allows all the C4 and K4 paddler records to be imported to Excel
Also set the import encoding to UTF-8 and update date format to yyyy-mm-dd
When preparing the start list file 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<be>
The uploaded file needs to be UTF-8 encoded.
After selecting 'Import timetable / startlist' remember to change event code to correct number in the URL
Once the Start List has been completed, you can generate a print out using the following URL with the last number changed to the regatta number. Make sure that the PDF is output to A4 not US A4.
https://canoesprint.britishcanoeing.org.uk/public/default/startlist-print/3
Once signed off, check the following: - races have correct categorization, e.g. National Championship, Selection, Paddle-Ability etc - races have correct distances set, e.g. 5000 > 500 and 2000 > 200 - races have correct naming, e.g. V1 not C1 for Va'a events
Paddlers with disabilities or special needs
We occasionally receive requests for paddlers to race in specific lanes, e.g. for hearing or sight impairment, or anxiety. We endeavour to support these requests if they are known about prior to timetabling and the preparation of the Start Lists.