Spreadsheet file requirements, 43 sample spreadsheet, Spreadsheet file formatting requirements – HP XP Array Manager Software User Manual
Page 86

Spreadsheet File Requirements
You will need to write the spreadsheet according to specific rules and in a specific format.
on page 86 shows an example of a spreadsheet.
Declaration
Function Tag
Comment
Changing
Adding
Deleting
Current Configuration Definition (including blank columns)
New Configuration Definition (user setting)
Figure 43 Sample Spreadsheet
All of the formatting requirements in
on page 86 must be satisfied.
Table 9 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 200 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
on page 90)
The following parameters should be written in one or two-digit
hexadecimal numbers:
Host group ID, host mode, LDKC, CU, LDEV.
The parameter for LUN should be written in up to four-digit hexadecimal
numbers.
Tab codes and a series of spaces before or after comma are ignored.
86
Performing LUN Manager Operations Using Configuration File Loader