Faria products support various CSV imported datasets. This article is a quick guide to what, and where, as well as how you can find more specific guidance for each import.
Please refer to the linked support articles for further documentation on each item.
Under Settings > Import Manager you can find roster imports for Students, Parents and Teachers. Each page includes a downloadable template and full guidance on formatting in the right navigation panel as well as a link to the help centre guide: Adding Students, Parents & Teachers to ManageBac
The imports can include the fields below:
Students | Parents | Teachers |
Student ID | Student ID | First Name |
First Name | Student E-mail | Middle Name |
Middle Name | Salutation | Last Name |
Last Name | First name | E-mail Address |
Preferred Name | Middle Name | |
Other Name | Last name | |
E-mail Address | Preferred Name | |
Grade | Other Name | |
Programme | E-mail Address | |
Year Group | Relationship | |
Gender | Gender | |
Date of Birth | Date of Birth | |
Mobile Phone | Title | |
National ID | Employer | |
1st Nationality | Mobile Phone | |
2nd Nationality | 1st Nationality | |
3rd Nationality | 2nd Nationality | |
4th Nationality | 3rd Nationality | |
1st Language | 4th Nationality | |
2nd Language | 1st Language | |
3rd Language | 2nd Language | |
4th Language | 3rd Language | |
Address | 4th Language | |
Address 2 | Work E-mail | |
Phone Number | Work Phone | |
City | Work Address | |
State/Province | Work Address 2 | |
Postal Code | Work Fax | |
Country | Work City | |
UI Language | Work State | |
Enrollment Date | Work Postal Code | |
Password | Work Country | |
Graduation Date | Address | |
Withdrawal Date | Address 2 | |
Phone Number | ||
City | ||
State/Province | ||
Postal Code | ||
Country | ||
UI Language | ||
Password |
Classes and their respective timetables can be imported via Classes > Classes Manager > Import Classes or Import Timetables. Afterwards, students or teachers can be enrolled into these classes via Classes > See all Classes > Bulk Assign Students or Bulk Assign Teachers. For full guidance see the articles: Adding new Classes and Assigning Students & Teachers to Classes
Below are the relevant fields for each import:
Classes | Timetables | Bulk Assign students | Bulk Assign Teachers |
Class ID | Class ID | Student ID | Class ID |
Year | Academic Year | Teacher Email | |
Group | Rotation Day Number | Class ID | Show on Reports |
Subject | Period Number | ||
Name | Location | ||
Level | |||
Section | |||
Teacher E-mail | |||
Description |
Advisors and Supervisors can also be bulked assign via IB Manager > Grade > Members > Bulk assign Students. For further guidance see: Assigning Students to Advisors: Homeroom, CAS, SA, EE, TOK, Personal and Community Projects
OpenApply has a very flexible import facility under Settings > Import & Export > Import whereby you can select the fields you would like to import. You can populate any of the standard fields or custom fields that the school has defined. These new values will then be visible in any of the forms that use those fields.
Please see the comprehensive help for this functionality: Importing Data into OpenApply.
SchoolsBuddy does not have a self-service import function, but schools that don't use an automated data sync may supply CSV uploads of student & parent data, and staff data to the Support team for upload. Example templates can be found in CSV / Manual Import.
Student & Parents | Staff |
MIS Pupil ID | Id |
School House | Title |
Year Group | FirstName |
Tutor Group | LastName |
Title | EmailAddress |
First Name | DOB |
Surname | CountryOfBirth |
Email Address | Ethnicity |
DOB | Gender |
Gender | |
ParentTitle1 | |
ParentFirstName1 | |
ParentSurname1 | |
ParentEmail1 | |
Parent1Mobile | |
ParentTitle2 | |
ParentFirstName2 | |
ParentSurname2 | |
ParentEmail2 | |
Parent2Mobile |