B.One Gallery Howto: Export Device Raw Data

– 📖🕓 ≈ 6 min – In my last article I already showed you how you can connect the B.One Middleware to the IoT platform TagoIO. Today we come to the…
– 📖🕓 ≈ 6 min – In my last two articles I have already shown you how you can connect the B.One.Middleware to the IoT platforms TagoIO and Kaa. In this…
– 📖🕓 ≈ 7 min – Are you wondering what device groups are in the B.One Gallery, what are they good for and how can you create and manage them? You can find the answers in this post.
– 📖🕓 ≈ 4 min – Updated on 01/12/2023 Like me, you already use the B.One Gallery visualization platform in combination with a compatible GPS tracker and would like to receive…
– 📖🕓 ≈ 3 min – In the past and also in the coming articles you have already read a lot about the B.One Middleware, B.One Gallery, Gateways, IoT PLUG&PLAY and…
– 📖🕓 ≈ 10 min – You have purchased access to the B.One Gallery visualization tool, but are now wondering where exactly you can find what? Our Quick Guide – B.One Gallery provides the answer to this question and gives an overview of the areas and functions of the tool.
As you may already know, your sensor data is visualized in descriptive diagrams in the B.One Gallery, making it easier to evaluate and interpret. But is it also possible to get the raw data from the devices? If you are asking yourself this question or have asked it before, here is the answer: Yes, it is possible. How exactly and how easy we show you below.
To get the raw data from your devices, simply follow these four steps (or alternatively watch the short video below):
Under “ Buildings & Groups ” you will find an overview of your device groups created in the B.One Gallery and the devices in them on the left-hand side. First navigate to the device whose data you want to export.
Next, you call up the device options via the small gear icon next to the corresponding device. It is important that you retrieve the device via the "Meters / Devices" list and not via a subgroup, as only the former has the option to export the data.
Now click on "Download raw data" in the list of device options, select the desired time period in the window that opens and click on "Download". A ZIP archive is now created that contains a CSV file with all measured values of the selected period for each measured variable of your sensor.
As a last step, you only have to unpack the downloaded ZIP archive if necessary for further processing of the data/files and, if necessary, convert the CSV files into a format that suits you.
Here is the whole thing using an example in a short video:
https://community.mz-connect.com/wp-content/uploads/2022/03/2022-03-25_b-one-gallery_rohdaten-exportieren_comp.mp4Now that you know how to get the raw data from your sensors, here are three additional hints:
As already described, the exported data is raw data. This means that the values in the downloaded CSV file are output as they were originally generated by the respective device. Example : With a gas meter, the unit of the measured values sent by the device is "m³ gas", but the visualization in the B.One Gallery is in "kWh". The unit on which the export is based is therefore always specified in the CSV file.
The values always range from midnight on the start date to 11:59 p.m. on the end date.
"Only" the last 30,000 values are exported for each device. If you need more, just send us a message via the contact form or to b-one-community@mz-connect.com .
COOKIES: