Document toolboxDocument toolbox

Table 1.1 CSV File Example 1


A

B

C

D

E

1

HEADER-NETWORK

ADDRESS*

NETMASK*

EA-Gateway

EA-Secondary Address

2

HEADER-HostRecord

configure_for_dns*

FQDN*

ADDRESSES


3

NETWORK

10.251.133.128

255.255.255.192

10.251.133.129


4

NETWORK

10.176.80.255

255.255.252.0

10.176.80.1

172.16.213.0

5

HostRecord

TRUE

host1.dhcp.corp100.com

172.20.2.21


6

HostRecord

TRUE

host2.dhcp.corp100.com

172.20.2.22



In CSV File Example 1, the field name HEADER-NETWORK identifies the first row as a header row for the Network objects. The field names ADDRESS, NETMASK, EA-Gateway, and EA-Secondary Address (in rows B1 to E1) tell NIOS how to interpret a row of network data in the CSV file. Each row of data that begins with "Network" in column A is identified as a network data row. Therefore, NIOS interprets rows 3 and 4 as network data rows, in which column B contains the network addresses, column C contains the network masks, and columns D and E contain extensible attribute values for gateway and secondary address.
Similarly, the field name HEADER-HostRecord identifies the second row as a header row for the Host Record objects. This header declaration tells NIOS that for each subsequent row of data that begins with "HostRecord" in column A, column C contains the FQDN of the host, and column D contains the host address. Therefore, NIOS interprets rows 5 and 6 as host record data rows that contain the FQDNs of the hosts in column C and the host addresses in column D.
Alternatively, you can organize the information in CSV File Example 1 so that the data rows immediately follow the header rows, as shown in CSV File Example 2.