Importing Data

This manual is in pilot operation.

Data can be imported into sheets. Importing is possible in both [Browser] and [Contributor]. To enable importing, the form must be designed with import settings configured. Check with the Designer to see if importing is possible for individual forms.

Formats of Importable Files

Please refer to the document "Formats of Importable Files".

For parts dependent on form design mentioned in the above document, please check with the Designer or Administrator.

Import Procedure

Please set the encoding before importing.
  1. Launch [Browser] (or [Contributor]) and log into the application.

  2. Navigate to the data entry screen via sheets (the method varies between [Browser] and [Contributor]).

  3. Select Action  Import…​ from the menu.
    An import file selection dialog box will appear.

  4. Select the import file and click the Import button.
    The import process will execute, and the number of processed items will be displayed.

    1. Total Count ・・・ Number of items excluding blank rows (the count here refers to the number of import target values, i.e., the number of data rows × number of value fields. Each of the following 'counts' are part of this total)

    2. Skipped Count ・・・ Number of rows skipped because the conversion table’s destination code column was specified as #IGNORE

    3. Warned Count ・・・ Number of rows skipped for reasons such as the target cell not being within the readable area

    4. Error Count ・・・ Number of rows skipped due to reasons such as no registration in the conversion table or incorrect member labels

      If there are any warnings or errors, a message screen will pop up indicating this.

      Additionally, details of the process are output to a log file, and the name of that log file will be displayed in the message field.

Refining Import Log Data

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

From the menu in [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