Import alumni roster
Upload your alumni CSV in any shape. We'll match columns, dedupe, and reconcile against existing claims.
Re-mock of
apps/next/app/college/[slug]/roster/import/page.tsx . CSM does this for the college on Day 0 — the UI exists for re-imports / yearly batch additions. Pairs with
M5 archive upload as the two ingestion surfaces.
Drop your CSV here
Or browse — .csv , .xlsx , .tsv . Up to 500k rows.
Step 1 · Map columns (your file → aumik-alumni fields)
Your column → aumik-alumni field Sample row 1 Sample row 2
Full Name Name Skip Priya Subramanian
Rohan Desai
Email ID Email Skip priya.s@stripe.com
rohan@razorpay.com
Year of passing Batch year Skip 2014
2014
Branch Department Skip CSE
CSE
Mobile Phone (optional) Skip +91 …
+91 …
Hostel Skip Custom — keep as tag Hostel-A
Hostel-D
Step 2 · Reconcile (this is what we'll do)
Action Count Detail
New rows 2,143 First-time entries — invite emails queued. Match existing 9,617 Same email — update name/dept/year if changed. Fuzzy match 187 Likely duplicates — needs human review. Skip 23 Missing required fields (no name or email). Total 11,970 From your file
Run import →
Cancel
Privacy & consent
Imports are PII — only platform admins see raw email/phone
Alumni see "your college uploaded your contact" on first email
Hard delete on alum's request (one-click in their profile)
No outbound email until you click "send invite campaign"
Tips
Year + dept must be present — they drive batch landing pages
If multiple emails per alum (personal + work), upload both rows; we'll merge on first claim
Hostel/club tags survive into directory filters
Need help?
Your CSM (Ravi @ aumik-alumni) does this for the first import. You don't have to touch this screen on Day 0.