2 general spreadsheet conventions, 2-1 spreadsheet file requirements – HP StorageWorks XP Remote Web Console Software User Manual

Page 107

Advertising
background image

Configuration File Loader 107


5-2 General Spreadsheet Conventions

5-2-1 Spreadsheet File Requirements

You will need to write the spreadsheet according to specific rules and in a specific format. Figure 5-2 shows a

sample spreadsheet.

Figure 5-2

Sample Spreadsheet

All of the formatting requirements in Table 5.1 must be satisfied.

Table 5-1

Spreadsheet File Formatting Requirements

Item Requirements

File type

Text file

File name

Extension must be “.spd”.
Maximum number of letters for the file name is 32 including the extension.
The following symbols cannot be used for the file name:
\ / : , ; * ? “ < > | and space.
File path must be under 255 letters.

Maximum number of rows in a
spreadsheet

400,000 rows

End-of-line character

Linefeed code must be put in the end of each row.

Maximum number of letters in a row Maximum number of letters in a row is 128 bytes, including the linefeed code at the

end.

Case-sensitivity

Settings are not case-sensitive, except for WWN and host group.

Format (for more information on the
required format, see section 5-3)

Host group ID, host mode, LUN, CU, and LDEV parameters should be written in one or
two-digit hexadecimal numbers.
LUN parameters can be written in up to four-digit hexadecimal numbers.
Tab codes and a series of spaces before or after a comma are ignored.

Advertising