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.

Below you can see the window which is used making Entries into race. The FIS-file is selected using Browse-button and then ExTime lists the header line and columns letters plus 14 first lines in ascending sequence. Using this window, you can set the columns letter into Field sequence area.

After the Browse the list is sorted after first field, but later on it is sorted after any field you want, the sort field column is added as extra column beginning the each line.

If the file contains only combined name, definition of forename must be spaces (no separate forename), only Surname-field is defined. If the file do not contains any FIS-points, the definition of this field must be zero.

Definition can take some time if you use this feature first time, but you can use the definitions shown below depending which type of file from FIS you are using. I skip 6 first columns (A--F) of the line and start listing from column G (FIS-code). Of course column H (Surname/Firstname) is the first column on screen, because it is the Sort field.

[FISLIST]
Surname=H
Forename=I    
Sex=K
Birthdate=L
Club=M
Country=J
FIScode=G
FISPoints=Q
FISPointssprint=U
filename=I:\Tuotanto\ranki\2019_kausi\FIS\FIS-points-list-toka-300139.csv
delimiter=,
text_start="
Sort=D
First=G
Fislist=2
missingpoints=999.00

to begin

29.12.2016 when I was asked to make the entries for Lahti Scandinavia Cup, I received different Excel worksheets. Eeach country used their own system to send entries for the race. On the right is swedish version. So I added two buttons in the Fis-entry Dialog, Paste from clipboard and Add list into race. Those buttons work following way: First select the fis-codes from Excel-sheet, you can also select other fields as I did, on the right. Then copy that area into clipboard (by clicking mouse's right button and select Copy) or just press CTRL + INS. The FIS-code MUST be leftmost column.   Press Paste from clipboard and all the data will be now in ExTime, maybe order is different, now its by FIS-code. Again, FIS-code MUST be the leftmost column.   Press Add list into race and then ExTime will take the first FIS-code, search all the data from FIS-list file, select class, enter the athlete into race and at least deletes the added line from list.   If there was erros (wrong FIS-code), the line stays in the list.   ExTime repeats the steps 3 and 4 until all lines have been processed.   Then you can change Excel-sheet and repeat all steps 1 to 5 as many time it is necessary.
You can add all brasilien men skiers into race very fast just using FIS-code as sort field (the most left column), selecting BRA as country code and M as Gender, searching them from FIS-datafile and then just press button Add list into race. All 15 skiers are added into race. If you will skip one or more competitors from race you can remove them from list just double clicking those lines. But do it before pressing button Add list into race. If you have only one FIS-code to be entered, just type in or copy paste that code into the box right side of button FIS-code and press first button FIS-code to check the athĺetes data and then button Enter to enter that athlete into race. Notice, that on rigth screen the sort field is FIS-code (column G).

to begin

Surname and forename exist as separate fields, ExTime will concate those into one field, forename first of course. At the beginning of season 2019 there was 905 finnish records in FIS database, including relay teams.

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." This screen is also used, when you update the competitors name before you make the XML-file to report FIS races penalties. New feature is, that ExTime makes a list not found competitors to the right. You can correct that person by double clicking his/her line on list.

After updating the points, it is a very good practice to check, that every competitor has got his/her points. Below you can see, that Katri Saavalainen has no points and no FIS-code, that must be check from FIS-website.

And there is only one competitor, whos surname is Saavalainen:

But because she is only 16 years old and has very new FIS-code, she is without FIS-points and that's why she was missing. I must update her FIS-code and country code manually, so she will earn her first points from that race.

But Lauri Pyhäjärvi (mens class) is not active. He has FIS-code (from KILMO), but no points. I must take his FIS-code away, because he is not allowed to earn any FIS-points.

Season 2019 is without payment.

To make starting order is very easy. 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.

The buttons and check boxes on the sample window left works following way: 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.

Back to ExTime-page