Custom import mandatory fields

Custom import mandatory fields

For a successful custom import, the data in your custom import file must be formatted correctly and must match data in the portal when necessary.


The following tables list 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

Class Name|Student

Year code + Class name. For example, the year Zoology has the year code ‘Zoo’. The year contains a class by the name ‘2014A’. In the Class 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

Class Name|Attendance

Student exam scores

Exam group name|inject

Class 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

Class 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



    • Related Articles

    • How to add custom fields in library?

      When adding books to the library, apart from the default fields, you can add custom fields that can be used to record any additional details about the book. At the top of your dashboard, click the module access icon > Academics > Library > Manage ...
    • How to add custom fields to student admission form?

      At the top of your dashboard, click the module access icon > Administration > Settings > Add Admission Additional Details to open the Add additional details page. In the Name field, enter the name of the custom field that will appear on the student ...
    • About Custom import

      The Custom Imports plugin helps institutions import employee, student, and intuitional data into the portal using a comma-separated value (CSV) formatted file. The Custom Imports plugin will help save time by alleviating manual data entry tasks, and ...
    • Can I add custom additional fields to record donor information?

      At the time of recording donor information, apart from the existing default fields, you can add custom fields to record additional information about the donor. Add custom additional detail fields to record donor information At the top of your ...
    • How bulk edit is useful in custom import?

      Bulk edit feature is useful when a change needs to be made to many records that were uploaded through Custom Import.  All data that can be bulk uploaded can be edited also using bulk edit.  To do a bulk edit click on any of the custom imports done ...