Importing manual power measurements

[DCIM_Support]

Where is the template excel file on the DCO server for importing manual power measurements ?

(CID:111415448)

[DCIM_Support · Accepted solution]

Hi James,

As illustrated, the template file can be created via: File > Import > "Manual Power Measurements from Excel Workbook", ... "Create template file" feature:

manual import and creating the template file would need that ETL import database has been setup already. It is worth to mention that a template file could be created based on the selected room ("Choose external system") - if the room should contain associated devices (such as PDU getting its measurements from DCE), then those devices may not appear in the template file.

Kind regards

(CID:111415735)

[DCIM_Support]

Thanks Jef Faridi, have got the template file now. 

The documentation on the website seems to suggest the file is already on the DCO server, maybe this could be modified with what you have supplied above.

(CID:111415787)

[DCIM_Support]

You are most welcome James,

will be added to our documentation soon - very good suggestion, thank you.

Kind regards

(CID:111937308)

[DCIM_Support]

Thanks for pointing out the unclarity in the documentation James. I've updated it to try to explain better that the file is automatically created and includes the current data in your solution on the server when you click Create template file... I hope this clarifies it for you and other users.

Importing manual power measurements

(CID:111937349)

[DCIM_Support]

Pernille Bagger Nielsen and Jef Faridi good to see the documentation updated.  I have successfully now setup the process and imported power data.

One last thing to note is it would be good on the export/import Excel file to show the connected device on the breaker.  So at the moment my file looks like this

It would be good to have another column that said connected device (power consumer) with the name of said device, like in the Breaker Panel tab of a Power Panel

(CID:111937353)

[DCIM_Support]

Hi James,

I will capture that as a feature request, thanks.

Kind regards

(CID:111937394)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.