National FIS Software : Import

From SplitSecond
Revision as of 02:14, 2 September 2009 by Geoff (talk | contribs)
Jump to navigation Jump to search

Import

Under the menu option File|Import there are four options:



For almost all situations the first option listed will be the one to use. The others, which are also explained below, are somewhat obsolete but have been kept rather than remove functionality that may still be in use by someone.

Import from any comma or tab separated file

This will give a standard Windows screen to select the file to be imported. By default it expects files in a .csv format but other extensions may be selected via the drop-down typically on the bottom of the screen.

Once selected it will display an interactive screen to define what is imported and how:



Follow the instructions carefully on the screen. This involves: selecting the format, how duplicate data is managed, lines to be ignored, and selecting which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.

In the example above you can see on the right of the screen the user is selecting the use for the 5th column. In this case it will be "Team". The user also needs to change the "Lines to ignore" to "1" because, as can be seen via the preview, the first line of the file isn't actual data.

Once "OK" is hit the import takes place. At this point the settings are saved and will be the default settings next time the screen is used.


NOTE: Be very careful to set how duplicates are managed correctly! Duplicates are based on bib number. If there aren't bibs assigned or they aren't defined in the import a new record will always be created.


from Timer (DOS Standard Skiing Package)

This is a very old format used to transfer data between Split Second's original DOS software. It's been kept because some users might still use it. It expects a simple comma separated file with the fields: bib, class, team, result1, result2.

Registration file from USSA (Nor-Am+)

This is to import a specific data format from USSA from a file with a .usr extension. It's only used for entries for Nor-Am and higher events.

The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, FIS race code.

This is followed by one line per competitor with comma separated fields. The only fields used by the software are the 2nd field for USSA number, and the 3rd field which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the points lists a report is generated.

Comp Import

Clicking on this option will first give the following explanation:



If you have a file with the data in this format click OK to continue.