You can import manual breaker panel measurements into DCO by importing the values from a preconfigured Excel workbook through an ETL configuration. This makes it possible for you to include your manual power measurements on each of the circuits in a PDU in the automatic power capacity calculations in DCO.
You'll need to
- Create a staging database on the DCO server
- Setup an ETL server configuration to read from the staging database
- Select to create the Excel template in the DCO import wizard, enter your manual power measurements, and save the file
- 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.
Note
It is important that you use the template from the DCO 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 DCO, 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, 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
- Create an ETL staging database (first time only).
- 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
. - Log on to Webmin using the user credentials created during the DCO installation.
- In the menu to the left, select DC Operationn>ETL Integration Management.
- 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.
- Open the Webmin server management web interface by selecting Administration>Webmin in the DCO web client.
- Configure the staging database created in step 1 (first time only).
- Log in to the DCO desktop client (with a user that has rights to external system configuration).
- In System Setup>External System Configuration, click Add server (+ icon) and follow the steps in the wizard:
- Select system type Data Center Operation ETL Integration.
- 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.
- Get the Excel workbook template from the DCO server, enter and save your measurements in this file.
- 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. - Select File>Import>Manual Power Measurements from Excel Workbook.
- Follow the first steps in the Import manual measurements form Excel workbook wizard.
- 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.
- Enter a file name for your power measurements template file, and make a note of the location in which you save it.
- 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.
- 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.
- Import the file with your measurements into DCO.
- 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.
- 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.
- 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 DCO, and will not be used for the Predicted Power calculations until they have been processed. Every 24 hours DCO 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.
0 comments
Please sign in to leave a comment.