Diode: Unstructured File Processing Implementation

Owned by Rajeev Rai
Last updated: Sept 24, 2024
1 min read

Learning Objective:

  • Automate file processing: Automatically process unstructured files (e.g., PDF, Excel) received from customers.

  • Standardize format: Convert the files to a standard format for consistent processing.

  • Data insertion: Insert processed data into the Oracle database.

  • Failure notifications: Notify Customer Service Representatives (CSRs) in case of processing failures.

Key Use Case:

Key Roles:

  • Customer Service Representatives (CSRs): Receives unstructured files from customers.

  • System: Processes files, converts them into a standard format, and inserts data into Oracle.

Process:

  1. File Reception:

    • CSR receives unstructured files (e.g., PDF, Excel) from customers.

  2. File Processing:

    • System processes these unstructured files using the Diodes_Unstructured_PO_Process workflow.

    • Files are mapped from their original layout to a standard format.

  3. Data Insertion into Oracle:

    • After standardization, data from the files is inserted into the Oracle database.

  4. Notifications:

    • If any failures occur during the process, the system automatically notifies the CSR.

Templates and Reusability:

  • Templates: Predefined templates are created for different types of transactions:

    • Diodes_Unstructured_PO_Template: Used for customer-specific transactions.

    • Diodes_Unstructured_PO_OnDemand_Template: Used for on-demand transactions.

  1. Transaction Types:

    • Example transactions such as Arrow Verical PO use the unstructured PO template.

    • OnDemand transactions use the on-demand template for instant processing.

  2. Error Handling:

    • Files that encounter issues during processing are stored in an error file location and appropriate notifications are sent to the relevant parties.

This use case demonstrates the automation of file processing, data integration, and notification handling for unstructured file inputs within the Diodes implementation​(Unstructured File Proce…).

Object Zip

Click Here to download the Object Zip

Â