Support Center

HOWTO: in-bulk import all your project in DEXCell Energy Manager

Last Updated: May 31, 2018 05:28PM CEST
With DEXCell Energy Manager it is possible to create a huge portfolio of locations without having to configure them manually one by one. By filling up our template a massive number of sites can be configured in a few steps. In this tutorial you'll learn how to do so! 

Template example

To better understand this tutorial it is advisable to take a look at the following template which has been already filled up with an example of project. You can find it here

Prerequisites
 
  1. To have an existing account in DEXCell Energy Manager. If you still don't have an account you can learn how to create it here.
  2. To be a SuperAdmin user. You can find more information about how to configure users here.
  3. To have at least one Gateway created, if you don't have it, you can create one as explained here.
  4. It is recommended to have your prices configured. See how to configure a price here ;)
  5. To have a portfolio of sites that you want to in-bulk.

Step 1: Fill up the template

Our template consists in an Excel file that you should complete with all the information you want to in-bulk. The file is obtained when you export your account as explained in here. If you export an empty account then you'll get an empty file that you could use as template. The file contains the following sheets to be completed:



Locations 


As you may know, DEXCell Energy Manager allows you to establish a hierarchy order of your locations in a form of tree as it can be seen in the following image.



The scope of this sheet is to correctly insert the hierarchy of your locations and their data.  You can take a look at the filled template provided above in where the hierarchy tree displayed in the image is implemented as example. To do that, keep in mind the following tips:
  • Make sure to use a unique LOCATION KEY. The LOCATION KEY is a code that is internally used to determine the structure of your hierarchy tree. 
​                 
  • Remember to add the LOCATION KEY of the hierarchy parent of your location. In other words, the code to identify the location you have above. If you leave blank the Hierarchy Parent cell, then the location will be automatically assigned to the first level, i.e to the location created by default in your account.
                                   
  • Pay attention to the comments below each parameter on the template. There are cases such as the Country or the Activity_tag that should be typed down exactly as specified in the sheet Designations.


Devices


DEXCell Energy Manager needs all your gateways to be already created in your account in order to in-bulk your portfolio of buildings. If you hadn't create your gateways you can learn how to do it here.

The purpose of the Device sheet is to track how your devices are connected to which gateways and to which locations. In a similar manner as in the Locations tab, the DEVICE KEY is linked to a GATEWAY KEY and finally is assigned to a LOCATION KEY.



Keep in mind that:
  • This time the GATEWAY KEY is an existing parameter since your gateways need to be previously registered. You can find your gateway key in Settings -> Gateways.
  • Once you found the GATEWAY KEY, it is advisable to fill up the rest of the row and then copy/paste the row as many times as devices has the gateway. After that, complete the empty cells with the information of the devices belonging to that gateway.
  • Note that if the device tracks a consumption of a certain supply, then the POD number should be inserted.


Reference devices


Reference devices are very important to better organize your data in the analysis section, especially for a large portfolio of buildings. Our in-bulk template allows you to easily define your reference devices without going through the manual process

The Reference Devices sheet is quite similar to the Devices one, actually, the first 3 columns can be directly copy pasted from Devices. The only difference is that you should introduce the LOCATION KEY and the Reference meter type of the devices that you want to use as reference. 


 

Supplies


All the supplies of your portfolio of buildings must be inserted in the sheet Supplies. If you are not familiar on how DEXCell Energy Manager allows you to manage your supplies you can find more information here. Note that a supply is identified by the POD NUMBER which is a unique ID provided by your supplier.



Make sure to type down the ENERGY SOURCE, THE COUNTRY and the METER COUNTRY exactly as specified in Designations.


Contracts


Our template has 5 additional sheets, each one for a specific type of contract available in DEXCell Energy Manager, so you can easily introduce all your contracts during the in-bulk. If you need more information about the contracts in DEXCell Energy Manager you can find it here. The information requested depends mainly on the type of contract, however, in general terms each contract:
  • Requires a CONTRACT KEY, which will be used for DEXCell Energy Manager to identify the contract.
  • Must have a POD NUMBER, which is used to link the contract to a specific supply.
  • Must have a PRICE KEY from a previously defined price in your DEXCell Energy Manager account. You can get the price key from one of your prices in Settings -> Supplies and prices -> Prices
 



As example, the following image shows the sheet for electricity contracts.



Step 2: Send us the template

 
To upload your file you should send it to us at support@dexma.com and our support team will insert it for you.

You're done!

Contact Us

  • Post a Public Question
  • Email Us
  • Tel : +34 931 810 195
    Hours: 9am - 6pm CEST, Mon to Fri
    support@dexmatech.com

    Check Public holidays here

    Support
support@dexma.com
http://assets1.desk.com/
false
dexma
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete