Importing manual power measurements

You'll need to

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

About the Excel file

When importing data from an Excel file into DCO, you must use a fixed format for the Excel file to ensure the data is compatible and can be processed by DCO. 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.

The Excel file contains information about the power equipment, customer information (equipment assigned to customer, DCO 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 DCO 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 Webmin server management interface
• Access to External System Configuration in DCO
• If importing power measurements into multiple rooms in DCO, 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. Open the Webmin server management web interface by selecting Administration>Webmin in the DCO web client.
      Alternatively, type the address of your DCO server in a Web browser folllowed by :10000, <https://>:10000 .  
   2. Log on to Webmin using the user credentials created during the DCO installation.
   3. In the menu to the left, select DC Operationn>ETL Integration Management. 
   4. In Management tasks, click Manage internal database and create a new internal import database, providing details about the database, user, and secure communication.
      The name you provide in Configuration Name will be used in the next step. 
2. Configure the staging database created in step 1 (first time only).
   
   1. Log in to the DCO desktop client (with a user that has rights to external system configuration). 
   2. In System Setup>External System Configuration, click Add server (+ icon) and follow the steps in the wizard: 
      1. Select system type Data Center Operation ETL Integration.
      2. Configure parameters for the ETL integration, pointing to the staging database created in step 1 (in ETL Database, select your staging database recognizable with the configuration name you added in Webmin), and selecting transformation type BreakerPanelMeasurements.
3. Get the Excel workbook template from the DCO server, enter and save your measurements in this file.
   1. Open the DCO 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 Data Center Operation, and save your changes.
         
4. Import the file with your measurements into DCO.
   
   1. Reopen the import wizard in DCO (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.