Screen 8: Upload Screen

Pre-Requisites

• 1. Decide the Structure of the Upload file and create a RAW table with the name  'omni_upload_<specific name>' - this will be the table to which the Upload file will be copied into.

1. Create an SP to Process Data from the RAW table to the final table(s) in OMNI.

The steps to be followed to create a Bulk Upload Screen are:

• 1. Create a PAGE using the OMNIBulkUploadPageTemplate.

     1. When a PAGE is created with this template automatcially 4 modules are added to the template.

        1. Module 1: Shows the Structure of the file - which can be either a CSV, XLS or XSLX

        2. Module 2: Shows the Upload File Control.

        3. Module 3: Shows a DataGrid that will display the uploaded data.

        4. Module 4: Shows Process Upload Control - this will execute an SP that will copy the data from the Raw Table to the final table.

  2. Configure the 4 modules in the page.

• • 1. Edit the First Module - change the name of the RAW Table.

       1. The RAW table is the table to which the excel file will be copied into. The structure of the RAW table and the excel file must match EXACTLY. The RAW table must be named as 'omni_upload_<specific name>'. The data is initially copied into the RAW table and then is processed into the final tables.

    2. Edit the Second Module - configure the Bulk Upload Action

• • • 1. Change the Table that will be saved into - this will be the RAW table.

• • 3. Edit the 3rd module - configure the DataGrid instance that will display the data from the RAW table.

    4. Edit the 4th module - Change the name of the SP to be executed to Process the data from the RAW table to the final table(s).

See Video: