Loading Multiple Files Including ZIPs

Load employee data from multiple uploaded files, including ZIP archives, using Data Load Definitions and PL/SQL.

Suppose HR representatives need to load external employee data from multiple files at a time. They work with different supplier systems that provide the data in Excel format, CSV, JSON, and XML. Sometimes multiple files arrive in a ZIP archive. A Load Employees page in the Woods HR app can meet this requirement by combining:

• Data Load Definitions for each kind of source file (Excel, CSV, JSON, and XML)

• A File Upload page item with Allow Multiple Files enabled

• A custom EMPLOYEES_FROM_FILES procedure that uses:

  • A FOR loop over the uploaded files, calling

  • APEX_DATA_LOADING package to load data using a Data Load Definition, and

  • APEX_ZIP package to process the contents of a ZIP file