Method for rapidly completing smart building multi-protocol adaptive project template through VBA

Abstract

The invention discloses a method for rapidly completing a smart building multi-protocol adaptive project template through VBA. The method comprises the following steps: S1, defining sheet pages of protocol modules, subsystems, equipment, gateway configurations and protocol working parameter tables, and carrying out initialization; S2, carrying out format unification on the sheet pages through a public function, so that standard lines and rows are established; S3, acquiring protocol types of the subsystems, and hiding and displaying sheets in forms according to the protocol types; S4, judging whether the acquired protocol types are OPC protocols or not, directly entering S5 if the acquired protocol types are the OPC protocols, and initializing equipment IPs of non-OPC protocols according torequirements if the acquired protocol types are not the OPC protocols; S5, carrying out IP address configuration and validity examination on the OPC protocols and the initialized non-OPC protocols; and S6, calling VBA scripts configured for the protocol modules to automatically generate equipment attribute IDs of the protocols. The method provided by the invention has the advantages that the attribute IDs of the protocol modules are automatically generated through VBA codes, so that the accuracy and consistency of configuration template data can be improved, and errors in complicated operation steps can be avoided.

Description

technical field [0001] The invention belongs to the technical field of smart buildings, and more specifically relates to a method for quickly completing a multi-protocol adaptation project template for smart buildings by using VBA. Background technique [0002] At present, there are many kinds of interface protocols for smart building manufacturers. When configuring the data attributes of different module protocols, it is necessary to convert the data in various formats into unified engineering configuration template data as required. Because each module has many attribute ID fields and the format Inconsistency makes it very easy to make mistakes when configuring project templates. When configuring the smart building project template, the following problems exist: [0003] 1. There are too many protocols of the manufacturer, and the user is prone to make mistakes when operating the protocol table; it is inconvenient to enter the parameter attribute field according to the da...

AI Technical Summary

Problems solved by technology

[0003] 1. There are too many protocols of the manufacturer, and the user is prone to make mistakes when operating the protocol table; it is inconvenient to enter the parameter attribute field according to the data conversion rules and the protocol table;

[0004] 2. When configuring the device attribute ID of each manufacturer, it is necessary to combine and input each field. Since there are many fields involved and the types are inconsistent, this step is cumbersome and time-consuming, resulting in low efficiency and error-prone

Images