SLALOM NEW ZEALAND - RACE ORGANISERS
This page contains a number of IT resources for race organisers.
If you are a keen developer there is also information on how you
can interface your result processing applications or spreadsheets
into the slalomnz web site.
Microsoft Excel Templates
Below is a link
to an Excel template that can be used to upload race results to the web server.
After using the spreadsheet your results will be immediately visible
on the web site.
The spreadsheet require the
user to have a results administration password. This type of password
can be applied for after you sign up with a normal web account
and will only be given to individuals approved by the slalom
committee. NOTE: For security reasons all IP addresses are logged
when using the results upload interface. If you don't have a results
administration password then you can simply email the results
to results@slalomnz.org.nz and one of the administrators will upload the results
for you.
Download Results Template
The Results Process
1. On the morning of the race download the startlist
from the web site. (XsnCalendar > Startlist). Choose the CSV option
and save the file to your local machine. This file should automatically
open in Excel and will have competitor names and the categories
they have registered for.
2. On completion of the race verify that all
results that you have entered are correct and full competitor
names are used ie no nicknames
3. If you don't have a results administration
password email the Excel spreadsheet to results@slalomnz.org.nz.If
you do have a password then follow the steps below.
4. Click on the WebResults tab in the Excel
spreadsheet. This should be automatically filled with the results
from the results sheet.
5. Verify that all fields are filled eg If a
competitor has no penalties for a run 0 should be entered not
a blank cell.
6. Click on the Upload Results button and logon
with your normal web username and password.
7. If your logon is successful a Race and Results
tab will be displayed
8. Click on the Results tab and verify that
your race is in the list. If it isn't in the list you can enter
the race details via the Race tab.
9. Select the race for which you will be uploading
the results for.
10. Select a category from the combo box and
enter the row index where the category starts and finishes. The
below example shows the user uploading K1 Under 16 Men results
for the Buller Festival. The category starts at 4 and finishes
at 6. When all the correct information is entered click Upload.
11. Repeat step 10 for all categories in the
race.
12. If you find that you have made a mistake
you can remove results by selecting the correct race and category
and clicking Delete. This will delete the results for the selected
category. You can then re-upload the category results.
For Developers
The slalomnz web server supports two interfaces.
1. XMLHTTP
2. WebServices
Both interfaces support the same methods and what one you choose
largely depends on the client application. If you would like to
develop a timing application that interacts with the web
site or even another spreadsheet, just send a message through
the contact page and I will send the relevant xsd schemas and
other supporting documentation.
|