Importing Data from Sporti

This document describes how you can import participants' data collected with Sporti into IceTestNG.

Requirements

The following data need to exist in IceTestNG before importing a Sporti file:

How to import data

Sporti files can be imported by opening the Setup - Competitions page and selecting the competition you want to import the Sporti data into:

  1. Go to the Import Data tab.
  2. Select the Sporti file from your computer. See how to generate it properly
  3. Set the column delimiter to tab.
  4. Adjust the further import settings if needed.
  5. Click the Import Data button to start the import

Recognized column titels

IceTestNG will recognize these column titels in the import file:

Column in CSV Entity in NG Column in NG Example
STA participant start number 1
FEIFID horse FEIF-ID NO2010108055
name_horse horse name of horse Þokki frá Árgerði
rider person full name Jane Doe
birthday_horse horse date of birth 2010-7-20
owner horse horse owner Jane Doe
breeder horse horse breeder John Doe
color horse color Chestnut
marking horse marking Star
country_horse horse country of origin NO
f horse sire Þokki frá Bjarnanesi
ff horse father's father Stormur frá Bjarnanesi
fm horse father's mother Gláma frá Eyjarhólum
m horse dam Nös frá Árgerði
mf horse mother's father Feykir frá Hafsteinsstöðum
mm horse mother's mother Irpa frá Árgerði
sex_horse horse gender Stallion
microchip horse microchip 352206000045XXX
name_first person first name Jane
name_last person last name Doe
birthday person date of birth 1986-6-23
city person city Vienna
mobile person mobile +1234567890
phonemobile person mobile +1234567890
email person email hello@gmail.com
team participant team Tölty Tölters
club participant club Katla
class participant age class Senior
stable participant stabling option Box

Column titles not mentioned in the table above will be treated as test codes.

Only the bold columns are required, all others are optional.

Post import operations

IceTestNG will try to match all FEIF-IDs against WorldFengur after import. If the FEIF-ID is known to WorldFengur, the horse data will be used in IceTestNG as well. The matching process can take some time and happens automatically in the background.

Export from Sporti

When exporting the file from Sporti, make sure the settings are as seen below:

You need to convert the resulting xls-file to a UTF-8 comma separated file by opening it in Excel and pressing Save as or Export.

Defining the tests properly

You need to make sure that the test columns in the CSV match the test codes in IceTestNG:

If you have multiple instances of a test, e.g. T8.s and T8.j, you can edit the testcode by pressing the pen icon. When a test has been assigned a new testcode, it will reappear in the list, and you can drag it into your event again.

Defining age classes

If you want IceTestNG to assign age classes, you need to define them for your event first:

And set the switch to on in the import settings:

If you get an error

If IceTestNG reports that it could not recognise column or test name, first make sure you defined the test properly. If the column is safe to skip, you can try to copy the columns names suggestion into the field "Skip columns in file”