Desktop Device Required

This is a comprehensive web-based application designed for Industrial Training Institutes to manage trainee data, track fee payments, monitor cancelled admissions, and handle PRN (Permanent Registration Number) records. It provides a complete dashboard with analytics and export capabilities.

Go to the Home tab and follow these steps:

• Click on "Choose File" under Trainee Data Upload
• Select an Excel (.xlsx) or CSV file with trainee details
• Ensure your file contains required columns: Name, Father's Name, Trade, Aadhaar Number, etc.
• Click "Upload Trainees" button
• Note: After uploading, the upload option will be hidden until you clear all data

Your trainee data file should include these columns:

• Trainee Name
• Father's Name
• Trade (e.g., Electrician, Fitter, Welder)
• Aadhaar Number (12 digits)
• Date of Birth
• Mobile Number
• Address
• Any other relevant trainee information

Supported formats: Excel (.xlsx) and CSV (.csv)

To manage fee data:

• Go to the Home tab and use the Fee Data Upload section
• Upload an Excel/CSV file with fee payment details
• The file should contain trainee identifiers and payment status
• Visit the Fee Status tab to view payment statuses
• Use filters to view paid/unpaid trainees
• Export fee reports using the XLSX button

The Fee Status tab provides comprehensive fee tracking:

• View all trainees with their payment status (Paid/Unpaid)
• Filter by trade to see specific groups
• Use the search function to find specific trainees
• Export fee status reports to Excel
• Print fee status lists for record keeping

To view trainee details:

• Click the eye icon (👁️) in the Actions column of any trainee row
• A modal window will display complete trainee information
• Aadhaar numbers are displayed in proper format (XXXX-XXXX-XXXX)
• All uploaded trainee data fields will be visible
• Use keyboard navigation (Tab/Shift+Tab) to navigate between trainees

To cancel a trainee's admission:

• Click the ban icon (🚫) in the Actions column
• Select a cancellation date from the date picker
• Confirm the cancellation in the dialog box
• The trainee will be moved to the Cancelled tab
• They will be marked as cancelled in the Home tab
• Cancelled trainees are preserved when uploading new data

Multiple search and filter options are available:

• Universal Search: Use the search box to find trainees by name, father's name, or Aadhaar number
• Trade Filter: Use the Trade dropdown to filter by specific trades
• Sorting: Click column headers to sort data
• Status Filter: In Fee Status tab, filter by payment status
• All filters work together for refined results

The Dashboard provides comprehensive analytics:

• Overview Cards: Total trainees, active trainees, cancelled admissions, fee collection stats
• Trade Distribution Chart: Visual representation of trainees per trade
• Fee Status Chart: Pie chart showing paid vs unpaid fees
• Monthly Trends: Track admissions and cancellations over time
• Filter all charts by trade for detailed analysis

The PRN tab handles registration number management:

• Upload two types of Excel files: PRN Trainee Success Sheet and Registration-PRN Mapping Sheet
• The system automatically combines and deduplicates data
• Removes duplicate StateRegNumber entries
• View consolidated PRN data in a clean table format
• Export to XLSX or print PRN lists
• Search and filter PRN records

Multiple export options are available across all sections:

• Excel Export: XLSX button in Fee Status, Cancelled, and PRN tabs
• PDF Export: Print button generates PDF reports
• Filtered Exports: Export only the currently filtered/searched data
• Dashboard Charts: Visual reports for presentations
• All exports maintain data formatting and structure

To clear all data:

• Click the 'Clear All Data' button in the Home tab
• Confirm the action in the dialog box
• This removes all trainee and fee records
• Re-enables the trainee file upload option
• Note: PRN data is preserved and not cleared
• Use this when starting a new academic session

System requirements:

• Browser: Modern browsers (Chrome, Firefox, Safari, Edge)
• Screen Size: Minimum 1024px width for optimal experience
• JavaScript: Must be enabled
• Storage: Uses browser's local storage for data persistence
• File Support: Excel (.xlsx) and CSV (.csv) files
• No internet connection required after initial load

Data security and privacy:

• All data is stored locally in your browser
• No data is transmitted to external servers
• Data remains on your device only
• Clearing browser data will remove all stored information
• Aadhaar numbers are handled with proper formatting
• Application works offline after initial load