...
Field number | Abbreviation | Definition | Allowable values |
---|---|---|---|
' 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). | 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 , | Address1 , | 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 , | Home , | 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 |
...