Versions Compared

Old Version 6

changes.mady.by.user Deepak Kumar

Saved on

compared with

New Version 7

changes.mady.by.user Deepak Kumar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. File Pickup and Validation:

    1. The process initiates upon detecting a canonical XML file in the designated FTP location.

    2. It picks up the file and proceeds to validate its content against predefined data integrity rules and formatting standards.

    3. Record Categorization:

      • Upon validation, records within the XML file are categorized into two main groups:

        • Good Records: Records that pass validation and conform to specified standards.

        • Error Records: Records that fail validation due to discrepancies or errors.

    4. Output Generation:

      • The validated and categorized records are processed to generate a final output file in a specified format.

      • The output file is then delivered to the configured output FTP location as per the user-defined filename pattern.

    5. Reporting and Notifications:

      • In cases where validation fails for any records, the system generates detailed data discrepancy reports.

      • Email notifications are sent to designated recipients to alert them of validation failures and provide necessary details for corrective actions.

  2. Key Components:

    • FTP Event Trigger: This process flow is triggered by the detection of the canonical XML file in the FTP location, ensuring timely initiation and processing of data validation tasks.

    • Template Management: The process includes the capability to manage templates associated with the output file format, ensuring consistency and compliance with organizational standards.

    • User Configuration: Users can configure the output FTP location and define the filename pattern for the generated output file through a dedicated transaction interface, facilitating flexibility and customization based on operational requirements.3.

  3. Customs Plugin Details: UNUM_CP_ExcelColumnName_Handler

    Description:

The UNUM_CP_ExcelColumnName_Handler Customs Plugin serves the purpose of standardizing Excel column names by removing numerical suffixes such as "_Numbering (_1, _2, _3)" from the column names.

Functionality: This plugin is specifically designed to transform column names in Excel files, ensuring consistency and clarity in data representation. For instance, it seamlessly converts column names like "BenefitID_1" and "BenefitID_2" to "BenefitID" by eliminating numerical suffixes.