Timetable: Difference between revisions
Created page with "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 t..." |
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 | 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 | 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 | Replace long hyphens with short hyphens, but not in - R1, - R2, Paddle-Ability - Saturday, Paddle-Ability - Sunday, Canoe A-D - Mixed etc<br> | ||
Replace 2000 with 200 in Events | Replace 2000 with 200 in Events<br> | ||
Replace 5000 with 500 in Events | Replace 5000 with 500 in Events<br> | ||
Replace , with ; in the CSV file | Replace , with ; in the CSV file<br> | ||
After selecting 'Import timetable / startlist' remember to change event code to correct number in URL | After selecting 'Import timetable / startlist' remember to change event code to correct number in URL<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 21:24, 5 April 2018
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 2000 with 200 in Events
Replace 5000 with 500 in Events
Replace , with ; in the CSV file
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.