Difference between revisions of "Generating a lookup file for runners"
| Line 9: | Line 9: | ||
* Third column - The club the runner belongs to (optional) | * Third column - The club the runner belongs to (optional) | ||
| − | Between each column there must be either a comma (,) or a semicolon (;) | + | Between each column there must be either a comma (,) or a semicolon (;). Any rows that doesn't start with numbers are ignored |
| − | Any rows that doesn't start with numbers are ignored | + | |
A valid example of such a file: | A valid example of such a file: | ||
Revision as of 20:59, 7 November 2017
One of the ways SI-Droid Event can find the name and club of finishing runners is to read it from a file located on the mobile device.
You can prepare the file by yourself (e.g. by using Excel or Notepad) and import it into the app. The easiest way to transfer the file from your computer to the device is probably through a Cloud service such as Dropbox, Google Drive or Microsoft OneDrive. It is of course also possible to use e.g a USB cabel or Bluetooth to transfer the file.
The file must have one row for each runner with the following format:
- First column - The number of the card
- Second column - Name of the runner (both surname and last name)
- Third column - The club the runner belongs to (optional)
Between each column there must be either a comma (,) or a semicolon (;). Any rows that doesn't start with numbers are ignored
A valid example of such a file:
SI Number, Name, Club (this row is ignored) 681010, Johan Jacobsson, OK Orion 12345, Andersson Sven 3333333; Pelle Gustafsson; Klubben IK
Create file using Excel
The easiest way to create your own file like this is probably to use Excel.
Start Excel and start to type in the runners, one on each row, like this
When all runners have been enters, save the file with "Save as", "Other formats"
In the final dialog, select "CSV file" as the format and choose a name
Auto generate file from Swedish Eventor
If the runners are entering your event via Swedish Eventor then there is a very simple way to generate the file with all runners.
- Start with finding out which competition number your event has in Eventor. You can clearly see the number in the URL when you are visiting the competition page, e.g. https://eventor.orientering.se/Events/Show/20561 (in this case the number is 20561).
- Take the following URL, enter it in your browser and replace the competition number with your own number
http://www.joja.se/sidroid/cardsFile/20561 - When you visit that URL you should be given the option to open or save a text file with all the runners for the event.
