Wiki source code of ThingsBoard
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | **Table of Contents:** | ||
2 | |||
3 | {{toc/}} | ||
4 | |||
5 | {{warning}} | ||
6 | Draft Document | ||
7 | {{/warning}} | ||
8 | |||
9 | |||
10 | |||
11 | |||
12 | = 1. Introduction = | ||
13 | |||
14 | |||
15 | This document guides you on integrating Dragino **-NB** and **-CB** series devices data with ThingsBoard. For this guide, we use ThingsBoard Cloud, which is one of the ThingsBoard versions that allows you to try it for free. | ||
16 | |||
17 | The **NB series** devices end with the suffix **-NB**, and the **CB series** devices end with the suffix **-CB**. For example, **S31B-NB** is an **NB device**, and **S31-CB** is a **CB device**. | ||
18 | |||
19 | |||
20 | = 2. Add New Device = | ||
21 | |||
22 | |||
23 | First, we will add a device to simulate data using MQTT. This device does not represent a real physical device but serves as a common virtual device for all Dragino NB/CB devices. | ||
24 | |||
25 | In the left navigation, click **Entities** and then click **Devices**. | ||
26 | |||
27 | [[image:device-list-empty.png]] | ||
28 | |||
29 | |||
30 | On the **Devices **page, click on the ‘**+**’ button, and then click on the **Add new device **from the dropdown menu. | ||
31 | |||
32 | [[image:ThingsBoard-add-new-device.png||height="279" width="500"]] | ||
33 | |||
34 | |||
35 | The **Add new device** window appears. Name the device, for example '**Virtual NB/CB device**'. | ||
36 | |||
37 | Click on the **Next: Credentials** button. | ||
38 | |||
39 | [[image:new-device-device-details.png||height="529" width="500"]] | ||
40 | |||
41 | |||
42 | Click the **Access token** button if it is not selected by default. | ||
43 | |||
44 | Copy the **Access token** to a text editor, as you will need it in the section **'Sending data from an MQTT client'**. | ||
45 | |||
46 | Click on the **Add** button. | ||
47 | |||
48 | [[image:new-device-access-token.png||height="528" width="500"]] | ||
49 | |||
50 | |||
51 | Click on the **MQTT** button. | ||
52 | |||
53 | Then, select the operating system you are going to use with the **Mosquitto MQTT Broker**. This example shows sending a command from a computer running **MacOS**. First, install the necessary client tools on your computer. | ||
54 | |||
55 | Copy the MQTT pub command in the '**Execute the following command**' section. | ||
56 | |||
57 | {{code language="none"}} | ||
58 | mosquitto_pub -d -q 1 -h mqtt.eu.thingsboard.cloud -p 1883 -t v1/devices/me/telemetry -u "24vk3w9h7sqdld1me5eh" -m "{temperature:25}" | ||
59 | {{/code}} | ||
60 | |||
61 | Note that the **State** is still shown as **'Inactive'** in the **Latest telemetry** section. | ||
62 | |||
63 | [[image:new-device-check-connectivity.png||height="522" width="500"]] | ||
64 | |||
65 | |||
66 | On the terminal, enter the command you copied. This command sends the MQTT payload **{temperature:25}** as telemetry data from a virtual device named **'me'**. Of course, you can replace **'me'** with a device name or use the wildcard character **'+'** to match any device name. | ||
67 | |||
68 | |||
69 | [[image:mqtt-command-1.png||height="228" width="700"]] | ||
70 | |||
71 | |||
72 | If the command is successful, you can see the telemetry data you sent under the **Latest telemetry** section. Note that the **State** is now **'Active'** in the **Latest telemetry** section. | ||
73 | |||
74 | |||
75 | [[image:new-device-telemetry-test.png||height="520" width="500"]] | ||
76 | |||
77 | |||
78 | Send the same command again, only changing the **temperature** value, to see how the **Latest telemetry** section updates its data. | ||
79 | |||
80 | Once you are done experimenting with this, close the window by clicking the **Close** button. | ||
81 | |||
82 | |||
83 | [[image:mqtt-command-2.png||height="227" width="700"]] | ||
84 | |||
85 | |||
86 | |||
87 | [[image:virtual-device-active.png]] | ||
88 | |||
89 | |||
90 | = 3. Data Converters = | ||
91 | |||
92 | |||
93 | 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. | ||
94 | |||
95 | |||
96 | == 3.1 Uplink == | ||
97 | |||
98 | |||
99 | In the left navigation, click **Integrations center**, and then click **Data converters**. | ||
100 | |||
101 | [[image:data-converter-list-page.png]] | ||
102 | |||
103 | |||
104 | On the **Data converters** page, click on the ‘+’ button, and then click on the **Create new converter** from the dropdown menu. | ||
105 | |||
106 | [[image:ThingsBoard-new-data-converter.png||height="282" width="500"]] | ||
107 | |||
108 | |||
109 | The **Add data converter** window will appear. Name it ‘**MQTT Uplink Converter NB/CB**’ and select the Type as **Uplink**. | ||
110 | |||
111 | Click on the **JavaScript** button. Now copy and paste the following JavaScript to the **Decoder function** section. This decoder function is valid for both NB and CB series devices. | ||
112 | |||
113 | {{code language="JavaScript"}} | ||
114 | //Version: 0.1 | ||
115 | // decode payload to string | ||
116 | var payloadStr = decodeToString(payload); | ||
117 | |||
118 | // decode payload to JSON | ||
119 | var objdata = {}; | ||
120 | var obj1 = {}; | ||
121 | var data = decodeToJson(payload); | ||
122 | var deviceName = data.IMEI; | ||
123 | delete data.IMEI; | ||
124 | var modelname = "Dragino " + data.Model; | ||
125 | //var mod = data.mod | ||
126 | delete data.Model; | ||
127 | //delete data.mod | ||
128 | var timestamp = new Date().getTime(); | ||
129 | |||
130 | for (var key in data) { | ||
131 | |||
132 | if (Number(key)) { | ||
133 | obj1[key] = data[key]; | ||
134 | obj1[key][obj1[key].length - 1] = Number(new Date( | ||
135 | obj1[key][obj1[key].length - 1])); | ||
136 | |||
137 | } | ||
138 | //Alec submitted25/02/25 | ||
139 | //turn old key into new | ||
140 | else if (key === "Reading") { | ||
141 | objdata["reading"] = data[key]; | ||
142 | } else if (key === "work mode") { | ||
143 | objdata["work_mode"] = data[key]; | ||
144 | } else if (key === "hum") { | ||
145 | objdata["humidity"] = data[key]; | ||
146 | }else if (key === "hum2") { | ||
147 | objdata["humidity2"] = data[key]; | ||
148 | } else if (key === "hum3") { | ||
149 | objdata["humidity3"] = data[key]; | ||
150 | } else if (key === "tem") { | ||
151 | objdata["temperature"] = data[key]; | ||
152 | } else if (key === "tem2") { | ||
153 | objdata["temperature2"] = data[key]; | ||
154 | } else if (key === "tem3") { | ||
155 | objdata["temperature3"] = data[key]; | ||
156 | } else if (key === "DS18B20_Temp") { | ||
157 | objdata["temperature_pro"] = data[key]; | ||
158 | } else if (key === "ds18b20_temperature") { | ||
159 | objdata["temperature_pro"] = data[key]; | ||
160 | } else if (key === "DS18B20_temperature_pro") { | ||
161 | objdata["temperature_pro"] = data[key]; | ||
162 | } else if (key === "tdc send flag") { | ||
163 | objdata["tdc_send_flag"] = data[key]; | ||
164 | } else if (key === "trigger mode") { | ||
165 | objdata["trigger_mode"] = data[key]; | ||
166 | } else if (key === "soil dielectric constant") { | ||
167 | objdata["soil_dielectric_constant"] = data[key]; | ||
168 | } else if (key === "door open num") { | ||
169 | objdata["door_open_num"] = data[key]; | ||
170 | } else if (key === "door duration") { | ||
171 | objdata["door_duration"] = data[key]; | ||
172 | } else if (key === "count time") { | ||
173 | objdata["count_time"] = data[key]; | ||
174 | } else if (key === "last open time2") { | ||
175 | objdata["last_open_time2"] = data[key]; | ||
176 | } else if (key === "last open time3") { | ||
177 | objdata["last_open_time3"] = data[key]; | ||
178 | } | ||
179 | //Alec submitted25/02/25 | ||
180 | else { | ||
181 | objdata[key] = data[key] | ||
182 | } | ||
183 | } | ||
184 | var listdata = [{ | ||
185 | "ts": timestamp, | ||
186 | "values": objdata | ||
187 | }] | ||
188 | for (var key1 in obj1) { | ||
189 | if (modelname == "Dragino RS485-NB") { | ||
190 | listdata.push({ | ||
191 | "ts": obj1[key1][obj1[key1].length - 1], | ||
192 | "values": { | ||
193 | "Payload": obj1[key1][0], | ||
194 | } | ||
195 | }) | ||
196 | } else { | ||
197 | listdata.push({ | ||
198 | "ts": obj1[key1][obj1[key1].length - 1], | ||
199 | "values": { | ||
200 | "values": obj1[key1] | ||
201 | }, | ||
202 | }) | ||
203 | } | ||
204 | } | ||
205 | var result = { | ||
206 | |||
207 | deviceName: deviceName, | ||
208 | deviceType: modelname, | ||
209 | attributes: { | ||
210 | model: modelname, | ||
211 | //customerName: "NB-CB", | ||
212 | //groupName: "NB-CB", | ||
213 | //integrationName: metadata['integrationName'] | ||
214 | |||
215 | }, | ||
216 | telemetry: listdata | ||
217 | } | ||
218 | |||
219 | function decodeToString(payload) { | ||
220 | return String.fromCharCode.apply(String, payload); | ||
221 | } | ||
222 | |||
223 | function decodeToJson(payload) { | ||
224 | // covert payload to string. | ||
225 | var str = decodeToString(payload); | ||
226 | |||
227 | // parse string to JSON | ||
228 | var data = JSON.parse(str); | ||
229 | return data; | ||
230 | } | ||
231 | |||
232 | return result; | ||
233 | |||
234 | {{/code}} | ||
235 | |||
236 | |||
237 | Click on the **Add** button. | ||
238 | |||
239 | [[image:uplink-data-converter.png||height="529" width="500"]] | ||
240 | |||
241 | |||
242 | You should see that the newly added **uplink data converter** is listed on the **Data Converters** page. | ||
243 | |||
244 | [[image:data-converter-list-showing-uplink-dc.png]] | ||
245 | |||
246 | |||
247 | == 3.2 Downlink == | ||
248 | |||
249 | |||
250 | On the **Data converters** page, click on the ‘**+**’ button, and then click on the **Create new converter** from the dropdown menu. | ||
251 | |||
252 | [[image:ThingsBoard-new-data-converter.png||height="282" width="500"]] | ||
253 | |||
254 | |||
255 | The **Add data converter** window will appear. Name it ‘**MQTT Downlink Converter NB/CB**’ and select the Type as **Downlink**. | ||
256 | |||
257 | Click on the **JavaScript** button. Now copy and paste the following JavaScript to the **Encoder function **section. This encoder function is valid for both NB and CB series devices. | ||
258 | |||
259 | |||
260 | {{code language="JavaScript"}} | ||
261 | function hexToBase64(hexString) { | ||
262 | // 将16进制字符串两个字符转换为一个字节 | ||
263 | var bytes = hexString.match(/.{2}/g); | ||
264 | // 对每个字节进行解析,并转换为对应的字符 | ||
265 | var binaryString = bytes.map(function(byte) { | ||
266 | return String.fromCharCode(parseInt(byte, 16)); | ||
267 | }).join(''); | ||
268 | |||
269 | // 使用btoa进行base64编码 | ||
270 | return btoa(binaryString); | ||
271 | } | ||
272 | |||
273 | // Result object with encoded downlink payload | ||
274 | var result = { | ||
275 | // downlink data content type: JSON, TEXT or BINARY (base64 format) | ||
276 | contentType: "BINARY", | ||
277 | |||
278 | // downlink data | ||
279 | data:hexToBase64(metadata.shared_value) | ||
280 | |||
281 | // Optional metadata object presented in key/value format | ||
282 | //metadata: {} | ||
283 | |||
284 | }; | ||
285 | |||
286 | return result; | ||
287 | {{/code}} | ||
288 | |||
289 | |||
290 | Click on the **Add** button. | ||
291 | |||
292 | [[image:downlink-data-converter.png||height="530" width="500"]] | ||
293 | |||
294 | |||
295 | You should see that the newly added **downlink data converter** is listed on the **Data Converters** page. | ||
296 | |||
297 | [[image:data-converter-list.png]] | ||
298 | |||
299 | |||
300 | = 4. Add Integration = | ||
301 | |||
302 | |||
303 | In the left navigation, click **Integrations center**, and then click **Integrations**. | ||
304 | |||
305 | On the **Integrations** page, click on the '**+**' button. | ||
306 | |||
307 | [[image:data-converter-list-page.png]] | ||
308 | |||
309 | |||
310 | The **Add integration** window appears. | ||
311 | |||
312 | In the **Add integration** window, configure the following settings: | ||
313 | |||
314 | |||
315 | **Basic settings:** | ||
316 | |||
317 | * **Integration type**: MQTT | ||
318 | * **Name**: MQTT integration NB/CB | ||
319 | |||
320 | Click **Next** button. | ||
321 | |||
322 | [[image:add-integration-basic-settings.png||height="511" width="500"]] | ||
323 | |||
324 | |||
325 | **Uplink data converter:** | ||
326 | |||
327 | * Click on the **Select existing** button. | ||
328 | * **Uplink data converter**: Select **MQTT Uplink Converter NB/CB **from the dropdown list. | ||
329 | |||
330 | Click **Next** button. | ||
331 | |||
332 | [[image:add-integration-uplink-data-converter.png||width="500"]] | ||
333 | |||
334 | |||
335 | **Downlink data converter:** | ||
336 | |||
337 | * Click on the **Select existing** button. | ||
338 | * **Downlink data converter**: Select **MQTT Downlink Converter NB/CB **from the dropdown list. | ||
339 | |||
340 | Click **Next** button. | ||
341 | |||
342 | [[image:add-integration-downlink-data-converter.png||height="510" width="500"]] | ||
343 | |||
344 | |||
345 | **Connection:** | ||
346 | |||
347 | * **Host**: mqtt.eu.thingsboard.cloud (This is the host name you copied from the device - See section xxxxx for more information) | ||
348 | * **Port**: 1883 (This is the port number you copied from the device - See section xxxxx for more information) | ||
349 | * **Credentials**: Basic | ||
350 | * **Username**: Access token (This is the access token you copied from the device) | ||
351 | * **Password** - Leave it as blank | ||
352 | * **Topic** - v1/devices/+/telemetry (sightly modify the topic 'v1/devices/me/telemetry' you copied from the device to enable receiving data from any 'device name') | ||
353 | * **QoS** - 0-At most once | ||
354 | |||
355 | Click on the **Check connection** button to verify the MQTT connection using the provided parameters. | ||
356 | |||
357 | [[image:add-integration-connection.png||width="500"]] | ||
358 | |||
359 | |||
360 | If the connection is successful, you will see the **Connected** message. | ||
361 | |||
362 | Click on the **Add** button. | ||
363 | |||
364 | [[image:add-connection-success.png||height="511" width="500"]] | ||
365 | |||
366 | |||
367 | You should see that the newly added integration is listed on the **Integrations** page. | ||
368 | |||
369 | Since we haven't received data from a device yet, the integration **Status** is shown as **Pending.** | ||
370 | |||
371 | [[image:integrations-list-added-pending.png]] | ||
372 | |||
373 | |||
374 | = 5. Verifying the receipt of data from the device = | ||
375 | |||
376 | |||
377 | On the terminal, issue the following MQTT command which simulates the device S31B-NB. | ||
378 | |||
379 | {{code language="none"}} | ||
380 | mosquitto_pub -d -q 1 -h mqtt.eu.thingsboard.cloud -p 1883 -t v1/devices/S31B-NB/telemetry -u "24vk3w9h7sqdld1me5eh" -m "{temperature:20}" | ||
381 | {{/code}} | ||
382 | |||
383 | If the integration was performed without errors, after the transmission of the first telemetry, a new device with the name “S31B-NB” will appear in the Devices → All. Also, you can verify the input and output data, respectively, before and after conversion in Data converters → UDP Uplink Converter NB/CB → Events. | ||
384 | |||
385 |