Page History

' Standard fields '

- these

These fields MUST be supplied, in this order, and the header/field name (if provided in the import file) is ignored.

1

ID

The person's ID. This is a 7 digit number that can best obtained by generating an import template (see below).
* If the ID is specified any data - except the last name and first name* - for the record will be updated. However, the ID must belong to a person within your list (either with or without current roles)*. In some cases the person may be present in your list, but not be editable (this could be the case for certain transfers between clubs etc). You will not be able to change these records.
* First/Last names can only be changed by editing the individual record.*Roles of existing records is not changed by this process.
* If the ID is left blank then a new record will be created, and an ID assigned after the import process.

Integer- leading zeroes are ignored, or left blank.

2

First Name

The person's first name. For existing records any changes to this field are ignored. Must be supplied for new records.

Text

3

Middle Name

The person's middle name(s) (or initial).

Text

4

Last Name

The person's last name/surname. For existing records any changes to this field are ignored. Must be supplied for new records.

Text

5 ,
6 ,
7

Address1 ,
Address2 ,
Address3

Person's street or postal address. Use as many of these as required.

Text

8

Suburb

Suburb, or city/town related to address.

Text

9

Postcode

Postcode/zipcode related to address.

Text

10

State

State (or county) related to address.

Text

11

Country

Country related to address.

Text

12

Date of birth

Date of birth for person. Allowable formats: d/m/yyyy (eg 3 April 1963 is 3/4/1963), yyyy/m/d (eg 1963/4/3), formats such as Apr 3, 1963 also allowable. Hyphens - may be used instead of slashes /. Please use the full year (1963 instead of 63) and avoid the US style m/d/yyyy format.

Date format as listed.

13 ,
14 ,
15

Home ,
work ,
mobile phone

Phone numbers for person. Mobile phone numbers should be specified as they would be called from your country - avoid international and other codes.

Text

16

Email address

Email address for person. Recommended. Must be a valid email address. Multiple addresses can be entered by separating with a semi colon ( ;) - eg fred@example.com;fred@work.com

Text

17

Gender

Preferably enter M or F. Anything starting with M or F is accepted, anything else ignored.

Text

18

Next of Kin / Emergency Contact - Name

Text

19

Next of Kin / Emergency Contact - Number

Text

' Custom fields *' - these

These fields MUST follow all standard fields, order is not important, but the header/field name as obtained from the downloaded template must not be changed. Custom fields that are not required to be uploaded/modified can safely be removed/omitted from the import file, and any data in such fields will not be changed within the system.

20+

Custom Fields - as many as required.

Text

*Custom fields are only imported if the Import Custom Fields option is checked.

Maximum number of records