2 general spreadsheet conventions, 2-1 spreadsheet file requirements – HP StorageWorks XP Remote Web Console Software User Manual
Page 107
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.