Skip to content

Import

Overview

Set the import options.

Prerequisites

  1. "Site Management Permissions" are required for this operation.

Cautions

  1. When adding or updating records via "Import," input validation is performed on all fields, even if you restrict the fields to be read from the CSV. If fields that are excluded from the import have input validation settings and contain data that triggers validation errors, an error message to that effect will be displayed in the import dialog.

Operation Procedure

  1. Open the target table.
  2. Click "Manage Table” from the "Manage” menu.
  3. Open the "Import" tab.
  4. After setting, click the "Update" button at the bottom of the screen.

Setting Body

Setting items of the Import tab of the Manage Table screen

Column Name Description Setting Method
Character code Select the default character code for the CSV file Select between [Shift-JIS] and [UTF-8]
Update record with the same key Specify the default behavior for updating records with the same key Specify check ON/OFF
Default import key Select the column to be the default import key Select from the index of columns checked in "Import Key" in table settings

Operation Image

The above settings are reflected as the default values ​​on the import screen that is displayed when you perform an import operation on the target table.
Import screen with the settings reflected as the default values
For information on import keys, please refer to "Specify Key Column When Importing".

Supported Versions

Supported versions Body
1.3.11.2 and later Added a function to allow selection of keys when importing