Kuika's 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 process, Excel columns can be mapped to database columns and logical primary keys are defined. In this tutorial, you will learn how to use the Import Mapped Excel action.

The Import Mapped Excel action is only supported in web applications.

This training content consists of the following topics:

Adding an Import Mapped Excel action,
Configure Import Mapped Excel parameters.

Add Import Mapped Excel Action

After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
While in the “UI Design” module, open the “Elements” panel on the right side.

Then 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 in the table that is Unique. ¹

In the column mapping table, specify the aliases for the columns. Disable fields in the column mapping table 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.
Check the checkbox in the Req. column for fields that must be nullable but mandatory.
Click on the “NEXT” button to complete the configuration.
Then click the Preview button in the upper right corner.
Click on the button you added from the screen that opens.