WinMSS Help

Update Match Competitors from Excel Spreadsheet

Update Match Competitors from Excel Spreadsheet

Previous topic Next topic  

Update Match Competitors from Excel Spreadsheet

Previous topic Next topic  

A Microsoft Excel Spreadsheet can be used to import and synchronize a Match Competitor list/table from an external source.  This feature should not be used once the Match has officially started.  The Microsoft Excel Spreadsheet should be saved in "Excel 97 - 2003 Workbook" (*.XLS) format and must have a Worksheet named Sheet that has the following mandatory columns:

 

Column Name

Max Field Length

Competitor's

#

4

Number

Family Name

25

Family Name

Given Name

15

Given Name(s)

Country of Residence

3

Domicile Country Code

Date of Birth

9

Date of Birth (DD-MMM-YYYY)

IPSC Alias

16

IPSC Alias

Division

25

Division

Category

12

Category

Power Factor

5

Declared Power Factor

Email Address

36

Email Address

Home Phone

20

Home Phone Number

Mobile Phone

20

Mobile Phone Number

Passport: Gender

6

Gender

 

Additional columns may appear in the Worksheet, but they will be ignored by WinMSS.  All of the above required fields can be blank, except: Family Name; Given Name; and, Country of Residence.  Please take note:

 

Country of Residence - must be a valid Region Code.
Division - entry is blank, Open Division will automatically be assumed.  If the Division is entered, it must be one from the Division List.
Category - if entered must be one from the Category List.
Power Factor - entry is left blank, the Power Factor will default to Major unless the Competitor's Division only permits Minor.
Passport: Gender - entry is left blank, the Competitor will not be placed into the Lady Category.  If this entry is filled in, the permissible values are: Male; and, Female.

 

See also: gvCompetitor.xls which will be found in your WinMSS application directory.