How to Import Entrants

Home

Home
TScore
VScore
What's New
Downloads
Answers
Known Issues
Suggestions
Contact Us
Forum

Previous Up Next

In most cases, you will be using the intelligent Excel Entry Forms to load entrants into the competition, as these handle all of the age group mappings, club details and officials with the minimum of fuss.  Occasionally though, you may choose to use the Import option to add entrants to your competition from a simple text file ('comma separated').
The Import option also lets you restore copies of the database from an earlier archive or another computer.

 

From the Main screen, click on the 'Import / Export' button to display the following screen,

To import a comma separated file (.csv) of entrants, pick one of the 'Import Competitors' options, enter the pathname of the csv file and then click Ok.

The import file is a text file containing information about each competitor, one per line. Each line of information must include their name, club, gender, grade and age group.  It may also include team, BG number and start order. Each value is separated from the next by a comma.

CSV files are easily created from programs such as Excel.


Import File Format

The first line of the file (the 'header row') should contain the following column names

Column Title

Aliases

Description of contents

Club            

     

The name of the club

Name

 

The full name of the competitor

First Name

 

The first name of the competitor

Last Name

Surname

The last name of the competitor

Gender        

Sex, M/F      

M or F

Grade

 

Depends on the competition. Examples "Novice", "H"

AgeGroup 

Age

Age group designator - U13, 17+ etc.

Team

 

Team identifier - A, B C etc

Start

 

Start order if known

BG

Number

Competitor or BG membership number

If preferred, you may supply the Name as two columns instead of one.

First Name

Name

The first name of the competitor

Last Name

Surname

The last name of the competitor


If no header row is present, the following order is assumed -
            Club,   Name,   Gender,   Grade,   AgeGroup,   Team,    Start,    BG
The first 5 columns are mandatory, but can be in any order.
 


Restoring a Saved Competition Database
 
If you have previously saved a copy of a competition database for safe keeping, or simply to move it between computers, you must use the Import option to restore it.  When you restore a saved competition, you may rename it.
When restoring a competition database, first enter (or browse to) the .tsc file that you want to import.

Next, ensure that the computer name of the database server is set in the 'Server' box.

Change the database name if you wish (you cannot restore into an existing database)

Click Ok - TScore will restore the competition from the file you have given.

 
 
Click here for data export options.
 

 


Home | TScore | VScore | What's New | Downloads | Answers | Known Issues | Suggestions | Contact Us | Forum

Questions or problems regarding this web site should be directed to support@tscore.co.uk.
Copyright 2007-11 Chris Edwards. All rights reserved.
Last modified: 01/16/11.