← EnterNOW for Schools

Importing Students

You can import data from a spreadsheet into EnterNOW

The spreadsheet will need to be exported or saved as a csv file

The following fields are required, the rest are optional

• First Name
• Last Name
• Date of Birth
• Gender

The following column headers are recognised, they are case insensitive, anything that doesn't match will be ignored.

Student ID Number

• cm.special(20)
• local student id
• id number
• pupil id
• student id
• reference
• slsnz id number

Remote Unique Identifier (used to match external systems)

• contactid

Student Last Name

• legal surname
• surname (preferred)
• surname
• last name
• family name
• preferred family name
• surname (legal)

Student First Name

• preferred firstname
• first name (preferred)
• first name
• first names
• preferred name
• first name (legal)
• first

Gender (Acceptable Values M or F)

• gender
• sex

Date of Birth (Expected format YYYY-MM-DD)

- date of birth (yyyymmdd) - birthdate - dob

**Enrollment Date**

• first attendance
• date started here
• first started school

Year Level

• year level
• this year
• year

**Previous School**

- previous school - previous schools

**Email**

- email

**Phone**

- phone

**Address**

- address

**Suburb**

- suburb

**Town / City**

- town/city - city

**Ethnicity**

- ethnicity

### The following applications should generate files with these headers

**Kamar**

ID Number,Surname (Preferred),First Name (Preferred),Gender,Date of Birth,First Attendance,Year Level,Previous School 1 Name

**Musac**

Local student ID, Family Name, First Names, This Year, Gender, DOB, Date started here, Previous schools

**eTAP**

Pupil ID, Preferred Family name, Preferred name, Year level, Gender, Date of birth, First started school, Previous school

**Surf Life Saving NZ**

ContactID, SLSNZ ID Number, First Name, Last Name, Birthdate, Gender