Skip to content

VSN-2046 : Implementing mass importation of dynamic validated passengers excel sheet related to their circuits data.

yassine.elazami a demandé de fusionner VSN-2046 vers develop

Merge Request Summary

Feature: Mass Importation of Validated Passenger Data for Circuits

This merge request introduces a comprehensive implementation for importing dynamic passenger data from Excel sheets into the preparation service. The work ensures that validated passenger information can be ingested in bulk, mapped to circuit structures, and integrated with external contract references. The solution emphasizes robust validation, clear data mapping, and extensible service logic to support future enhancements.

Scope of Changes

Backend

  • Data Importation Logic

    • Implemented the core functionality to process Excel sheets containing validated passenger data.
    • Introduced a new Imported Circuit DTO to encapsulate imported data in a structured format.
    • Defined new mapper classes to transform raw Excel input into domain entities.

  • Validation Enhancements

    • Added type-based validation tests to ensure data integrity during import.
    • Implemented specific validation rules for string, numeric, and date fields.
    • Established exception message constants to provide clear error feedback when validation fails.

  • Service Layer & Contracts

    • Defined new method signatures for handling import operations, ensuring a clear contract at the service level.
    • Finalized contract retrieval implementation to support external references during import.
    • Added external API call integration to fetch contract data dynamically, ensuring consistency between imported passengers and contractual obligations.

  • Feature Exposure

    • Introduced new endpoints to expose import functionality to external consumers.
    • Ensured separation of concerns by isolating import logic from existing preparation workflows.

Documentation

  • Updated the changelog to reflect the addition of mass importation features and validation improvements.
  • Provided clear notes on new endpoints, DTOs, and validation rules for maintainers and integrators.

Key Benefits

  • Enables efficient bulk importation of validated passenger data, reducing manual entry and potential errors.
  • Ensures strong data integrity through comprehensive validation rules across multiple data types.
  • Provides extensible service contracts and method signatures for future enhancements.
  • Integrates external contract references seamlessly, ensuring imported data aligns with business rules.
  • Improves maintainability by centralizing import logic and validation in dedicated components.

Related Commits Overview

  • Added file validation tests on type.
  • Updated changelog documentation.
  • Finalized importation logic and DTO definition.
  • Defined new mapper for data transformation.
  • Implemented contract retrieval and external API integration.
  • Introduced exception message constants for validation errors.
  • Added endpoints to expose import functionality.
  • Implemented string, numeric, and date validation rules.

This MR completes the foundation for mass importation of validated passenger data into circuit preparation workflows, ensuring end-to-end consistency from Excel ingestion to contract integration.

Closes VSN-2046

Modification effectuée par yassine.elazami

Rapports de requête de fusion