canoesprint-wiki - User contributions [en]

Start Lists

2022-06-19T21:04:48Z

162.158.159.117:

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.

Start Lists

2022-04-27T20:48:40Z

162.158.159.117:

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.

Timetable

2022-04-27T20:48:25Z

162.158.159.117:

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 
<code>;;;;V;2021-09-04;08:00;;;Course Open</code> 
<code>;;;;V;2021-09-04;08:15;;;Start Gate Practice at 200m Start</code> 
<code>;;;;V;2021-09-04;08:45;;;Course Cleared</code>