CN114003008A - Method for greatly reducing DP configuration workload through database processing - Google Patents
Method for greatly reducing DP configuration workload through database processing Download PDFInfo
- Publication number
- CN114003008A CN114003008A CN202111274230.3A CN202111274230A CN114003008A CN 114003008 A CN114003008 A CN 114003008A CN 202111274230 A CN202111274230 A CN 202111274230A CN 114003008 A CN114003008 A CN 114003008A
- Authority
- CN
- China
- Prior art keywords
- bus
- equipment
- brand
- configuration
- database
- 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.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000012545 processing Methods 0.000 title claims abstract description 11
- 238000004891 communication Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
Images
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/41865—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by job scheduling, process planning, material flow
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/30—Nc systems
- G05B2219/33—Director till display
- G05B2219/33273—DCS distributed, decentralised controlsystem, multiprocessor
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for greatly reducing DP configuration workload through database processing, which comprises the steps of making a sample for each brand according to a conventional bus configuration mode, backing up a DCS database to obtain a DCS database file, converting the DCS database file into an electronic form, and determining that the electronic form contains bus measuring points finished by the conventional bus configuration. Copying the bus measuring points, and replacing the device codes with device codes of other DP bus devices of the same brand; the processed table is converted into a database file, and the newly generated database file is imported into a DCS database, so that the DP bus configuration can be completed. The invention can not cause the problem of data item content mismatching caused by manual omission in the conventional bus configuration, and can greatly reduce the workload of the field DP bus configuration.
Description
Technical Field
The invention relates to the field of configuration of an automatic control system (DCS for short) of a thermal power plant, in particular to a method for greatly reducing DP configuration workload through database processing, which is a method for configuring a Profibus DP bus (DP bus for short) of an Elder system.
Background
At present, the field bus communication technology of the thermal power plant is applied for more than ten years, and the coverage rate of DP buses of a plurality of power plants reaches more than 80%. The DP bus is again one of the most common. The current DP bus configuration is mostly dominated by the conventional DP configuration.
The DP bus configuration process is to associate intermediate points with specific data segments in the communication data between the bus device and the DCS system by establishing the intermediate points, and the intermediate points are marked as bus test points. After the configuration is completed, the DP bus equipment can be monitored and operated by reading or changing the bus measuring points. The conventional DP configuration process is performed manually by associating bus stations one by one. With the spread of bus technology in thermal power plants, a single unit may have 100 to 1000 bus devices. Each device requires an associated bus station, typically a minimum of 6, and possibly up to several tens of stations. Because the field DP bus equipment is more, so DP bus configuration work load is huge, and because the same brand often has tens or even hundreds of equipment, so DP bus configuration work repeatability is high. The conventional DP configuration method takes up a lot of manpower in the field debugging stage. Meanwhile, because the manual DP bus configuration needs more parameters to be set, errors or omissions are easy to occur, and the later maintenance is very difficult.
Disclosure of Invention
The invention provides a method for greatly reducing DP configuration workload through database processing aiming at the DP bus configuration of an Emerson overview 3.x system. Converting the conventional DP configuration process into a mode of processing an electronic form by using a computer to generate bus measuring points, converting the newly generated bus measuring points into a database file, and finally importing the database file into a DCS database to complete DP configuration. In the process of the capital construction of the thermal power plant, the configuration work period is about 4 to 10 months. With 10% to 40% of the time being used for DP bus configurations. By using the method and the device, all DP bus configurations can be completed within 5 to 10 hours under the condition of obtaining a specific equipment brand list, and the workload of field DP bus configurations can be greatly reduced. Rough estimates reduce operating time by at least three and four hundred hours during a plant configuration cycle. The idea can be popularized to various control systems.
The technical scheme adopted by the invention for solving the problems is as follows: a method for substantially reducing DP configuration workload through database processing, comprising the steps of:
the first step is as follows: determining all brands of DP bus equipment adopted in the current thermal power plant according to data, making corresponding abbreviations, and then marking in a database;
the second step is that: determining a specific position of a DP bus measuring point on DP bus data according to a configuration specification provided by a DP bus equipment manufacturer;
the third step: according to the specific position information of the DP bus measuring point in the DP bus data obtained in the second step, respectively making a sample for all DP bus equipment brands used by the thermal power plant in a conventional configuration mode;
the fourth step: determining a list of all DP bus equipment corresponding brands in the thermal power plant, and recording the list as a 'whole plant DP bus equipment corresponding brand list';
the fifth step: exporting a DCS database file by using 'opptexport.exe' of an Emerson system, reading the exported DCS database file by using an 'ovationUtils-D52. xla' EXCEL loading item provided by Emerson to obtain an electronic form in an EXCEL format, recording the electronic form as an 'electronic form generated by an original database', and finishing the subsequent operation in the form;
and a sixth step: for a certain brand, searching the electronic form generated by the original database for the equipment code corresponding to the brand sample equipment in the third step to obtain all bus measuring points related to the brand sample; under the condition that the brand sample configuration is complete and has no omission, other equipment of the brand is considered to need bus measuring points with the same number and the same data items; copying the bus measuring points, and replacing the sample equipment codes with equipment codes of other equipment of the same brand; the data items to be modified according to the actual situation also comprise controller numbers, card positions, ports and addresses;
the seventh step: repeating the sixth step until bus measuring points of all DP bus devices on a brand list corresponding to the whole plant DP bus devices are established, and storing the electronic form at the moment;
eighth step: converting the electronic form saved in the seventh step into a DCS system database file by using an 'ovationUtils-D52. xla' tool;
the ninth step: importing the DCS database file generated in the eighth step into the DCS by using the ovoptimmor.
The tenth step: and finishing other subsequent work of the DP bus configuration.
The method for determining the specific position of the DP bus measuring point on the DP bus data in the second step comprises the following steps: the operation feedback, stop feedback, fault and remote position state of the device are positioned in the first word or the first byte of the input data, and the operation instruction and stop instruction of the device are positioned in the first word or the first byte of the output data.
The 'brand list corresponding to the DP bus equipment of the whole plant' in the fourth step comprises signals of controller numbers, card positions, port numbers, addresses and brands.
According to the method, a sample is made for each brand (each brand can have a plurality of versions, and the configuration method of each version can be different, the brand or the version is different, and the brand or the version is regarded as different brands for simplification), a DCS database is backed up to obtain a DCS database file, and the DCS database file is converted into an electronic form. The spreadsheet contains bus test points that are completed with conventional bus configurations. And copying the part of the bus measuring points, and replacing the device codes of the bus measuring points with the device codes of other DP bus devices of the same brand. The table processed in this way is converted into a database file, and the newly generated database file is imported into a DCS system database. This completes the DP bus configuration. Compared with the prior art, the invention has the following advantages:
1. according to the invention, through a batch replacement mode, bus measuring points of the same brand of equipment are completely consistent except a few special data items such as equipment codes, controller numbers, card positions, addresses and the like, so that the equipment of the same brand has basically the same data items. Under the condition that the bus measuring point data items of the sample configuration are not overlooked, the bus measuring point data items of all devices of the same brand can not be overlooked, and even if a certain data item of the bus measuring point of a certain brand device is adjusted in the later period, the content of the data item can not be mismatched due to manual overlooking in the conventional bus configuration.
2. In the process of the capital construction of the thermal power plant, the configuration work period is about 4 to 10 months. With 10% to 40% of the time being used for DP bus configurations. By using the method and the device, all DP bus configurations can be completed within 5 to 10 hours under the condition of obtaining a specific equipment brand list, and the workload of field DP bus configurations can be greatly reduced. Rough estimates reduce operating time by at least three and four hundred hours during a plant configuration cycle. The idea can be popularized to various control systems. Drawings
Fig. 1 is a flowchart corresponding to the DP bus configuration method of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples of application in engineering.
As shown in fig. 1, a method for greatly reducing DP configuration workload by database processing according to the present invention includes the following steps:
the first step is as follows: firstly, all brands of DP bus equipment adopted in the current thermal power plant are determined according to the data, and corresponding abbreviations are established. Which later can be used for marking in the database.
The second step is that: and determining the specific position of the DP bus measuring point on the DP bus data according to the configuration specification provided by the DP bus equipment manufacturer. The states such as operation feedback, stop feedback, fault, remote location and the like of the device are positioned in the first word or the first byte of the input data, and the operation instruction and the stop instruction of the device are positioned in the second word or the first byte of the output data.
The third step: and according to the specific position information of the DP bus measuring points in the DP bus data obtained in the second step, respectively making a sample for all DP bus equipment brands used by the thermal power plant in a conventional configuration mode.
The fourth step: and determining a list of the corresponding brands of all DP bus equipment in the thermal power plant, and recording the list as a 'whole plant DP bus equipment corresponding brand list'. The list includes at least signals of controller number, card position, port number, address, brand.
The fifth step: exporting a DCS database file by using 'opptexport. exe' of an Emerson system, reading the exported DCS database file by using 'ovationUtils-D52. xla' EXCEL loading item provided by Emerson, and obtaining a spreadsheet in an EXCEL format and recording the spreadsheet as 'a spreadsheet generated by an original database'. The subsequent operations are completed in this table.
And a sixth step: and for a certain brand, searching the electronic form generated by the original database for the equipment code corresponding to the brand sample equipment in the third step to obtain all bus measuring points related to the brand sample. Under the condition that the brand sample configuration is complete and has no omission, other devices of the brand also need the same number of bus measuring points with basically the same data items. These bus stations are duplicated and the device code of the sample device is replaced with the device code of other devices of the same brand. The data items to be modified according to actual conditions include controller numbers, card positions, ports and addresses.
The seventh step: repeating the sixth step until all bus measuring points of the DP bus equipment on the brand list corresponding to the whole plant DP bus equipment are established, and storing the electronic form at the moment.
Eighth step: and converting the electronic form saved in the seventh step into a DCS database file by using an 'ovationUtils-D52. xla' tool.
The ninth step: and importing the DCS database file generated in the eighth step into the DCS by using the ovoTimport.
The tenth step: and finishing other subsequent work of the DP bus configuration.
Examples of the applications
The present invention has been tested in a number of thermal power plants. All DP bus configuration work is done substantially within 1 working day. Saves a large amount of time, standardizes the configuration and brings great convenience for subsequent maintenance.
Claims (3)
1. A method for substantially reducing DP configuration workload through database processing, comprising: the method comprises the following steps:
the first step is as follows: determining all brands of DP bus equipment adopted in the current thermal power plant according to data, making corresponding abbreviations, and then marking in a database;
the second step is that: determining a specific position of a DP bus measuring point on DP bus data according to a configuration specification provided by a DP bus equipment manufacturer;
the third step: according to the specific position information of the DP bus measuring point in the DP bus data obtained in the second step, respectively making a sample for all DP bus equipment brands used by the thermal power plant in a conventional configuration mode;
the fourth step: determining a list of all DP bus equipment corresponding brands in the thermal power plant, and recording the list as a 'whole plant DP bus equipment corresponding brand list';
the fifth step: exporting a DCS database file by using 'opptexport.exe' of an Emerson system, reading the exported DCS database file by using an 'ovationUtils-D52. xla' EXCEL loading item provided by Emerson to obtain an electronic form in an EXCEL format, recording the electronic form as an 'electronic form generated by an original database', and finishing the subsequent operation in the form;
and a sixth step: for a certain brand, searching the electronic form generated by the original database for the equipment code corresponding to the brand sample equipment in the third step to obtain all bus measuring points related to the brand sample; under the condition that the brand sample configuration is complete and has no omission, other equipment of the brand is considered to need bus measuring points with the same number and the same data items; copying the bus measuring points, and replacing the sample equipment codes with equipment codes of other equipment of the same brand; the data items to be modified according to the actual situation also comprise controller numbers, card positions, ports and addresses;
the seventh step: repeating the sixth step until bus measuring points of all DP bus devices on a brand list corresponding to the whole plant DP bus devices are established, and storing the electronic form at the moment;
eighth step: converting the electronic form saved in the seventh step into a DCS system database file by using an 'ovationUtils-D52. xla' tool;
the ninth step: importing the DCS database file generated in the eighth step into the DCS by using the ovoptimmor.
The tenth step: and finishing other subsequent work of the DP bus configuration.
2. The method of claim 1, wherein the database processing is configured to substantially reduce DP configuration workload, and further comprising: the method for determining the specific position of the DP bus measuring point on the DP bus data in the second step comprises the following steps: the operation feedback, stop feedback, fault and remote position state of the device are positioned in the first word or the first byte of the input data, and the operation instruction and stop instruction of the device are positioned in the first word or the first byte of the output data.
3. The method of claim 1, wherein the database processing is configured to substantially reduce DP configuration workload, and further comprising: the 'brand list corresponding to the DP bus equipment of the whole plant' in the fourth step comprises signals of controller numbers, card positions, port numbers, addresses and brands.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111274230.3A CN114003008A (en) | 2021-10-29 | 2021-10-29 | Method for greatly reducing DP configuration workload through database processing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111274230.3A CN114003008A (en) | 2021-10-29 | 2021-10-29 | Method for greatly reducing DP configuration workload through database processing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114003008A true CN114003008A (en) | 2022-02-01 |
Family
ID=79925543
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111274230.3A Withdrawn CN114003008A (en) | 2021-10-29 | 2021-10-29 | Method for greatly reducing DP configuration workload through database processing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114003008A (en) |
-
2021
- 2021-10-29 CN CN202111274230.3A patent/CN114003008A/en not_active Withdrawn
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108563569B (en) | Automatic interface testing method for early warning detection system | |
| CN110310134B (en) | Customized furniture management tracing method based on coding information association | |
| CN111673251B (en) | Virtual debugging method and device for welding parameters and welding quality of robot spot welding | |
| CN105224458A (en) | A kind of database method of testing and system | |
| CN101364529B (en) | Method for automatically downloading sequence number of integrated circuit | |
| CN102968371A (en) | Method and device for testing JAVA API unit component | |
| DE10157323A1 (en) | Method for operating a field device | |
| CN103488562A (en) | Automated testing method and device | |
| CN103870587A (en) | Method for establishing semiconductor manufacturing test technological processes | |
| CN103913672A (en) | Satellite low-frequency interface automatic testing system | |
| CN110928796A (en) | Automatic change test platform | |
| CN112292644A (en) | Constrained programming using block-based workflows | |
| CN114003008A (en) | Method for greatly reducing DP configuration workload through database processing | |
| CN110377476B (en) | Terminal testing method, terminal and readable storage medium | |
| CN102243489B (en) | Cross-platform data processing system and method | |
| CN112346966B (en) | Automatic analysis method for test data of special controller | |
| CN108303669B (en) | Method for improving meter calibration efficiency of intelligent electric meter | |
| CN110609984B (en) | Method and system for automatically splitting Google key in Windows system | |
| CN116542032B (en) | Chip integrated design method and system | |
| CN110866150A (en) | Method for rapidly generating ledger data map and overhauling defects of pre-control equipment family | |
| CN110674573A (en) | Method, device and storage medium for simulating hardware work in MES system | |
| CN111591046B (en) | Bar code binding system and method | |
| CN114448851B (en) | Automatic data testing method and system | |
| CN116561014B (en) | Device and method for generating test case of electric power secondary equipment | |
| CN109857018B (en) | Digital sensor soft model 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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20220201 |