Editing spreadsheet templates, Validating cli-based spreadsheets – HP XP P9500 Storage User Manual

Page 34

Advertising
background image

Editing spreadsheet templates

1.

Launch Microsoft Excel.

2.

Open the spreadsheet.

3.

Change the variable placeholders to meet your storage needs.

4.

Edit the spreadsheet.

5.

Save your changes.

6.

Validate your changes. For more information on how to validate your changes, see

“Validating

CLI-based spreadsheets ” (page 34)

.

Validating CLI-based spreadsheets

After you edit a spreadsheet, validate the spreadsheet by executing the CFLCHK command and
then execute the CFLSET command.

(For Windows) From the command prompt (Start > Run), execute the following command:

CFLCHK input-file-name output-file-name

NOTE:

For UNIX, execute the following command:

CFLCHK.sh

Description

Operand

The spreadsheet you want to verify. Include the relative or absolute path.

input-file-name

Character limit: 240

The output file name. Include the relative or absolute path.

output-file-name

Character limit: 240

“Normal end” appears at the end of each correctly processed line.

NOTE:

Processing stops when you right-click the command prompt window while the command

prompt is not in Quick Edit Mode. To start processing, press the Esc key or left-click the command
prompt window.

Processing also stops if you left-click when the command prompt is in Quick Edit Mode. To start
processing, press the Esc key or right-click the command prompt window.

If CLI processing is suspended for a long period, an RMI time-out occurs and your log-in status is
cancelled. When you resume processing, an error (0001 4011) occurs. To resume processing
and avoid this error, open a new command prompt window.

Correcting validation errors in a CLI-based spreadsheet

If you find errors in the spreadsheet results, edit the spreadsheet and execute the CFLCHK command
again until no errors exist. Use the following guidelines to check for errors in the results file:

Message codes appear at the end of lines that contain errors.

For more information, see HP P9000 Remote Web Console Messages.

Check errors from the last row with an error.

If a lower layer has an error, the upper layers also show an error—even though no error might
exist.

If a higher layer has an error, parameters in the lower layers are not verified. After correcting
the error in the upper layer, execute the CFLCHK command to check for errors further down.

Example 1

34

External Storage operations

Advertising