import_excel
Import student records from an Excel file, run validation, column mapping, duplicate detection, and store to database with summary statistics.
Instructions
Import student data from an Excel (.xlsx) file.
Runs the full pipeline: validate → map columns → normalize →
detect duplicates → persist to database → report statistics.
Args:
file_path: Absolute path to the .xlsx file on the server filesystem.
Returns:
Import result with statistics (total, successful, failed, duplicate rows).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |