Import/Export File Output Format

This topic explains the format of CSV files that are created when the management information is exported.

Use the same CSV file format when you import the management information.

[Remarks]  
Double quotation marks (") can be omitted as text enclosures.
  However, if the data includes any double quotation marks (") or commas (,), they cannot be omitted. Furthermore, to ensure that double quotation marks are displayed in the data as is, enter two consecutive double quotation marks ("") for each double quotation character that is to be displayed in the data.
The leading spaces and middle spaces of items are read as is, but trailing spaces are truncated.
  Example:
Pattern Example input Read data
Double quotation marks (") are omitted 0123abcd 0123abcd
Text enclosed in double quotation marks (") "0123abcd" 0123abcd
Data that includes double quotation marks (") "0123""abcd" 0123"abcd
Data that includes consecutive double quotation marks ("") "0123""""abcd" 0123""abcd

Double quotation marks (") are omitted

Space or tab before or after the setting value

_0123abcd_ (*1) _0123abcd (*1)

Text enclosed in double quotation marks (")

Space or tab in the setting value

"_0123abcd_" (*1) _0123abcd (*1)

Text enclosed in double quotation marks (")

Space or tab before or after double quotation marks (")

_"0123abcd"_ (*1) 0123abcd

*1: Underscores (_) represent a space or a tab.

For details of the setting values for each field, refer to Management Information Reference.

File Content

When HULFT-HUB outputs the management information to a file, the information is grouped according to each type of the information for each host.

Transfer Information of Server 1

Transfer Information of Server 2

:

Send Management Information of Client 1

Receive Management Information of Client 1

Job Information of Client 1

Host Information of Client 1

Transfer Group Information of Client 1

Format Information of Client 1

Multi Format Information of Client 1

Mail Interface Information of Client 1

Schedule Information of Client 1

File Trigger Information of Client 1

Send Management Information of Client 2

Receive Management Information of Client 2

:

For each set of the management information, a title is output to the first row, and the settings of each ID (or host name) are output to the second and subsequent rows.

[Remarks]  
- Even if the ID (or host name) is not registered, a title is always output.
- Even a CSV file without a title row can be imported.

(Example)

"send-title","ClientName","ClientServiceName","FileID",....

"send","HOST01","Service1","SEND01",....

"send","HOST01","Service1","SEND02",....

"recv-title","ClientName","ClientServiceName","FileID",....

"recv","HOST01","Service1","RECV01",....

"recv","HOST01","Service1","RECV02",....

"job-title","ClientName","ClientServiceName","JobID",....

"job-Slave-title","ClientName","ClientServiceName","JobID",....

"job","HOST01","Service1","JOB01",....

"job-Slave","HOST01","Service1","JOB01",....

"host-title","ClientName","ClientServiceName","HostName",....

"host","HOST02","Site01","HOST02_30000",....

:

The tables below show the output format of the following management information:

Client

Server