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.