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
| Columns | Accepted Values | Example and Instructions |
| *Admission no | Alphanumeric, underscore, hyphen and back slash (/). | AYS/2018/S001. |
| *Admission date | dd/mm/yyyy or dd-mm-yyyy | 13/03/2016 or 13-03-2016 |
| *First name | Alphanumeric. | |
| Middle name | Alphanumeric. | |
| Last name | Alphanumeric. | |
| *Batch Name | Course code - Batch name | For a course ‘Grade 1’ having course code ‘G1' and a batch named '2018 A’ batch name is G1 - 2018 A. |
| *Date of birth | dd/mm/yyyy or dd-mm-yyyy | 13/03/2007 or 13-03-2007 |
| *Gender | m or f | |
| Blood group | A+, A-, A1+, A1-, A1B+, A1B-, A2-, A2+, A2B+, A2B-, B+, B-, B1+, O+, O-, AB+, AB-. | |
| Birth place | Alphanumeric. | |
| *Nationality Name | Country Name. | eg. For a student from India, enter nationality as India. |
| Language | Alphanumeric. | |
| Religion | Alphanumeric. | |
| Student Category Name | An active student category. | General,OBC etc. |
| Address line1 | Alphanumeric. | |
| Address line2 | Alphanumeric. | |
| City | Alphanumeric. | |
| State | Alphanumeric. | |
| Pin code | Alphanumeric. | |
| Country Name | Country Name. | |
| Phone1 | Numeric. | |
| Mobile | Numeric. | 1234512345 |
| Valid email address. | This field is mandatory only if moodle is enabled. | |
| SMS Enabled | Y, NULL. | Enter Y to enable checkbox, NULL to keep it unchecked. |
| Has paid fees | Y, NULL. | Enter Y to enable checkbox, NULL to keep it unchecked. |
| EMail Enabled | Y, NULL. | Enter Y to enable checkbox, NULL to keep it unchecked. |
| Has paid fees for batch | Y, NULL. | Enter Y to enable checkbox, NULL to keep it unchecked. |
| Learn sync lock | ||
| Biometric ID | Alphanumeric. |
Additional Details for Student Admission
| Columns | Accepted Values | Example and Instructions |
| Aadhar Number | Alphanumeric | |
| PEN | Alphanumeric | |
| APAAR ID | Alphanumeric |
Employee Admission
| Columns | Accepted Values | Example and Instructions |
| *Employee Category Name | An active employee category. | System admin etc. |
| *Employee number | Alphanumeric, underscore, hyphen and back slash (/). | AYS/2018/S001 |
| *Joining date | dd/mm/yyyy or dd-mm-yyyy | 13/03/2016 or 13-03-2016 |
| *First name | Alphanumeric. | |
| Middle name | Alphanumeric. | |
| Last name | Alphanumeric. | |
| *Gender | m or f | |
| Job title | Alphanumeric. | |
| *Employee Position Name | An active employee position. | System admin etc. |
| *Employee Department Name | An active employee department. | System admin etc. |
| Reporting Manager Number | Alphanumeric, underscore, hyphen and back slash (/). | Type the reporting manager's employee number. eg:- AYS/2018/S001. |
| Employee Grade Name | An active employee grade. | |
| Qualification | Alphanumeric. | |
| Experience detail | Alphanumeric. | |
| Previous experience year | Numeric. | Enter the no. of years of experience. |
| Previous experience month | Numeric. | Enter the no. of months of experience. |
| *Date of birth | dd/mm/yyyy or dd-mm-yyyy | 13/03/2016 or 13-03-2016 |
| Marital status | married, single, widowed, divorced. | |
| Children count | Numeric. | |
| Father name | Alphanumeric. | |
| Mother name | Alphanumeric. | |
| Spouse Name | Alphanumeric. | |
| Blood group | A+, A-, A1+, A1-, A1B+, A1B-, A2-, A2+, A2B+, A2B-, B+, B-, B1+, O+, O-, AB+, AB-. | |
| *Nationality Name | Country Name. | eg. For an employee from India, enter nationality as India. |
| Home address line1 | Alphanumeric. | |
| Home address line2 | Alphanumeric. | |
| Home city | Alphanumeric. | |
| Home state | Alphanumeric. | |
| Home Country Name | Country name. | |
| Home pin code | Alphanumeric. | |
| Office address line1 | Alphanumeric. | |
| Office address line2 | Alphanumeric. | |
| Office city | Alphanumeric. | |
| Office state | Alphanumeric. | |
| Office Country Name | Country name. | |
| Office pin code | Alphanumeric. | |
| Office phone1 | Numeric. | 12345 |
| Office phone2 | Numeric. | 12345 |
| Mobile phone | Numeric. | 1234512345 |
| Home phone | Numeric. | 12345 |
| Valid email address. | ||
| Fax | Alphanumeric. | |
| Last credit date | ||
| Learn sync lock | ||
| Biometric ID | Alphanumeric. | |
| Leave Group |
Guardian Details
| Columns | Accepted Values | Example and Instructions |
| *First name | Alphanumeric. | |
| Last name | Alphanumeric. | |
| Is Father | Y or Leave Blank. | If guardian is father, enter Y, leave blank otherwise. This column cannot be modified during bulk edit. |
| Is Mother | Y or Leave Blank. | If guardian is mother, enter Y, leave blank otherwise. This column cannot be modified during bulk edit. |
| Other Relation | Alphanumeric. | Enter name of relation like Uncle, Grandmother etc. Either one of the 3 fields is mandatory. This column cannot be modified during bulk edit. |
| Valid email address. | ||
| Office phone1 | Numeric. | 12345 |
| Office phone2 | Numeric. | 12345 |
| Mobile phone | Numeric. | 1234512345 |
| Office address line1 | Alphanumeric. | |
| Office address line2 | Alphanumeric. | |
| City | Alphanumeric. | |
| State | Alphanumeric. | |
| Country Name | Alphanumeric. | |
| Date of Birth | dd/mm/yyyy or dd-mm-yyyy | 13/03/2007 or 13-03-2007 |
| Occupation | Alphanumeric. | |
| Income | Alphanumeric. | |
| Education | Alphanumeric. | |
| Set immediate contact | Alphanumeric, 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
Feedback sent
We appreciate your effort and will try to fix the article