Import Excel Base64

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

       3. Select “Initial Action> Export> Import Excel Base64” from the “+ ADD ACTION” drop-down menu.

       4. Configure the “Excel Base64” field from the drop-down menu. This field is the field where the Base64 value of the Excel file to be imported is written.

1. Click on the “ + ADD OPTIONAL PARAMETER” (1) drop-down menu.

2. Configure the following parameters from the drop-down menu:
   
   
   • Table name: Allows you to define the table name where the data you import will be written.
   • Primary key name: Defines the name of the primary key of the data you are importing.some text
     • If a row has a key value (Primary Key) and this field is empty in Excel, the data will be inserted as a new record.
     • If the key value exists and the field in Excel is full, the existing record is updated.
     • If the key value is not entered, the platform automatically accepts it as “Id”.
       
3. Then click on the “SAVE” (2) button to complete the configuration process.