Fields settings

This section explains the fields of CSV information.

(1) Fields for CSV - Detailed Information

The ID used for recognition of registered CSV information.

Business group

A business group for which general users have access rights.

Alternatively, a business group that is used as a filter condition only.

Comment

Comment about the CSV information.

Enclosure character

The enclosure character attached to character string data.

The characters that you can specify are 0x00, and 0x09 to 0x7E.

If you specify 0x00, the system will operate without enclosure characters. This setting is valid when CSVID is specified during mapping. If you omit CSVID, the settings in the data processing information is applied.

Note

If you select 0x00 as the enclosure character in the CSV information on the input side, all input fields are treated as character data.

Delimiter

The delimiter that separates each field.

The characters that you can specify are 0x09, and 0x20 to 0x7E.

This setting is valid when CSVID is specified during mapping. If you omit CSVID, the settings in the data processing information is applied.

Field Name

The name that identifies the field. Duplicate values cannot be used within the same ID.

Comment

Comment about each field.

(2) Fields for CSV information field settings

Field name

See Fields settings in (1) Fields for CSV - Detailed Information.

Comments

See Fields settings in (1) Fields for CSV - Detailed Information.

(3) Fields for importing items

Import source

Import source.

CSV file, format information, and database table information.

Preview

Content of the read file. A maximum of 1000 fields can be imported. An error occurs if the number of fields is 1001 or more.

If a CSV file is selected as Import source

File name

The name of the file to be imported.

Enclosure character

The enclosure character attached to character string data.

The characters that you can specify are 0x00, and 0x09 to 0x7E.

If 0x00 is specified, the system will operate without enclosure characters.

Delimiter

The delimiter that separates each field.

The characters that you can specify are 0x09, and 0x20 to 0x7E.

Kanji code type

The kanji code type for file to be imported.

Line break code

Specify the line break code by using a hexadecimal value. Up to this line break, code will be determined as a record. Specify the 2-byte and 4-byte line break code (4 and 8 digits on the screen).

If Kanji code type is a value other than UTF-16, specify a 2-byte line break code. If Kanji code type is UTF-16, specify a 4-byte line break code.

Unicode byte order

The UTF-16 byte order.

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

Same as host: : Depends on the byte order of the connected hardware (Windows or UNIX).
Big-endian: : Uses big-endian.
Little-endian: : Uses little-endian.

If format information or database table information is selected as Import source

Select Format ID or Database table ID.