Generating a lookup file for runners - Revision history

Johan: /* Auto generate file from Swedish Eventor */

2020-01-05T20:53:49Z

‎Auto generate file from Swedish Eventor

Johan at 20:51, 5 January 2020

2020-01-05T20:51:16Z

Johan: /* Auto generate file from Swedish Eventor */

2020-01-05T20:50:09Z

‎Auto generate file from Swedish Eventor

Johan at 20:46, 5 January 2020

2020-01-05T20:46:03Z

Johan: 10 revisions

2018-02-18T15:39:21Z

10 revisions

Johan at 21:19, 7 November 2017

2017-11-07T21:19:26Z

Johan: /* Auto generate file from Swedish Eventor */

2017-11-07T20:38:34Z

‎Auto generate file from Swedish Eventor

Johan at 19:59, 7 November 2017

2017-11-07T19:59:04Z

Johan at 19:58, 7 November 2017

2017-11-07T19:58:16Z

Johan at 19:55, 7 November 2017

2017-11-07T19:55:02Z

@@ Line 43: / Line 43: @@
 If the runners are entering your event via Swedish Eventor then there is a very simple way to generate the file with all runners.
 Note: The external id (i.e. EventorId) will not be part of the generated file since that data isn't available via Eventor without a login.
 * 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).

@@ Line 22: / Line 22: @@
   3333333; Pelle Gustafsson; Klubben IK
 , Kalle Kula, Klubben OK, 9999, Course A
 == Create file using Excel ==

← Older revision		Revision as of 20:50, 5 January 2020
Line 42:		Line 42:

	If the runners are entering your event via Swedish Eventor then there is a very simple way to generate the file with all runners.		If the runners are entering your event via Swedish Eventor then there is a very simple way to generate the file with all runners.
		+	Note: The external id (i.e. EventorId) will not be part of the generated file since that data isn't available via Eventor without a login.

	* 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).		* 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).

@@ Line 8: / Line 8: @@
 * 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
+Between each column there must be either a comma (,) or a semicolon (;). Any rows that doesn't start with numbers will be ignored
 A valid example of such a file:
-  SI Number, Name, Club (this row is ignored)
+  SI Number, Name, [Club], [Id], [Course] (this row is ignored)
-, Johan Jacobsson, OK Orion
+, Johan Jacobsson, OK Orion, 4619
 , Andersson Sven
   3333333; Pelle Gustafsson; Klubben IK
 == Create file using Excel ==

← Older revision		Revision as of 21:19, 7 November 2017
Line 43:		Line 43:

	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.		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.
		+
		+	== Import file into SI-Droid Event ==
		+
		+	When you have the file created and stored on the device, you also need to tell the app where it is located.
		+
		+	* Go into Settings in the app and choose "Lookup of Card owner".
		+	* There you first need to enable "Fetch owners from own file" so that the item "File with card owners" becomes clickable.
		+	* Click "File with card owners" to open the file selection dialog. (This dialog can look a bit different and contain different options depending on your Android version and the apps you have installed).
		+	* Navigate to your stored file and select it.<br>Note: If you transferred the file via cable, directly to the internal storage of the device, you might not see the file directly. In that case you have to tell the file chooser to also show the contents of the internal storage of the device. You do this by clicking on the three dots in the upper right corner and selecting "Show internal storage".
		+	* The dialog will close and a short note telling how many valid runners that was found will show on the screen.
		+
		+	[[File:Android filechooser1.png\|200px]] [[File:Android filechooser2.png\|200px]] [[File:Android filechooser3.png\|200px]]

← Older revision	Revision as of 15:39, 18 February 2018
(No difference)

@@ Line 39: / Line 39: @@
 * 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<br>http://www.joja.se/sidroid/cardsFile/20561
+* Copy&paste the following URL into your browser and replace the competition number with your own number<br>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.
+* 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.