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

Leave a Reply

Your email address will not be published. Required fields are marked *