Guide Importing Competitors

Importing Competitor Data

The Sports Administrator allows you to import competitors from a text file. A simple text needs to be generated in the following format:

Given Name, Surname, House/School Code, Sex, Age, DOB, PIN

All fields are required except the last three. Only one of the Age / DOB fields is required. If a DOB is supplied the Sports Administrator will calculate the age. Alternatively if an age is supplied the program will set the competitor’s DOB to the first day of the year in which he was born. PIN is optional but can be useful to link students to their student number.

To import competitors into the database first generate a plain text file in the format described above. Enter the location of that file or locate it by pushing the Locate button. If there is already data in the temporary table clear it by pushing the Clear Temporary Data file. Now push the View Text File button. The data in the text file will be imported into a temporary location and displayed in the grid on the form. Once the text file has been displayed you can check its accuracy. If you are happy with it simply push the Import Competitors button and the data will be imported into the current carnival.