For a successful custom import, the data in your custom import file must be formatted correctly and must match data in School Software Pro when necessary.
The following tables lists all mandatory fields for each data type.
|
Employee admission details |
|
|---|---|
|
Mandatory Fields |
Data Format Description |
|
Employee Category Name|Employee |
– |
|
Employee number|Employee |
– |
|
Joining date|Employee |
mm/dd/yyyy (02/22/1990) or dd-mm-yyyy (22-02-1990) |
|
First name|Employee |
– |
|
Gender|Employee |
Enter ‘m’ for male and ‘f’ for female. If you do not enter a value, the Gender field for the employee record will be considered as Male. |
|
Employee Position Name|Employee |
– |
|
Employee Department Name|Employee |
– |
|
Date of birth|Employee |
mm/dd/yyyy (02/22/1990) or dd-mm-yyyy (22-02-1990) |
|
Nationality Name|Employee |
Enter the name of the country. For example, an employee from India will have Nationality as India, not Indian. |
|
Email|Employee |
– |
|
Student admission details |
|
|
Admission no|Student |
– |
|
Admission date|Student |
mm/dd/yyyy (02/22/1990) or dd-mm-yyyy (22-02-1990) |
|
First name|Student |
– |
|
Batch Name|Student |
Course code + Batch name. For example, the course Zoology has the course code ‘Zoo’. The course contains a batch by the name ‘2014A’. In the Batch Name|Student field, you will enter ‘Zoo – 2014A’. |
|
Date of birth|Student |
mm/dd/yyyy (02/22/1990) or dd-mm-yyyy (22-02-1990) |
|
Gender|Student |
Enter ‘m’ for male and ‘f’ for female. If you do not enter a value, the Gender field for the student record will be considered as Male. |
|
Nationality Name|Student |
Enter the name of the country. For example, a student from India will have Nationality as India, not Indian. |
|
Email|Student |
This field is mandatory only if Moodle enabled. |
|
Student guardian details |
|
|
Ward Admission Number|Guardian |
– |
|
First name|Guardian |
– |
|
Relation|Guardian |
– |
|
Student attendance details |
|
|
Student Admission Number|Attendance |
– |
|
Forenoon|Attendance and Afternoon|Attendance |
Both fields, or either one of the fields must be filled if a student was absent. |
|
Month date|Attendance |
– |
|
Batch Name|Attendance |
– |
|
Student exam scores |
|
|
Exam group name|inject |
– |
|
Batch name|inject |
– |
|
Subject code|inject |
– |
|
Student Admission Number|Exam score |
– |
|
Marks|Exam score |
– |
|
Library book details |
|
|
Title|Book |
– |
|
Author|Book |
– |
|
Book number|Book |
– |
|
Store item details |
|
|
Item name|Store item |
– |
|
Quantity|Store item |
– |
|
Unit price|Store item |
– |
|
Tax|Store item |
– |
|
Batch number|Store item |
– |
|
Store Code|Store item |
– |
|
Code|Store item |
– |
|
Item Category Code|Store item |
This field is mandatory only if you fill the Sellable|Store item field. |
|
Item supplier details |
|
|
Name|Supplier |
– |
|
Contact no|Supplier |
– |
|
Supplier Type Code|Supplier |
– |
|
Store details |
|
|
Name|Store |
– |
|
Code|Store |
– |
|
Store Category Code|Store |
– |
|
Store Type Code|Store |
– |