Entries using FIS-list

Starting from Extime version 7.2.2 it is now possible to make entries into race using data from FIS. This data must contains following items

• FIS-code
• Forename
• Surname
• Combined name (if available)
• Sportclub
• FIS-points (even normal or sprint) to be used when define start order
• Country
• Birthdate (to find class automatically)
• Gender (to find class automatically)

The file is normally comma delimited file (like csv-files exported from Excel) and the field delimited can be TAB-character or any other visible character, normally semicolon (;). You can load your own copy from FIS-web-site (https://www.fis-ski.com/DB/cross-country/fis-points-lists.html). Just select correct list (normally 8 lists / season) and select the csv format (full list in CSV when cursor is over text csv).

After loading the csv-file (make folder FIS under c:\ExTime), you must tell ExTime the name and folder of newest file and which is the sequence of the columns in file. Sometimes FIS makes changes the columns, that's why you must define the column order fo ExTime.

To start making entries define first the classes to be used in the race or open the existing race file.

Starting ExTime version 8.4.8 it is also possible to use clipboard to move the FIS-codes from different Excel-sheets directly to ExTime. I made it to help my own work, when I made the startlist for Scandinavia Cup 6.-8.1.2017 in Lahti.

Menu Ilmoittautumiset contains new task, Entries using FIS-list.

[FISLIST]
Surname=I
Forename=J
Sex=L
Birthdate=N
Club=N
Country=K
FIScode=H
FISPoints=S
FISPointssprint=V
filename=I:\Tuotanto\ranki\2026_kausi\FIS\FIS-points-list-CC-2026-300196.csv
delimiter=,
text_start="
Sort=D
First=G
Fislist=1
missingpoints=999.00

FIS-entries window contains a special part Field sequence, where the data field sequences and delimited character are defined.

The definitons are automatically saved in the file extime.ini into section labelled [FISLIST].

When sequence of the fields and delimiter character are defined, you should Refresh the list to save the definitions into ExTime.ini-file.

By clicking some line, you can see the extracted data in separate fields in the area Competitors data. And if you later modify Field sequence attributes, refresh the parameters by clicking the Search button.

To start making entries of one country fill first the Country and Gender (if necessary) in the area Search criteria and click the Search-button. ExTime will list all found lines in the list box using defined sort field (dublicated beginning of each line) and shows the total amount. Country code must of course be same what FIS is using.

To make one entry into race use the following procedure:

1. Fill the country code and gender and press Search to get only one country on the list.
2. Scroll the competitor to be seen using vertical scroll bar. You can easily change the sorting order match the order of paper or email entries, see box in the area Sort field.
3. Click the line of the competitor.
4. Check the data in the area of Competitors data.
5. Check the assumed class and select correct one, if not OK.
6. Fill any missing data (starting number, FIS-Points, token numbers, draw group).
7. Correct names (if..).
8. Enter competitor into race (Enter-button). Note that starting number will change in drawing procedure.

Repeat the procedure for each competitor and country.

Surname and forename exist as separate fields, ExTime will concate those into one field, forename first of course.

At the beginning of season 2026 there are only 764 finnish records in FIS database, compared to season's 2019 905 records. Relay teams are included.

Sometimes (quite often) there is need to update FIS-points information before drawing. Some entries are made by hand, some by loading data from KILMO, but every competitor must have an active FIS-code to have FIS-points.

The updating procedure can be found in menu Muutokset, FIS:n tietojen käyttö, Piste- ja nimitietojen päivitys.

If the race contains also classes outside FIS-classes, it would be convient to eliminate those classes from updating procedure. This can be done using menu  Ajanotto, Rajaa aktiivisia sarjoja.

Check the classes you will eliminate from update and accept you choose by clicking Hyväksy valinta.

You can give default value for missing points, also it is possible to use those points (distance or sprint), which are better for each competitor. FIS rules says (team sprint):

"326.4.2.1 The better points of distance and sprint FIS points of a competitor will be used. In case the entered competitor does not have FIS Points, 999 points will be used for calculation."

ExTime makes a list not found competitors to the right. Also, if the name is not same as in FIS database, the line is inserted. FIS don't use scandinavian letters ÅÄÖ, also apostrophe (É) make differences.

You can correct that person by double clicking his/her line on list or you use FIS-database directly from ExTime.

If the athlete has FIS-code, you can copy the FIS-code to the box Code: by clicking his line (Petteri Laurén) on the black window.

By pressing button Search FIS WEBsite ExTime make a request to internet (door must be open) and fill the boxes Season and List and also shows distance and sprint points, birthdate and active status. You can also write the FIS code you will check manually to the box Code:.

By pressing button Update active status you can update his active status in ExTime. But you must insert/modify the points manually (just double click the black windows line to open the properties window of athlete).

If the athlete has no FIS-code, you must use the FIS-database by yourself using different search criteria.

To make starting order is very easy procedure. Before drawing you should set the classess same order in race file as they will start. Of course you must have current starting times and numbers (BIBs) to be used.

The drawing procedure can be found in menu Muutokset, FIS:n tietojen käyttö, Lähtöjärjestyksen laadinta.

• Previous Class, navigate to previous class in starting sequence.
• Next Class, navigate to next class in starting sequence. You can see the class full name as the window name and the short name on the select window left of Previous Class button. You can use that window also for the navigation.
• Update BIB and start time calculates the first BIB and start time of the selected class using previous classess last athletes information and given start interval (normally 30 sec) and amount of racers starting same time (normally 1) and empty slots (free BIBs) between classes.
• Smallest first, if checked, the smalles points are in the beginning. Must be checked in sprint race and unchecked in distance race.
• Use FIS-points, shows the BIBs and sorts the racers on left list after FIS-points
• Accept starting times, shows the racers, BIBs and their starting times on the rigth list. The first bib and start time of the class are given middle of the screen. If you don't press this button, the starting times are not saved.
• Done, closes the window.