Available for IT Advisor on-premise installations only

[Jef]

Available for IT Advisor on-premise installations only

You can import manual breaker panel measurements into ITA by importing the values from a preconfigured Excel workbook through an ETL configuration. You can then include your manual power measurements on each of the circuits in a PDU in the automatic power capacity calculations in ITA.

You'll need to:

1. Create a staging database on the ITA server
2. Setup an ETL server configuration to read from the staging database
3. Select to create the Excel template in the ITA import wizard, enter your manual power measurements, and save the file
4. Import the saved file, including your measurements, into ITA.

About the Excel file

When importing data from an Excel file into ITA, you must use a fixed format for the Excel file to ensure the data is compatible and can be processed by ITA. 

A button is available in the import wizard to automatically create a workbook template based on the latest solution data from the server to ensure the data is compatible.

Note

It is important that you use the template from the ITA server, and generate the latest version of it in case of an update rather than using an older version since the template includes information about the current fields in ITA, new equipment added, or changes made to the breaker panel layout.

The Excel file contains information about the power equipment, customer information (equipment assigned to customer, ITA for Colo feature), and allows you to enter current (Amp) and power (kW) measurements.

About entering measurements

• The only data you should change in the Excel is this: 
  • Date and Time (to specify when the measurements where taken)
  • Amps 
  • Power
  • Power Factor (which is remembered separately for each PDU) 
• You can enter your power measurements as both Amps and kW. 
  Do not delete kW values, even if you use Amps for your measurements only, as ITA needs the kW values for the automatic capacity calculations. 
• If you want to use the import functionality to update existing measurement values, provide the same timestamp. 

Prerequisites

• Access to the web client (user with admin rights)
• Access to desktop client (user with admin rights)
• If importing power measurements into multiple rooms in ITA, you you need access to the rooms for which you want to import power measurements. 

Step-by-step instructions

1. Create an ETL staging database (first time only).
   1. Log in to the web client
   2. Go to Configuration > Manage ETL Configurations.
   3. Click Add ETL Configuration . 
   4.  In the New Configuration / Database window, create a new internal import database, providing details about the database, Configuration name, Database name, user, password and Allowed IP addresses and ranges.
      In the New Configuration / Transformation window, select transformation type BreakerPanelMeasurements, define the location of the xls_folder (ex:  /data/pentaho/import).
      In the New Configuration / Schedule window, schedule the frequency.
      Finish the configuration by clicking on the Submit button.
2. Get the Excel workbook template from the ITA server, enter and save your measurements in this file.
   1. Open the ITA desktop client and, in the Planning>Data Center perspective, open the rooms to which you want to import your manual power measurements.
      This is a necessary first step as only the open rooms will be available for selection in a later step. 
   2. Select File>Import>Manual Power Measurements from Excel Workbook.
   3. Follow the first steps in the Import manual measurements form Excel workbook wizard. 
      1. To export the template workbook for a set of rooms as it says in step 1, click Create template file... and select the rooms to which you later want to import your manual power measurements.
      2. Enter a file name for your power measurements template file, and make a note of the location in which you save it.
      3. In your file system, open the template file, and enter your manual power measurements into it to ensure the format is accepted by IT Advisor, and save your changes.
         
3. Import the file with your measurements into ITA.
   
4. 1. Reopen the import wizard in ITA (File>Import>Manual Power Measurements from Excel Workbook), and in Import settings, browse to the location of your import file, select it, then click Next to review the import preview.
   2. If the preview list shows data that will be excluded from the import because of issues encountered, click Save log file... and review your Excel file again, fixing issues causing the errors before attempting a new import. 
   3. When you're sure that the import preview looks as it should, click Finish to complete the import.

Measurements that are less than 24 hours old might not be completely processed by ITA, and will not be used for the Predicted Power calculations until they have been processed.

Every 24 hours ITA looks at the measurements received during the last day and aggregates the data. To ensure stable values in the predicted power calculations, data will not be used before they have been aggregated.