Screen guide · Web app
Bulk Upload
Add many students at once from a CSV or Excel file, with an optional check of the file before anyone is added.
यह पेज अंग्रेज़ी में है। कुछ समझ न आए तो ।
Bulk Upload (the page is headed Bulk Import Student) admits a whole list of students from one file. You download the sample file, fill it in, optionally select Validate File (Optional) to find problems, and then select Upload.
The Admission Number column may be left blank. A row with a blank admission number gets the next available admission number of the school. A row that has an admission number keeps it.
Who uses it and when
Section titled “Who uses it and when”The office uses it at the start of a session, or when a school moves its list of students into EDII.
Before you start
Section titled “Before you start”- Download the sample file and keep its headings exactly as they are.
- The classes and sections written in the file must already exist in the school.
- The file must be a CSV (.csv) or an Excel file (.xlsx, .xls), and at most 5 MB.
Where to find it
Section titled “Where to find it”- In school.edii.in: Students › Directory › Bulk Upload
- Or press Ctrl K (⌘ K on a Mac) and type Bulk Upload.
- Address:
school.edii.in/add/add-studentFile - Who can see it: Staff whose role includes Students or Attendance access. Shown only when your school uses Student in EDII. If it is missing from your menu, ask your school admin.
Open a bigger pictureतस्वीर बड़ी करेंStep by step
Section titled “Step by step”1. Download the sample file
Section titled “1. Download the sample file”Select Download Sample File and choose Download CSV or Download Excel. The sample shows the columns and the way each one is to be filled. Do not change the headings.
2. Fill in the file
Section titled “2. Fill in the file”Fill every cell except Admission Number, which you may leave blank.
You may add a column called House at the end of the row (after SMID) to set each student’s house, for example Red, Blue or Green. You may also add a column called Student Type after it with Boarder, Day Boarder or Day Scholar. Any other value is left blank, and a missing column leaves the field blank.
3. Choose the file
Section titled “3. Choose the file”Under Student file (.csv, .xlsx, .xls) select Choose file and pick your file. When it is accepted you see File has been uploaded, Please click on the Upload Button to Continue adding the student. An Excel file is first changed into a CSV for you, and then you see Excel file has been converted and uploaded. Please click on the Upload Button to Continue adding the student.
4. Check the file (optional)
Section titled “4. Check the file (optional)”Select Validate File (Optional). EDII reads the file the way the upload does and shows a Validation report without adding anybody. It also compares each row with the students already in the school, such as an Aadhaar number or State ID that is already used.
The report says either that all rows look good, or lists Problems to fix (you must correct them) and Points to review (you may still upload). Row 1 in the report is the first student, not the heading row. After fixing the file, choose it again.
5. Upload
Section titled “5. Upload”Select Upload. You see Starting upload… and then the Student Upload Progress page opens. It shows how many students are done, and at the end how many were Done and how many Failed, so you can fix the rows that were not added.
Fields and filters
Section titled “Fields and filters”| Field | What it is | Notes |
|---|---|---|
| Student file (.csv, .xlsx, .xls) | The file with the students. | Only these three types. At most 5 MB. |
| Admission Number (column in the file) | The admission number of each student. | May be blank. A blank gets the next free number. |
| House (extra column) | The house of each student. | Optional. Put it after SMID. |
| Student Type (extra column) | Boarder, Day Boarder or Day Scholar. | Optional. Put it after House. |
Buttons
Section titled “Buttons”| Button | What it does | What happens next |
|---|---|---|
| Download Sample File | Gives you the template as Download CSV or Download Excel. | The file is saved on your computer. |
| Validate File (Optional) | Checks the chosen file without adding any student. | A Validation report appears below. |
| Upload | Starts adding the students from the chosen file. | The Student Upload Progress page opens. |
After you save
Section titled “After you save”- Each good row becomes a student in its class and section for the selected session.
- Rows that could not be added are listed on the Student Upload Progress page, so you can correct them and upload them again.
- The new students show in Students.
Good to know
Section titled “Good to know”- In a CSV file, every Aadhaar number must start with an apostrophe, for example ’012345678901. Without it Excel turns the 12 digits into a number like 5.66E+11. When EDII sees this it shows Aadhaar Number Format Error and clears the file choice. Excel files do not need the apostrophe.
- Validation changes nothing. Students are created only when you select Upload.
Messages you may see
Section titled “Messages you may see”| Message | What it means | What to do |
|---|---|---|
| Only CSV or Excel files are allowed. Please upload a .csv, .xlsx, or .xls file. | The file is of another type. | Save the list as CSV or Excel and choose it again. |
| Max File Size is 5 MB | The file is too big. | Split the list into two or more files. |
| Error processing Excel file. Please ensure the file is valid. | The Excel file could not be read. | Open it in Excel, save it again as .xlsx and choose it again. |
| Please choose a CSV or Excel file first, then click Validate. | No file was chosen before you selected Validate File. | Choose the file first. |
| Please Add the Student List first by clicking on the “+” button! | You selected Upload without a good file chosen. | Choose the file with Choose file (there is no plus button) and wait for the File has been uploaded message. |
| No blocking problems found. | The check found nothing that stops the upload. Some points to review may be listed. | Read the points, then upload. |
| Network Issue, Please Try Again. | The request did not reach EDII. | Check the internet and try again. |
- Use Validate File (Optional) every time. It costs nothing and finds typos and duplicates before they become students.
- Upload one class at a time if you are new to the sample file, so any problem is easy to trace.
Stuck? Try this
Section titled “Stuck? Try this”| Problem | Likely cause | What to do |
|---|---|---|
| Some students were not added | A cell was empty, a class or section does not exist, or the Aadhaar number or State ID already belongs to another student. | Open the Student Upload Progress page, read the list of failed rows, correct them in the file and upload only those rows again. |
| The Aadhaar Number Format Error window appears | The CSV was saved from Excel and the Aadhaar numbers lost their digits. | Put an apostrophe in front of each Aadhaar number, save the file and choose it again. |
Did this page help?क्या इस पेज से मदद मिली?
Thanks! Glad it helped.धन्यवाद! अच्छा लगा कि काम बन गया।
Sorry about that. Ask in your own words, or write to us.माफ़ कीजिए। अपने शब्दों में पूछें, या हमें लिखें।
