Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Compliance & government portals/Portal exports: validate, fix and download a portal-ready CSV/Script

    Recording script: Portal exports: validate, fix and download a portal-ready CSV

    8 shots · about 1 min 49 s of finished video · lesson 2 of Compliance & government portals

    Record as

    Principal (demo_principal)

    Sign in at /demo on a demo-mode build

    Screens

    /compliance/exports /compliance/exports/[key] /students/[id]/edit /compliance/fields

    Length

    1 min 49 s

    narration at ~150 words/min + screen time

    Status

    Not yet recorded

    Before recording

    • A current academic year.
    • Students enrolled with the fields the portal asks for (profile fields, and for state-specific columns the Extra fields grid).

    Intro voice-over

    Pick an exporter (UDISE+ SDMIS, Banglar Shiksha, CBSE LOC, WBBSE registration and 23 more), check the data, follow the Fix links, then download the CSV, the issue list or a blank template.

    #ScreenAction (on screen)Must be visibleVoice-over~s
    1/compliance/exportsOpen Compliance → Portal exports.The page Portal exports described as Portal-ready CSV files for WB · WBBSE, filter buttons All, UDISE+, State portals, Board registration, Scholarships & schemes, Teachers & staff, and cards for the exporters that apply to your state and board. Others sit under Other states and boards (n).Twenty-seven exporters cover UDISE+, the state student portals, CBSE, CISCE and state boards, scholarship schemes and the teacher module. Your state and board come first.14
    2/compliance/exports/[key]Read a card: the exporter name, the portal, a description, the number of columns and a badge Verify template (or Template verified). Click Open on UDISE+ student module (SDMIS).

    Callout: Every exporter is marked Verify template on purpose: portals change their headings yearly. Compare with the portal's current template before uploading.

    The exporter page with a Blank template button in the header, an info box Verify against the current template, a Filters card, the counts Rows, Errors, Warnings, the Validation report and the Column mapping card.Each card tells you which portal the file is for and how many columns it has. The verify badge is a reminder that portal templates change every year.15
    3/compliance/exports/[key]In Filters choose the Academic year and, for student exports, a Class (or All classes). Board exporters add a Classes choice such as Class 9 & 11 (registration); the RTE exporter asks for a Month. Click Check data.The counts refresh: Rows (students in the export), Errors ("Portal is likely to reject these rows") and Warnings ("Blank optional fields, data to enter on the portal").Check data runs the whole export in memory and tells you what the portal would reject before you waste an upload.12
    4/compliance/exports/[key]Open the Validation report. Expand a portal column (for example Aadhaar Number of Student or Mother Tongue) to see each issue: Error: or Warning: with the message and the student's name and class.Up to 25 issues per column with a Fix link each; a column that can be filled from the Extra fields grid shows Fill in Extra fields →. If there are more, the note says …and n more (download the issue list).Aadhaar numbers are never stored, so every Aadhaar column is exported blank and flagged: a warning when the last four digits are on file, an error when nothing is.16
    5/students/[id]/editClick Fix on an issue.

    Callout: Staff exporters link to the staff profile instead.

    The student's edit form opens. Correct the field (for example add the PEN or set the mother tongue), save, return to the exporter and click Check data again.Fix takes you straight to the student's record, so you correct the data at the source and every future export is right too.13
    6/compliance/fieldsClick Fill in Extra fields → for a state-only column (for example Banglar Shiksha student code).The Extra fields grid opens filtered to that field group and class (next lesson).Some columns have no home on the student form at all. For those, the link opens the grid where that state-specific data lives.13
    7/compliance/fieldsWhen errors are down to zero (or you accept the rest), click Download CSV (n). Optionally click Download issue list to get the validation report as a CSV for the office.A UTF-8 CSV with BOM downloads; it opens cleanly in Excel. The download is written to the audit log as a sensitive export.If the portal insists on .xlsx, open the CSV in Excel and save it as .xlsx; the columns are already in the portal's order.14
    8/compliance/fieldsClick Blank template in the header.A CSV with only the header row downloads, useful to compare against the portal's own template.The blank template is just the headings, handy for checking against the portal's own sample file before you upload anything.12

    Outro voice-over

    • A portal-ready CSV whose errors you have seen and fixed, and an issue list for anything still outstanding.

    After the video is published

    Add its YouTube id under compliance-portal-exports in src/lib/help/videos.ts, with a chapters map of step number → seconds. The lesson page then shows the video and a “Watch this step” link on every step. See the video production guide.