« Checking the System Environment   |   Exporting Data »

Import Data

This manual is in pilot operation.

You can import data into sheets. Importing is available in either [Browser] or [Contributor]. To enable importing, the form must be configured for import in the form design. To confirm whether importing is available for a specific form, consult the Designer.

Importable File Formats

Refer to the document Importable File Formats.

For items described in the above document as dependent on the form design, consult the Designer or Administrator.

Import Procedure

Before importing, make sure to configure the Encoding.

Importing from a Comma-Separated Values File (CSV File)

  1. Launch [Browser] (or [Contributor]) and log in to the application.

  2. Navigate to the data entry screen using sheets (the navigation method differs between [Browser] and [Contributor]).

  3. From the menu, select Action  Import
    The Import File Selection dialog box is displayed.

  4. Select the import file and click the Import button.
    The import process is executed and the number of processed items is displayed.

Importing Data from the Clipboard (fusion_place >= 14.1)

  1. Launch [Browser] (or [Contributor]) and log in to the application.

  2. Navigate to the data entry screen using sheets (the navigation method differs between [Browser] and [Contributor]).

  3. Select and copy the range on the Excel sheet that was created based on the import specification.

  4. From the menu, select Action  From Clipboard.
    The import process is executed and the number of processed items is displayed.


⚠ Number of Processed Items

  1. Total Count ・・・ The count excluding blank rows (the count refers to the number of values to be imported, that is, the number of data rows × the number of value fields. Each of the following counts is a subset of this total).

  2. Skipped Count ・・・ The number of rows skipped because #IGNORE was specified in the Translated Code column of the Translation Table.

  3. Warning Count ・・・ The number of rows skipped for reasons such as the target cells not being included in readable areas.

  4. Error Count ・・・ The number of rows skipped for reasons such as no entry in the Translation Table or incorrect member labels.

    If warnings or errors occur, a message screen pops up and displays the information.

    In addition, details of the processing are output to the log file, and the log file name is displayed in the message area.

Refining Import Log Data

You can refine the log data output to the import log based on Severity.

From the menu of [Browser] (or [Contributor]), select Action  Set Severity for Import Log…​ and choose one of the following:

  • Error only

  • Warning and higher

  • Info and higher

  • All