You can create a competition in eScore by importing a namelist (a list of participants) from a spreadsheet. Each import creates a new competition. It does not add participants to an existing competition.
Supported files
The namelist must be an Excel workbook (.xlsx). Only the first worksheet is read. The older .xls format is not supported.
Two layouts can be used:
- Format A, fixed columns. There is no header row, and every column has a fixed position. This is the original format.
- Format B, named columns. The first row names the columns. Columns can come in any order, and you can leave out the ones you don't need.
eScore picks the layout for you (see "How eScore detects the correct format" below).
Format A: Fixed columns (no header row)
Participant data starts in row 1. Do not add a header row. If you add one anyway, eScore skips it and reports it as a "Bad entry on line 0" warning.
| Column | Field | Type | Required | Description |
|---|---|---|---|---|
| A | Relay Group | Integer | Yes | The relay group number. All rows with the same number go into the same relay group, named "Relay Group <number>". Use 1 if you only need one group. |
| B | Relay Number | Integer | Yes | The relay the shooter is in. Rows without a valid number are skipped and reported. |
| C | Firing Point | Integer | Yes | The target (firing point) number in the relay. Rows without a valid number are skipped and reported |
| D | Name | Text | No* | The shooter's full name in one cell, for example Ola Nordmann. The whole value is saved as the first name, and eScore does not split it into first name and last name. Use Format B if you need separate fields |
| E | Club | Text | No | The shooter's club |
| F | Class | Text | No | The shooter's class, for example 1, 5, J, V55 or Sporter. It is saved exactly as written |
| G | Sum In | Number | No | Ingoing score carried into this competition, for example from an earlier stage. You can use decimals, for example 523.4. Use at most one decimal. Leave it empty or use 0 if there is no score to carry |
| H | Shooter ID | Text | No* | The shooter's ID in the organisation, for example a membership number. It can contain letters |
| I** | Team Name | Text | No | Team name, used for team shooting. See Team shooting. |
* A row needs either a Name or a Shooter Id to create a participant. If both are empty, eScore still creates the target in that relay but leaves it empty. You can use this to keep a lane free.
** Team name is only relevant when doing a CMP Style team shooting event.
Example file
The Excel file below is an example of a file with the "Fixed columns" format.
Format B: Named columns (header row)
The first row holds the column names, and participant data starts in row 2. Columns can come in any order. You can leave out columns you don't need, and eScore ignores columns it doesn't recognise.
Column names
Column names are not case-sensitive (FirstName, firstname and FIRSTNAME all work), and spaces before or after the name are ignored. Otherwise the name must be spelled exactly as shown. For example, First name with a space in the middle and Shooter Id are not recognised.
| Column Name | Field | Type | Description |
|---|---|---|---|
| relay | Relay Number | Integer | The relay the shooter is in |
| target | Firing Point Number | Integer | The firing point (target) number in the relay |
| firstname | First Name | Text | The shooter's first name |
| lastname | Last Name | Text | The shooter's last name |
| club | Club | Text | The shooter's club |
| class | Class | Text | The shooter's class. It is saved exactly as written |
| sumin | Sum In | Number | Ingoing score, as in Format A. If it is empty or not a number, 0 is used |
| shooterid | Shooter Id | Text | The shooter's ID in the organisation |
| team | Team | Text | Team name for team shooting. It is only used when relay and target are both present |
Format B has no Relay Group column, so all participants go into a single relay group, "Relay Group 1"
With or without relay and target
relay and target both present: participants are placed on targets. This works the same way as Format A: relays and targets are created, and team shooting and empty targets are supported. Rows where relay or target is not a valid whole number are skipped and reported as "Skipping invalid row".
relay or target missing: participants only. Participants are imported without a relay or target, in the same order as in the file. You then assign them to relays and targets in eScore. In this mode:
- The team column is ignored
- If only one of relay or target is present, it is ignored
- Rows with neither firstname nor shooterid are skipped
Things to watch out for in Format B
- Do not leave empty cells between the column names, and do not use numbers as column names. If you do, eScore won't recognise the header row and will read the file as Format A, which usually gives an empty or invalid import.
- A header with only, for example, firstname and club is not recognised. You must include both firstname and lastname, or both relay and target, even if some of the cells below are empty.
Example files
The example files below shows three different ways to use the "Named columns" format when importing squadding from a file.
Format B - Without relay and target.xlsx
How eScore detects the correct format
When importing squadding lists from a file, eScore will automatically detect the format based on the contents of the file. eScore looks at the first row of the first worksheet:
1. If every cell in the first row is text and the row contains either
- both relay and target, or
- both firstname and lastname
the file is read as Format B - Named columns
2. Otherwise, the file is read as Format A - Fixed columns
Team shooting (multiple shooters on one target)
NOTE! This functionality is designed specifically for CMP style team shooting events and requires the use of shooting programs designed for team shooting in order to work properly.
In Format A, and in Format B with relay and target, you can put more than one row on the same Relay Group, Relay and Target. These shooters then form a team on that target:
- eScore creates a team for each target that has more than one shooter, and turns on team shooting for the relay group.
- Members per team is set to the size of the largest team in the file.
- Team members shoot in the same order as their rows appear in the file.
- All rows on the same target must have the same team name, or all leave it empty. If the names differ, the whole import is cancelled with "Entries on the same target and relay have different team names".
- A team name on a target with only one shooter is ignored.