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)

Enrollment Date

• first attendance
• date started here
• first started school

Year Level

• year level
• this year
• year

• previous school
• previous schools

Phone

Address

Suburb

Town / City

Ethnicity

The following applications should generate files with these headers

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

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

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

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