Fields for matching settings

Format

The Matching File Format screen will change depending on the selection.

CSV

: CSV data

Format

: Format data

Excel

: Excel format

Database Table

: Database table data

Comment

Comment about the matching file to be set

ID

ID for identifying the matching information.

Specify a format ID, a CSV ID, an Excel ID, or a database table ID, according to Format.

This must be specified if Format is not CSV.

File name

The matching file name used for the matching process. This is not displayed if Format in the matching settings is Database Table. Use the absolute path or the relative path to specify this.

The same file as an input file and output file, standard input $STDIN, and standard output $STDOUT cannot be specified. If you specify any of these, upon execution, an error occurs.

Omit ID

Specify this if you do not specify a CSV ID. If you select this, Delimiter and Enclosure character are active.

Delimiter

Select a delimiter. You can specify it when you select Omit ID.

Delimiter (hexadecimal)

If Enter hexadecimal value is selected for Delimiter, specify a delimiter. Enter the value by using hexadecimal characters.

Enclosure character

Select an enclosure character. You can specify it when you select Omit ID.

Enclosure character (hexadecimal)

If Enter hexadecimal value is selected for Enclosure character, specify an enclosure character. Enter the value by using hexadecimal characters.

Check number of fields

If ID is specified, select whether to check the number of fields in the actual file and the layout information.

When this check box is selected, upon the data processing execution, if the number of fields in the actual file with the number of fields in the layout information is different, an error occurs. Also, upon the preview, an error occurs.

Use header record

Specify the number of header record rows in the matching file. Select this to not handle the records from the title row to the specified row as data, and to skip them. The values of the rows subsequent to the skipped rows are handled as input data.

Record number

Specify the number of records to skip when Use header record is set to ON. If the title row is 1, you can specify a maximum of 99 records.

Kanji code

Kanji code for the input file. Select Shift JIS, EUC, UTF-8, or UTF-16.

If Format in the matching settings is set to CSV or Database Table, you can select a value from Shift JIS, EUC, UTF-8, or UTF-16.

If Format in the matching settings is set to Excel, the kanji code type is fixed as UTF-8.

Unicode byte order

UTF-16 byte order.

If UTF-16 is selected for Kanji code for the input file, specify the byte order for the input file.

Same as host

: Uses the same byte order as the hardware of the connection destination (Windows, UNIX).

Big-endian

: Uses big-endian.

Little-endian

: Uses little-endian.

EBCDIC set

One-byte codeset type.

Specify the one-byte codeset type if the kanji code of the matching file is EBCDIC-type or JIS encoding.

Specifiable encoding set types are as follows.

Line break code

Specify a line break code as a hexadecimal number.

Data up until this line break code is determined to be a record.

When Kanji code is UTF-16, enter a 4-byte or 8-byte character. In other cases, enter a 2-byte or 4-byte character.

Handling of multiple keys

Specify the processing for when multiple key values exist for the matching file.

Treat as an error

: It will cause conversion error.

Do not treat as an error

: If the key matches multiple records, it will be processed as input data for multiple records.

For details, see DataMagic Operation Manual.

Keys are unique

If the key value for the matching file is unique, specify this field. If the check is set to ON, conversion is faster compared to when it is set to OFF. However, the check is enabled only if the following condition is met:

• Treat as an error is set in Handling of multiple keys.

• The condition for AND, OR for conditional expression is only 1.

• Set either == or Equals as the comparative operator for the condition.

• If Format for the input file is Hierarchy Format or Multi Format, the fields or types referenced in each condition are all the same.

Handling of no keys

Specify the processing to be performed when no value matches the key value of the input file in the data of the matching file.

If Do not treat as an error is specified for this field, you can set the default value.

Treat as an error

: It will cause a conversion error.

Do not generate an error

: If Default value is set, Default value is used. If Default value is not set, the Default value of the field type is used.

For details about the default value of the field type, see DataMagic Operation Manual.

Default setting value list

If Do not treat as an error is selected for Handling of no keys, a list of ID fields of the set layout information is displayed. Specify the default value to be set when no matching field exists at the time of matching.

Field No.

: The field number that is automatically assigned

If CSV with no ID specified is selected in Format, the user is required to perform the setting

Field Name

: The field name set for the layout information.

Input type

: The input type of the default value.

You can specify Character string and Character string (Hexadecimal).

Default value

: The value to be set against the record that does not match to the condition during the matching.

If Input Type is Character string, specify this value with 9999 bytes or fewer. If Input Type is Character string (Hexadecimal), specify this value with 9998 bytes or fewer.

The specified value will be converted to that input type at the time of output. Therefore, if a value not appropriate for the input type is specified, a conversion error occurs.

= Remarks =

The default value set as Character string (Hexadecimal) is interpreted as the kanji code type of the matching file.

Expansion method

Specify the processing method of the matching file at the time of conversion execution.

Expand to memory

: The matching file is expanded to the memory and processed.

It can convert faster compared to Expand to a file.

Expand to a file

The matching file is expanded to the temporary file (a file created temporary to save the working data) and processed. For details about the temporary file, see DataMagic Operation Manual.

Handling of trailing spaces after character data

How a fullwidth space or a halfwidth space after a character is handled when the character data of the input file and of the matching file are compared.

Do not trim

: Data is compared without trimming the fullwidth space and the halfwidth space.

Trim

: Data is compared after trimming fullwidth and halfwidth spaces. For example, AAA○△ will be compared as AAA (where the ○symbol represents a halfwidth space, and the △ symbol represents a fullwidth space).