Changes for page ThingsBoard

Last modified by Dilisi S on 2025/04/23 19:23

From 178.1 to 179.1 From 206.1 to 207.1

From version 179.1

edited by Dilisi S
on 2025/03/27 01:21

Change comment: There is no comment for this version

To version 206.1

edited by Dilisi S
on 2025/04/21 16:53

Change comment: Uploaded new attachment "add-integration-part-2.png", version {1}

Raw
Rendered

Summary

Page properties (1 modified, 0 added, 0 removed)
Attachments (3 modified, 13 added, 0 removed)

Details

Page properties

Content

@@ -164,34 +164,18 @@
  [[image:ins1.png||height="310" width="500"]]
--= 3. Creating Devices =
++= 3. Data Converters =
--First, you need to create devices in ThingsBoard to represent your physical devices. For example, you can name it **Device A**, and the second device could be **Device B** or any name you prefer. The device name should be unique within the **Devices** space.
--
--In the left navigation, click Entities -> Devices.
--
--Click the **Add Device** button (the button with the **+** sign), and from the dropdown menu, click **Add new device**.
--
--In the **Add new device** dialog box, enter the device name in the **Name** text box. For example, we will use **Device A**.
--
--Click the **Add** button.
--
--Skip the **connectivity testing** by clicking the **Close** button.
--
--The device is created and listed on the **Devices** page. Note that its initial state is **Inactive** because it has not received any data yet.
--
--
--= 4. Data Converters =
--
--
  In **ThingsBoard**, **Data Converters** are components used to transform incoming or outgoing data between different formats, typically to convert raw telemetry data from devices into a structured format that ThingsBoard can understand, or vice versa.
++**In this section, you will create a universal uplink data converter for all Dragino NB-IoT devices. The uplink decoder converts any MQTT message coming from a device into key-value pairs that can be used to display and visualize data using various widgets on the dashboard**.
--== 4.1 Uplink ==
++== 3.1 Uplink ==
++
  In the left navigation, click **Integrations center**, and then click **Data converters**.
@@ -198,7 +198,7 @@
  [[image:data-converters-list-empty.png]]
--On the **Data converters** page, click on the ‘**+**’ button, and then click on the **Create new converter** from the dropdown menu.
++On the **Data converters** page, click on the ‘**+**’ button, and then click on **Create new converter** from the dropdown menu.
@@ -205,98 +205,75 @@
  [[image:create-new-converter-menu.png||height="259" width="500"]]
--The **Add data converter** window will appear. Name it ‘**MQTT Uplink Converter NB/CB**’ and select the Type as **Uplink**.
++The **Add data converter** window appears.
++Name it ‘**MQTT Uplink Converter**’ and select the Type as **Uplink**.
++
  Click on the **TBEL** button if it has not been selected by default.
--Modify the default TBEL function to match with your device as described below:
++Replace the default TBEL decoder function with the following universal TBEL decoder function, which decodes MQTT payload from any Dragino NB-IoT device.
--~1. Uncomment line 11:
--
--var data = decodeToJson(payload)
--
--[[image:Screenshot 2025-03-26 at 18.15.08.png||height="219" width="500"]]
--
--
--3. Modify the telemetry section to allow parsed data to be assigned to the fields.
--
--telemetry: {
--       temperature: data.temperature,
--       humidity: data.humidity,
--       rawData: payloadStr
--   }
--
--
--
  {{code language="JavaScript"}}
--// Decode an uplink message from a buffer
--// payload - array of bytes
--// metadata - key/value object
--
--/** Decoder **/
--
--// decode payload to string
--var payloadStr = decodeToString(payload);
--
  // decode payload to JSON
++var pattern = "yyyy/MM/dd HH:mm:ss";
++var objdata = {};
++var obj1 = {};
  var data = decodeToJson(payload);
--
--var deviceName = 'Device B';
--var deviceType = 'thermostat';
--var customerName = 'Customer C';
--var groupName = 'thermostat devices';
--var manufacturer = 'Example corporation';
--// use assetName and assetType instead of deviceName and deviceType
--// to automatically create assets instead of devices.
--// var assetName = 'Asset A';
--// var assetType = 'building';
--
--// Result object with device/asset attributes/telemetry data
--var result = {
--// Use deviceName and deviceType or assetName and assetType, but not both.
--   deviceName: deviceName,
--   deviceType: deviceType,
--// assetName: assetName,
--// assetType: assetType,
--// customerName: customerName,
--   groupName: groupName,
--   attributes: {
--       model: 'Model A',
--       serialNumber: 'SN111',
--       integrationName: metadata['integrationName'],
--       manufacturer: manufacturer
--   },
--   telemetry: {
--       temperature: data.temperature,
--       humidity: data.humidity,
--       rawData: payloadStr
--   }
++var deviceName = data.IMEI;
++data.remove("IMEI");
++var modelname = "Dragino "+ data.Model;
++//var mod = data.mod
++data.remove("Model");
++//delete data.mod
++var timestamp = new Date().getTime();
++foreach (entry: data.entrySet()) {
++    var key = entry.getKey();
++    var value = entry.getValue();
++    //objdata[key] = data[key]
++    if(key.matches("^-?\\d+$")){ //is number
++        obj1[key]=data[key];
++        var index = obj1[key].length-1;
++        obj1[key][index]=new Date(obj1[key][index],pattern).getTime();
++    }
++    else if (key==="bat"||key==="BAT"){
++        objdata["battery"] = data[key];
++    }
++    else{
++    objdata[key] = data[key];
++}}
++var listdata = [{"ts":timestamp,"values":objdata}];
++foreach ( entry1: obj1.entrySet()){
++    var key1 = entry1.getKey();
++    var value1 = entry1.getValue();
++    var index = obj1[key1].length-1;
++    var ts = obj1[key1][index];
++    if (modelname=="Dragino RS485-NB"){
++        listdata.push({"ts":ts,"values":{"Payload":obj1[key1][0]}});
++    }
++    else{
++        listdata.push({"ts":ts,"values":{"values":obj1[key1]}});
++    }
++}
++   var result = {
++    deviceName: deviceName,
++    deviceType: modelname,
++    attributes: {
++        model: modelname
++        //customerName: "NB-CB",
++        //groupName: "NB-CB",
++        //integrationName: metadata['integrationName']
++    },
++    telemetry: listdata
  };
--
--/** Helper functions 'decodeToString' and 'decodeToJson' are already built-in **/
--
  return result;
  {{/code}}
--We use the same decoder function for all our devices. However, you need to modify a few things for each device. Among these, **deviceName** is a **mandatory** field. You should assign a device name to the **deviceName** field that matches the name of your device in the **Devices** section.
--For example, if your device name is **Device B**, you can change **Device A** to **Device B**.
--
--
--{{code language="JavaScript"}}
--var deviceName = 'Device A';
--var deviceType = 'thermostat';
--var customerName = 'Customer C';
--var groupName = 'thermostat devices';
--var manufacturer = 'Example corporation';
--{{/code}}
--
--
  Once you modify the decoder function, click on the **Add** button.
--[[image:mqtt-uplink.png||width="500"]]
++[[image:mqtt-uplink-converter.png||height="498" width="500"]]
@@ -303,12 +303,13 @@
  You should see that the newly added **MQTT Uplink converter **NB/CB is listed on the **Data Converters** page.
--[[image:data-converter-list-showing-uplink-dc.png]]
++[[image:data-converters-list.png]]
--= 5. Add Integration =
++= 4. Add Integration =
++
  In the left navigation, click **Integrations center**, and then click **Integrations**.
@@ -326,16 +326,18 @@
  **Basic settings:**
  * **Integration type**: MQTT
--* **Name**: MQTT integration NB/CB
++* **Name**: MQTT integration - Device A
  * **Enable integration**: YES
--* **Allows create devices or assets**: YES
++* **Allow create devices or assets**: YES
  Click **Next** button.
--[[image:add-integration-basic-settings.png||height="511" width="500"]]
++[[image:add-integration-basic-settings.png||height="504" width="500"]]
++
++
  **Uplink data converter:**
  * Click on the **Select existing** button.
@@ -344,9 +344,10 @@
  Click **Next** button.
--[[image:add-integration-uplink-data-converter.png||height="511" width="500"]]
++[[image:add-integration-ul-data-converter.png||height="505" width="500"]]
++
  **Downlink data converter:**
  Dragino NB/CB devices don't require a downlink data converter to decode their payloads, so you can skip this step.
@@ -362,16 +362,16 @@
  **Connection:**
--* **Host**: Cluster URL (Eg. **//011731f7xxxxxxxxxxxfbbedfc63f4.s1.eu.hivemq.cloud//**)
++* **Host**: Host URL (Eg. **//011731f7xxxxxxxxxxxfbbedfc63f4.s1.eu.hivemq.cloud//**)
  * **Port**: 8883
--* **Credentials**: Basic
--* **Enable SSL**: YES
++* **Credentials type**: Basic
  * **Username**: Username (from your HiveMQ Cloud Cluster with your credentials)
  * **Password:** Password (from your HiveMQ Cloud Cluster with your credentials)
--* **Topic: v1/devices/me/telemetry** (The topic can be anything; you can even use just the device name. For example, you can use your device name here, such as devices/a/telemetry.)
++* **Enable SSL**: YES
++* **Topic: device/a** (The topic can be anything; you can even use just the device name.)
  * **QoS:** 0-At most once
--[[image:add-integration-connection.png||height="511" width="500"]]
++[[image:add-integartion-connection.png||height="505" width="500"]]
  Click on the **Advanced settings** button.
@@ -401,35 +401,36 @@
  Since we haven't received data from a device yet, the integration **Status** is shown as **Pending.**
--[[image:new-integration-pending.png]]
++[[image:integration-added.png]]
--= 6. Verifying the receipt of data from virtual devices =
++= 5. Verifying the receipt of data from virtual devices =
--== 6.1 How does it work? ==
++== 5.1 How does it work? ==
++
  We use the Mosquitto MQTT client to simulate MQTT messages, acting as a virtual device. First, install the Mosquitto client on your computer from [[this link>>url:https://mosquitto.org/download/]]. The Mosquitto client publishes messages to the MQTT broker (HiveMQ) on a specified MQTT topic. ThingsBoard subscribes to these messages using the same topic.
--The Mosquitto client publishes messages (payloads) on the topic **v1/devices/me/telemetry**. Of course, you can use any topic for testing.
++The Mosquitto client publishes messages (payloads) on the topic **/device/a**. Of course, you can use any topic for testing.
--(% id="cke_bm_37386S" style="display:none" %) (%%)The MQTT payload format is as follows, which is common for all **~-~-NB** and **~-~-CB** series devices. The **IMEI** field is mandatory and is used to provision a new device with the name assigned to it in ThingsBoard.
++(% id="cke_bm_37386S" style="display:none" %) (%%)The MQTT payload format is as follows:
  {{code language="none"}}
--{"IMEI": "S31B-NB", "temperature": 27, ......}
++{"IMEI": "350693903995577", "temperature":25, "humidity":80, "pressure":1005}
  {{/code}}
--Once ThingsBoard receives this message, it automatically creates (provisions) the device mentioned in the **IMEI**, for example, S31B-NB.
++Once ThingsBoard receives this message, it forwards this payload to the matching device through the integration.
  == 5.2 Sending messages ==
--On the terminal, issue the following MQTT command which simulates the device S31B-NB. The message payload contains the fields temperature and humidity, which hold the values S31B-NB and 27, respectively. This payload is also (technically) known as telemetry.
++On your computer's terminal, issue the following MQTT command which simulates the device '**Device A'**. The message payload contains the fields IMEI, temperature, humidity, and pressure, which hold the values 350693903995577, 30, 80, and 1005 respectively. This payload is also (technically) known as telemetry.
  {{code language="none"}}
--mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -t "v1/devices/me/telemetry" -u "xxxxx" -P "xxxxx" -m '{"IMEI": "S31B-NB", "temperature": 27}'
++mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":30, "humidity":80, "pressure":1005}'
  {{/code}}
  If the integration was performed without errors, the status of the integration changes to 'Active' after the first telemetry transmission.
@@ -438,15 +438,9 @@
  [[image:integration-active.png]]
--Also, a new device named **S31B-NB** will appear under **//Entities -> Devices -> All//**. This means the first MQTT message triggers ThingsBoard to provision a device named **S31B-NB**.
++== 5.3 Viewing messages ==
--[[image:new-device.png]]
--
--
--== 6.3 Viewing messages ==
--
--
  Go back to the **Integrations** page.
  Click on the **MQTT integration NB/CB** in the **Integrations** page to see its details.
@@ -462,29 +462,40 @@
  Then click on the **Apply changes** (//**tick icon**//) button.
--[[image:Screenshot 2025-03-18 at 09.23.10.png]]
++[[image:debug-enabled.png||height="301" width="700"]]
++
++
  Now go to the **Events** tab.
--Select the Event type as **Debug** from the dropdown list.
++Select the **Event type** as **Debug** from the dropdown list.
--Now you can see all the Uplink messages you are simulating through the MQTT broker. The status should be OK if there is no errors in your integration.
++Publish another message (of course, you can repeat the previous message by pressing the UP arrow on your keyboard and then press Enter key) to your MQTT broker from your terminal, for example:
++{{code language="none"}}
++mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":30, "humidity":80, "pressure":1005}'
++{{/code}}
--[[image:Screenshot 2025-03-16 at 18.38.59.png]]
++Now you can see that uplink message in the **Events** tab (Click the **refresh** button if you didn't see any messages in the Events tab). The status should be **OK **if there is no errors in your integration.
++[[image:Screenshot 2025-03-26 at 19.49.31.png]]
++
++
++
  Then click on the **three dots (...)** in the **Message** column. You can see the uplink message's **payload** in the **Message** window.
--[[image:Screenshot 2025-03-16 at 18.39.12.png]]
++[[image:Screenshot 2025-03-26 at 19.47.52.png]]
++
++
  Now, you have successfully tested your integration with a simulated uplink payload and verified that it is received by ThingsBoard, and the device is provisioned.
--= 7. Creating a Dashboard =
++= 6. Creating a Dashboard =
  ThingsBoard **Dashboards** provide a powerful way to visualize and monitor real-time and historical data from connected devices. They allow users to create interactive, customizable panels displaying telemetry data, device status, and other key metrics. With a variety of widgets, including charts, maps, and tables, dashboards help users gain insights, track trends, and manage IoT deployments efficiently.
@@ -494,7 +494,7 @@
  First simulate a few messages using MQTT. This time, we have added the 'humidity' field to the payload. Eg:
--{{code language="none"}}mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -t "v1/devices/me/telemetry" -u "xxxxx" -P "xxxxx" -m '{"IMEI": "S31B-NB", "temperature": 22, "humidity":80}'{{/code}}
++{{code language="none"}}mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":22, "humidity":80, "pressure":1005}'{{/code}}
  In **ThingsBoard**, from the left navigation menu, click **Dashboards**. Then, click the **+** button and select **Create new dashboard** from the dropdown menu.
@@ -532,15 +532,19 @@
  Configure the **Time series chart** widget as follows:
--* **Datasource** - select S31B-NB device you provisioned.
++* **Datasource** - select **Device A** device you provisioned.
  * **Series**:
  ** **temperature** - you can see this key by default.
  ** **humidity** - Click **Add series** button. Then add the **humidity** for the key and then type **%** as its unit.
  * Click on the **Add** button.
--[[image:timeseries-1.png||height="491" width="700"]]
++{{info}}
++You can add only the relevant fields from the device's payload to display data on a widget. These fields are called 'keys'.
++{{/info}}
++[[image:Screenshot 2025-03-31 at 06.51.15.png||height="485" width="700"]]
++
  The time-series chart will appear in edit mode. Resize it by clicking and dragging the lower-right corner.
  Click the **Save** button to add the widget to the dashboard.
@@ -553,12 +553,11 @@
  {{code language="none"}}
--mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -t "v1/devices/me/telemetry" -u "xxxxx" -P "xxxxx" -m '{"IMEI": "S31B-NB", "temperature": 22, "humidity":70}'
++mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":22, "humidity":70, "pressure":1005}'
--mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -t "v1/devices/me/telemetry" -u "xxxxx" -P "xxxxx" -m '{"IMEI": "S31B-NB", "temperature": 27, "humidity":72}'
++mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":27, "humidity":72, "pressure":1005}'
--mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -t "v1/devices/me/telemetry" -u "xxxxx" -P "xxxxx" -m '{"IMEI": "S31B-NB", "temperature": 19, "humidity":80}'
--
++mosquitto_pub -d -q 1 -h 011731f7928xxxxx.s1.eu.hivemq.cloud -p 8883 -u "xxxxx" -P "xxxxx" -t "device/a" -m '{"IMEI":"350693903995577", "temperature":19, "humidity":80, "pressure":1005}'
  {{/code}}
  The chart will update with the values in realtime, as shown in the below image.
@@ -567,7 +567,7 @@
  [[image:timeseries-4.png||height="316" width="700"]]
--= 8. Configure NB-IoT Sensor =
++= 8. Configure Physical NB-IoT Sensor =
  Now, let's experiment with sending data to ThingsBoard using a real NB-IoT device. For example, we will use the **TS01-NB**.
@@ -589,13 +589,7 @@
--The following image shows the uplink payload of a real Dragino device. The publish topic is **TS01-NB**, and the device name is **861275077962896**, which is represented by the **IMEI**.
++The following image shows the uplink payload of a real Dragino device. The publish topic is '**TS01-NB' that contains fields in the payload, IMEI, IMSI, Model, temperature, etc**. Note that we have created a device named **TS01-NB** in the **Devices** section in advance.
--{{info}}
--The ThingsBoard uses the device's IMEI number included in the payload to create a device in the Devices section.
--{{/info}}
  [[image:image-4.png]]
--
--
--

add-integration-basic-settings.png

Size

@@ -1,1 +1,1 @@
--122.5 KB
++123.8 KB

Content

data-converters-list.png

Size

@@ -1,1 +1,1 @@
--212.2 KB
++19.0 KB

Content

integration-active.png

Size

@@ -1,1 +1,1 @@
--64.2 KB
++64.1 KB

Content

Screenshot 2025-03-26 at 19.47.52.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+168.4 KB

Content

Screenshot 2025-03-26 at 19.49.31.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+133.0 KB

Content

Screenshot 2025-03-31 at 06.51.15.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+179.5 KB

Content

add-integartion-connection.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+110.3 KB

Content

add-integartion-connetcion.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+146.0 KB

Content

add-integration-part-1.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+48.6 KB

Content

add-integration-part-2.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+47.7 KB

Content

add-integration-ul-data-converter.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+121.2 KB

Content

debug-enabled.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+196.3 KB

Content

integration-added.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+196.2 KB

Content

mqtt-uplink-converter.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+75.3 KB

Content

ul-data-converter-added.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+189.4 KB

Content

ul-data-converter-device-a.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.pradeeka

Size

...	...	@@ -1,0 +1,1 @@
	1	+168.3 KB

Content

Changes for page ThingsBoard

Summary

Details

Applications

Navigation