Administration Portal

Data Import

4min

Introduction

This guide provides step-by-step instructions for importing data into storage tables using our system's file upload feature. By following these instructions, you will be able to easily populate your desired storage table with data from CSV files.

Uploading Data

  1. Navigate to the storage table where you want to import data.
  2. Locate and click on the "Data" button in the command bar. This will take you to the data page.
  3. On the data page, you will find an "Import" button. Click on it to initiate the data import process.

Selecting and Uploading Files

  1. After clicking the Import button, a dialog box will appear.
  2. To upload your file, you have two options:
    • Drag-and-Drop: Simply drag and drop your CSV file from your file system onto the designated area in the dialog box.
    • File Selector: Click on the designated area to open a file selector. Use the file selector to locate and choose your CSV file for upload.

Configuring Import Settings

  1. Below the file selector, you will find options to configure the import settings:
    • Column Delimiter: Select the appropriate delimiter that separates columns in your CSV file.
    • Text Qualifier: Choose the text qualifier used in your CSV file if applicable.
  2. Ensure that your CSV file meets the following requirements:
    • The file must be in UTF-8 format.
    • The file must contain headers, specifying column names.
    • All columns in the CSV file must already exist in the storage table you are importing to.
    • If the CSV file contains more columns than the storage table, the import will be rejected. Please note that this comparison is case sensitive.
    • Exclude any columns that are set to auto increment in the storage table. These columns will be automatically generated and should not be provided in the CSV file.
    • The modify-columns CreatedAt, CreatedByUserId, UpdatedAt and UpdatedByUserId are reserved columns. If they exist in the target table, they will be updated with the User Id and Current time. This is done even if you have these columns in the csv-file. So these columns can be omitted in the csv-file.

Conclusion

By following these instructions, you will be able to successfully import data from CSV files into your storage tables. If you encounter any issues or have further questions, please refer to our support documentation or contact our customer support team for assistance.

Updated 20 Nov 2023
Did this page help you?
PREVIOUS
Storage Tables
NEXT
Processes
Docs powered by Archbee