Custom import Instructions

Modified on Fri, 20 Nov at 10:39 AM

 

Instruction
  • Custom Import is useful to enter many records of institutional data at once using a comma separated value (CSV) file.
  • The headers in the CSV file indicate the value that has to entered. Use the instructions given below to enter data into the file.
  • The mandatory fields have been marked using the asterix (*) mark before each column.
  • A maximum of 1000 rows can be imported at once.

Student Admission

ColumnsAccepted ValuesExample and Instructions
*Admission noAlphanumeric, underscore, hyphen and back slash (/).AYS/2018/S001.
*Admission datedd/mm/yyyy or dd-mm-yyyy13/03/2016 or 13-03-2016
*First nameAlphanumeric.
Middle nameAlphanumeric.
Last nameAlphanumeric.
*Batch NameCourse code - Batch nameFor a course ‘Grade 1’ having course code ‘G1' and a batch named '2018 A’ batch name is G1 - 2018 A.
*Date of birthdd/mm/yyyy or dd-mm-yyyy13/03/2007 or 13-03-2007
*Genderm or f
Blood groupA+, A-, A1+, A1-, A1B+, A1B-, A2-, A2+, A2B+, A2B-, B+, B-, B1+, O+, O-, AB+, AB-.
Birth placeAlphanumeric.
*Nationality NameCountry Name.eg. For a student from India, enter nationality as India.
LanguageAlphanumeric.
ReligionAlphanumeric.
Student Category NameAn active student category.General,OBC etc.
Address line1Alphanumeric.
Address line2Alphanumeric.
CityAlphanumeric.
StateAlphanumeric.
Pin codeAlphanumeric.
Country NameCountry Name.
Phone1Numeric.
MobileNumeric.1234512345
EmailValid email address.This field is mandatory only if moodle is enabled.
SMS EnabledY, NULL.Enter Y to enable checkbox, NULL to keep it unchecked.
Has paid feesY, NULL.Enter Y to enable checkbox, NULL to keep it unchecked.
EMail EnabledY, NULL.Enter Y to enable checkbox, NULL to keep it unchecked.
Has paid fees for batchY, NULL.Enter Y to enable checkbox, NULL to keep it unchecked.
Learn sync lock
Biometric IDAlphanumeric.


Additional Details for Student Admission

ColumnsAccepted ValuesExample and Instructions
Aadhar NumberAlphanumeric
PENAlphanumeric
APAAR IDAlphanumeric



Employee Admission

ColumnsAccepted ValuesExample and Instructions
*Employee Category NameAn active employee category.System admin etc.
*Employee numberAlphanumeric, underscore, hyphen and back slash (/).AYS/2018/S001
*Joining datedd/mm/yyyy or dd-mm-yyyy13/03/2016 or 13-03-2016
*First nameAlphanumeric.
Middle nameAlphanumeric.
Last nameAlphanumeric.
*Genderm or f
Job titleAlphanumeric.
*Employee Position NameAn active employee position.System admin etc.
*Employee Department NameAn active employee department.System admin etc.
Reporting Manager NumberAlphanumeric, underscore, hyphen and back slash (/).Type the reporting manager's employee number. eg:- AYS/2018/S001.
Employee Grade NameAn active employee grade.
QualificationAlphanumeric.
Experience detailAlphanumeric.
Previous experience yearNumeric.Enter the no. of years of experience.
Previous experience monthNumeric.Enter the no. of months of experience.
*Date of birthdd/mm/yyyy or dd-mm-yyyy13/03/2016 or 13-03-2016
Marital statusmarried, single, widowed, divorced.
Children countNumeric.
Father nameAlphanumeric.
Mother nameAlphanumeric.
Spouse NameAlphanumeric.
Blood groupA+, A-, A1+, A1-, A1B+, A1B-, A2-, A2+, A2B+, A2B-, B+, B-, B1+, O+, O-, AB+, AB-.
*Nationality NameCountry Name.eg. For an employee from India, enter nationality as India.
Home address line1Alphanumeric.
Home address line2Alphanumeric.
Home cityAlphanumeric.
Home stateAlphanumeric.
Home Country NameCountry name.
Home pin codeAlphanumeric.
Office address line1Alphanumeric.
Office address line2Alphanumeric.
Office cityAlphanumeric.
Office stateAlphanumeric.
Office Country NameCountry name.
Office pin codeAlphanumeric.
Office phone1Numeric.12345
Office phone2Numeric.12345
Mobile phoneNumeric.1234512345
Home phoneNumeric.12345
EmailValid email address.
FaxAlphanumeric.
Last credit date
Learn sync lock
Biometric IDAlphanumeric.
Leave Group


Guardian Details

ColumnsAccepted ValuesExample and Instructions
*First nameAlphanumeric.
Last nameAlphanumeric.
Is FatherY or Leave Blank.If guardian is father, enter Y, leave blank otherwise. This column cannot be modified during bulk edit.
Is MotherY or Leave Blank.If guardian is mother, enter Y, leave blank otherwise. This column cannot be modified during bulk edit.
Other RelationAlphanumeric.Enter name of relation like Uncle, Grandmother etc. Either one of the 3 fields is mandatory. This column cannot be modified during bulk edit.
EmailValid email address.
Office phone1Numeric.12345
Office phone2Numeric.12345
Mobile phoneNumeric.1234512345
Office address line1Alphanumeric.
Office address line2Alphanumeric.
CityAlphanumeric.
StateAlphanumeric.
Country NameAlphanumeric.
Date of Birthdd/mm/yyyy or dd-mm-yyyy13/03/2007 or 13-03-2007
OccupationAlphanumeric.
IncomeAlphanumeric.
EducationAlphanumeric.
Set immediate contactAlphanumeric, underscore, hyphen and back slash (/).Enter admission number of the student to be made immediate contact. eg:-AYS/2018/S001

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article