Bulk Upload on Banglar Shiksha Portal

Bulk Upload on Banglar Shiksha Portal

It is informed that besides direct online data entry, provision for bulk uploading of data in respect of students’ DCF entry in Banglar Shiksha Portal has now been enabled in a modified excel format which is available in the home page as well as in the ‘Bulk Upload’ menu under HOI login in the portal. Therefore, it is requested to use this facility for immediate completion of students’ data entry.  All HOIs are hereby informed accordingly.

The topics that I will discuss here are as follows…..




  1. Download Entry Format (Incomplete Excel file)
  2. Complete the excel file
  3. How to upload the Excel file in Banglar Shiksha Portal ?
  4. How to edit uploaded data?
  5. Student Image Upload.
Download entry format from Banglar shiksha portal.

🌈Click on "Bulk Upload"  option under Student Management in the Banglar Shiksha e-portal Navigation menu.

🌈Bulk Upload page will open. At the top of this page, click on "Download entry format" excel file, the file will be downloaded.
Bulk Upload on Banglar Shiksha Portal

How to fill excel file downloaded from Banglar Shiksha Portal.
Remember a few tips to complete the excel file.

⚠️Do not make an excel sheet more than 200 rows.
⚠️Make a separate excel sheet for each class. Do not add more than one class to one excel sheet.
⚠️Don't copy paste any data from.


GUIDE LINE FOR FILLING UP STUDENT DATA







1
PLEASE FILL UP COLUMNS FROM LEFT TO RIGHT & ROWS FROM TOP TO BOTTOM







2
DON’T LEAVE ANY ROW/ROWS BLANK IN BETWEEN ROWS CONTAING DATA, ROWS MAY BE KEPT BLANK AT END







3
IF ANY MANDATORY FIELD (MARKD *) KEPT BLANK, THE FILE CANNOT BE UPLOADED







4
THIS FILE IS DESIGNED FOR A PARTICULAR CLASS & SECTION AS CHOSEN IN FIRST ROW ( COLUMN "Y" & "Z")








IF FIRST ROW IS SELECTED FOR CLASS V, SEC-A, ALL STUDENTS TO BE SELECTED IN SAME CLASS & SECTION IN REMAINING ROWS








USE DIFFERENT FILES FOR DIFFERENT CLASS & SECTION







5
MAXIMUM DATA CAN BE UPLOADED = 200, USE DIFFERENT FILE IF NUMBER OF STUDENTS EXCEEDS 200 IN A PARTICULAR CLASS & SECTION







6 *
COPY (Ctrl+C) FROM ANOTHER WORKSHHET & PASTE (Ctrl+V) TO THIS FILE NOT RECOMMENDED AS IT WILL REMOVE VALIDATION IN CERTAIN CELLS








AS A RESULT FILE CANNOT BE UPLOADED.








HOWEVER DATA MAY BE COPIED (Ctrl+C) FROM ANOTHER WORKSHEET, AND CAN BE PASTED HERE USING PASTE_SPECIAL > VALUES







7 *
NO SPECIAL CHARACTERS  ALLOWED IN ALL NAME FIELDS (VIZ STUDENT NAME, FATHER'S NAME, MOTHER'S NAME, GUARDIAN'S NAME, HABITATION NAME, PANCHAYET NAME, PO NAME ETC)








LIST OF FREQUENTLY USED SPECIAL CHARACTERS : ALL BRACKETS, COMMA, SEMI-COLON,  COLON, STOP, HYPHEN, SINGLE/DOUBLE QUOTE, SLASH, EXCLAMATION/QUESTION MARK








ONLY CHARACTERS FROM A - Z AND ALLOWED, FILE UPLOADING WILL FAIL IF THE ABOVE NAME FIELDS CONTAIN SPECIAL CHARACTERS







8
FILE TO BE SAVED IN EXISTING FORMAT (XLSX) ONLY

















Upload the Excel file in Banglar Shiksha Portal
🌈Login to the Banglar Shiksha e-portal with HoI login.

🌈Click on "Bulk Upload"  option under Student Management in the Banglar Shiksha e-portal Navigation menu.

🌈Bulk Upload page will open.Click on "Choose file" in the Attached Document  here.
🌈Once the file is uploaded, click on the "Upload" option.
Bulk Upload on Banglar Shiksha Portal
🌈The file will be uploaded to the Students details page. Reverify all details before finalize.
Then click on "Finalize".
All the details of the students will be saved in the Banglar Shiksha portal.

Edit uploaded data in Banglar Shiksha portal.
You can edit Student details after final Submit.
Click here to see what I've already posted about this.

Student Image Upload in the Banglar Shiksha portal.
🌈Login to the Banglar Shiksha e-portal with HoI login.

🌈Click on "Student image uploading status"  option under Student Management in the Banglar Shiksha e-portal Navigation menu.

🌈"List of students" page will open.If you click on the Action button of each student here, the image upload page will open.
Here you can add 20kb size image of any student.

____________________________
You can join our Whatsapp group-1 or group-2 to get instant updates.

Subscribe to my blog to find out more information.
Like my facebook page
Follow YouTube
         
           Twitter













Comments

Popular posts

Class routine for primary school in West Bengal

The best age calculator for determining the age of students

All setup on Banglar shiksha sms portal, ECA setting on banglar Shiksha Portal.

Home District transfer for primary school teacher

Student ID card on Banglar Shiksha portal

Login to the Banglar shiksha sms portal (for School) for the first time

Teacher's Training on Bihan

Student DCF entry on Banglar shiksha portal

Activity Task on Banglar Shiksha Portal