6 shots · about 1 min 06 s of finished video · lesson 8 of Students
Record as
Principal (demo_principal)
Sign in at /demo on a demo-mode build
Screens
/students/import /students
Length
1 min 06 s
narration at ~150 words/min + screen time
Status
Not yet recorded
Before recording
Download the template, upload your spreadsheet, map columns, preview errors and import up to 2000 students with guardians in one go.
| # | Screen | Action (on screen) | Must be visible | Voice-over | ~s |
|---|---|---|---|---|---|
| 1 | /students/import | Open Students → Import. | Header "Import students — Bulk-load the admission register from a CSV. Existing admission numbers are skipped." and card 1. Upload CSV. | Moving from paper or another software? The import wizard loads the whole register in four steps. | 10 |
| 2 | /students/import | Click Download template and open unibandh-students-template.csv in Excel. Fill one row per student. Required columns: First name and Class; one guardian phone per student. Callout: Leave admission no blank to auto-number. Dates work as YYYY-MM-DD or DD/MM/YYYY. | A CSV with headers such as admission no, first name, last name, dob, gender, category, class, section, roll no, father name, father phone, mother name, mother phone, guardian phone, address line 1, district, pincode, admission date. | Start from the template so the columns line up. Only the first name and the class are compulsory. | 11 |
| 3 | /students/import | Save as CSV (UTF-8) and click Choose CSV file. | Card 2. Map columns appears: "We guessed from the header row; fix anything that looks wrong." Each field (First name *, Class *, Date of birth, Father phone…) has a dropdown of your headers or — not imported —. | Column names do not have to match exactly. The wizard guesses from your headers and you correct the rest. | 12 |
| 4 | /students/import | Check card 3. Preview: the count of rows, how many are ready and how many with errors (first 20 shown). Fix errors in the spreadsheet and re-upload if needed. | Ready rows show a green Ready badge; bad rows show the reason in red. An Unknown classes warning lists class names that do not exist in the school. | The preview catches mistakes before anything is saved. Fix the spreadsheet and upload again until the error count is zero. | 12 |
| 5 | /students/import | Click Import 60 students. | Card 4. Result: "60 inserted · 0 failed" and All rows imported., or a table of failed lines with the error. | Rows are imported one by one, so a bad row never blocks the others. | 10 |
| 6 | /students | Click Go to directory and spot-check a few students and their guardians. | The directory count has grown; each student shows class, section and guardian phone. | Spot-check a few rows against the spreadsheet to make sure names, sections and guardian phones landed correctly. | 11 |
After the video is published
Add its YouTube id under students-import 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.