You can import new meters by pressing the "Bulk import" button. When importing meters via the Bulk Import functionality, multiple tabs can be used. In this article we explain why this structure was chosen and how you can use it.
To perform the import, you must first download an Excel template by pressing "Download Excel template".
An Excel template is then downloaded with a tab per entity, such as Organisation, Location and Building. Each column contains a property. For the meters, a subdivision is made between the different metering companies. This is because each metering company can have different properties.
When filling in, you must make sure that the name must be exactly correct in the "Organization" column under the Locations tab, or in the "Location" column under the "Buildings" tab. The import system matches the correct objects on the name of these fields.
Once the template has been filled in, you need to click the "Upload Excel template" button. On this page you can upload one or more Excel templates.
As soon as a number of errors are detected, you will see a table with the wrong values.
If the import was successful, you will see the notification "Excel template is successfully processed".
¶ The different tabs
Each type of meter and data link has specific properties. That is why we have chosen to place different types of meters and their associated properties in separate tabs. This maintains an overview and allows us to specifically request additional information where necessary. For metering companies, EAN will have to be filled in for a main meter, but for intermediate meters (such as production meters), additional properties sometimes have to be filled in. For small consumption meters, only the EAN will have to be filled in on the EDSN (ODA) tab.
For example:
- EDSN (ODA) meters: only an EAN code is required.
- Analog meters: additional properties are required, such as:
- (Unit:) Eenheid (bijv. kWh, m3 of GJ)
- (Direction/channel:) Richting (LDN, ODN, Production)
- (Double meter:) Dubbele meter (JA/NEE)
- BP meters (intermediate meters): sometimes also require additional properties.
¶ The "Label" field?
When there are multiple meters in a building, it can be confusing what a specific meter is for. In that case, it is useful to use the "Label" field to distinguish meters from each other. This could be something like "Main meter floor 1" or "Heat meter office".
¶ Organizational structure
The first tabs are about the organizational structure. Here you indicate which organizational level a meter belongs to. Think of:
- Organization (e.g. MeterInsight)
- Location (e.g. Central Netherlands)
- Building (e.g. Head office)
In principle, you only need to fill in the Name field per tab and, if applicable, the name of the higher level.
¶ Example: adding a main meter
Suppose you want to link a main meter to a specific building. Then fill in at least the following columns in the tab for meters:
- Organization
- Location
- Building
- EAN
Based on this data, the meter is automatically placed in the correct place in the organizational structure.