beautypg.com

Importing from excel worksheets – HP Insight Control Software for Linux User Manual

Page 19

background image

3 Managing power and cooling facilities in your data center

Task: Importing power configuration from third-party management software

HP Insight Control power management provides tools to read data from third-party management software
in the form of SQL or web services queries. For each power management supported third-party management
software, a command is provided to generate output in the text format suitable for use by the ipmimport
command. The following integration tools are provided:

nlyte Software: nlyte2txt
HP DCIM: dcim2txt
EATON POWER XPERT: eaton2txt

To import power configuration from the third-party management software, perform the following:

1.

Execute the appropriate integration command redirecting the output to a file using the capabilities of
your local operating system. For example, use the following command to import data from HP DCIM:

dcim2txt > data.txt

2.

Prior to importing the data into Systems Insight Manager, check the text file for errors using the ipmtxt2xml
command as given below. Insight Control power management will detect any available rack or slot
collision reference in the text file.

ipmtxt2xml data.txt

3.

Import the data.txt file using the following command:

ipmimport data.txt

You can similarly import data from nlyte software and EATON POWER XPERT software.

Task: Importing power configuration from external databases

HP Insight Control power management collects power utilization and capacity data from systems and devices
in a data center and allows an administrator to set a cap on the utilization. Before power management starts
monitoring or managing power consumption of systems and devices, it requires information on the physical
topology of systems and devices, and the power topology of the power delivery devices connected in a
data center. The power configuration information is available in the CMS database and you can import this
information available in text formats or Microsoft Excel worksheets using the available power management
CLI commands.

Importing from Excel worksheets

In Excel worksheets, the data is normally available in visual layout (VIS) and tabular (TAB) formats. For
example, the data in an Excel worksheet is shown below:

Task: Importing power configuration from third-party management software

19