Import Table Data (CSV)

Import Data (CSV)

  1. Click 'Table management' in "Manage" screen, and then 'Table management' view is opened.
../../../_images/img_01.en224.png
  1. Select table to import data, and then right-click 'Import table data' menu.
../../../_images/img_02.en209.png

Tip

Just CELF database (default) in 'Database to connect to' can import table data.

  1. Configure import settings in the 'Import table data' dialog.
../../../_images/img_03.en173.png

[1] File name

Specify the importing file name with the location (.csv).

[2] Char encoding of the file (Initial Setting: Shift-JIS)

Specify the character encoding of the file to be imported.

[3] Register with specified ID (Initial Setting: Checked)

Register with the value specified in the ‘ID’ columns. If this is not checked, ID value is registered automatically.

[4] Register with specified ‘LAST_UPDATER’ and ‘LAST_MODIFIED’ (Initial Setting: Checked)

Register with the values ​​specified in the ‘LAST_UPDATER’ and ‘LAST_MODIFIED’ columns. If this is not checked, these values are registered automatically.

[5] Empty the table and import (Initial Setting: Not checked)

The data will be added to the table. If this is checked, the existing data will be deleted before importing the data.

Attention

  • Please specify the column names in the header row of the CSV file.
  • If 'Register with specified ID' is checked, an error will occur if the ID is duplicated in the existing data and table data file to be imported, and registration is not possible.
  • You can not restore deleted data. If you check ' Empty the table and import', make sure that you really want to delete the data.
  • If the "Empty the table and import" checkbox is checked and the import fails, the data is deleted and not restored.
  • Please make sure to back up all necessary data before importing.
  • If the specified character encoding is different from the character encoding of the file to be imported, an error will occur and registration will not be possible. Please select the same character encoding as the file or change the character encoding of the file and re-run.

Tip

  • If 'Register with specified ID' is not checked, 'ID in the table column can be omitted from the file, and the value is automatically set and registered at import.
    (Even if the value of "ID" is set, the value is not registered.)
  • If 'Register with specified LAST_UPDATER and LAST_MODIFIED' is no check, the 'LAST_UPDATER' and 'LAST_MODIFIED' columns is optional.
    When importing, the login user ID is automatically registered to 'LAST_UPDATER', and the registration date is automatically registered to 'LAST_MODIFIED'.
    (Even if the value of 'LAST_UPDATER' and 'LAST_MODIFIED' is set in the file, that value is not registered.)

  • If you check 'Empty the table and import', the ID will be reset. (If you do not check 'Register with specified ID', the ID will be a sequential number from 1.)

Hint

Table data file to import must be created in advance. Regarding exporting table data, refer Export Table Data (CSV).

  1. Click 'Register' button.

Important

To import table data, users require the following permissions.

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

Related keywords

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