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. 1
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.
Click “Upload Excel File” from the modal that opens and upload the excel file containing the data you want to import.
If there is more than one sheet, select the sheet you want.
Match the Excel columns with the corresponding source columns in the table.
If the Excel column contains empty values, enter the default value.
Click the NEXT button when done.
Screen in case not all rows can be imported:
Screen if data has been partially added/updated and some failed.
The Excel file must not contain combined cells or formulas.
The Excel file format you uploaded must be Excel version 2007 or newer.
1 Make sure that the rows with the primary key you selected are unique. If it is not unique, multiple rows will be updated.
