Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03

From 41.1 to 40.1 From 63.1 to 62.1

From version 62.1

edited by Theodore Xu
on 2023/08/24 17:27

Change comment: There is no comment for this version

To version 41.1

edited by Hunter
on 2023/03/17 18:05

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.AiXia
++XWiki.Hunter

Content

@@ -1,9 +1,9 @@
  = **1 General Script Demo** =
--== **1.1 Address Operation** ==
++== **1.1 Address Operation:Write/Read data from address A to B** ==
  (((
--Write/Read data from address A to B**. **For example:transfer D2 to D0
++For example:transfer D2 to D0
  )))
  (% style="text-align:center" %)
@@ -27,19 +27,25 @@
  == **1.4 Short message** ==
--The following demo shows that when the alarm condition is reached: temp1 > 5 & temp2 >10 & temp3 < 20(lasts more than 5 seconds) , then send an "alarm trigger" sms.
++When the alarm condition is reached: temp1 > 5 & temp2 >10 & temp3 < 20(lasts more than 5 seconds) , then send an "alarm trigger" sms.
--When the alarm condition is released，then send an  "alarm release" sms. Script is as below:
++When the alarm condition is released，then send an "alarm release" sms.
--{{code language="lua"}}
++(% style="text-align:center" %)
++[[image:1645535936750-316.png||height="385" width="400" class="img-thumbnail"]]
++
++Script is as below:
++
++(% class="box infomessage" %)
++(((
  function sms.main()
--------send condition------
++~-~-~-~-~-~-send condition~-~-~-~-~-~-
  local temp1 = addr_getword("@Temperature1")
  local temp2 = addr_getword("@Temperature2")
  local temp3 = addr_getword("@Temperature3")
  local timer = addr_getword("@Timer")
  local tag = addr_getbit("@Tag")
--------lasting time------
++~-~-~-~-~-~-lasting time~-~-~-~-~-~-
  if temp1 > 5 and temp2 > 10 and temp3 < 20 then
      timer = timer + 1
      addr_setword("@Timer",timer)
@@ -47,7 +47,7 @@
      timer = 0
      addr_setword("@Timer",timer)
  end
--------send sms & output Y0------
++~-~-~-~-~-~-send sms & output Y0~-~-~-~-~-~-
  if timer > 5 then
      if tag == 0 then
          send_sms_ira("19859254700","alarm trigger")
@@ -58,7 +58,7 @@
  addr_setbit("@Tag",0)
  end
  end
--{{/code}}
++)))
  == **1.5 Telegram notification** ==
@@ -139,7 +139,7 @@
  This example shows how to use the LINE Notify to send message into LINE group. When monitoring bit "@test" changes, it will trigger and send the message. Please replace with your own Token.
--{{code language="lua"}}
++{{code}}
  local tempBit = 0
  local tempWord = 0
@@ -343,7 +343,7 @@
  end
  {{/code}}
--== **1.8 HTTP response body** ==
++== **1.8 How to parse value from HTTP response body** ==
  This example use [[https:~~/~~/www.weatherapi.com/>>https://www.weatherapi.com/]] as example, to show how to parse value from HTTP response body. When we input the city name into address "@HDW5050":
@@ -441,39 +441,8 @@
  end
  {{/code}}
--== **1.9 High-Low Byte Switch** ==
++= **2 V-Box connect with third part server** =
--The following example is converting the floating number from order 1234 to order 3412, and formating output the number with 2 decimal point. About which high-low word order corresponding to which value, please refer to the [[Address Operation Table>>doc:V-BOX.V-Net.Manual.04 Lua Script.01 Lua Functions.WebHome||anchor="H2Addressoperation"]].
--
--{{code language="lua"}}
--function highLowByteSwitch(floatNumber)
--    addr_setfloat("@W_0#HDW23036",floatNumber,0,2)
--    local newFloat = addr_getfloat("@W_0#HDW23036")
--    local formattedFloat = string.format("%.2f",newFloat)
--    print("The formatted float value is the : "..formattedFloat)
--    return formattedFloat
--end
--{{/code}}
--
--== **1.10 Read 64bits Unsigned Value** ==
--
--In our built-in function library doesn't have the function for reading 64-bit unsigned format value, so the following function is for solve this. But if the number is greater 2^53, the precision will be lost. So the final result will be a little bit different from the original value.
--
--{{code language="lua"}}
--function addr_getquatra(address)
--    local highAddress = addr_newnoaddr(address,2)
--    local low32 = addr_getdword(address)
--    local high32 = addr_getdword(highAddress)
--    --print("the low number is "..low32)
--    --print("the high number is "..high32)
--    local formatVal = string.format("%64.0f",2^32*high32+low32)
--    print("the format value is ".. formatVal)
--    return formatVal
--end
--{{/code}}
--
--= **2 Third part server** =
--
  V-Box have two mode.One is for V-Net,User need to use WECON server to store data.We call this V-NET platform.
  (% class="mark" %)1.Europe server:eu.v-box.net
@@ -497,7 +497,7 @@
  (% class="wikigeneratedid" %)
  Tool link: **[[MQTT.fx>>http://mqttfx.jensd.de/index.php/download]]**
--== **2.1 Test server(General Example)** ==
++== **2.1 V-Box connect with test server(General Example)** ==
  The following example is trying to publish to the topic "testtopic/test/no1/7890", and subscribe the topic "testtopic/test/no1/123456".
@@ -521,7 +521,6 @@
  {{code language="lua"}}
  --MQTT configuration table
  local MQTT_CFG={}
----if there is no need the username and password, please put them as ""
  MQTT_CFG.username = "weconsupport"
  MQTT_CFG.password = "123456"
  MQTT_CFG.netway = 0
@@ -561,7 +561,7 @@
  function mqtt_init()
      print(string.format("mqtt init mqtt_url:%s mqtt_clientid:%s", MQTT_URL, MQTT_CLIENT_ID))
      if g_mq then
--        mqtt.close(g_mq) --Close mqtt object
++        mqtt.close() --Close mqtt object
      end
      g_mq, err = mqtt.create(MQTT_URL, MQTT_CLIENT_ID) -- create mqtt object,and declare it as a global variable
      if g_mq then
@@ -646,7 +646,7 @@
  end
  {{/code}}
--== **2.2 Customer server:grouprobotinfo.com** ==
++== **2.2 V-Box connect with customer server:grouprobotinfo.com** ==
  This demo does not use SSL certification. Script is as below
@@ -787,7 +787,7 @@
  end
  {{/code}}
--== **2.3 Azure platform** ==
++== **2.3 V-Box connect with Azure platform** ==
  In this demo,V-Box connects with Azure by SSL certification.
@@ -918,12 +918,8 @@
  end
  )))
--== **2.4 Huawei platform** ==
++== **2.4 How to configure the Huawei platform?（✎Note: Huawei IOT DA function is only in China area.If you want this function,you need to use chinese mobile to register）** ==
--{{info}}
--**✎Note**:**Huawei IOT DA function is only in China area.If you want this function,you need to use chinese mobile to register**
--{{/info}}
--
 .Register a account: [[https:~~/~~/www.huaweicloud.com/intl/en-us/s/JUlPVERNJQ>>https://www.huaweicloud.com/intl/en-us/s/JUlPVERNJQ]]
 .log in the Huawei IOTDA
@@ -1071,8 +1071,10 @@
  (% style="text-align:center" %)
  [[image:1624441186851-536.png||height="434" width="700" class="img-thumbnail"]]
--=== Huawei by SSL certification. ===
++== **2.5 V-Box connect with Huawei platform** ==
++In this demo,V-Box connects with Huawei by SSL certification.
++
 .Create a project access for Huawei IOT
 .configure MQTT configuration
@@ -1190,7 +1190,7 @@
  (% style="text-align:center" %)
  [[image:1624506666650-161.png||height="547" width="1000" class="img-thumbnail"]]
--== **2.6 AWS platform** ==
++== **2.6 V-Box connect with AWS platform** ==
  === **Log in AWS** ===
@@ -1255,7 +1255,7 @@
  [[image:image-20220709165402-11.png]]
--=== **MQTT.fx tool** ===
++=== **Test with MQTT.fx tool** ===
  Click “View Setting” to get the “Broker Adress”
@@ -1283,7 +1283,7 @@
  [[image:image-20220709165402-18.png]]
--=== **CloudTool** ===
++=== **Configurate in CloudTool** ===
  Copy the same setting in MQTT.fx to MQTT configuration
@@ -1481,67 +1481,3 @@
  Get message in AWS
  [[image:image-20220709165402-21.png]]
--
--= **2.7 Mysql** =
--
--
--
--=== 1.Install Mysql software ===
--
--Download the latest version of Mysql.
--
--(% style="text-align:center" %)
--[[image:Mysql的软件版本.png||height="673" width="894"]]
--
--=== 2.Navicat connect Mysql ===
--
--Connecting to Mysql with navicat.
--
--(% style="text-align:center" %)
--[[image:连接到mysql.png]]
--
--=== 3.Create a database ===
--
--Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
--
--(% style="text-align:center" %)
--[[image:创建数据库.png||height="585" width="818"]]
--
--=== 4.Create a data table ===
--
--Create a table, enter the fields you need.
--
--(% style="text-align:center" %)
--[[image:创建表1.png||height="484" width="737"]]
--
--Save, enter table name.
--
--(% style="text-align:center" %)
--[[image:创建表2.png]]
--
--=== 5.Input Table Data ===
--
--(% style="text-align:center" %)
--[[image:输入或者导入数据.png]]
--
--=== 6.Modifying scripts and debug：**[[Mysql script>>https://docs.we-con.com.cn/bin/view/V-BOX/V-Net/Manual/04%20Lua%20Script/01%20Lua%20Functions/\#H11MySQLdatabaseoperation]]** ===
--
--(% style="text-align:center" %)
--[[image:调试结果.png]]
--
--=== 7.Problem ===
--
--During our debugging process it may there are some problems about Mysql， such as
--
--* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
--* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
--* MySQL: SSL connection error: unknown error number.
--* (((
--1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
--)))
--
--This type of problem has nothing to do with scripts or devices, it is a Mysql configuration issue. If you have any of these problems, please look for a solution online.
--
--{{info}}
--✎Note: If you want to use CMD to access Mysql, you need to add the bin file to the environment variable, please check online for details of the operation.
--{{/info}}

Changes for page 2 Script

Summary

Details

Navigation

Table of Contents