Changes for page ThingsBoard

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

From version 191.1
edited by Dilisi S
on 2025/03/27 23:16
Change comment: Uploaded new attachment "integration-active.png", version {1}
To version 176.1
edited by Dilisi S
on 2025/03/26 20:27
Change comment: Mar 26 edits - part 1

Summary

Details

Page properties
Content
... ... @@ -164,6 +164,7 @@
164 164  [[image:ins1.png||height="310" width="500"]]
165 165  
166 166  
167 +(% class="wikigeneratedid" %)
167 167  = 3. Creating Devices =
168 168  
169 169  
... ... @@ -205,97 +205,152 @@
205 205  [[image:create-new-converter-menu.png||height="259" width="500"]]
206 206  
207 207  
208 -The **Add data converter** window will appear.
209 +The **Add data converter** window will appear. Name it ‘**MQTT Uplink Converter NB/CB**’ and select the Type as **Uplink**.
209 209  
210 -Let's create an uplink data converter for the device named '**Device A**'. Name it ‘**MQTT Uplink Converter - Device A**’ and select the Type as **Uplink**.
211 +Click on the **JavaScript** button.
211 211  
212 -Click on the **TBEL** button if it has not been selected by default.
213 +Delete the default decoder function in the code editor. Now copy and paste the following decoder function written in **JavaScript** in to the **code editor**. This decoder function is compatible for both NB and CB series devices.
213 213  
214 -Modify the default TBEL function to match with your device as described below:
215 +{{info}}
216 +Please note that the value assigned to the IMEI field in the payload will be used by ThingsBoard to create a device on the platform with the same name.
217 +{{/info}}
215 215  
216 -
217 -* Uncomment** line 11**:
218 -
219 -//var data = decodeToJson(payload)//
220 -
221 -
222 -* **Line 13**: Assign your device name to the **deviceName** field. - We used **Device A** as it is to match with our device, **Device A **in the Devices section.
223 -* From **line 38**: Modify the telemetry section to allow parsed data to be assigned to the fields.
224 -
225 -//telemetry: {
226 - temperature: data.temperature,
227 - humidity: data.humidity,
228 - rawData: payloadStr
229 - }//
230 -
231 -
232 -The modified uplink decoder function to match with **Device A** is shown below.
233 -
234 234  {{code language="JavaScript"}}
235 -// Decode an uplink message from a buffer
236 -// payload - array of bytes
237 -// metadata - key/value object
238 -
239 -/** Decoder **/
240 -
220 +//Version: 0.1
241 241  // decode payload to string
242 242  var payloadStr = decodeToString(payload);
243 243  
244 244  // decode payload to JSON
225 +var objdata = {};
226 +var obj1 = {};
245 245  var data = decodeToJson(payload);
228 +var deviceName = data.IMEI;
229 +delete data.IMEI;
230 +var modelname = "Dragino " + data.Model;
231 +//var mod = data.mod
232 +delete data.Model;
233 +//delete data.mod
234 +var timestamp = new Date().getTime();
246 246  
247 -var deviceName = 'Device A';
248 -var deviceType = 'thermostat';
249 -var customerName = 'Customer C';
250 -var groupName = 'thermostat devices';
251 -var manufacturer = 'Example corporation';
252 -// use assetName and assetType instead of deviceName and deviceType
253 -// to automatically create assets instead of devices.
254 -// var assetName = 'Asset A';
255 -// var assetType = 'building';
236 +for (var key in data) {
237 +
238 + if (Number(key)) {
239 + obj1[key] = data[key];
240 + obj1[key][obj1[key].length - 1] = Number(new Date(
241 + obj1[key][obj1[key].length - 1]));
256 256  
257 -// Result object with device/asset attributes/telemetry data
243 + }
244 +//Alec submitted25/02/25
245 +//turn old key into new
246 + else if (key === "Reading") {
247 + objdata["reading"] = data[key];
248 + } else if (key === "work mode") {
249 + objdata["work_mode"] = data[key];
250 + } else if (key === "hum") {
251 + objdata["humidity"] = data[key];
252 + }else if (key === "hum2") {
253 + objdata["humidity2"] = data[key];
254 + } else if (key === "hum3") {
255 + objdata["humidity3"] = data[key];
256 + } else if (key === "tem") {
257 + objdata["temperature"] = data[key];
258 + } else if (key === "tem2") {
259 + objdata["temperature2"] = data[key];
260 + } else if (key === "tem3") {
261 + objdata["temperature3"] = data[key];
262 + } else if (key === "DS18B20_Temp") {
263 + objdata["temperature_pro"] = data[key];
264 + } else if (key === "ds18b20_temperature") {
265 + objdata["temperature_pro"] = data[key];
266 + } else if (key === "DS18B20_temperature_pro") {
267 + objdata["temperature_pro"] = data[key];
268 + } else if (key === "tdc send flag") {
269 + objdata["tdc_send_flag"] = data[key];
270 + } else if (key === "trigger mode") {
271 + objdata["trigger_mode"] = data[key];
272 + } else if (key === "soil dielectric constant") {
273 + objdata["soil_dielectric_constant"] = data[key];
274 + } else if (key === "door open num") {
275 + objdata["door_open_num"] = data[key];
276 + } else if (key === "door duration") {
277 + objdata["door_duration"] = data[key];
278 + } else if (key === "count time") {
279 + objdata["count_time"] = data[key];
280 + } else if (key === "last open time2") {
281 + objdata["last_open_time2"] = data[key];
282 + } else if (key === "last open time3") {
283 + objdata["last_open_time3"] = data[key];
284 + }
285 +//Alec submitted25/02/25
286 + else {
287 + objdata[key] = data[key]
288 + }
289 +}
290 +var listdata = [{
291 + "ts": timestamp,
292 + "values": objdata
293 +}]
294 +for (var key1 in obj1) {
295 + if (modelname == "Dragino RS485-NB") {
296 + listdata.push({
297 + "ts": obj1[key1][obj1[key1].length - 1],
298 + "values": {
299 + "Payload": obj1[key1][0],
300 + }
301 + })
302 + } else {
303 + listdata.push({
304 + "ts": obj1[key1][obj1[key1].length - 1],
305 + "values": {
306 + "values": obj1[key1]
307 + },
308 + })
309 + }
310 +}
258 258  var result = {
259 -// Use deviceName and deviceType or assetName and assetType, but not both.
260 - deviceName: deviceName,
261 - deviceType: deviceType,
262 -// assetName: assetName,
263 -// assetType: assetType,
264 -// customerName: customerName,
265 - groupName: groupName,
266 - attributes: {
267 - model: 'Model A',
268 - serialNumber: 'SN111',
269 - integrationName: metadata['integrationName'],
270 - manufacturer: manufacturer
271 - },
272 - telemetry: {
273 - temperature: data.temperature,
274 - humidity: data.humidity,
275 - rawData: payloadStr
276 - }
277 -};
278 278  
279 -/** Helper functions 'decodeToString' and 'decodeToJson' are already built-in **/
313 + deviceName: deviceName,
314 + deviceType: modelname,
315 + attributes: {
316 + model: modelname,
317 + //customerName: "NB-CB",
318 + //groupName: "NB-CB",
319 + //integrationName: metadata['integrationName']
280 280  
321 + },
322 + telemetry: listdata
323 +}
324 +
325 +function decodeToString(payload) {
326 + return String.fromCharCode.apply(String, payload);
327 +}
328 +
329 +function decodeToJson(payload) {
330 + // covert payload to string.
331 + var str = decodeToString(payload);
332 +
333 + // parse string to JSON
334 + var data = JSON.parse(str);
335 + return data;
336 +}
337 +
281 281  return result;
282 282  {{/code}}
283 283  
284 284  
285 -Once you modify the decoder function, click on the **Add** button.
342 +Click on the **Add** button.
286 286  
287 287  
345 +[[image:mqtt-uplink.png||width="500"]]
288 288  
289 -[[image:ul-data-converter-device-a.png||height="524" width="500"]]
290 290  
291 291  
292 292  You should see that the newly added **MQTT Uplink converter **NB/CB is listed on the **Data Converters** page.
293 293  
294 294  
295 -[[image:ul-data-converter-added.png||height="257"]]
352 +[[image:data-converter-list-showing-uplink-dc.png]]
296 296  
297 297  
298 -
299 299  = 5. Add Integration =
300 300  
301 301  
... ... @@ -316,7 +316,7 @@
316 316  **Basic settings:**
317 317  
318 318  * **Integration type**: MQTT
319 -* **Name**: MQTT integration - Device A
375 +* **Name**: MQTT integration NB/CB
320 320  * **Enable integration**: YES
321 321  * **Allows create devices or assets**: YES
322 322  
... ... @@ -323,11 +323,9 @@
323 323  Click **Next** button.
324 324  
325 325  
326 -[[image:add-integration-basic-settings.png||height="504" width="500"]]
382 +[[image:add-integration-basic-settings.png||height="511" width="500"]]
327 327  
328 328  
329 -
330 -
331 331  **Uplink data converter:**
332 332  
333 333  * Click on the **Select existing** button.
... ... @@ -336,10 +336,9 @@
336 336  Click **Next** button.
337 337  
338 338  
339 -[[image:add-integration-ul-data-converter.png||height="505" width="500"]]
393 +[[image:add-integration-uplink-data-converter.png||height="511" width="500"]]
340 340  
341 341  
342 -
343 343  **Downlink data converter:**
344 344  
345 345  Dragino NB/CB devices don't require a downlink data converter to decode their payloads, so you can skip this step.
... ... @@ -355,20 +355,19 @@
355 355  
356 356  **Connection:**
357 357  
358 -* **Host**: Host URL (Eg. **//011731f7xxxxxxxxxxxfbbedfc63f4.s1.eu.hivemq.cloud//**)
411 +* **Host**: Cluster URL (Eg. 011731f7xxxxxxxxxxxfbbedfc63f4.s1.eu.hivemq.cloud)
359 359  * **Port**: 8883
360 -* **Credentials type**: Basic
413 +* **Credentials**: Basic
414 +* **Enable SSL**: YES
361 361  * **Username**: Username (from your HiveMQ Cloud Cluster with your credentials)
362 362  * **Password:** Password (from your HiveMQ Cloud Cluster with your credentials)
363 -* **Enable SSL**: YES
364 -* **Topic: device/a** (The topic can be anything; you can even use just the device name.)
417 +* **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 S31B-NB.)
365 365  * **QoS:** 0-At most once
366 366  
367 367  
421 +[[image:add-integration-connection.png||height="511" width="500"]]
368 368  
369 -[[image:add-integartion-connection.png||height="505" width="500"]]
370 370  
371 -
372 372  Click on the **Advanced settings** button.
373 373  
374 374  * **Clean session:** YES
... ... @@ -407,15 +407,15 @@
407 407  
408 408  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.
409 409  
410 -The Mosquitto client publishes messages (payloads) on the topic **/device/a**. Of course, you can use any topic for testing.
462 +The Mosquitto client publishes messages (payloads) on the topic **v1/devices/me/telemetry**. Of course, you can use any topic for testing.
411 411  
412 -(% id="cke_bm_37386S" style="display:none" %) (%%)The MQTT payload format is as follows:
464 +(% 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.
413 413  
414 414  {{code language="none"}}
415 -{"IMEI": "350693903995577", "temperature":25, "humidity":80, "pressure":1005}
467 +{"IMEI": "S31B-NB", "temperature": 27, ......}
416 416  {{/code}}
417 417  
418 -Once ThingsBoard receives this message, it forwards this payload to the matching device through the integration.
470 +Once ThingsBoard receives this message, it automatically creates (provisions) the device mentioned in the **IMEI**, for example, S31B-NB.
419 419  
420 420  
421 421  == 5.2 Sending messages ==
... ... @@ -424,7 +424,7 @@
424 424  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.
425 425  
426 426  {{code language="none"}}
427 -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}'
479 +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}'
428 428  {{/code}}
429 429  
430 430  If the integration was performed without errors, the status of the integration changes to 'Active' after the first telemetry transmission.
... ... @@ -433,8 +433,12 @@
433 433  [[image:integration-active.png]]
434 434  
435 435  
488 +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**.
436 436  
437 437  
491 +[[image:new-device.png]]
492 +
493 +
438 438  == 6.3 Viewing messages ==
439 439  
440 440  
... ... @@ -460,22 +460,18 @@
460 460  
461 461  Select the Event type as **Debug** from the dropdown list.
462 462  
463 -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.
519 +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.
464 464  
465 465  
466 -[[image:Screenshot 2025-03-26 at 19.49.31.png]]
522 +[[image:Screenshot 2025-03-16 at 18.38.59.png]]
467 467  
468 468  
469 -
470 -
471 471  Then click on the **three dots (...)** in the **Message** column. You can see the uplink message's **payload** in the **Message** window.
472 472  
473 473  
474 -[[image:Screenshot 2025-03-26 at 19.47.52.png]]
528 +[[image:Screenshot 2025-03-16 at 18.39.12.png]]
475 475  
476 476  
477 -
478 -
479 479  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.
480 480  
481 481  
... ... @@ -593,3 +593,4 @@
593 593  [[image:image-4.png]]
594 594  
595 595  
648 +
Screenshot 2025-03-26 at 18.15.08.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -92.2 KB
Content
Screenshot 2025-03-26 at 19.47.52.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -168.4 KB
Content
Screenshot 2025-03-26 at 19.49.31.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -133.0 KB
Content
add-integartion-connection.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -110.3 KB
Content
add-integartion-connetcion.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -146.0 KB
Content
add-integration-basic-settings.png
Size
... ... @@ -1,1 +1,1 @@
1 -123.8 KB
1 +122.5 KB
Content
add-integration-ul-data-converter.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -121.2 KB
Content
integration-active.png
Size
... ... @@ -1,1 +1,1 @@
1 -64.1 KB
1 +64.2 KB
Content
integration-added.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -196.2 KB
Content
ul-data-converter-added.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -189.4 KB
Content
ul-data-converter-device-a.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.pradeeka
Size
... ... @@ -1,1 +1,0 @@
1 -168.3 KB
Content