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

3. Add a Button element.

4. 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.

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

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

‍

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

3. Match the Excel columns with the corresponding source columns in the table.
4. If the Excel column contains empty values, enter the default value.

5. Click the NEXT button when complete.

Failure to Import Data

• If the data has been partially inserted/updated and some of them failed, the corresponding error messages will be displayed on the screen.

• Make sure that the rows are Unique with the primary key you selected.
  
  • If not unique, multiple rows will be updated.

Important Notes:

• The Excel file must not contain combined cells or formulas.
• The Excel file format you uploaded must be Excel 2007 or newer.

By following these steps, you can successfully configure the Import Mapped Excel action on the Kuika platform.