EcoStruxure Augmented Operator Advisor - Manager - 用户手册 - 05/2019

Size: px

Start display at page:

Download "EcoStruxure Augmented Operator Advisor - Manager - 用户手册 - 05/2019"

低璩
4 years ago
Views:

1 EcoStruxure Augmented Operator Advisor EIO /2019 EcoStruxure Augmented Operator Advisor Manager 用户手册 05/2019 EIO

2 本文档中提供的信息包含有关此处所涉及产品之性能的一般说明和 / 或技术特性本文档并非用于 ( 也不代替 ) 确定这些产品对于特定用户应用场合的适用性或可靠性任何此类用户或设备集成商都有责任就相关特定应用场合或使用方面对产品执行适当且完整的风险分析评估和测试 Schneider Electric 或其任何附属机构或子公司对于误用此处包含的信息而产生的后果概不负责如果您有关于改进或更正此出版物的任何建议或者从中发现错误请通知我们本手册可用于法律所界定的个人以及非商业用途在未获得施耐德电气书面授权的情况下, 不得翻印传播本手册全部或部分相关内容亦不可建立任何有关本手册或其内容的超文本链接施耐德电气不对个人和非商业机构进行非独占许可以外的授权或许可请遵照本手册或其内容原义并自负风险与此有关的所有其他权利均由施耐德电气保留在安装和使用本产品时, 必须遵守国家地区和当地的所有相关的安全法规出于安全方面的考虑和为了帮助确保符合归档的系统数据, 只允许制造商对各个组件进行维修当设备用于具有技术安全要求的应用场合时, 必须遵守有关的使用说明未能使用施耐德电气软件或认可的软件配合我们的硬件, 则可能导致人身伤害设备损坏或不正确的运行结果不遵守此信息可能导致人身伤害或设备损坏 2019 Schneider Electric 保留所有权利 2 EIO /2019

3 目录安全信息关于本书第 1 章简介 EcoStruxure Augmented Operator Advisor Manager 简介第 2 章使用 Augmented Operator Advisor Manager 启动 EcoStruxure Augmented Operator Advisor Manager 用户管理 Node-RED 管理注释管理过程附录附录 A EcoStruxure Augmented Operator Advisor 的 Node-RED 样例将来自 MySQL 数据库的数据整合到 EcoStruxure Augmented Operator Advisor 中将来自 EcoStruxure Augmented Operator Advisor 的数据写入到 MySQL 数据库术语表 EIO /2019 3

4 4 EIO /2019

5 安全信息重要信息声明在试图安装操作维修或维护设备之前, 请仔细阅读下述说明并通过查看来熟悉设备下述特定信息可能会在本文其他地方或设备上出现, 提示用户潜在的危险, 或者提醒注意有关阐明或简化某一过程的信息 EIO /2019 5

6 请注意电气设备的安装操作维修和维护工作仅限于有资质的人员执行施耐德电气不承担由于使用本资料所引起的任何后果有资质的人员是指掌握与电气设备的制造和操作及其安装相关的技能和知识的人员, 他们经过安全培训能够发现和避免相关的危险 6 EIO /2019

7 关于本书概览文档范围本手册说明如何使用 EcoStruxure Augmented Operator Advisor Manager 软件在使用本文档前, 请先阅读 EcoStruxure Augmented Operator Advisor Quick Start Guide, 以便大概了解 EcoStruxure Augmented Operator Advisor 建议您在使用本产品前先接受 EcoStruxure Augmented Operator Advisor 培训有效性说明本文档适用于 EcoStruxure Augmented Operator Advisor 的版本 2.3 注册商标 : EcoStruxure Vijeo 和 Magelis 是 Schneider Electric 的注册商标 Chrome Google Pixel C 和 Android 是 Google LLC 的注册商标 Internet Explorer Microsoft Edge 和 Windows 是 Microsoft Corporation 的注册商标 Firefox 是 The Mozilla Foundation 的注册商标 ios 和 ipad 是 Apple 的注册商标 Samsung Galaxy 是 Samsung Electronics Co Ltd 的注册商标 EIO /2019 7

8 相关的文件文件名称参考编号 EcoStruxure Augmented Operator Advisor Quick Start Guide EIO ( 英语 ) EIO ( 法语 ) EIO ( 德语 ) EIO ( 西班牙语 ) EIO ( 意大利语 ) EIO ( 简体中文 ) EIO ( 日语 ) EIO ( 韩语 ) EcoStruxure Augmented Operator Advisor Builder User Manual EIO ( 英语 ) EIO ( 法语 ) EIO ( 德语 ) EIO ( 西班牙语 ) EIO ( 意大利语 ) EIO ( 简体中文 ) EIO ( 日语 ) EIO ( 韩语 ) EcoStruxure Augmented Operator Advisor App User Manual EIO ( 英语 ) EIO ( 法语 ) EIO ( 德语 ) EIO ( 西班牙语 ) EIO ( 意大利语 ) EIO ( 简体中文 ) EIO ( 日语 ) EIO ( 韩语 ) 您可以从我们的网站下载这些技术出版物和其它技术信息, 网址是 : 8 EIO /2019

9 关于产品的资讯此产品要求使用者在控制系统设计和操作方面具有一定的专业知识失去控制警告任何控制方案的设计者都必须考虑到控制路径可能出现故障的情况, 并为某些关键控制功能提供一种方法, 使其在出现路径故障时以及出现路径故障后恢复至安全状态关键控制功能的例子包括紧急停止和越程停止对于关键控制功能, 必须提供单独或冗余的控制路径系统控制路径可包括通讯链路必须对暗含的无法预料的传输延迟或链路失效问题加以考虑为了保证正确运行, 在投入使用前, 必须对 EcoStruxure Augmented Operator Advisor 的每次执行分别进行全面测试不遵循上述说明可能导致人员伤亡或设备损坏意外的设备操作警告只有在控制系统的设计和操作方面具有丰富专业知识的授权人员才能够对本产品进行编程安装改动和应用请遵守当地和国家的安全法规和标准不遵循上述说明可能导致人员伤亡或设备损坏假场景检测小心如果相似的设备和 / 或环境可能导致检测到假场景, 请使用标签将标签牢牢地设置到设备, 并采用足够的保护措施来防止标签受损或退化不遵循上述说明可能导致人身伤害或设备损坏 EIO /2019 9

10 未授权的操作员访问注意注意对用户名和密码保密用密码或其他安全机制保护平板电脑和 Runtime 设备不得与他人共享访问首次连接时, 更改缺省密码定期更新密码应用相关的本地 IT 规则不得将保密性信息保存在便利贴或笔记本中不要在项目中添加机密性或敏感性用户文档不遵循上述说明可能导致设备损坏 10 EIO /2019

11 EcoStruxure Augmented Operator Advisor EIO /2019 简介第 1 章简介 EcoStruxure Augmented Operator Advisor Manager 简介 EcoStruxure Augmented Operator Advisor Manager 包含在 EcoStruxure Augmented Operator Advisor Runtime Software 中在安装有 EcoStruxure Augmented Operator Advisor Runtime 的情况下 ( 参见 EcoStruxure Augmented Operator Advisor, 快速入门指南 ), 会自动安装 EcoStruxure Augmented Operator Advisor Manager 利用 EcoStruxure Augmented Operator Advisor Manager 软件, 您可以 : 管理用户证书 (Runtime/Manager 和 Operator), 并在用户选项卡中查看所有用户 ( 已添加的已删除的或已修改的用户 ) 在 EcoStruxure Augmented Operator Advisor App 的生产者选项卡中, 查看操作员完成的所有操作在 EcoStruxure Augmented Operator Advisor App 的注释选项卡中, 查看操作员创建的所有场景注释在 NODE-RED 选项卡中激活并编辑 Node-RED EIO /

12 12 EIO /2019

13 EcoStruxure Augmented Operator Advisor EIO /2019 使用第 Augmented Operator 2 Advisor 章 Manager 使用 Augmented Operator Advisor Manager 本章包含了哪些内容? 本章包含了以下主题 : 主题页启动 EcoStruxure Augmented Operator Advisor Manager 14 用户管理 15 Node-RED 管理 19 注释管理 21 过程 22 EIO /

启动 EcoStruxure Augmented Operator Advisor Manager 启动 EcoStruxure Augmented Operator Advisor Manager 在启动 EcoStruxure Augmented Operator Advisor Manager 之前, 确保您的 Runtime 设备上安装有 EcoStruxure Augmented

14 启动 EcoStruxure Augmented Operator Advisor Manager 启动 EcoStruxure Augmented Operator Advisor Manager 在启动 EcoStruxure Augmented Operator Advisor Manager 之前, 确保您的 Runtime 设备上安装有 EcoStruxure Augmented Operator Advisor Runtime, 您的防火墙已配置, 并且端口检查已成功完成 ( 参见 EcoStruxure Augmented Operator Advisor, 快速入门指南 ) 如要启动 EcoStruxure Augmented Operator Advisor Manager: 步骤操作 1 打开 EcoStruxure Augmented Operator Advisor Runtime, 然后单击 AOA Manager 结果 :EcoStruxure Augmented Operator Advisor Manager 打开注意 : 首次启动软件时, 会激活许可证, 如果使用的是试用版本, 则会显示许可证的剩余有效天数必须保持 EcoStruxure Augmented Operator Advisor Runtime Software 在后台运行如果 EcoStruxure Augmented Operator Advisor Runtime Software 未运行, 就无法登录到 EcoStruxure Augmented Operator Advisor Manager 2 使用缺省用户名和密码 (admin/admin) 登录注意 : 将密码保存在安全的地方, 并提供适当的保护 3 在打开的窗口中, 按照说明输入新管理员密码 14 EIO /2019

15 用户管理概述 EcoStruxure Augmented Operator Advisor 的用户有三种类型 : Builder 用户 Runtime/Manager 管理员 Operator 用户 Builder 用户是那些将访问 EcoStruxure Augmented Operator Advisor Builder 的用户没有证书的用户可以在 Builder 登录屏幕中注册 Runtime/Manager 管理员负责使用 EcoStruxure Augmented Operator Advisor Manager 配置用户和安全设置 Runtime/Manager 管理员必须拥有管理员权限 ( 最高安全级别 ) Operator 用户是那些将使用 EcoStruxure Augmented Operator Advisor App 的用户根据他们的不同用户权限 ( 安全级别 ), 他们将访问应用程序中的不同对象在 Builder 项目中, 对象具有安全级别数值安全级别数值等于或大于对象安全级别的 Operator 用户可以查看对象并与对象交互否则, 对象被隐藏或无法访问注意 : EcoStruxure Augmented Operator Advisor Manager 仅能够管理 ( 创建 / 修改 / 删除 ) 用户 (Runtime 和 Operator) 无法创建 Builder 用户无法删除 Admin 组 EIO /

创建 Operator 用户 Runtime 设备上的 EcoStruxure Augmented Operator Advisor Manager 能够用于创建 / 修改 / 删除 Operator 用户, 并为这类用户配置安全设置注意 : 只有拥有 Admin 权限的用户才能够登录到 EcoStruxure Augmented Operator Advisor Manager 软件

16 创建 Operator 用户 Runtime 设备上的 EcoStruxure Augmented Operator Advisor Manager 能够用于创建 / 修改 / 删除 Operator 用户, 并为这类用户配置安全设置注意 : 只有拥有 Admin 权限的用户才能够登录到 EcoStruxure Augmented Operator Advisor Manager 软件以下过程说明了如何在 EcoStruxure Augmented Operator Advisor Manager 中创建用户 : 步骤操作 1 如果尚未运行, 请从已安装的 Windows 程序列表中启动 EcoStruxure Augmented Operator Advisor Augmented Operator Advisor 结果 :EcoStruxure Augmented Operator Advisor 窗口随即打开 2 启动 AOA Manager 3 使用用户名和密码登录 4 单击用户选项卡 5 单击添加组, 创建新用户组所有用户必须属于某个组 16 EIO /2019

17 步骤操作 6 对组命名, 并输入安全级别安全级别是介于 0 与之间的数字数字越大, 安全权限就越大 Admin 权限对应于最高安全级别组内的所有用户都具有该组的安全级别单击确认, 确认组创建 7 单击添加用户, 创建新用户 EIO /

18 步骤操作 8 输入用户名和密码还应选择用户将属于的组单击确认, 确认用户创建注意 : 您可以选中专用模式复选框, 为用户授予专用权限 Expert 用户能够跳过某些步骤, 而非 Expert 用户则必须一一沿循这些步骤更改 Runtime/Manager 用户密码在页面右上角, 单击已登录 Runtime/Manager 用户的可用详细信息, 从下拉列表中选择配置信息, 更改密码 18 EIO /2019

19 Node-RED 管理简介 Node-RED 是一款开源可视化编程工具, 它几乎不需要编程技能它使用的是预编程且可重复使用的代码块 ( 称为节点 ) 节点线连接在一起, 以创建数据流 Node-RED 随附在 Runtime 设备的 EcoStruxure Augmented Operator Advisor Manager 中利用它, 您可以将 Node-RED 流轻松连接到目标点, 进而在您的增强现实应用程序中显示 SQL 数据库 Node-RED 包括以下组件 : Node-RED 引擎 Node-RED 编辑器您可以管理 Node-RED 引擎激活 ( 启动或停止 ), 还可以将其设置为自动或手动启动您还可以启动 Node-RED 编辑器, 以修改 Node-RED 参数启动 Node-RED 引擎以下过程说明了如何启动 Node-RED 引擎 : 步骤操作 1 转到开始菜单, 从已安装的 Windows 程序列表中启动 EcoStruxure Augmented Operator Advisor Augmented Operator Advisor 结果 :EcoStruxure Augmented Operator Advisor 窗口随即打开 2 启动 AOA Manager 3 使用 Admin 组用户名和密码登录 4 单击 Node-Red 选项卡 5 单击启动按钮, 启动 Node-RED 引擎结果 :Node-RED 引擎的状态 ( 开 / 关 ) 显示在状态列中 EIO /

20 启动 Node-RED 编辑器以下过程说明了如何启动 Node-RED 编辑器 : 步骤操作 1 启动 Node-RED 引擎 ( 参见第 19 页 ) 2 启动 Node-RED 引擎后, 单击启动按钮启动 Node-RED 编辑器自动启动 Node-RED 以下过程说明了如何自动启动 Node-RED 引擎 : 步骤操作 1 启动 Node-RED 引擎 ( 参见第 19 页 ) 2 单击自动启动按钮, 可在每次启动服务器时自动启动 Node-RED 结果 :Node-RED 启动模式的状态 ( 自动 / 手动 ) 显示在状态列中 20 EIO /2019

21 注释管理在此选项卡中, 您可以看到操作员在 App 中创建的所有注释当在其平板设备上运行 App 时, 操作员可以在场景或子场景中创建注释操作员输入到注释中的信息可以用来改善项目注意 : 您可以使用每列中的箭头来更改列表中的显示顺序您可以使用图标删除报告中的列表条目 EIO /

22 过程在此选项卡中, 您可以看到操作员在 EcoStruxure Augmented Operator Advisor App 中执行的所有过程的报告您可以看到项目的名称和版本过程执行的日期和时间所采取的具体步骤以及执行过程的用户的名称注意 : 您可以使用每列中的箭头来更改列表中的显示顺序您可以使用图标删除报告中的列表条目 22 EIO /2019

23 EcoStruxure Augmented Operator Advisor EIO /2019 附录 EIO /

24 24 EIO /2019

25 EcoStruxure Augmented Operator Advisor 附录 EIO /2019 EcoStruxure 附录 Augmented Operator Advisor 的 Node-RED A样例 EcoStruxure Augmented Operator Advisor 的 Node-RED 样例概述本章介绍 MySQL 数据库与 EcoStruxure Augmented Operator Advisor 之间的数据流的样例本章包含了哪些内容? 本章包含了以下主题 : 主题页将来自 MySQL 数据库的数据整合到 EcoStruxure Augmented Operator Advisor 中 26 将来自 EcoStruxure Augmented Operator Advisor 的数据写入到 MySQL 数据库 30 EIO /

26 附录将来自 MySQL 数据库的数据整合到 EcoStruxure Augmented Operator Advisor 中概述 MySQL 数据可以被整合到 EcoStruxure Augmented Operator Advisor 中这里提供了两个示例, 说如如何执行此操作起始样例下面的样例显示了 SQL 变量在 EcoStruxure Augmented Operator Advisor 中的整合在调用了 SQL 之后,MySQL 数据库会返回两行数组, 其中包含变量名称和相关值来自 MySQL 数据库每个变量名称都与 EcoStruxure Augmented Operator Advisor 变量相关联 26 EIO /2019

27 附录将起始样例流部署到 Node-RED 中如要在 Node-RED 中部署此数据流 : 首先, 复制以下代码 [{"id":"90aecf00.2d5e3","type":"debug","z":"4a a494","name":"optional help node for debugging the Augmented Operator result","active":true,"tosidebar":true,"console":false,"complete":"statuscode","x":83 0,"y":500,"wires":[]},{"id":"56ad79c5.7a0d98","type":"Augmented-Operatorserver","z":"4a a494","arserverport":"8082","arservermethod":"PUT","arserverb ufferinterval":"0","x":760,"y":460,"wires":[["90aecf00.2d5e3"]]},{"id":"93b1903e.49d6 d","type":"augmented-operatorvariable","z":"4a a494","arservervarnamespace":"","arservervarname":"arvar2", "arserverdatatype":"string","arservervaluetype":"msg","arservervalue":"payload","x":5 80,"y":420,"wires":[["56ad79c5.7a0d98"]]},{"id":"f6f6007e.2ccff","type":"Augmented- Operatorvariable","z":"4a a494","arservervarnamespace":"","arservervarname":"ARvar1", "arserverdatatype":"string","arservervaluetype":"msg","arservervalue":"payload","x":5 80,"y":380,"wires":[["56ad79c5.7a0d98"]]},{"id":"cc9333f9.d89d8","type":"change","z": "4a a494","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payloa d.value","tot":"msg"},{"t":"set","p":"topic","pt":"msg","to":"","tot":"str"}],"action ":"","property":"","from":"","to":"","reg":false,"x":420,"y":360,"wires":[["93b1903e. 49d6d"]]},{"id":"3ffbe32c.1d252c","type":"function","z":"4a a494","name":"Err or mgnt","func":"var msg1 = {};\nvar msg2 = {};\nif (msg.status.text == \"connection refused\" msg.status.text == \"Error\" msg.status.text == \"ETIMEDOUT\" msg.status.text == \"not yet connected\" msg.status.text == \"ER_ACCESS_DENIED_ERROR\"){\n msg1.ar_datamodel_quality = \"bad\";\n msg1.ar_datamodel_name = \"ARvar1\";\n msg1.ar_datamodel_value = \"\";\n msg1.ar_datamodel_type = \"String\";\n msg2.ar_datamodel_quality = \"bad\";\n msg2.ar_datamodel_name = \"ARvar2\";\n msg2.ar_datamodel_value = \"\";\n msg2.ar_datamodel_type = \"String\";\n return [msg1, msg2]; \n}","outputs":2,"noerr":0,"x":400,"y":460,"wires":[["f6f6007e.2ccff"],["93b1903e.49d 6d"]]},{"id":"5f0845cd.f3e794","type":"change","z":"4a a494","name":"","rules ":[{"t":"set","p":"payload","pt":"msg","to":"payload.value","tot":"msg"},{"t":"set"," p":"topic","pt":"msg","to":"","tot":"str"}],"action":"","property":"","from":"","to": "","reg":false,"x":420,"y":320,"wires":[["f6f6007e.2ccff"]]},{"id":"1fd8516b ", "type":"switch","z":"4a a494","name":"","property":"payload.name","propertyty pe":"msg","rules":[{"t":"eq","v":"sqlvar1","vt":"str"},{"t":"eq","v":"sqlvar2","vt":" str"}],"checkall":"false","outputs":2,"x":350,"y":280,"wires":[["5f0845cd.f3e794"],[" cc9333f9.d89d8"]]},{"id":"4b5f5f41.bc5f9","type":"status","z":"4a a494","name ":"","scope":["5bc4cfc.4e291f"],"x":360,"y":440,"wires":[["3ffbe32c.1d252c"]]},{"id": "f654da85.781e58","type":"split","z":"4a a494","name":"","splt":"","x":310,"y ":240,"wires":[["1fd8516b "]]},{"id":"5bc4cfc.4e291f","type":"mysql","z":"4a407 EIO /

$78a494","name":"sql Select","func":"msg.topic=\"select name,value from testtable where name in ('sqlvar1', 'sqlvar2')\";\nreturn msg;","outputs":1,"noerr":0,"x":170,"y":160,"wires":[["5bc4cfc.$

28 附录 a494","mydb":"f330429e.16cc","name":"Mysql localhost - testdb","x":230,"y":200,"wires":[["f654da85.781e58"]]},{"id":"1325a0b0.35b78f","type" :"function","z":"4a a494","name":"sql Select","func":"msg.topic=\"select name,value from testtable where name in ('sqlvar1', 'sqlvar2')\";\nreturn msg;","outputs":1,"noerr":0,"x":170,"y":160,"wires":[["5bc4cfc.4e291f"]]},{"id":"b c8f01","type":"inject","z":"4a a494","name":"every second","topic":"","payload":"","payloadtype":"date","repeat":"","crontab":"","once": false,"x":130,"y":120,"wires":[["1325a0b0.35b78f"]]},{"id":"f330429e.16cc","type":"my SQLdatabase","z":"","host":" ","port":"3306","db":"testdb","tz":""}] 在 Node-RED 的屏幕右上角, 单击图标, 然后选择 Import Clipboard, 粘贴此代码如果从 PDF 文件复制示例代码, 则将需要先删除所有换行符, 然后才能进行下个步骤单击 Import, 创建数据流中间样例下面的样例显示了 SQL 变量在 EcoStruxure Augmented Operator Advisor 中的整合这种样例与前一种样例的区别在于, 它能够在不添加新节点的情况下整合多个 SQL 变量 28 EIO /2019

29 附录将中间样例流部署到 Node-RED 中如要在 Node-RED 中部署此数据流 : 首先, 复制以下代码 [{"id":" fcd2e8","type":"subflow","name":"write SQL variables to Augmented Operator","info":"","in":[{"x":40,"y":80,"wires":[{"id":"860c4ff9.0252f"}]}],"out":[{"x":460,"y":160,"wires":[{"id":"fc f018","port":0}]}]},{"id":"860c4ff9.0252f","type":"function","z":" fcd2e8","name":"variable producing","func":"\nif (! msg.sqlarassociationtable[msg.payload.name]){\n node.error(\"error: The variable SQL:'\" + msg.payload.name + \"' does not exists in SQL to AR association table!\");\n} else{\n //Setup the msg specific entry ('ar_datamodel_name','ar_datamodel_type','ar_datamodel_value') for AR variable producing:\n msg.ar_datamodel_name = msg.sqlarassociationtable[msg.payload.name].name;\n msg.ar_datamodel_type = msg.sqlarassociationtable[msg.payload.name].type;\n msg.ar_datamodel_value = msg.payload.value;\n msg.topic = msg.payload.name;\n return msg;\n}\nnode.error(\"could not send the msg properly. Please check your flow!\");\nreturn msg;","outputs":1,"noerr":0,"x":170,"y":80,"wires":[["b39542af.112ba8"]]},{"id":"b39542af.112ba8","type":"augmented-operatorvariable","z":" fcd2e8","arservervarnamespace":"","arservervarname":"","arserverdatatype":"string","arservervaluetype":" msg","arservervalue":"payload","x":230,"y":120,"wires":[["fc f018"]]},{"id":"fc f018","type":"augmented- Operatorserver","z":" fcd2e8","arserverport":"8082","arservermethod":"PUT","arserverbufferinterval":"0","x":320,"y":160,"wires": [[]]},{"id":"e94fdc14.677f9","type":"mysql","z":"ac2dce00.6e948","mydb":"2f8ee0b8.083b","name":"mysql localhost - testdb","x":350,"y":160,"wires":[["3cc7c810.d30728"]]},{"id":"dd8448f7.41a148","type":"inject","z":"ac2dce00.6e948","name":"ever y minute","topic":"select name,value from testtable where name in ('sqlvar1', 'sqlvar2')","payload":"","payloadtype":"date","repeat":"","crontab":"","once":false,"x":290,"y":120,"wires":[["e94fdc14.677f9"]] },{"id":"537d55bf.43727c","type":"debug","z":"ac2dce00.6e948","name":"optional help node for debugging the Augmented Operator result","active":true,"console":"false","complete":"statuscode","x":590,"y":320,"wires":[]},{"id":"3cc7c810.d30728","type":"spli t","z":"ac2dce00.6e948","name":"split each rows returned into multiple msg","splt":"","x":440,"y":200,"wires":[["ce0e683e.de3758"]]},{"id":"ce0e683e.de3758","type":"function","z":"ac2dce00.6e948","na me":"edit HERE your SQL/AR variables association table","func":"//set of Augmented Operator Advisor types:\n//========================do not change Begin.========================\nconst AR_TYPES= {\n\"string\":\"string\",\n\"wstring\":\"wstring\",\n\"boolean\":\"boolean\",\n\"int8\" :\"Int8\",\n\"Int16\" :\"Int16\",\n\"Int32\" :\"Int32\",\n\"UInt8\" :\"UInt8\",\n\"UInt16\" :\"UInt16\",\n\"UInt32\" :\"UInt32\",\n\"Float\" :\"Float\",\n\"Double\" :\"Double\",\n\"SByte\" :\"SByte\",\n\"Byte\" :\"Byte\",\n\"Time\" :\"Time\",\n\"Date\" :\"Date\",\n\"DateTime\":\"DateTime\",\n\"TimeOfDay\":\"TimeOfDay\"\n};\n//========================Do not change End.========================\n\n/*Association table that associates SQL variables with AR ones:\none entry per variables. Each entry must follow this model:\n\"sql_variable_name\": {\n name:\"ar_variable_name\",\n type: AR_TYPES[\"<types>\"] // <= choose <types> under AR_TYPES\n \n },\n \ni.e: The folowing association table contains two entry:\nin this exemple:\n-entry 1: The SQL variable \"sqlvar1\" is associated to an AR variable \"ARvar1\" of type \"String\"\n-Entry 2: The SQL variable \"sqlvar2\" is associated to an AR variable \"ARvar2\" of type \"Int32\"\n*/\nmsg.SQLARassociationTable = {\n // Entry 1 begin \n \"sqlvar1\": {\n name:\"arvar1\",\n type: AR_TYPES[\"String\"]\n }, \n // Entry 1 end \n // Entry 2 begin \n \"sqlvar2\": {\n name:\"arvar2\",\n type: AR_TYPES[\"Int32\"]\n }\n // Entry 2 end \n};\n\n\n//========================do not change from here=============================\nreturn msg;","outputs":1,"noerr":0,"x":500,"y":240,"wires":[["4837af90.ab286"]]},{"id":"5d8695ae.320bdc","type":"comment","z":"ac2dce00.6e948","name":"write SQL variables to Augmented Operator","info":"","x":490,"y":80,"wires":[]},{"id":" cb0c78","type":"status","z":"ac2dce00.6e948","name":"","scope":[" e94fdc14.677f9"],"x":120,"y":160,"wires":[["576d2b7b.725b64"]]},{"id":"576d2b7b.725b64","type":"function","z":"ac2dce00.6e948"," name":"error mgnt","func":"if (msg.status.text == \"connection refused\" msg.status.text == \"Error\" msg.status.text == \"ETIMEDOUT\" msg.status.text == \"not yet connected\" msg.status.text == \"ER_ACCESS_DENIED_ERROR\"){\n msg.payload = [{name:\"sqlvar1\",value:\"\"},{name:\"sqlvar2\",value:\"\"}];\n msg.ar_datamodel_quality = \"bad\";\n return msg; \n}\n","outputs":1,"noerr":0,"x":150,"y":200,"wires":[["3cc7c810.d30728"]]},{"id":"4837af90.ab286","type":"subflow: fcd2 e8","z":"ac2dce00.6e948","x":490,"y":280,"wires":[["537d55bf.43727c"]]},{"id":"2f8ee0b8.083b","type":"mysqldatabase","z":"","hos t":" ","port":"3306","db":"testdb","tz":""}] 在 Node-RED 的屏幕右上角, 单击图标, 然后选择 Import Clipboard, 粘贴此代码如果从 PDF 文件复制示例代码, 则将需要先删除所有换行符, 然后才能进行下个步骤单击 Import, 创建数据流 EIO /

30 附录将来自 EcoStruxure Augmented Operator Advisor 的数据写入到 MySQL 数据库概述以变量形式表示的数据可以从 EcoStruxure Augmented Operator Advisor 获得, 以用于将特定表格中的特定行更新到 MySQL 数据库中 EcoStruxure Augmented Operator Advisor 至 MySQL 样例 30 EIO /2019

31 附录将 EcoStruxure Augmented Operator Advisor 至 MySQL 流部署到 Node-RED 中如要在 Node-RED 中部署此数据流 : 首先, 复制以下代码 [{"id":"a c46a68","type":"subflow","name":"read Augmented Operator variables","info":"","in":[{"x":60,"y":40,"wires":[{"id":"f4336d.17329c9"}]}],"out":[{"x":380,"y":40,"wires":[{"id":"f4336d c9","port":0}]}]},{"id":"f4336d.17329c9","type":"Augmented-Operatorserver","z":"a c46a68","arserverport":"8082","arservermethod":"GET","arserverbufferinterval":"0","x":220,"y":40,"wires":[ []]},{"id":"86b a069","type":"mysql","z":"b2a4893f ","mydb":" d.cf0238","name":"mysql localhost - testdb","x":570,"y":620,"wires":[["8ae7a977.6d8148"]]},{"id":"2c5bfb ","type":"inject","z":"b2a4893f ","name":"eve ry minute","topic":"","payload":"arvar1,arvar2","payloadtype":"str","repeat":"","crontab":"","once":false,"x":230,"y":460,"wires":[ ["27f48cc7.5d36b4"]]},{"id":"fb4ea7ae.03f268","type":"function","z":"b2a4893f ","name":"EDIT HERE your AR/SQL variables association table","func":"/*association table that associates SQL variables with AR ones:\none entry per variables. Each entry must follow this model:\n\"ar_variable_name\": {\n name:\"sql_variable_name\"\n },\n \ni.e: The folowing association table contains two entry:\nin this exemple:\n-entry 1: The AR variable \"ARvar1\" is associated to an SQL variable \"sqlvar1\"\n- Entry 2: The AR variable \"ARvar2\" is associated to an SQL variable \"sqlvar2\"\n*/\narsqlassociationtable = {\n // Entry 1 begin \n \"ARvar1\": {\n name:\"sqlvar1\",\n \n }, \n // Entry 1 end \n // Entry 2 begin \n \"ARvar2\": {\n name:\"sqlvar2\",\n }\n // Entry 2 end \n};\n\nmsg.topic = \"UPDATE testtable SET value = '<VALUE>' WHERE name = '<NAME>';\".replace(\"<VALUE>\",msg.payload.value).replace(\"<NAME>\", ARSQLassociationTable[msg.parts.key].name);\n//========================Do not change from here=============================\nreturn msg;","outputs":1,"noerr":0,"x":440,"y":580,"wires":[["86b a069"]]},{"id":"8ae7a977.6d8148","type":"debug","z":"b2a4893f ","name":"Optional help node for debug the MySQL server result","active":true,"console":"false","complete":"payload.message","x":720,"y":660,"wires":[]},{"id":"e46fd4ee.2f7318","type": "split","z":"b2a4893f ","name":"","splt":"","x":530,"y":540,"wires":[["fb4ea7ae.03f268"]]},{"id":"b5bb57a3.d9eb38","type": "json","z":"b2a4893f ","name":"","x":410,"y":540,"wires":[["e46fd4ee.2f7318"]]},{"id":"27f48cc7.5d36b4","type":"subflow:a c46a68","z":"b2a4893f ","name":"","x":390,"y":500,"wires":[["b5bb57a3.d9eb38"]]},{"id":"704bcb69.9c7f24","type":"co mment","z":"b2a4893f ","name":"write Augmented Operator variables to SQL","info":"","x":450,"y":420,"wires":[]},{"id":" d.cf0238","type":"MySQLdatabase","z":"","host":" ","port":"3306 ","db":"testdb","tz":""}] 在 Node-RED 的屏幕右上角, 单击图标, 然后选择 Import Clipboard, 粘贴此代码如果从 PDF 文件复制示例代码, 则将需要先删除所有换行符, 然后才能进行下个步骤单击 Import, 创建数据流 EIO /

32 附录 32 EIO /2019

33 EcoStruxure Augmented Operator Advisor 术语 EIO /2019 术语区域变量场景区域是指您希望使用 EcoStruxure Augmented Operator Advisor 来监视的每个场点或建筑物内部的区域 ( 如生产线机房存储区域车间实验室和办公区域 ) 如果拥有合适的许可证类型, 您就可以为场点的每个部分创建区域, 以便在 EcoStruxure Augmented Operator Advisor 项目内监视变量是一种目标点, 当在平板电脑上显示包含变量的场景时, 该目标点被替换为来自过程或数据库的软件对象的实时值, 比如系统位场景相当于由目标点叠加而成的图像增强现实这是一种将电脑生成的图像叠加在真实世界的用户视图上的技术, 它提供图像与所叠加的目标点的组合视图子场景标签场景的一部分, 通常是场景某个区域的微距视图子场景可以包含其自己的目标点一种二维矩阵标签可以打印并附加到设备的具有物理相同性或相似性的设备器件上 EcoStruxure Augmented Operator Advisor App 将标签作为场景的一部分来进行扫描, 然后会显示器件的正确目标点目标点目标点是指区域场景或子场景中提供了额外的诊断或技术信息的位置可以定义各种类型的目标点, 其中包括技术文档设计图电子表格中包含的信息以及所生成的过程变量的实时值过程过程是操作员为完成任务而必须以预定顺序执行的一系列任务步骤过程变量过程变量是受监视或控制的过程的某个部分的测量值, 比如温度压力级或流速项目 EcoStruxure Augmented Operator Advisor 项目由区域场景和过程组成生成项目, 并将其复制到 EcoStruxure Augmented Operator Advisor Runtime 操作员然后可以在运行 EcoStruxure Augmented Operator Advisor App 的平板电脑上访问此项目 EcoStruxure Operator Terminal Expert EcoStruxure Operator Terminal Expert 是一款人机界面 (HMI) 配置软件, 让您能够创建并编辑应用程序面板, 以便控制 Magelis GTU 终端 (Premium 和 Open Box) 以及 Magelis 工业 PC (Panel 和 Box) 的自动化系统 EIO /

34 术语 IIoT IoT 工业物联网 IoT 在制造业中的应用又被称为工业互联网或工业 4.0 物联网由收集和共享数据的智能设备组成的网络 Node-RED Node-RED 是一款开源可视化编程工具, 它几乎不需要编程技能它使用的是预编程且可重复使用的代码块 ( 称为节点 ) 节点可以线连接在一起, 以创建数据流 SQL URI 结构化查询语言统一资源标识符它用来指向诸如文件等的对象, 并定义使用哪个应用程序来打开此对象可能需要安装第三方应用程序 34 EIO /2019

中文版

中文版人机界面 Easy Harmony 工业平板电脑产品目录 2019 schneider-electric.con www.schneider-electric.com/hmi 目录 Easy Harmony 工业平板电脑选型指引....page 0590Q/2 介绍产品特点... page 28626/2 EcoStruxure Architecture... page 28626/2 概述...