Difference between revisions of "Generating a lookup file for runners"

Revision as of 20:49, 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 (;)

A valid example of such a file:

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 have in Eventor. It is clearly shown 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 edit or save a text file with all runners for the event.