CN107864152A - A kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA - Google Patents
A kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA Download PDFInfo
- Publication number
- CN107864152A CN107864152A CN201711298860.8A CN201711298860A CN107864152A CN 107864152 A CN107864152 A CN 107864152A CN 201711298860 A CN201711298860 A CN 201711298860A CN 107864152 A CN107864152 A CN 107864152A
- Authority
- CN
- China
- Prior art keywords
- property
- row
- attribute
- vba
- agreement
- 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.)
- Granted
Links
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 kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, comprise the following steps：S1：Define the sheet pages of each protocol module, subsystem, equipment, gateway configuration and agreement engineering parameter table and initialized；S2：Uniform format is carried out to the sheet pages by public function, benchmark ranks are established；S3：The protocol type of subsystem is obtained, the sheet in form is hidden and shown according to protocol type；S4：Whether the protocol type for judging to obtain is OPC agreements, if so, being directly entered step S5；If it is not, the device IP of non-OPC agreements is initialized as requested；S5：IP address configuration and validity check are carried out to the non-OPC agreements after OPC agreements and initialization；S6：The VBA scripts of each protocol module configuration are called, automatically generate the device attribute ID of each agreement；The present invention improves the accuracy and uniformity of configuration template data, can avoid malfunctioning in cumbersome operating procedure by the Property ID of each protocol module of VBA Code automatic builds.
Description
Technical field
The invention belongs to wisdom technical field of buildings, more particularly, to one kind using VBA be rapidly completed wisdom build it is more
The method of protocol adaptation engineering template.
Background technology
Current wisdom building producer interface protocol is varied, is needed when configuring the data attribute of disparate modules agreement
The data of various forms are converted into unified engineering configuration template data on request, due to every kind of module attribute ID field compared with
More and form is inconsistent, causes to be very easy to error in allocation project template.Now wisdom building engineering shuttering is matched somebody with somebody
When putting, problems be present：
1st, producer's agreement is excessive, and user during agreement table handling to easily malfunctioning；Contrasting data transformation rule and agreement table are defeated
It is inconvenient during parameter attribute field to enter；
2nd, need to input each field combination when configuring the device attribute ID of each manufacturer, due to the field being related to
More and Type-Inconsistencies, the step operation is cumbersome time-consuming, causes inefficient, and easily malfunctions.
The content of the invention
For the disadvantages described above or Improvement requirement of prior art, wisdom is rapidly completed using VBA the invention provides one kind
The method for building multi-protocols adaptation engineering template, the Property ID of each protocol module is automatically generated by VBA scripts, improved whole
The accuracy and form uniformity of configuration template data；The operation behavior of user has been controlled with specification, has been avoided in cumbersome operation
Malfunctioned in step.
To achieve the above object, according to one aspect of the present invention, there is provided a kind of to be rapidly completed wisdom building using VBA
The method of multi-protocols adaptation engineering template, comprises the following steps：
S1：Define the sheet pages of each protocol module, subsystem, equipment, gateway configuration and agreement engineering parameter table and carry out just
Beginningization；
S2：Uniform format is carried out to the sheet pages by public function, carries out benchmark ranks foundation；
S3：The protocol type of subsystem is obtained, the sheet in form is hidden and shown according to protocol type；
S4：Whether the protocol type for judging to obtain is OPC agreements, if so, being then directly entered step S5；If it is not, then to non-
The device IP of OPC agreements is initialized as requested；
S5：IP address configuration and validity check are carried out to the non-OPC agreements after OPC agreements and initialization；
S6：The VBA scripts of each protocol module configuration are called, automatically generate the device attribute ID of each agreement.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, after step S6
Also include the device attribute ID storages of each protocol module to the step in engineering template summary table.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, the non-OPC
Agreement includes KNXNetIp, BACnet and ModBustcp agreement.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, the OPC associations
The device attribute ID of view automatic generation method comprises the following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the data conversion in attribute OPC tables
FunctionCode row are initialized, and the value of the row is arranged to the 3rd field of Property ID；
S2：According to the OPC typonym DPT_NAME fields in the agreement engineering parameter table page to the data point in attribute OPC tables
Typonym DPT_NAME row are initialized, and the value of the row is arranged to second field of Property ID；
S3：The object oriented that producer is provided is arranged to the first character section of Property ID.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, it is described
The device attribute ID of KNXNetIp agreements automatic generation method comprises the following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the data in attribute KNXNetIp tables
Conversion FunctionCode row are initialized, and the value of the row is arranged to the 3rd field of Property ID；
S2：According to the KNXNetIp Object Type Names DPT_NAME fields in the agreement engineering parameter table page to attribute
Data point typonym DPT_NAME row in KNXNetIp tables are initialized；
S3：Object type in step S2 arranges the data vertex type ID with reference to corresponding to KNXNetIp in agreement engineering parameter table
Field sets a property ID second field；
S4：The data that KNX group address in attribute KNXNetIp tables arranges are carried out simplifying operation, and are simplified form setting
For the first character section of Property ID.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, the BACnet
The device attribute ID of agreement automatic generation method comprises the following steps：
S1：The data in attribute BACnet tables are turned according to the data conversion FunctionCode fields in data conversion table
Change FunctionCode row to be initialized, and the value of the row is arranged to the 4th field of Property ID；
S2：According to the BACnet Object Type Names field in the agreement engineering parameter table page to the object in attribute BACnet tables
Typonym row are initialized；
S3：Object Type Names in step S2 arrange the type with reference to corresponding to object type in agreement engineering parameter table and abridged
Field sets a property ID first character section；
S4：According to the application data type DPT_NAME fields in agreement engineering parameter table to the data point in attribute BACnet tables
Typonym DPT_NAME row are initialized；
S5：To in attribute BACnet tables whether subscription row initialize, and the property value of the row is arranged to attribute
ID the 5th field；
S6：Data point typonym DPT_NAME row in step S4 combine corresponding types value in agreement engineering parameter table
It is set to the 3rd field of Property ID；
S7：Object ID is arranged in order and is set to second field of Property ID.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, it is described
The device attribute ID of ModBustcp agreements automatic generation method comprises the following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the number in attribute ModBusTCP tables
Initialized according to conversion FunctionCode row, and the value of the row is arranged to the 5th field of Property ID；
S2：According to the ModBusTCP typonym DPT_NAME fields in the agreement engineering parameter table page to attribute ModBusTCP
Typonym DPT_NAME row in table are initialized；
S3：Typonym DPT_NAME in step S2 arranges the number with reference to corresponding to ModBusTCP in agreement engineering parameter table
Strong point Type ID field sets a property ID the 3rd field；
S4：According to the action type ActionType fields of ModBusTCP in agreement engineering parameter table to attribute ModBusTCP tables
In action type ActionType row initialized, and the value of the row is arranged to the first character section of Property ID；
S5：The address that producer is provided is arranged to second field of Property ID.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, each protocol attribute
It is further comprising the steps of after ID whole fields are provided with：Manufacturer's category is automatically generated according to each field value of the Property ID of setting
Property ID row；The Property ID that manufacturer's Property ID row are copied to subsystem arranges.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, the simplified behaviour
Make to include removing insignificant 0 character before and after blank character and address.
Preferably, the above-mentioned method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, it is described whether to order
The property value for readding row is 1 or 0, corresponds to two kinds of fields of yes/no respectively.
In general, by the contemplated above technical scheme of the present invention compared with prior art, it can obtain down and show
Beneficial effect：
(1) a kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA provided by the invention, profit
The VBA editting functions carried with excel, are automatically configured to the attribute ID field of engineering configuration template, each defining
Data conversion rule, the agreement work of producer are automatically generated respectively after joining rule and each field attribute of selection by the VBA scripts of establishment
The Property ID of protocol module；The device attribute ID extracting methods of each protocol module are designed first, then establish general engineering template
All protocol modules are integrated together to realize that script automatically generates Property ID, improve the accurate of whole configuration template data
Property and form uniformity；
(2) a kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA provided by the invention, energy
Enough by selecting all kinds of field parameters such as data type quickly to carry out automation generation to device attribute ID parameters, ensure data
Accuracy and uniformity, and improve operating efficiency；
(3) a kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA provided by the invention, is led to
VBA Code automatic build Property IDs are crossed, the operation behavior of user has been controlled with specification, has avoided going out in cumbersome operating procedure
It is wrong；Operation interface is more humane, facilitates user to be selected.
Brief description of the drawings
Fig. 1 is the product process figure of BACnet protocol modules Property ID provided in an embodiment of the present invention；
Fig. 2 is the product process figure of KNX protocol modules Property ID provided in an embodiment of the present invention；
Fig. 3 is the product process figure of OPC protocol modules Property ID provided in an embodiment of the present invention；
Fig. 4 is the product process figure of ModBus protocol modules Property ID provided in an embodiment of the present invention；
Fig. 5 is engineering template product process figure provided in an embodiment of the present invention；
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.As long as in addition, technical characteristic involved in each embodiment of invention described below
Conflict can is not formed each other to be mutually combined.
A kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA provided by the present invention, is used
Automatically extracted and format adaptation in the Property ID of multiple Subsystem protocol modules being related to wisdom building；It is currently used
The protocol type of multiple subsystems includes：OPC, KNXNetIp, BACnet and ModBustcp agreement；Each association is devised first
The device attribute ID extracting methods of module are discussed, general engineering template is then established and is integrated together all protocol modules to realize
VBA scripts automatically generate Property ID, and this two parts is described in detail separately below.
First, the flow of each protocol module Property ID generation method
The present embodiments relate to tetra- kinds of agreements of OPC, KNXNetIp, BACnet and ModBustcp, due to every kind of subsystem
The field quantity and form that device attribute ID is included in the agreement of system are inconsistent, so VBA scripts are respectively created first to each association
The Property ID for discussing module carries out format adaptation and extraction, and now the extraction flow to each module is introduced.
1st, BACnet protocol modules
The Property ID of illumination BACnet modules includes five fields：Object Type Names, object ID, data point type name
Claim, data conversion FunctionCode and whether subscription identity.Product process such as Fig. 1 institutes of BACnet protocol module Property IDs
Show, specifically include following steps：
S1：The data in attribute BACnet tables are turned according to the data conversion FunctionCode fields in data conversion table
FunctionCode row are changed to be initialized, the row are arranged to drop-down selection by selectchange events, and by the row
Value is arranged to the 4th field of Property ID；
S2：According to the BACnet Object Type Names field in the agreement engineering parameter table page to the object in attribute BACnet tables
Typonym row are initialized, and the row are arranged to drop-down selection by selectchange events；
S3：Object Type Names in step S2 arrange the type with reference to corresponding to object type in agreement engineering parameter table and abridged
Field sets a property ID first character section；
S4：According to the application data type DPT_NAME fields in agreement engineering parameter table to the data point in attribute BACnet tables
Typonym DPT_NAME row are initialized, and the row are arranged to drop-down selection by selectchange events；
S5：To in attribute BACnet tables whether subscription row initialize, the field includes two kinds of Yes/No and is worth and respectively
Corresponding property value 1/0, the row are arranged to drop-down selection by selectchange events, and the value of the row is arranged into Property ID
The 5th field；
S6：Data point typonym DPT_NAME row in step S4 combine corresponding types value in agreement engineering parameter table
It is set to the 3rd field of Property ID；
S7：Object ID is arranged in order and is set to second field of Property ID；
S8：Property ID row are automatically generated according to each field value of the Property ID set in step S1~S7；
S9：The Property ID that the manufacturer's Property ID row automatically generated are copied to subsystem arranges.
2nd, KNX protocol modules
The Property ID of illumination KNX modules includes three fields：KNX addresses, DPT_ID and data conversion FunctionCode.
The product process of KNX protocol module Property IDs is as shown in Fig. 2 specifically include following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the data in attribute KNXNetIp tables
Conversion FunctionCode row are initialized, and the row are arranged to drop-down selection by selectchange events, and this is arranged
Value be arranged to the 3rd field of Property ID；
S2：According to the KNXNetIp Object Type Names DPT_NAME fields in the agreement engineering parameter table page to attribute
Data point typonym DPT_NAME row in KNXNetIp tables are initialized, and the row are set by selectchange events
Selected for drop-down；
S3：Object type in step S2 arranges the data vertex type ID with reference to corresponding to KNXNetIp in agreement engineering parameter table
Field sets a property ID second field；
S4：The data that KNX group address in attribute KNXNetIp tables arranges are carried out simplifying operation, the data are provided by producer,
Simplify operation to specifically include：Remove before and after blank character and address insignificant 0 character and simplified form and be arranged to Property ID
First character section；
S5：Property ID row are automatically generated according to each field value of the Property ID set in step S1~S4；
S6：The Property ID that the manufacturer's Property ID row automatically generated are copied to subsystem arranges.
3rd, OPC protocol modules
The Property ID of illumination OPC modules includes three fields：Object oriented, data point typonym and data conversion
FunctionCode.The product process of OPC protocol module Property IDs is as shown in figure 3, specifically include following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the data conversion in attribute OPC tables
FunctionCode row are initialized, and the row are arranged to drop-down selection by selectchange events, and by the value of the row
It is arranged to the 3rd field of Property ID；
S2：According to the OPC typonym DPT_NAME fields in the agreement engineering parameter table page to the data point in attribute OPC tables
Typonym DPT_NAME row are initialized, and the row are arranged to drop-down selection by selectchange events, and this is arranged
Value be arranged to second field of Property ID；
S3：The object oriented that producer is provided is arranged to the first character section of Property ID；
S4：Property ID row are automatically generated according to each field value of the Property ID set in step S1~S3；
S5：The Property ID that the manufacturer's Property ID row automatically generated are copied to subsystem arranges.
4th, ModBus protocol modules
The Property ID of electric energy ModBusTCP modules includes five fields：Action type, address, data point typonym, number
According to length or data bit and data conversion FunctionCode.The product processes of ModBus protocol module Property IDs as shown in figure 4,
Specifically include following steps：
S1：According to the data conversion FunctionCode fields in data conversion table to the number in attribute ModBusTCP tables
Initialized according to conversion FunctionCode row, the row are arranged to drop-down selection by selectchange events, and should
The value of row is arranged to the 5th field of Property ID；
S2：According to the ModBusTCP typonym DPT_NAME fields in the agreement engineering parameter table page to attribute ModBusTCP
Typonym DPT_NAME row in table are initialized, and the row are arranged to drop-down selection by selectchange events；
S3：Typonym DPT_NAME in step S2 arranges the number with reference to corresponding to ModBusTCP in agreement engineering parameter table
Strong point Type ID field sets a property ID the 3rd field；
S4：According to the action type ActionType fields of ModBusTCP in agreement engineering parameter table to attribute ModBusTCP tables
In action type ActionType row initialized, the row by selectchange events be arranged to drop-down selection, and
The value of the row is arranged to the first character section of Property ID；
S5：The address that producer is provided is arranged to second field of Property ID；
S6：Property ID row are automatically generated according to each field value of the Property ID set in step S1~S5；
S7：The Property ID that the manufacturer's Property ID row automatically generated are copied to subsystem arranges.
2nd, the flow of engineering template generation method
Realized by the VBA scripts of establishment after being automatically extracted to the Property ID of above-mentioned each protocol module, establish one and lead to
The VBA scripts of each protocol module are called to generate engineering template with VBA scripts；The engineering template product process such as Fig. 5
It is shown, specifically include following steps：
S1：Define the sheet pages of each protocol module, subsystem, equipment, gateway configuration and agreement engineering parameter table and carry out just
Beginningization；
S2：Uniform format is carried out to the sheet pages by public function, benchmark ranks foundation is carried out, removes space, TAB
Symbol etc. operates；Public function is the function that each protocol module is required for calling, for obtaining sheet ranks number, obtaining factory
Business's type etc.；
S3：Protocol type is obtained by subsystem, the sheet in form entered according to the protocol type being related in template
Row hides and the operation of display；
S4：Whether the protocol type for judging to obtain is OPC agreements, if so, being then directly entered step S5；If it is not, then to non-
The device IP of OPC agreements is initialized as requested；
S5：The operation such as IP address configuration, validity check is carried out to the non-OPC agreements after OPC agreements and initialization；
S6：The VBA scripts of each protocol module configuration are called, automatically generate the device attribute ID of each agreement；
S7：The device attribute ID at each protocol module interface is put in storage into engineering template summary table.
It is provided by the invention that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA the invention provides a kind of
Method, by the Property ID of each protocol module of VBA Code automatic builds, improve whole configuration template data accuracy and
Form uniformity；The operation behavior of user has been controlled with specification, has avoided malfunctioning in cumbersome operating procedure.
As it will be easily appreciated by one skilled in the art that the foregoing is merely illustrative of the preferred embodiments of the present invention, not to
The limitation present invention, all any modification, equivalent and improvement made within the spirit and principles of the invention etc., all should be included
Within protection scope of the present invention.
Claims (10)
- A kind of 1. method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA, it is characterised in that including following Step：S1：Define the sheet pages of each protocol module, subsystem, equipment, gateway configuration and agreement engineering parameter table and carry out initial Change；S2：Uniform format is carried out to the sheet pages by public function, carries out benchmark ranks foundation；S3：The protocol type of subsystem is obtained, the sheet in form is hidden and shown according to protocol type；S4：Whether the protocol type for judging to obtain is OPC agreements, if so, being then directly entered step S5；If it is not, then non-OPC is assisted The device IP of view is initialized as requested；S5：IP address configuration and validity check are carried out to the non-OPC agreements after OPC agreements and initialization；S6：The VBA scripts of each protocol module configuration are called, automatically generate the device attribute ID of each agreement.
- 2. the method for wisdom building multi-protocols adaptation engineering template, its feature are rapidly completed using VBA as claimed in claim 1 It is, also includes the device attribute ID storages of each protocol module to the step in engineering template summary table after step S6.
- 3. the method for wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA as claimed in claim 1 or 2, its It is characterised by, the non-OPC agreements include KNXNetIp, BACnet and ModBustcp agreement.
- 4. the method for wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA as claimed in claim 1 or 2, its It is characterised by, the device attribute ID of OPC agreements automatic generation method comprises the following steps：S1：According to the data conversion FunctionCode fields in data conversion table to the data conversion in attribute OPC tables FunctionCode row are initialized, and the value of the row is arranged to the 3rd field of Property ID；S2：According to the OPC typonym DPT_NAME fields in the agreement engineering parameter table page to the data vertex type in attribute OPC tables Title DPT_NAME row are initialized, and the value of the row is arranged to second field of Property ID；S3：The object oriented that producer is provided is arranged to the first character section of Property ID.
- 5. the method for wisdom building multi-protocols adaptation engineering template, its feature are rapidly completed using VBA as claimed in claim 3 It is, the device attribute ID of KNXNetIp agreements automatic generation method comprises the following steps：S1：According to the data conversion FunctionCode fields in data conversion table to the data conversion in attribute KNXNetIp tables FunctionCode row are initialized, and the value of the row is arranged to the 3rd field of Property ID；S2：According to the KNXNetIp Object Type Names DPT_NAME fields in the agreement engineering parameter table page to attribute KNXNetIp tables In data point typonym DPT_NAME row initialized；S3：Object type in step S2 arranges the data point Type ID field with reference to corresponding to KNXNetIp in agreement engineering parameter table Set a property ID second field；S4：The data that KNX group address in attribute KNXNetIp tables arranges are carried out simplifying operation, and is simplified form and is arranged to belong to Property ID first character section.
- 6. the method for wisdom building multi-protocols adaptation engineering template, its feature are rapidly completed using VBA as claimed in claim 3 It is, the device attribute ID of BACnet agreements automatic generation method comprises the following steps：S1：According to the data conversion FunctionCode fields in data conversion table to the data conversion in attribute BACnet tables FunctionCode row are initialized, and the value of the row is arranged to the 4th field of Property ID；S2：According to the BACnet Object Type Names field in the agreement engineering parameter table page to the object type in attribute BACnet tables Name column is initialized；S3：Object Type Names in step S2 arrange the type abbreviation field with reference to corresponding to object type in agreement engineering parameter table Set a property ID first character section；S4：According to the application data type DPT_NAME fields in agreement engineering parameter table to the data vertex type in attribute BACnet tables Title DPT_NAME row are initialized；S5：To in attribute BACnet tables whether subscription row initialize, and the property value of the row is arranged to Property ID 5th field；S6：In step S4 data point typonym DPT_NAME row combine agreement engineering parameter table in corresponding types value by its It is set to the 3rd field of Property ID；S7：Object ID is arranged in order and is set to second field of Property ID.
- 7. the method for wisdom building multi-protocols adaptation engineering template, its feature are rapidly completed using VBA as claimed in claim 3 It is, the device attribute ID of ModBustcp agreements automatic generation method comprises the following steps：S1：The data in attribute ModBusTCP tables are turned according to the data conversion FunctionCode fields in data conversion table Change FunctionCode row to be initialized, and the value of the row is arranged to the 5th field of Property ID；S2：According to the ModBusTCP typonym DPT_NAME fields in the agreement engineering parameter table page in attribute ModBusTCP tables Typonym DPT_NAME row initialized；S3：Typonym DPT_NAME in step S2 arranges the data point with reference to corresponding to ModBusTCP in agreement engineering parameter table Type ID field sets a property ID the 3rd field；S4：According to the action type ActionType fields of ModBusTCP in agreement engineering parameter table in attribute ModBusTCP tables Action type ActionType row are initialized, and the value of the row is arranged to the first character section of Property ID；S5：The address that producer is provided is arranged to second field of Property ID.
- 8. the side that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA as described in any one of claim 4~7 Method, it is characterised in that further comprising the steps of after each protocol attribute ID whole fields are provided with：According to the attribute of setting Each field values of ID automatically generate manufacturer's Property ID row；The Property ID that manufacturer's Property ID row are copied to subsystem arranges.
- 9. the method for wisdom building multi-protocols adaptation engineering template, its feature are rapidly completed using VBA as claimed in claim 5 It is, the simplified operation includes removing insignificant 0 character before and after blank character and address.
- 10. being rapidly completed the method for wisdom building multi-protocols adaptation engineering template using VBA as claimed in claim 6, it is special Sign is that the property value for whether subscribing to row is 1 or 0, corresponds to two kinds of fields of yes/no 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 true CN107864152A (en) | 2018-03-30 |
| CN107864152B 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) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111291441A (en) * | 2020-02-18 | 2020-06-16 | 浙江源创建筑智能科技有限公司 | Intelligent building integration method and system based on object modeling drive |
| CN114222009A (en) * | 2021-12-15 | 2022-03-22 | 北京工业大学 | 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 |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111291441A (en) * | 2020-02-18 | 2020-06-16 | 浙江源创建筑智能科技有限公司 | Intelligent building integration method and system based on object modeling drive |
| CN114222009A (en) * | 2021-12-15 | 2022-03-22 | 北京工业大学 | Industrial communication multi-protocol conversion system |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107864152B (en) | 2020-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107864152A (en) | A kind of method that wisdom building multi-protocols adaptation engineering template is rapidly completed using VBA | |
| CN105549982A (en) | Automated development platform based on model configuration | |
| US9749072B2 (en) | End point parameterization management of generic devices | |
| CN106095376B (en) | A kind of implementation method of quick configuration monitoring picture | |
| CN103020158A (en) | Report form creation method, device and system | |
| WO2017206787A1 (en) | Message forwarding control method for communication network device, and communication network device | |
| CN107817703B (en) | A method of realizing that Industry Control host computer controls slave computer | |
| CN103595717A (en) | Household appliance control protocol conversion method and control terminal | |
| CN105049256A (en) | Method and system for realizing universal custom interface message | |
| CN104268241A (en) | Attribute display method in configuration database | |
| CN105573774B (en) | Application Parameters management and configuration method | |
| CN103425497A (en) | Network engineering script across-manufacturer conversion method and device | |
| CN110460473B (en) | Communication configuration method and device of configuration software and computer readable storage medium | |
| CN114818594A (en) | Automatic wiring and naming method, device, equipment and medium | |
| CN107103035A (en) | This earth's surface data-updating method and device | |
| CN104895817B (en) | A kind of based on the SNMP method carrying out server fan control | |
| CN103902539A (en) | Method and device for analyzing extensible markup language data | |
| CN106406127A (en) | Method and device for generating control interface of Internet of Things (IOT) device | |
| CN110647564A (en) | Hive table establishing method, electronic device and computer readable storage medium | |
| CN103888297A (en) | Interchanger network management method and system | |
| CN100386989C (en) | General command line inputting device based on man-machine interactive languages, and its method | |
| CN106408156A (en) | Flow template recovering method and device | |
| CN112511600B (en) | Method, system, equipment and storage medium for data matching of intelligent household equipment | |
| CN115639998A (en) | Report management method and device, storage medium and electronic device | |
| JP2005044111A (en) | Field bus system |
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 |