The Import Mapped Excel action allows you to import any Excel file into an existing table in your database. No prior knowledge of the table structure is required. During this operation, Excel columns can be mapped to database columns and logical primary keys can be defined.

Import Mapped Excel action is only supported in web applications.

This training content consists of the following topics:

Add an Import Mapped Excel action
Loading and mapping Excel file

Add Import Mapped Excel Action

Log in to the Kuika platform and open the project you will work on from the Apps screen.
Switch to the UI Design module and open the Elements panel on the right side.

Add a Button element.

To add the action to the Button element, select Onclick → Export → Import Mapped Excel from the + ADD ACTION drop-down menu on the right panel.

Click the ellipsis icon next to the action title and select Edit Import Action.
In the drop-down menu, select the relevant data table from the Managed DB field.

In the Primary Key field, select a field that is Unique in the table.
In the Column mapping table, specify the aliases of the columns.
Disable fields that you do not want the user to see/update.
- Note that columns that cannot be left blank cannot be disabled.
Define aliases in the Alias column for each database column listed.
Select a logical primary key for foreign key database columns.
For fields that must be nullable but mandatory, select the check box in the Req. column.
Click the NEXT button to complete the configuration.
Click the Preview button in the upper right corner.
Click on the button you added from the screen that opens.

‍

Upload and Map Excel File

From the modal that opens, click Upload Excel File and upload the Excel file you want to import.
If there is more than one sheet, select the sheet you want.