CN107864152B - Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA - Google Patents
Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA Download PDFInfo
- Publication number
- CN107864152B CN107864152B CN201711298860.8A CN201711298860A CN107864152B CN 107864152 B CN107864152 B CN 107864152B CN 201711298860 A CN201711298860 A CN 201711298860A CN 107864152 B CN107864152 B CN 107864152B
- Authority
- CN
- China
- Prior art keywords
- attribute
- protocol
- column
- field
- name
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/18—Multiprotocol handlers, e.g. single devices capable of handling multiple protocols
Landscapes
- Engineering & Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Communication Control (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention discloses a method for rapidly completing intelligent building multi-protocol adaptation engineering templates by adopting VBA, which comprises the following steps: s1: defining and initializing a sheet page of each protocol module, subsystem, equipment, gateway configuration and protocol work parameter table; s2: unifying the format of the sheet page through a public function, and establishing a reference line; s3: acquiring the protocol type of the subsystem, and hiding and displaying the sheet in the table according to the protocol type; s4: judging whether the acquired protocol type is an OPC protocol, if so, directly entering the step S5; if not, initializing equipment IP of the non-OPC protocol according to requirements; s5: IP address configuration and validity check are carried out on an OPC protocol and an initialized non-OPC protocol; s6: the VBA script configured by each protocol module is called, and the equipment attribute ID of each protocol is automatically generated; the invention automatically generates the attribute ID of each protocol module through the VBA code, improves the accuracy and consistency of the configuration template data, and can avoid errors in complicated operation steps.
Description
Technical Field
The invention belongs to the technical field of intelligent buildings, and particularly relates to a method for quickly completing a multi-protocol adaptation engineering template of an intelligent building by using VBA.
Background
The existing intelligent building manufacturer interface protocols are various, when data attributes of different module protocols are configured, data in various formats need to be converted into uniform engineering configuration template data according to requirements, and errors are easy to occur when the engineering templates are configured due to the fact that the attribute ID fields of each module are more and the formats of the modules are inconsistent. When the intelligent building engineering template is configured, the following problems exist:
1. the manufacturer has too many agreements, and the user is easy to make mistakes when operating the agreement table; it is inconvenient to input the parameter attribute field by comparing the data conversion rule with the protocol table;
2. when configuring the device attribute IDs of various manufacturers, it is necessary to input various fields in a combined manner, and because there are many involved fields and the types are not consistent, the operation of this step is complicated and time-consuming, resulting in low efficiency and easy error.
Disclosure of Invention
Aiming at the defects or the improvement requirements of the prior art, the invention provides a method for rapidly completing the intelligent building multi-protocol adaptation engineering template by adopting VBA, and the attribute ID of each protocol module is automatically generated by a VBA script, so that the accuracy and the format consistency of the whole configuration template data are improved; the operation behavior of the user is controlled and normalized, and errors in complicated operation steps are avoided.
To achieve the above object, according to one aspect of the present invention, there is provided a method for rapidly completing an intelligent building multi-protocol adaptation engineering template by using VBA, comprising the steps of:
s1: defining and initializing a sheet page of each protocol module, subsystem, equipment, gateway configuration and protocol work parameter table;
s2: unifying the format of the sheet page through a public function, and establishing a reference line;
s3: acquiring the protocol type of the subsystem, and hiding and displaying the sheet in the table according to the protocol type;
s4: judging whether the acquired protocol type is an OPC protocol, if so, directly entering the step S5; if not, initializing equipment IP of the non-OPC protocol according to requirements;
s5: IP address configuration and validity check are carried out on an OPC protocol and an initialized non-OPC protocol;
s6: and calling the VBA script configured by each protocol module to automatically generate the equipment attribute ID of each protocol.
Preferably, in the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA, after the step S6, the method further includes the step of storing the device attribute IDs of the protocol modules in an engineering template summary table.
Preferably, the aforementioned method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using VBA includes KNXNetIp, BACnet, and ModBustcp protocols.
Preferably, the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA includes the following steps:
s1: initializing a data conversion function code column in the attribute OPC table according to a data conversion function code field in the data conversion table, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in the attribute OPC table according to an OPC type NAME DPT _ NAME field in a protocol work parameter table page, and setting the value of the column as a second field of the attribute ID;
s3: the vendor-supplied object name is set to the first field of the attribute ID.
Preferably, the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA includes the following steps:
s1: initializing a data conversion function code column in the attribute KNXNetpip table according to a data conversion function code field in the data conversion table, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in an attribute KNXNetpip table according to a KNXNetpip object type NAME DPT _ NAME field in a protocol work parameter table page;
s3: setting a second field of the attribute ID according to the object type column in the step S2 and a data point type ID field corresponding to KNXNetpl in the protocol work parameter table;
s4: and simplifying the data in the KNX group address column in the attribute KNXNetpip table, and setting the simplified format of the data as the first field of the attribute ID.
Preferably, in the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA, the automatic generation method of the device attribute ID of the BACnet protocol includes the following steps:
s1: initializing a data conversion function code column in the attribute BACnet table according to a data conversion function code field in the data conversion table, and setting the value of the column as a fourth field of the attribute ID;
s2: initializing an object type name column in an attribute BACnet table according to a BACnet object type name field in a protocol work parameter table page;
s3: setting a first field of the attribute ID according to the object type name column in the step S2 in combination with a type abbreviation field corresponding to the object type in the protocol work parameter table;
s4: initializing a data point type NAME DPT _ NAME column in an attribute BACnet table according to an application data type DPT _ NAME field in a protocol work parameter table;
s5: initializing whether a subscription column in an attribute BACnet table is subscribed or not, and setting an attribute value of the column as a fifth field of an attribute ID (identity);
s6: setting the data point type NAME DPT _ NAME column in the step S4 as a third field of the attribute ID according to the corresponding type value in the protocol working parameter table;
s7: the object IDs are arranged in order and set as the second field of the attribute ID.
Preferably, in the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA, the automatic generation method of the device attribute ID of the ModBustcp protocol includes the following steps:
s1: initializing a data conversion function code column in the attribute ModBusTCP table according to a data conversion function code field in the data conversion table, and setting the value of the column as a fifth field of the attribute ID;
s2: initializing a type NAME DPT _ NAME column in an attribute ModBusTCP according to a ModBusTCP type NAME DPT _ NAME field in a protocol work parameter table page;
s3: setting a third field of the attribute ID according to the type NAME DPT _ NAME column in the step S2 in combination with the data point type ID field corresponding to ModBusTCP in the protocol work parameter table;
s4: initializing an operation type ActionType column in an attribute ModBusTCP table according to an operation type ActionType field of ModBusTCP in a protocol work-participation table, and setting the value of the column as a first field of an attribute ID;
s5: the vendor-supplied address is set to the second field of the attribute ID.
Preferably, the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA further includes the following steps after setting all fields of each protocol attribute ID is completed: automatically generating a manufacturer attribute ID column according to each set field value of the attribute ID; the vendor attribute ID column is copied to the subsystem's attribute ID column.
Preferably, in the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA, the simplification operation includes removing the blank characters and meaningless 0 characters before and after the address.
Preferably, in the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by using the VBA, the attribute value of the subscription column is 1 or 0, and the subscription column corresponds to a yes field or a no field respectively.
In general, compared with the prior art, the above technical solution contemplated by the present invention can achieve the following beneficial effects:
(1) the invention provides a method for rapidly completing intelligent building multi-protocol adaptation engineering template by VBA, which utilizes the VBA editing function of excel to automatically configure the attribute ID field of the engineering configuration template, and automatically generates the attribute ID of each protocol module through the created VBA script after defining the data conversion rule and the protocol parameter rule of each manufacturer and selecting the attribute of each field; firstly, designing an equipment attribute ID extraction method of each protocol module, then establishing a universal engineering template to integrate all protocol modules together to realize automatic generation of attribute IDs by scripts, and improving the accuracy and format consistency of the whole configuration template data;
(2) the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by adopting the VBA can rapidly and automatically generate the equipment attribute ID parameters by selecting various field parameters such as data types and the like, ensure the accuracy and consistency of data and improve the working efficiency;
(3) according to the method for rapidly completing the intelligent building multi-protocol adaptation engineering template by adopting the VBA, the attribute ID is automatically generated through the VBA code, the operation behavior of a user is controlled and normalized, and errors in complicated operation steps are avoided; the operation interface is more humanized, and the user can conveniently select.
Drawings
Fig. 1 is a flowchart of generating a BACnet protocol module attribute ID according to an embodiment of the present invention;
fig. 2 is a flowchart of generating an attribute ID of a KNX protocol module according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating the generation of an attribute ID of an OPC protocol module according to an embodiment of the present invention;
fig. 4 is a flowchart of generating an attribute ID of a ModBus protocol module according to an embodiment of the present invention;
FIG. 5 is a flow chart of engineering template generation provided by an embodiment of the present invention;
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. In addition, the technical features involved in the embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.
The invention provides a method for rapidly completing an intelligent building multi-protocol adaptation engineering template by adopting VBA, which is used for automatically extracting attribute IDs (identity) of a plurality of subsystem protocol modules related to an intelligent building and adapting formats; the types of protocols commonly used in many subsystems today include: OPC, KNXNetpip, BACnet and ModBustcp protocols; firstly, an equipment attribute ID extraction method of each protocol module is designed, then a general engineering template is established to integrate all protocol modules together so as to realize that a VBA script automatically generates an attribute ID, and the two parts are respectively introduced in detail below.
First, flow of each protocol module attribute ID generation method
The embodiment of the invention relates to four protocols of OPC, KNXNetpip, BACnet and ModBustcp, and because the number of fields and the format contained in the equipment attribute ID in the protocol of each subsystem are inconsistent, a VBA script is firstly respectively created to carry out format adaptation and extraction on the attribute ID of each protocol module, and the extraction process of each module is introduced.
1. BACnet protocol module
The attribute ID of the lighting BACnet module includes five fields: object type name, object ID, data point type name, data conversion function code, and subscription or not. The generation flow of the BACnet protocol module attribute ID is shown in fig. 1, and specifically includes the following steps:
s1: initializing a data conversion function code column in the attribute BACnet table according to a data conversion function code field in the data conversion table, setting the column as a pull-down selection through a selection event, and setting the value of the column as a fourth field of the attribute ID;
s2: initializing an object type name column in an attribute BACnet table according to a BACnet object type name field in a protocol work parameter table page, wherein the column is set as pull-down selection through a selection event;
s3: setting a first field of the attribute ID according to the object type name column in the step S2 in combination with a type abbreviation field corresponding to the object type in the protocol work parameter table;
s4: initializing a data point type NAME DPT _ NAME column in an attribute BACnet table according to an application data type DPT _ NAME field in a protocol work parameter table, wherein the column is set as pull-down selection through a selection event;
s5: initializing a subscription column in an attribute BACnet table, wherein the field comprises a yes value and a no value and corresponds to an attribute value 1/0 respectively, the column is set to be a pull-down selection through a selection event, and the value of the column is set to be a fifth field of an attribute ID;
s6: setting the data point type NAME DPT _ NAME column in the step S4 as a third field of the attribute ID according to the corresponding type value in the protocol working parameter table;
s7: a second field for arranging the object IDs in order and setting them as attribute IDs;
s8: automatically generating an attribute ID column according to each field value of the attribute ID set in the steps S1-S7;
s9: the automatically generated vendor attribute ID column is copied to the attribute ID column of the subsystem.
2. KNX protocol module
The attribute ID of the lighting KNX module includes three fields: KNX address, DPT _ ID, and data conversion function code. The generation flow of the KNX protocol module attribute ID is shown in fig. 2, and specifically includes the following steps:
s1: initializing a data conversion function code column in the attribute KNXNetpip table according to a data conversion function code field in the data conversion table, setting the column as a pull-down selection through a selection event, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in an attribute KNXNetpip table according to a KNXNetpip object type NAME DPT _ NAME field in a protocol work participation table page, wherein the column is set as pull-down selection through a selection event;
s3: setting a second field of the attribute ID according to the object type column in the step S2 and a data point type ID field corresponding to KNXNetpl in the protocol work parameter table;
s4: simplifying data of a KNX group address column in an attribute KNXNetpip table, wherein the data is provided by a manufacturer, and the simplifying operation specifically comprises the following steps: removing the blank character and meaningless 0 characters before and after the address and setting the simplified format of the blank character and meaningless 0 characters as the first field of the attribute ID;
s5: automatically generating an attribute ID column according to each field value of the attribute ID set in the steps S1-S4;
s6: the automatically generated vendor attribute ID column is copied to the attribute ID column of the subsystem.
3. OPC protocol module
The attribute ID of the illumination OPC module includes three fields: object name, data point type name, and data conversion function code. The generation flow of the attribute ID of the OPC protocol module is shown in fig. 3, and specifically includes the following steps:
s1: initializing a data conversion function code column in the attribute OPC table according to a data conversion function code field in the data conversion table, setting the column as a pull-down selection through a selection event, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in a property OPC table according to an OPC type NAME DPT _ NAME field in a protocol work participation table page, setting the column as a pull-down selection through a selection event, and setting the value of the column as a second field of a property ID;
s3: setting an object name provided by a manufacturer as a first field of an attribute ID;
s4: automatically generating an attribute ID column according to each field value of the attribute ID set in the steps S1-S3;
s5: the automatically generated vendor attribute ID column is copied to the attribute ID column of the subsystem.
4. ModBus protocol module
The attribute ID of the power ModBusTCP module includes five fields: operation type, address, data point type name, data length or data bit, and data conversion functional code. The generation flow of the attribute ID of the ModBus protocol module is shown in fig. 4, and specifically includes the following steps:
s1: initializing a data conversion function code column in the attribute ModBusTCP table according to a data conversion function code field in the data conversion table, setting the column as a pull-down selection through a selection event, and setting the value of the column as a fifth field of the attribute ID;
s2: initializing a type NAME DPT _ NAME column in an attribute ModBusTCP according to a ModBusTCP type NAME DPT _ NAME field in a protocol work participation table page, wherein the column is set as pull-down selection through a selection event;
s3: setting a third field of the attribute ID according to the type NAME DPT _ NAME column in the step S2 in combination with the data point type ID field corresponding to ModBusTCP in the protocol work parameter table;
s4: initializing an operation type ActionType column in an attribute ModBusTCP according to an operation type ActionType field of ModBusTCP in a protocol work participation table, setting the column as a pull-down selection through a selection event, and setting the value of the column as a first field of an attribute ID;
s5: setting the address provided by the manufacturer as a second field of the attribute ID;
s6: automatically generating an attribute ID column according to each field value of the attribute ID set in the steps S1-S5;
s7: the automatically generated vendor attribute ID column is copied to the attribute ID column of the subsystem.
Second, flow of engineering template generation method
After the attribute IDs of the protocol modules are automatically extracted through the created VBA script, establishing a universal VBA script to call the VBA script of each protocol module so as to generate an engineering template; the engineering template generation flow is shown in fig. 5, and specifically includes the following steps:
s1: defining and initializing a sheet page of each protocol module, subsystem, equipment, gateway configuration and protocol work parameter table;
s2: unifying the format of the sheet page through a public function, establishing a reference row and column, and removing operations such as spaces, TAB symbols and the like; the public function is a function which needs to be called by each protocol module and is used for acquiring the number of rows and columns of the sheet, the type of a manufacturer and the like;
s3: acquiring a protocol type through a subsystem, and hiding and displaying the sheet in the form according to the protocol type related in the template;
s4: judging whether the acquired protocol type is an OPC protocol, if so, directly entering the step S5; if not, initializing equipment IP of the non-OPC protocol according to requirements;
s5: carrying out operations such as IP address configuration, validity check and the like on an OPC protocol and an initialized non-OPC protocol;
s6: the VBA script configured by each protocol module is called, and the equipment attribute ID of each protocol is automatically generated;
s7: and warehousing the equipment attribute ID of each protocol module interface into an engineering template summary table.
The invention provides a method for rapidly completing intelligent building multi-protocol adaptation engineering templates by adopting VBA, which automatically generates attribute IDs of all protocol modules through VBA codes and improves the accuracy and format consistency of the whole configuration template data; the operation behavior of the user is controlled and normalized, and errors in complicated operation steps are avoided.
It will be understood by those skilled in the art that the foregoing is only a preferred embodiment of the present invention, and is not intended to limit the invention, and that any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method for rapidly completing an intelligent building multi-protocol adaptation engineering template by adopting VBA is characterized by comprising the following steps:
s1: defining and initializing a sheet page of each protocol module, subsystem, equipment, gateway configuration and protocol work parameter table;
s2: unifying the format of the sheet page through a public function, and establishing a reference line;
s3: acquiring the protocol type of the subsystem, and hiding and displaying the sheet in the table according to the protocol type;
s4: judging whether the acquired protocol type is an OPC protocol, if so, directly entering the step S5; if not, initializing equipment IP of the non-OPC protocol according to requirements;
s5: carrying out IP address configuration and validity check on subsystems corresponding to an OPC protocol and an initialized non-OPC protocol;
s6: and calling the VBA script configured by each protocol module to automatically generate the equipment attribute ID of each protocol.
2. The method of claim 1, wherein step S6 is followed by the step of warehousing the device property IDs of the protocol modules into the project template summary table.
3. The method for rapidly completing an intelligent building multi-protocol adaptation engineering template by using VBA according to claim 1 or 2, wherein the non-OPC protocol comprises KNXNetpip, BACnet and ModBustcp protocols.
4. The method for fast completion of intelligent building multi-protocol adaptation engineering templates using VBA according to claim 1, wherein the automatic generation method of device attribute ID of OPC protocol comprises the following steps:
s1: initializing a data conversion function code column in the attribute OPC table according to a data conversion function code field in the data conversion table, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in the attribute OPC table according to an OPC type NAME DPT _ NAME field in a protocol work parameter table page, and setting the value of the column as a second field of the attribute ID;
s3: the vendor-supplied object name is set to the first field of the attribute ID.
5. The method for fast completion of intelligent building multi-protocol adaptation engineering templates using VBA according to claim 3, wherein the method for automatically generating device attribute IDs of KNXNetIp protocol comprises the steps of:
s1: initializing a data conversion function code column in the attribute KNXNetpip table according to a data conversion function code field in the data conversion table, and setting the value of the column as a third field of the attribute ID;
s2: initializing a data point type NAME DPT _ NAME column in an attribute KNXNetpip table according to a KNXNetpip object type NAME DPT _ NAME field in a protocol work parameter table page;
s3: setting a second field of the attribute ID according to the object type column in the step S2 and a data point type ID field corresponding to KNXNetpl in the protocol work parameter table;
s4: and simplifying the data in the KNX group address column in the attribute KNXNetpip table, and setting the simplified format of the data as the first field of the attribute ID.
6. The method for fast completing intelligent building multi-protocol adaptation engineering templates using VBA according to claim 3, wherein the automatic generating method of device attribute ID of BACnet protocol comprises the following steps:
s1: initializing a data conversion function code column in the attribute BACnet table according to a data conversion function code field in the data conversion table, and setting the value of the column as a fourth field of the attribute ID;
s2: initializing an object type name column in an attribute BACnet table according to a BACnet object type name field in a protocol work parameter table page;
s3: setting a first field of the attribute ID according to the object type name column in the step S2 in combination with a type abbreviation field corresponding to the object type in the protocol work parameter table;
s4: initializing a data point type NAME DPT _ NAME column in an attribute BACnet table according to an application data type DPT _ NAME field in a protocol work parameter table;
s5: initializing whether a subscription column in an attribute BACnet table is subscribed or not, and setting an attribute value of the column as a fifth field of an attribute ID (identity);
s6: setting the data point type NAME DPT _ NAME column in the step S4 as a third field of the attribute ID according to the corresponding type value in the protocol working parameter table;
s7: the object IDs are arranged in order and set as the second field of the attribute ID.
7. The method of claim 3, wherein the automatic generation of the device attribute ID of the ModBustcp protocol comprises the following steps:
s1: initializing a data conversion function code column in the attribute ModBusTCP table according to a data conversion function code field in the data conversion table, and setting the value of the column as a fifth field of the attribute ID;
s2: initializing a type NAME DPT _ NAME column in an attribute ModBusTCP according to a ModBusTCP type NAME DPT _ NAME field in a protocol work parameter table page;
s3: setting a third field of the attribute ID according to the type NAME DPT _ NAME column in the step S2 in combination with the data point type ID field corresponding to ModBusTCP in the protocol work parameter table;
s4: initializing an operation type ActionType column in an attribute ModBusTCP table according to an operation type ActionType field of ModBusTCP in a protocol work-participation table, and setting the value of the column as a first field of an attribute ID;
s5: the vendor-supplied address is set to the second field of the attribute ID.
8. The method for fast completing an intelligent building multi-protocol adaptation engineering template by using VBA of any one of claims 4 to 7, further comprising the following steps after setting all fields of each protocol attribute ID: automatically generating a manufacturer attribute ID column according to each set field value of the attribute ID; the vendor attribute ID column is copied to the subsystem's attribute ID column.
9. The method for rapidly building intelligent multi-protocol adaptation engineering templates using VBA as claimed in claim 5, wherein said simplifying operation comprises removing blank characters and meaningless 0 characters before and after addresses.
10. The method of claim 6, wherein the attribute value of the subscription column is 1 or 0, corresponding to yes or no fields respectively.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711298860.8A CN107864152B (en) | 2017-12-08 | 2017-12-08 | Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711298860.8A CN107864152B (en) | 2017-12-08 | 2017-12-08 | Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107864152A CN107864152A (en) | 2018-03-30 |
| CN107864152B true CN107864152B (en) | 2020-04-28 |
Family
ID=61705677
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711298860.8A Active CN107864152B (en) | 2017-12-08 | 2017-12-08 | Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107864152B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111291441B (en) * | 2020-02-18 | 2023-05-30 | 浙江源创智控技术有限公司 | Intelligent building integration method and system based on object modeling driving |
| CN114222009B (en) * | 2021-12-15 | 2024-05-24 | 北京工业大学 | Industrial communication multi-protocol conversion system |
| CN116112554A (en) * | 2022-12-07 | 2023-05-12 | 上海通联金融服务有限公司 | Message conversion method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103425497A (en) * | 2013-08-15 | 2013-12-04 | 北京华胜天成科技股份有限公司 | Network engineering script across-manufacturer conversion method and device |
| US9020861B2 (en) * | 2011-05-06 | 2015-04-28 | Google Inc. | Predictive model application programming interface |
| CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
| CN106713004A (en) * | 2016-07-12 | 2017-05-24 | 腾讯科技（深圳）有限公司 | Router adaptation method and system |
| CN107315743A (en) * | 2016-04-26 | 2017-11-03 | 上海赢华软件科技有限公司 | A kind of big data conversion method and system based on adapter |
-
2017
- 2017-12-08 CN CN201711298860.8A patent/CN107864152B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9020861B2 (en) * | 2011-05-06 | 2015-04-28 | Google Inc. | Predictive model application programming interface |
| CN103425497A (en) * | 2013-08-15 | 2013-12-04 | 北京华胜天成科技股份有限公司 | Network engineering script across-manufacturer conversion method and device |
| CN107315743A (en) * | 2016-04-26 | 2017-11-03 | 上海赢华软件科技有限公司 | A kind of big data conversion method and system based on adapter |
| CN106021211A (en) * | 2016-05-18 | 2016-10-12 | 山东达创网络科技股份有限公司 | Intelligent form system and generation method thereof |
| CN106713004A (en) * | 2016-07-12 | 2017-05-24 | 腾讯科技（深圳）有限公司 | Router adaptation method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107864152A (en) | 2018-03-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107864152B (en) | Method for rapidly completing intelligent building multi-protocol adaptation engineering template by using VBA | |
| CN106095376B (en) | A kind of implementation method of quick configuration monitoring picture | |
| CN106445528B (en) | Method and device for rapidly configuring SETUP option of BIOS | |
| CN103020064A (en) | Method and configuration for generating query condition in annotation way | |
| CN111475192B (en) | Method, device, storage medium and system for performing thermal augmentation on game server | |
| CN111061678B (en) | Service data processing method, device, computer equipment and storage medium | |
| JP2016164775A (en) | Field device commissioning system and method | |
| CN104461610A (en) | Platformized multi-ECU online flashing method | |
| CN112861501A (en) | Report generation method and device, electronic equipment and computer readable storage medium | |
| CN105005543A (en) | Interface generation apparatus and method | |
| CN112100078B (en) | Method, device and equipment for generating interface test case | |
| CN110647564B (en) | Hive table building method, electronic device and computer readable storage medium | |
| CN102902526A (en) | Automatic setting method for realizing BMC (Baseboard Management Controller) and IP (Internet Protocol) information through time delay | |
| CN113687814A (en) | Automation realization method of model framework and interface file based on AUTOSAR (automotive open system architecture) | |
| CN103793240A (en) | Interface scanning method, interface scanning device and corresponding plug-in updating method | |
| CN111506362B (en) | Processing method, device, storage medium and system for configuration form of game | |
| CN105094925A (en) | Rolling code burning method and system for universal one-time programmable chip | |
| CN113190478A (en) | GPIO (general purpose input/output) efficient configuration method, system and medium | |
| CN116996601A (en) | Message format conversion method and device, electronic equipment and storage medium | |
| CN116360787A (en) | Automatic generation method and device for form codes, electronic equipment and storage medium | |
| CN114285692B (en) | Communication control system, identity determination method, distribution method and equipment | |
| CN114756183A (en) | Data printing method, device, equipment and storage medium | |
| CN107819621B (en) | Gateway configuration method and device and gateway | |
| CN113985849A (en) | Method for writing DTC (digital control channel) read ECU (electronic control unit) version of automatic clear-reading whole vehicle based on CANoe software | |
| CN109600776B (en) | Data interaction method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |