In-bulk account setup


In this article, it is explained how to in-bulk import / export the configuration of your account:

  1. In-bulk export the configuration of your account
  2. In-bulk import the configuration of your account


1. In-bulk export the configuration of your account

DEXCell Energy Manager allows to quickly export all the content of your account in an Excel file with just a few steps. This functionality makes sense when your portfolio of locations is considerably large and manually handling your data is not an option.​ Additionally, you can export your account information, make any change you consider convenient and then you can insert it back to your account as explained here.

In this tutorial, you will learn how to in-bulk export your project.

1.1 Prerequisites

  1. To have an existing account in DEXCell Energy Manager. 
  2. To be a SuperAdmin user. You can find more information about how to configure users here.

1.2 How to export your account

To export your account you should go to Settings -> Preferences -> Bulk account setup. Then just click in the "Export Inventory" button, and an EXCEL file will be generated and downloaded. It may take some minutes depending on the account size.



1.3 What will you obtain?  

  1. Locations: The hierarchy structure of your portfolio of locations along with their relative data.
  2. Devices: An inventory of all your devices and how they are associated with each gateway and associated POD supply if applies.
  3. Reference devices: You'll get a clear list of all your devices that act as reference devices, to which location are they placed and what type of device they are.
  4. Supplies: Your supplies will be listed along with their configured information.
  5. Contracts: There will be 5 sheets, each one for all the available types of contracts present in DEXCell Energy Manager. Configured information about your contracts will be inserted on the Excel file. 

You're done!



2. In-bulk import the configuration of your account


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! 

2.1 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 a project. You can find it here

2.2 Prerequisites

  1. To have an existing account in DEXCell Energy Manager. If you still do not 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 do not 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.

2.3 Step 1: Fill up the template

Our template consists of 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 a template. The file contains the following sheets to be completed:01_c0065bbdd0b5375c272e0df21188494ad152b85fd3a844af997f2307e0966199.png

2.3.1 Locations 

As you may know, DEXCell Energy Manager allows you to establish a hierarchy order of your locations in the form of a 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 an 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. 03_d96bfd78b2ef2a12ea91cafa8e0757f85b4d450ba7de0c63417ad18b519f6091.png


  • 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.

2.3.2 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 have not created 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 find 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 the gateway has. After that, complete the empty cells with the information of the devices belonging to that gateway.
  • Note that if the device tracks the consumption of a certain supply, then the POD number should be inserted.

2.3.3 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 a reference. 



2.3.4 Supplies

All the supplies of your portfolio of buildings must be inserted in the sheet Supplies. If you are not familiar with how DEXCell Energy Manager allows you to manage your supplies you can find more information here. Note that 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.

2.3.5 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 an example, the following image shows the sheet for electricity contracts.



2.4 Step 2: Send us the template


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

You're done!


0 out of 0 found this helpful



Please sign in to leave a comment.