Select the project you want to work on from the Apps screen.
Go to the UI Design module.
Add a Button from the Elements section on the left panel.
From the + ADD ACTION menu, add the Export > Import Mapped Excel action according to the desired trigger event (Initial Actions, OnClick, OnBlur, etc.).
Click on the three dots button on the right side of the action → select the Edit Import Action option.
Action Configuration Steps
1. Database Selection
Select the target table from the Managed DB field.
2. Primary Key Definition
Primary Key: If updating, select a unique column (e.g., user_id).
3. Column Mapping
Alias: The corresponding column name in the Excel file (nickname for easy reading).
Required: Check this box for columns that cannot be left blank.
Hide: Disables columns that users should not see or update.
Foreign Key: If the column is related to another table, logical matching can be performed.
4. Preview
Click the Preview button at the top right → click the button to launch the Excel upload modal screen.
Uploading and Mapping the Excel File
Click the Upload Excel File option.
Upload the Excel file.
If the file contains multiple pages, select the appropriate page.
Map the Excel columns to the system columns.
Define default values for empty cells.
NEXT button to start importing the data.
Data Import Failure
If the data has been partially added/updated and some of it has failed, the relevant error messages will be displayed on the screen.
Ensure that the rows are unique with the primary key you selected.
If they are not unique, multiple rows will be updated.
Important Notes:
The Excel file should not contain merged cells or formulas.
The Excel file format you upload must be Excel 2007 or a newer version.
By following these steps, you can successfully configure the Import Mapped Excel action on the Kuika platform.
