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
Download the file and then extract the contents.
- 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). - The above 3 files are located in the same folder
Open the epa 실행.xlsb file, minimize the window, and then open the 매출계획 입력장표(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.