Add the Import Excel Base64 Action

1. Log in to the Kuika platform.
2. Select the project you want to work on from the Apps screen.
3. Go to the UI Design module.
4. Open the Properties panel on the right side.

5. + ADD ACTION menu, add the Export > Import Excel Base64 action according to the trigger event you want (Initial Actions, OnClick, OnBlur, etc.).

Parameter Definitions

Required Parameters

• Excel Base64 (String): This is the Base64-encoded version of the Excel file. This data is obtained directly after the file is uploaded. It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input, or Fixed, and can be linked via the Symbol Picker.

Optional Parameters

• Table Name (String): Used to manually specify the name of the table to be created. If not specified, the Excel worksheet name is used.
• Primary Key Name (String): The name of the primary key column to be defined in the table. If not specified, the system automatically creates a column (usually id).

1. Add a Button element to your page on the Design Panel.
   
   • This button will be used to start the file upload and import process.
   • For example, you can set the button label to “Import Excel Base64”.

2. With the button selected, add an Upload File action from the Actions area.

3. Then add an Import Excel Base64 action to the same button.
4. In the Import Excel Base64 action settings, follow this path via the Symbol Picker: ActionResults → UploadFile → Data
5. Start the process by clicking the Run button.

Once these steps are complete, the Upload File and Import Excel Base64 actions work together to convert the selected Excel file to Base64 format and upload it to the system.

At the end of the process, the data in Base64 format of the uploaded file will be displayed as it appears in the sample Excel file and on the Kuika datasource (example: BookList) screen.

• Dynamic Table Name Definition: You can dynamically determine the Table Name field based on the user. For example, you can name it currentUser.username + ‘Import’.
• Form-Based File Upload: You can receive an Excel file from the user with the File Upload component and import the data instantly by linking the Base64 output of the file to the action.
• Action Chaining: After completing this action:
  
  • Navigate to a list page showing the transferred table.
  • Run SQL Query to perform immediate operations on the transferred data.

Technical Risks and Controls

• Invalid Base64: If there is an error in the encoding, the import will fail. The Base64 output must belong to a valid Excel file.
• Table Name Conflict: If a table with the same name has been created previously, a new table may not be created. Unique names must be used.
• Large Files: If the Excel file is very large, the processing time may increase. If necessary, the Excel file should be reduced in size and transferred in parts.
• Insufficient Permissions: The user running the action must have permission to create tables.

The Import Excel Base64 action automates data import processes, enabling files received from users to be used directly in the Kuika-based system. It is an ideal solution for quickly integrating structures such as lists, inventories, and reports from external systems into the application. It provides significant convenience in table creation, data recording, and integration processes.