What is the EPA Module?

The need for automating data retrieval and upload processing related to Cross-Tab screens has been growing.

To address this, the EPA utility is used to set up more efficient data operations. This guide provides steps for utilizing the EPA utility to streamline data work.

Creating a Cross-Tab Data Aggregation Screen

Analyze the requirements and define the screen in Excel (you can directly use the business file).

Using the EPA Utility

By utilizing the EPA (Enterprise Process Automation) utility, you can automate data retrieval and upload processes.

Below are the steps to configure the EPA utility.

Download the EPA Utility

• File download : EPA.zip

1. Download the file and then extract the contents.

2. You can find the following files inside the generated folder: (epa 실행.xlsb, epa_template.xlsx, Example screen 
   (Sales Plan Input Template (EPA).xlsx) - This can be changed to an actual business Excel file).
3. The above 3 files are located in the same folder

Open the Run the epa.xlsb file, minimize the window, and then open the Sales Planning Input Form (EPA).xlsx file.

Create data Mapping Key

Enter the values for DATA_NAME, ROW_CD, and COL_CD according to the table format.

Specify the data CRUD area.

Specify the area where the data will be entered and define the name.

(EX. upload1, upload2, …)

Create and verify the EPA temp file

Press [Ctrl + M] to open the EPA Developer popup window.

By clicking the button to execute, you can find the 'temp' file created as EPA 실행 in the folder.

Verify the EPA temp file.

Open the temp file and check the 'T1 sheet', 'U1 sheet', and 'P1 sheet'.

Using the MX-Grid component

The automatically generated temp file is converted to a web screen using the MX-Grid component of the i-AUD tool.

Afterward, CRUD operations can be efficiently registered using the DB bot and process bot.