Field list

Table 3.2 List of Fields for CSV Detailed Information

Field name

Initial value

Possible settings

Omission possible

Remarks

ID

 

Alphanumeric characters and symbols (#1)

No

50 bytes or fewer

Business group

 

A business group for which general users have access permissions.

Alternatively, a business group whose only purpose is to be used for filter conditions.

Yes

 

Comment

 

Characters (#4)

Yes

255 bytes or fewer

Enclosure character

0x22

0x00, 0x09 to 0x7E

No

 

Delimiter

0x2C

0x09, 0x20 to 0x7E

No

 

CSV field

 

Field name

NEWx (#2)

Characters (#3)

No

255 bytes or fewer

Comment

 

Characters (#4)

Yes

255 bytes or fewer

#1

:

You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()).

#2

:

The part marked x is replaced with the serial number.

#3

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&).Operations are not guaranteed if you use any platform-dependent characters.

#4

:

No line breaks can be registered.

 

Table 3.3 Field List for CSV Information Field Settings

Field name

Initial value

Possible settings

Omission possible

Remarks

Field Name

 

Characters (#1)

No

255 bytes or fewer

Comment

 

Characters (#2)

Yes

255 bytes or fewer

#1

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&). Operations are not guaranteed if you use any platform-dependent characters.

#2

:

No line breaks can be registered.

 

Table 3.4 Field List for Import Fields

Field name

Initial value

Possible settings

Omission possible

Remarks

Import source

CSV file

CSV file, format information, and database table information.

No

 

Preview

 

Display only

 

Maximum number of fields: 1000

When Import source is set to CSV file

 

File name

 

Windows

Characters (#1)

No

200 bytes or fewer

UNIX

Alphanumeric characters and symbols (#2)

Enclosure character

0x22

0x00, 0x09 to 0x7E (#3)

No

 

Delimiter

0x2C

0x09, 0x20 to 0x7E

No

 

Kanji code type

Kanji code type for connected OS (#4)

Shift JIS, EUC, UTF-8,

UTF-16

No

 

Line break code

 

Hexadecimal characters

No

UTF-16: 8 bytes

Others: 4 bytes

Unicode byte order

Same as host

Same as host,

Big-endian, Little-endian

Yes

You can use this when UTF-16 is specified for kanji code type.

When Import source is set to Format information

 

ID

 

Format ID

No

 

When Import source is set to Database table information

 

ID

 

Database table ID

No

 

No.

 

Display only

 

 

Validity

ON

ON, OFF

No

 

Field name

 

Display only

 

 

Fixed/Variable length

 

Display only

 

 

Size

 

Display only

 

 

Field type

 

Display only

 

 

Status

 

Display only

 

 

Comments

 

Display only

 

 

#1

:

You cannot use external characters. Operations are not guaranteed if you use any platform-dependent characters.

#2

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&).

#3

:

If 0x00 is specified, operations are performed without enclosure characters.

#4

:

In DataMagic Desktop grade, Kanji code type cannot be changed.