🖥️Data

Importing data to OpenApply

OpenApply can assist to facilitate the importation of various data types, including inquiries, applicant details, student records, and alumni information. Certain fields are mandatory and essential for the successful importation process into OpenApply.

It usually takes our team around 1-2 weeks to import data, depending on the quality and quantity of the data.

We recommend ensuring that you are satisfied with the forms and fields in OpenApply before beginning the data import process, as this will help ensure a smoother and more accurate import.

As listed there, the following fields are required when importing data into OpenApply:

Required Fields	Examples
First Name	Henry
Last Name	Epelbaum
Grade	Pre-K2, Pre-K3, Pre-K4, Kindergarten, Grade 1, Grade 2, Grade 3, Grade 4, Grade 5, Grade 6, Grade 7, Grade 8, Grade 9, Grade 10, Grade 11, Grade 12, Summer Camp
Enrollment Year	Academic Year 2023-2024, Academic Year 2022-2023, Academic Year 2021-2022, Academic Year 2020-2021
Student Status If blank, the Pending status will be used by default.	Pending, Applied, Admitted, Wait-listed, Declined, Enrolled, Graduated, Withdrawn
Campus Only required if there is more than one campus.	Main Campus, Kenting Campus
Parent First Name	Thomas
Parent Last Name	Epelbaum
Parent Email	[email protected]
Parent Gender	Male
Parent Relationship If blank, a male parent will be set to the Father and a female parent will be set to the Mother	Father, Mother, Stepfather, Stepmother, Legal Guardian

In addition to these mandatory fields, you can also import additional fields that you wish, such as Gender, Birth Date, Nationality, Day/Boarding, etc.

Please refer to the attached example template below, showing how the data should look. (If you are importing 2 parents, then you would need to specify if the parent data is for parent 1 or parent 2, the parent fields should spread to the right of the excel file).

29KB

Import_Student_Template.xls

So you could populate a spreadsheet such as this with your data from your current system, send it back to us, and then we could pass this to our data team for import. As well as thinking about which fields you want to import, you can also consider which existing data you want to import, e.g. if you are just importing current applicants, or if you are also importing applicants from previous years.