Changelog

v1.41.2

🚀 New

• Database-Level Duplicate Detection for Bulk Student Import

  • Added intelligent duplicate detection to prevent re-importing the same students from identical CSV files.

  • Detects existing students by name and mobile number (case-insensitive).

  • Automatically handles duplicates:

    • Creates new enrollments only for new students.

    • Skips existing or already-enrolled students gracefully.

  • Introduced visual status badges in the staging UI:

    • 🟩 Valid | 🟨 Duplicate | 🟧 Existing | 🟥 Already Enrolled

  • Improved transactional integrity and academic metadata handling to ensure new data consistency.

• Organization-Level Data Isolation (Multi-Tenant Security)

  • Added organizationExternalId filters to all key database queries for tenant-level data isolation.

  • Enforced organization-specific access across invoices, students, courses, batches, and dashboards.

  • Strengthened WorkOS-based multi-tenant boundaries, ensuring users can only access data within their organization.

🧠 Improved

• Phone Number Normalization

  • Standardized phone number formatting across imports using country code normalization (+ prefix).

  • Added getCountryNameFromDialCode utility and separated phoneNumber / countryCode fields.

  • Ensures consistent storage and display of phone numbers and country names for both students and parents.

• Unified Country Data Source

  • Centralized all country data in a single shared constant (countries.ts under 0eg-shared).

  • Removed duplicate definitions and updated all references across student and onboarding modules.

• Query Validation & Error Handling

  • Added robust validation to guard against invalid or non-numeric query parameters in loaders.

  • Prevented Prisma-related errors caused by malformed URLs or parameters.

🧩 Fixed

• Session Security

  • Resolved logout issue where user data persisted across sessions.

  • Added secure cookie clearing and cache prevention for proper session termination.

• Duplicate Detection

  • Fixed import logic to correctly handle null or empty lastName values during duplicate checks.

• Header Handling

  • Fixed a header merging issue that caused loss of Set-Cookie and toast notification headers in responses.

• Import Stability

  • Resolved academic metadata creation conflicts during bulk student imports.

✅ Overall Impact
This release delivers major upgrades in data security, import reliability, and session safety.
It enhances multi-tenant isolation, prevents accidental duplicate imports, and ensures consistent, normalized data across all records — resulting in a more secure and stable experience for organizations using EtheraGuru.

🚀 New

• Bulk Student Import via CSV Upload

  • Introduced a powerful CSV-based bulk student import feature for batches.

  • Supports importing:

    • Student personal details

    • Parent/guardian relationships

    • Enrollment data and status

  • Includes server-side CSV parsing with validation, transformation, and duplicate detection.

  • Added staging UI for data preview with progress tracking and real-time validation feedback.

  • Implemented transactional database operations with optimized parent lookups.

  • Supports text-based relationship mapping, automatic fee calculation, and status synchronization.

  • Modern modal flow with dynamic progress updates and concise, user-friendly design.

  • Restricted imports to active batches only to ensure data accuracy.

• Configurable Import Limits & Guidance

  • Introduced configurable 50-student limit per import via STUDENT_BULK_IMPORT_CONFIG.

  • Added upload guidance, warning alerts, and clear validation messages to prevent oversized imports.

  • Server-side validation ensures oversized CSVs are gracefully rejected with actionable feedback.

• Academic Metadata – School Name Field

  • Added conditional school name field for organizations of type Academic Tuition Centre.

  • Created new database table StudentAcademicMetadata linked to Student, Organization, and Branch.

  • Integrated school name field into:

    • Student add/edit forms

    • Student profile view (🎓 GraduationCap icon)

    • Bulk import CSV template and review screen

  • Automatically hidden for other organization types.

  • Updated validation schemas, types, and data access functions accordingly.

🧠 Improved

• Import Workflow Enhancements

  • Implemented per-student progressive import with real-time progress tracking.

  • Added IMPORT_SINGLE_STUDENT intent to support one-by-one import operations.

  • Reorganized modal and upload logic for better error handling and user feedback.

  • Enhanced staging flow to validate both data and relationships before final commit.

  • Added visual feedback for upload limits and import stages.

• Data Access & Validation Improvements

  • Strengthened input validation in all loaders (invoices, student, batch, and workspace).

  • Added Number.isFinite() checks for query parameters to prevent NaN and invalid data errors.

  • Default fallbacks applied for invalid query strings:

    • Invoices → Pending (1)

    • Courses/Batches/Students → Active (2)

    • Nested Invoice Views → All (-1)

  • Prevented server errors from malformed URLs such as /workspace/invoices?statusFilter=foo.

• Technical Architecture

  • Improved separation of validation and transformation for stronger type safety.

  • Server-side parsing avoids browser memory issues with large CSVs.

  • Simplified constants and naming across import and enrollment modules.

  • Cleaned up unused files (e.g., removed erroneous course-get-with placeholder).

• UI & UX Enhancements

  • Added progress-driven UI elements for better clarity during imports.

  • Updated error messages and feedback flows for improved transparency.

  • Streamlined design consistency across modals, lists, and import review views.

  • Polished form and validation feedback visuals across academic and student modules.

🧩 Fixed

• CSV Gender Parsing

  • Fixed parsing of the gender field by switching from numeric to string-based handling.

  • Prevented validation errors for values like “Male” or “Female.”

• Import Error Handling

  • Corrected the sequence of error and data handling in the bulk upload process.

  • Ensured validation errors display before processing valid records.

• Query Parameter Crashes

  • Fixed potential 500 errors from invalid URL parameters across multiple loaders.

  • Added safe guards and default fallbacks for all workspace query strings.

✅ Overall Impact
This release introduces robust bulk student import, academic metadata support, and enhanced system resilience.
Users can now efficiently onboard multiple students, track progress in real time, and capture additional academic details — all with better stability, smarter validation, and cleaner UI workflows.

🚀 New

• Workspace Filtering, Sorting & Reloading

  • Added complete filtering, sorting, and reloading support across all workspace types — Courses, Batches, Students, and Invoices.

  • Introduced local filtering and sorting within nested tabs (e.g., batches under courses, students under batches).

  • Enabled intelligent selection clearing when filters change and current items no longer match.

  • Added loading indicators and improved icons for sorting, filtering, and refresh actions.

  • Implemented URL persistence for filter and sort states for seamless navigation.

  • Improved dropdown UI for filters and sorting, ensuring consistent design and behavior.

  • Enhanced workspace navigation and state management for a smoother user experience.

• Invoices in Workspace Navigation

  • Added new Invoices section at /workspace/invoices.

  • Paginated list view with latest-first sorting, quick preview, and detailed view with actionable buttons.

  • Added semantic action buttons: Download (Blue), Finalize (Orange), and Paid (Green).

  • Displayed course/batch badges with “+N” shorthand for multiple items.

  • Added invoice metadata badges (period, due date, paid date).

  • Integrated with workspace loader for seamless performance across all sections.

🧠 Improved

• Unified Workspace Experience

  • Standardized empty-state messages and actions across all workspaces.

  • Updated empty-state titles and icons (replaced FileText with AcademicCapIcon).

  • Replaced “Generate Invoice” with “Add a Course” for better clarity.

• Enhanced Filtering, Sorting & Icons

  • Consistent filter dropdown visuals and icon usage across all modules.

  • Introduced intuitive sorting icons:

    • AArrowUp/Down → Name sorting (A–Z / Z–A)

    • BarsArrowUp/Down → Date sorting (Ascending / Descending)

• Data Access & Logic Updates

  • Added statusFilter, sortBy, and originalStatus parameters in all paginated list APIs.

  • Fixed invoice status filter bug (showing incorrect “Draft” invoices as “Pending”).

  • Ensured filtering and sorting work uniformly across data layers and UI components.

  • Updated shared constants and naming conventions for consistency (COURSE_STATUS_OPTIONS).

• Dashboard & Financial Metrics

  • Fixed total revenue calculations to exclude draft and carried-forward invoices.

  • Corrected paid amount calculations to rely on invoice totals rather than payment records.

  • Removed Average Fee metric for clarity and cleaner dashboards.

  • Updated all TypeScript interfaces and data models accordingly.

• UI & Theme Enhancements

  • Added white logo for dark mode (logo-white.png) for improved visibility.

  • Updated SettingsList to automatically switch logos based on theme.

  • Cleaned up workspace kebab menus, removing outdated options like “Generate Invoice”.

  • Updated timestamps and minor UI adjustments in dashboard and business modules.

🧩 Fixed

• Made all workspace searches case-insensitive (students, courses, batches, invoices, payments).

• Fixed nested tab filtering conflicts within workspace navigation.

• Resolved dropdown styling issues and missing content in some filter menus.

• Improved invoice display consistency in detail view and enrolled course sections.

• General cleanup of unused imports and variables across files.

✅ Overall Impact:
This release brings major usability improvements to the EtheraGuru workspace — unified filtering, sorting, and reloading across all modules, enhanced financial accuracy, a fully functional invoice management workspace, and a smoother dark theme experience.

Added full CRUD operations for line items in draft invoices to enable recording of existing due amounts during student enrolment. This feature is perfect for business onboarding scenarios where students have outstanding dues from previous periods.

✨ Key Features

• ➕ Create new line items with custom descriptions and amounts

• ✏️ Edit existing line items (description, quantity, unit price, discount)

• 🗑️ Delete line items with confirmation dialog

• 🔄 Automatic invoice recalculation when line items are modified

• 🔒 Draft-only editing - all operations restricted to draft invoices (status 0)

🎨 Enhanced User Interface

• 📋 Invoice preview enhancements with "Add Item" button for draft invoices

• ⚙️ Edit/delete actions for each line item in draft invoices

• ⚡ Real-time amount calculation in forms

• 📱 Responsive design with Dialog (desktop) and Drawer (mobile) modals

💼 Business Impact

Enables complete financial tracking from day one by allowing users to:

• 📊 Add manual line items like "Outstanding dues from December 2024" with exact amounts

• 🎯 Record pre-enrollment amounts during student onboarding

• 📈 Maintain complete financial visibility and reporting accuracy

🔧 Technical Improvements

• ✅ Comprehensive validation schemas for all line item operations

• 🛡️ Enhanced TypeScript type safety across invoice management

• 🚀 Improved form submission handling with auto-close functionality

• ⚠️ Proper error handling and user feedback throughout

Release Type: First Production Beta
Date: 9th October 2025

We’re thrilled to announce the first production release of EtheraGuru, our next-generation Tutoring Management System (TMS) built for modern institutes.
This Beta version introduces our core product foundation, with powerful tools to help you manage courses, batches, students, and billing—all in one place.

🆕 New

• Enterprise-Grade Authentication
  Secure and flexible sign-in options, including Google, Passkeys, Passwords, and Sign-in Codes.
  Single Sign-On (SSO) supported for enterprise users for seamless access.

• Course & Batch Management
  Create, edit, and organize courses with multiple batches.
  Supports flexible academic or coaching models with real-time status updates.

• Student & Family Management
  Record student details and link multiple students under a single parent/guardian account for easy family-level access and tracking.

• Streamlined Enrollment
  Enroll students into batches with automated fee assignments, track history, and manage batch capacity effortlessly.

• Automated Invoicing
  Configure invoice generation globally or per enrollment.
  Invoices are automatically generated and marked as overdue when due dates pass.

• WhatsApp Notifications
  Instant WhatsApp alerts for invoice generation and updates.
  Parents can easily opt out or back in using STOP/START commands.

• Payment Recording
  Manually record payments with full tracking.
  Invoice statuses automatically sync with payment entries.

• Insights Dashboard
  Real-time visibility into enrollments, payments, outstanding invoices, and overall business performance.