This document describes the definition of Master Data aimed at creating or modifying Opinum sites, sources, events* and users via a set of Excel files or a set of JSON files.

A master data is composed of 2 files:

• the template file that defines the mapping between the data file and the Opinum entities. This file is uploaded once in the Opinum storage

• the data file that contains the data that the MDE must process

When any of these files is uploaded in the Opinum storage, it is processed by a trigger in a deterministic order.

A special Whatif mode allows to test/debug the Master Data upload process.

Important

Master Data does not support the mix of Excel/JSON file type for the template and data file, both must be of the same file type

Tip

To ease troubleshooting, it is strongly recommended to include the account name/id in the uploaded file name

Throughout this document, we’ll assume that a customer owns 3 stores, each of them containing some meters whose data must be handled by Opinum Data Hub

• Store_Brussels located at Niewstraat 16, 1000 Brussels

  • Meter SN0001
  • Meter SN0002

• Store_Charleroi located at Avenue de Philippeville 24, 6001 Charleroi

  • Meter SN0003

• Store_Deurne located at Eyendijkstraat 10, 2100 Deurne

  • Meter SN0004

* Events are only available when using Json files