Generating a lookup file for runners

From SI-Droid Wiki
Revision as of 21:38, 7 November 2017 by Johan (Talk | contribs)

Jump to: navigation, search

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

Excel example.PNG

When all runners have been enters, save the file with "Save as", "Other formats"

Excel save as.PNG

In the final dialog, select "CSV file" as the format and choose a name

Excel csv.PNG

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).
  • Copy&paste the following URL into your browser and replace the competition number with your own number
    http://www.joja.se/sidroid/cardsFile/20561
  • Press Enter to visit that URL and you should be given the option to open or save a text file with all the runners for the event.

Hint: If you visit the URL via a browser on your mobile device, you can download the file directly to your device without going through a computer.

Retrieved from "http://www.joja.se/index.php?title=Generating_a_lookup_file_for_runners&oldid=159"