Import Excel Base64

Import Excel Base64

Import Excel Base64 enables the transfer of an Excel file in Base64 format to the system and the creation of these data as database tables. Each worksheet in the Excel file is imported as a separate table. The sheet names are used as the names of the tables to be created.

Technical Specifications

  • Excel to Table Conversion: The Excel file in Base64 format is directly converted into tables.
  • Page Name = Table Name: Each page in Excel is converted into a new table in Kuika. Page names are used as table names.
  • Dynamic Table Creation: Each imported page is dynamically structured in the database.
  • Primary Key Definition: If desired, a Primary Key specific to the table can be defined.
  • Web and Mobile Compatibility: Can only be used in web applications.
Import Excel Base64 Action Application Steps

Add the Import Excel Base64 Action

  1. Log in to the Kuika platform.
  2. Select the project you want to work on from the Apps screen.
  3. Go to the UI Design module.
  4. Open the Properties panel on the right side.
  1. + ADD ACTION menu, add the Export > Import Excel Base64 action according to the trigger event you want (Initial Actions, OnClick, OnBlur, etc.).

Parameter Definitions

Required Parameters

  • Excel Base64 (String): This is the Base64-encoded version of the Excel file. This data is obtained directly after the file is uploaded. It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input, or Fixed, and can be linked via the Symbol Picker.

Optional Parameters

  • Table Name (String): Used to manually specify the name of the table to be created. If not specified, the Excel worksheet name is used.
  • Primary Key Name (String): The name of the primary key column to be defined in the table. If not specified, the system automatically creates a column (usually id).
Usage Scenario: Transferring an Excel File to Application Tables

An administrator wants to transfer an Excel file containing a user list prepared outside the system to the application database. This file is sent to the system in Base64 format and each page is converted into a table.

Configuration

  • Element: ‘Import from Excel’ button
  • Trigger: OnClick
  • Action: Export → Import Excel Base64
  • Parameters
    • Excel Base64: uploadFile.base64
    • Table Name: ‘UserList’
    • Primary Key Name: ‘userId’

With this configuration, the data in the Excel file from the external system is converted into a table that can be used within the application.

Import Excel Base64 Action Advanced Customisations
  • Dynamic Table Name Definition: You can dynamically determine the Table Name field based on the user. For example, you can name it currentUser.username + ‘Import’.
  • Form-Based File Upload: You can receive an Excel file from the user with the File Upload component and import the data instantly by linking the Base64 output of the file to the action.
  • Action Chaining: After completing this action:
    • Navigate to a list page showing the transferred table.
    • Run SQL Query to perform immediate operations on the transferred data.

Technical Risks and Controls

  • Invalid Base64: If there is an error in the encoding, the import will fail. The Base64 output must belong to a valid Excel file.
  • Table Name Conflict: If a table with the same name has been created previously, a new table may not be created. Unique names must be used.
  • Large Files: If the Excel file is very large, the processing time may increase. If necessary, the Excel file should be reduced in size and transferred in parts.
  • Insufficient Permissions: The user running the action must have permission to create tables.

The Import Excel Base64 action automates data import processes, enabling files received from users to be used directly in the Kuika-based system. It is an ideal solution for quickly integrating structures such as lists, inventories, and reports from external systems into the application. It provides significant convenience in table creation, data recording, and integration processes.

Other Related Content

No items found.

Glossary

No items found.

Alt Başlıklar