1.1 Upload Framework
This topic describes a standard framework for uploading records.
Upload Framework supports the upload of both maintenance and transaction screens. Different steps involved in Bulk Upload are listed below:
- Data is populated in the upload tables through Macro Excel Upload or any other utility.
- Trigger on Master Upload Table would insert entries into a process table with Upload Status as U (Unprocessed). One entry would be inserted into the process table for each record. Function ID would also be updated in the process table along with other information.
- Upload routine is invoked for a particular function ID by the user from CVDUPLOD screen/stub.
- On processing the routine, the system would process all the unprocessed records from the process table for the particular function ID. This would be done using a cursor on the process table.
- An adapter package converts the upload table types to base table type data. Then it invokes the main package of the function ID.
- After processing of each record, process table columns for uploaded status, error code, etc would be updated by the system.
From the above steps, we can derive the components required for a particular function ID to be brought under this framework.
- Process Table
- Upload Tables
- Trigger on Master Upload Table
- Adapter package for Upload Routine
- Wrapper code in CVDUPLOD screen processing logic to call the adapter package based on the function ID
This topic contains the following sub-topics:
- Naming Convention
This topic describes a standard framework for uploading records. - Process Table
This topic describes process table for uploading records. - Upload Tables
This topic provides an overview of the Upload Table. - Trigger on Upload Table
This topic describes an overview to trigger the Upload Table. - Upload Adapter Package
This topic describes overview on upload adapter package for uploading records.
Parent topic: Overview of Bulk Upload of Records