« Importable File Formats (Full-featured)   |   Format of Exported Files (Full-featured) »

Import Processing Log

Designer Administrator
This manual is in pilot operation.

The import process is output to a file as a processing log. The file name is automatically assigned. A file name that does not conflict with existing file names is selected, so there is no risk that past processing log files will be overwritten by executing an import.

File Format

The file is in CSV format (comma-separated). The first row is a header row and the second and subsequent rows are content rows. The line break character is LF (line feed).

In the header row, labels used to identify each item in the content rows are output.

For each import data record (a valid row in the import file) and for each Value Field when Value Fields are defined in the Import Specification, two content rows are output. The first row holds the "Pre-translation Value" of each field and the second row holds the "Post-translation Value".

The format above is designed so that it can be easily loaded into Microsoft Excel and so that sorting and data extraction can be performed in Excel.

Item Descriptions

The item contents of each row are as follows.

Item (Column)

Item Content in Header Row
(Item Label)

Item Content in Content Row

Pre-translation Data

Post-translation Data

Line No.

#LINE_NO

A serial number assigned to the import data [1]

(Value Field Label)[2]

#VALUE_FIELD

Label of the Value Field to be imported

Before/After Type

#BEFORE_AFTER

Fixed value "1.BEFORE"

Fixed value "2.AFTER"

Field Value x n
⚠

(Label of each field)

Pre-translation Value
of each field

Post-translation Value
of each field

Value

#VALUE

Post-translation Value of the Value Field to be imported
(that is, the value to be imported)

Cell Value Before Update

#CELL_VALUE_BEFORE_UPDATE

Value of the target cell
(value immediately before the update
by the import data that produced this log data)

Cell Value After Update

#CELL_VALUE_AFTER_UPDATE

Value of the target cell
(value immediately after the update
by the import data that produced this log data)

Severity

#SEVIRITY

If an exception occurs during processing of the import data that produced this log data,
a code indicating the severity of the exception [3] is set.
If no exception occurs, this field is blank.

⚠ The number of "Field Value" columns and their order are as follows:

  • For Simple forms, "Field Value" columns are arranged by listing the dimensions placed in the "Background" after the Key Fields of the input data, in ascending order of "Order" (and if the order is the same, in ascending order of Dimension Label).

  • For Full-featured forms, "Field Value" columns are repeated for the number of fields defined in the Import Specification. Their order is as defined in the Import Specification.

1. Pre-translation Data and Post-translation Data for the same import data are assigned the same line number. Line numbers are also assigned to blank rows.
2. The Value Field Label is output only when Value Fields are explicitly defined in the Import Specification.
3. One of INFO, WARNING, or ERROR is set in ascending order of severity. Refer also to the explanation of "Import Processing Mechanism" and "Exception Handling".