Import Table Definition

Import Table Definition

  1. Click 'Table management' in "Manage" screen, and then 'Table management' view is opened.
../../../_images/img_01.en225.png
  1. Click the import icon next to '+ New Table' on the 'Table management' view.
../../../_images/img_02.en210.png

Tip

Only table definitions of CELF database (default) in ‘Database to connect to’ can be imported.

  1. Select the format of the file to be imported and select the file to import.
../../../_images/img_03.en174.png

Tip

When selecting a file, the 'Create table' dialog will be displayed with the table name, column name, and column type as shown below:

../../../_images/img_04.en149.png

Please refer to Create Table for creation of table.

Hint

  • 'CELF table definition file (.clt)' is created by exporting the table definition.

  • In addition to creating the CSV file (.csv) by exporting the table definition, it can also be created in the following format:

    ../../../_images/img_05.en135.png

    Specify the column type as follows:

    Column type In CSV
    Integer integer
    String text
    Number (with decimal point) float
    Calendar date
    Datetime datetime

  • For the CSV file (.csv), omit the 'ID', 'LAST_UPDATER' and 'LAST_MODIFIED' columns. These columns are registered automatically.

  • Regarding exporting table definition, refer Export Table Definition.

Important

To import table definitions, users require the following permissions.

  • Application author
  • Database administrator
../../../_images/celf_help_mascot50.png

Related keywords

read, load, format, comma, separate, separator, delimiter