« Translation Table   |   Excel-Link »

Import and Export of Translation Tables

Administrator
This manual is in pilot operation.

Import of Translation Tables

You can bulk register the contents of a translation table using data registered in an Excel sheet via the clipboard. This feature is called the "Import Function for Translation Tables."

Operation steps:

Format of Importable Data

The import process involves taking data from an Excel sheet via the clipboard. Specifically, you copy the range with the settings from the Excel sheet to the clipboard and import it into the translation table editing screen. Each item should be described in its own column on the sheet.

Below, the format of the importable data is described in detail. If you find it confusing, try exporting an existing translation table, pasting it into an Excel sheet, and importing it back. The exported data can be imported as is because it follows the rules described below.

General Rules on Notation

Uppercase and lowercase letters are not distinguished.

Rules on the Order of Rows

Please arrange the following two command-related rows in order from the top in the copy target range of the Excel sheet.

CLEAR-TRANSLATION-TABLE

Instructs clearing of the period table

ADD-TRANSLATION-RULE

Instructs adding a conversion rule (row) to the period table

The order of these two commands can be arbitrary, but usually, you place the CLEAR-TRANSLATION-TABLE command at the beginning to clear the contents of the translation table, followed by any number of ADD-TRANSLATION-RULE command rows to register the contents.

The CLEAR-TRANSLATION-TABLE command does not distinguish between header and detail rows. That is, you only need to write CLEAR-TRANSLATION-TABLE in the first field.

When using the ADD-TRANSLATION-RULE command, arrange one header row and any number of detail rows. Each detail row corresponds to a row of the translation table you want to register. The header row indicates the meaning of each field in the detail rows.

You can place empty rows anywhere within the copy target range. Empty rows are simply ignored.

The rules for arranging header and detail rows are as follows:

  1. The first row (other than an empty row) in the sequence of the ADD-TRANSLATION-RULE command must be a header row.

  2. You can place any number of "detail rows" after the header row. The fields in these detail rows must be arranged as directed by the immediately preceding header row.

  3. Multiple header rows are allowed.

  4. Detail rows are processed in the order they appear on the sheet.

In the detail rows, appropriate values must be specified for each field indicated by the header row. Therefore, each detail row must have the same number of fields as the preceding header row, and the fields in the header and detail rows must correspond in order.

Below, the method of describing each command is explained.

CLEAR-TRANSLATION-TABLE Command

This command instructs the clearing of the translation table (deleting all entries of "rows (conversion rules)"). Normally, this command is placed at the beginning of the group of commands processing the translation table to clear the existing registration.

To specify this command, write CLEAR-TRANSLATION-TABLE in the first field of the row. There are only header rows, no detail rows.

ADD-TRANSLATION-RULE Command

This command instructs the registration of conversion rules (each row of the translation table). Each row of the detail describes one conversion rule. Conversion rules are registered in the order of the command detail rows, so pay attention to the order of detail rows.

Rules for the Contents of Header Rows

The header row consists of the fields listed below.

Field Name Mandatory Number of Fields Field Position Specified Content (Field Symbol)

Command

✓

One

Always the first field

Fixed value ADD-TRANSLATION-RULE

Record Type

✓

One

Always the second field

Fixed value HDR

Source Code

―

One

Optional

Fixed value CODE_TO_TRANSLATE

Target Code

―

One

Optional

Fixed value TRANSLATED_CODE

The record type HDR indicates that this row is a header row.

Rules for the Contents of Detail Rows

The specified values for each field in the detail rows are as follows.

Field Name Specified Content (Field Value)

Command

Specify the same command as the previous header row

Record Type

Fixed value DTL

This line indicates that the row is a detail row.

Source Code

Each row registers the conversion rule’s respective item.

Target Code

Each row registers the conversion rule’s respective item.

Export of Translation Tables

The contents of a translation table can be pasted into an Excel sheet in the format described for import (the data is exported to the clipboard, then pasted from the clipboard into an Excel sheet). You can modify the contents of this sheet and import it back again.

Operation steps: