Contents
1. Preparing the CSV file
When the CSV file is ready:
- In the side menu of the race, click on “Rankings”.
- Select the event from those displayed.
2. Uploading the file
- In “Select file to import”, choose your CSV file. Select the file type (separated by commas, semicolons or tabs) and the character set.
If you use Microsoft Excel in Spain, the delimiter will be a semicolon and you must choose the ISO-8859-1 (WINDOWS) character set. If you saved the file as CSV UTF-8, choose UTF-8. - Make sure the “Header” checkbox is checked if your CSV contains the labels in the first line; this needs to be prepared in advance, before exporting the CSV.
- Check the “Save existing data” checkbox if you are uploading a CSV file to an event which you have already uploaded results to, and do not wish to delete the existing ones.
- Click “Upload and continue”.
3. Set up of splits
- On the next screen, check that the splits shown are correct. If a split is missing, you can add it by clicking on “+ Add another split”. Clicking on the split will open a window that allows you to edit and even delete it.
You don’t need to create the splits beforehand: they are created from the headers of the CSV file. If you have already created them, check that their names match those in the file; otherwise, the results for that split will not be associated correctly.
- Click “Continue”.
4. Association of fields
- On the next screen, check that the fields contained in the document are green, which means that the association has been made correctly. The following fields must be present for the results to be published: “Name”, “Bib”, “Pos” (position) and “Tofficial” (official time).
- Click on “Import”.
The panel shows how many entries have been saved and how many have failed. Click “Return”: in the list of events, the Counter column shows the number of finishers in each event, and Last updated, the date and time of the last upload.
5. After uploading the results
Once the event has results, its Rankings screen shows these options. All of them ask for confirmation first.
- Send push: if the race is in an app, it sends all the app users a notification with a predefined text saying that the race results are available.
- Send emails: if the file included the participants’ email addresses, it sends them an email with the same message.
- Regenerate ranking: it redoes the Sportmaniacs calculations, such as the average speed. Use it if you change the distance of a split or another split option after uploading the results.
- Delete ranking: it deletes the results of the event.
In the Upload attached files block, the Upload attachment button lets you add results as a PDF file, with a name.
The Import from Live button, which appears while the event has no results yet, belongs to an old version of live timing.
6. FAQs
How do I show the average speed of each split?
To show the average speed of each split, you must edit them in “Set up of splits”.
- Click on the name of the split.
- In the pop-up window, fill in the field “Distance from start in kilometres (KM)”.
- Click “Save”.
How do I show the timing points for swim, bike and run in a triathlon?
To show the swim, bike and run points in a triathlon, you must edit the splits in “Set up of splits”. This option only appears if the event type is Triathlon, Duathlon or Aquathlon (Edit event › Race type).
- Click on the name of the split.
- In the pop-up window, check the box “Main triathlon, aquathlon, duathlon Split?”.
- Complete “Split distance” and “Average type” (swimming, bicycle or running) if you also want the average speed of each point to be displayed.
- Click “Save”.
What do I do if, in the field association step, some fields appear in red?
If the field that appears in red is not critical, you can ignore it and continue. If it is a necessary field, you must make sure to associate it correctly. The most common issue is that the name you have used in the label of the header does not correspond to any of the labels defined in Sportmaniacs. For example, “Tofical” instead of “Tofficial”.
- Click the dropdown on the right of the field displaying in red.
- If any of the fields that appear corresponds to the one you need, choose it.
- If it is a field related to a split (position, time or time of day), select “Add Split” in the dropdown. This will open a second and third dropdown.
- In the second dropdown, choose the split that the field information is associated with.
- In the third dropdown, choose the data you want to show.
- Click “Import”.
Comments
Please sign in to leave a comment.