CN111830919B - Terminating file generation method and device based on EPLAN platform - Google Patents
Terminating file generation method and device based on EPLAN platform Download PDFInfo
- Publication number
- CN111830919B CN111830919B CN202010699650.5A CN202010699650A CN111830919B CN 111830919 B CN111830919 B CN 111830919B CN 202010699650 A CN202010699650 A CN 202010699650A CN 111830919 B CN111830919 B CN 111830919B
- Authority
- CN
- China
- Prior art keywords
- file
- termination
- platform
- eplan
- typical
- 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
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000010586 diagram Methods 0.000 claims abstract description 12
- 238000004519 manufacturing process Methods 0.000 claims abstract description 6
- 230000008676 import Effects 0.000 claims description 17
- 238000003780 insertion Methods 0.000 claims description 4
- 230000037431 insertion Effects 0.000 claims description 4
- 238000001514 detection method Methods 0.000 claims description 3
- 230000004048 modification Effects 0.000 claims description 3
- 238000012986 modification Methods 0.000 claims description 3
- 238000005538 encapsulation Methods 0.000 claims 1
- 230000006872 improvement Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 5
- 230000008054 signal transmission Effects 0.000 description 4
- CXOFVDLJLONNDW-UHFFFAOYSA-N Phenytoin Chemical compound N1C(=O)NC(=O)C1(C=1C=CC=CC=1)C1=CC=CC=C1 CXOFVDLJLONNDW-UHFFFAOYSA-N 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000004992 fission Effects 0.000 description 2
- 230000004927 fusion Effects 0.000 description 2
- 230000003252 repetitive effect Effects 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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]
-
- 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)
- Small-Scale Networks (AREA)
Abstract
The invention relates to a method and a device for generating a terminating file based on an EPLAN platform, belongs to the technical field of nuclear power, and solves the problems of low efficiency and high error rate in the prior art. The termination file comprises a terminal wiring table, and the generation method of the termination file comprises the following steps: manufacturing a standard macro required by a digital control system DCS on an EPLAN platform; making a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type; reading a database file of a DCS engineer configuration diagram by using PREPLAN to generate a Typical file; importing the Typical file into an EPLAN platform, performing signal matching, and then exporting and processing the EXCEL cable information file; and importing the processed EXCEL cable information file into a PREPLAN platform and automatically generating a termination file. The efficiency and quality of terminating the file is improved and the error rate is reduced.
Description
Technical Field
The invention relates to the technical field of nuclear power, in particular to a method and a device for generating a terminating file based on an EPLAN platform.
Background
All matter in the world is composed of atoms, which in turn are composed of atomic nuclei and electrons around them. The fusion of light nuclei and the fission of heavy nuclei can release energy, which are called nuclear fusion energy and nuclear fission energy, nuclear energy or nuclear power for short, respectively. A nuclear power plant is a novel power plant which produces electricity on a large scale by means of energy stored in a nuclear reactor. Nuclear power dcs (digital control systems) is called a nuclear power digital control system or a nuclear power digital instrument control system.
The compiling of a nuclear power DCS terminal wiring table is one of main works in nuclear power DCS hardware design, the former method is mainly realized by combining Excel with a VBA script, and the compiling is roughly divided into the following steps: (1) extracting the terminal basic information tables from the database one by one, and merging all the basic information tables; (2) manually matching each signal in the combined basic information table until all the signals are matched; (3) the merging and encoding work of the cables is carried out manually; and (4) generating a termination file by referring to the EXCEL template from the cable information table.
The above-described method steps of the prior art have the following problems:
(1) the efficiency is low. The method steps have a large amount of manual operation, and a large amount of manpower and time are consumed. Each connection signal needs manual matching, the operation steps are complicated, and various EXCEL meters need to be switched back and forth; and
(2) the error rate is high. Because too many manual operations can cause many people to have errors, and a large number of manual configurations are manually made, so that fatigue is easy to occur, and error information is generated.
Disclosure of Invention
In view of the foregoing analysis, the embodiments of the present invention are directed to providing a method and an apparatus for generating a termination file based on an epilan platform, so as to solve the problems of low efficiency and high error rate in the prior art.
In one aspect, an embodiment of the present invention provides a method for generating a termination file based on an EPLAN platform, where the termination file includes a terminal wiring table, and the method for generating the termination file includes: manufacturing a standard macro required by a Digital Control System (DCS) on the EPLAN platform; making a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type; reading a database file of a DCS engineer configuration diagram by using PREPLAN to generate a Typical file; importing the Typical file into the EPLAN platform, performing signal matching, and then exporting and processing an EXCEL cable information file; and importing the processed EXCEL cable information file into the PREPLAN platform and automatically generating the terminating file.
The beneficial effects of the above technical scheme are as follows: the termination file generation method provided by the embodiment of the invention can greatly improve the efficiency and quality of the nuclear power DCS terminal wiring table compilation by utilizing PREPLAN, thereby saving a large amount of time and manpower; and by means of the excellent self-checking function of the EPLAN platform, the error rate of the terminated file can be greatly reduced.
Based on a further improvement of the above method, automatically generating the termination file comprises: when the database file is a database file, generating an IED termination file according to a template of a selected batch LOT package reference termination file, wherein the IED termination file is a disk cabinet termination file; or when the database files are a plurality of database files, generating an ICM termination file according to a template of a selected LOT LOT package reference termination file, wherein the ICM termination file is a termination file of the whole project.
Based on a further improvement of the above method, reading in a database file using a PREPLAN to generate a Typical file includes: reading in a database file by using PREPLAN and extracting termination information; and selecting a corresponding macro name according to the signal type and the number of the signal terminals and filling the termination information into the Typical template to generate the Typical file.
Based on the further improvement of the method, importing the Typical file into the EPLAN platform and performing signal matching comprises the following steps: importing the Typical file into a selected project of the EPLAN platform via an import plug-in; automatically matching signals on the EPLAN platform; and performing matching detection and modification on the automatically matched signals until the signals are completely matched.
Based on the further improvement of the method, exporting and processing the EXCEL cable information file comprises the following steps: exporting the EXCEL cable information file from the EPLAN platform; combining cable information, filling a core sequence, a cable code and the cable information to obtain a complete Cablelist information file; re-importing the Cablelist information file into a selected project of the EPLAN platform via an import plug-in; inversely filling the cable information in the Cablelist information file in the project; and re-exporting the EXCEL cable information table from the EPLAN platform.
Based on further improvement of the method, the Typical template is an EXCEL file written in a specific format, and the standard macro comprises page macros, layout macro, configuration information of placeholder object variables of the schematic macro and insertion coordinate information of the corresponding macro.
Based on a further improvement of the above method, the standard macro is a package of a part of a circuit or a circuit scheme provided on the EPLAN platform for multiple reuse, wherein, when the standard macro is inserted, automatic completion of a part, a name, and a location code of the standard macro is realized by replacing the placeholder object variables.
Based on the further improvement of the method, the import plug-in is a plug-in developed by an EPLAN API and used for importing files, and the import plug-in can be loaded into a form of the EPLAN platform.
In another aspect, an embodiment of the present invention provides a termination file generating device based on an EPLAN platform, where the termination file includes a terminal wiring table, and the termination file generating device includes: the standard macro generation module is used for manufacturing standard macros required by the digital control system DCS on the EPLAN platform; a Typical template generating module used for generating a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type; the system comprises a Typical file generation module, a database file generation module and a database file generation module, wherein the Typical file generation module is used for reading a database file of a DCS system engineer configuration diagram by using PREPLAN to generate a Typical file; the processing module is used for importing the Typical file into the EPLAN platform and carrying out signal matching, and then exporting and processing the EXCEL cable information file; and the termination file generation module is used for importing the processed EXCEL cable information file into the PREPLAN platform and automatically generating the termination file.
Based on the further improvement of the device, the termination file generation module is further configured to: when the database file is one database file, generating an IED termination file according to the selected LOT LOT package by referring to a template of the termination file; or when the database files are a plurality of database files, generating an ICM terminating file according to the selected LOT LOT package and referring to a template of the terminating file.
Compared with the prior art, the invention can realize at least one of the following beneficial effects:
1. the automatic filling of the components, names and position codes of the standard macro is realized by replacing placeholder object variables, so that technicians are released from a large amount of repetitive labor, and the cost is reduced;
2. by means of the excellent self-checking function of the EPLAN platform, the error rate of the terminated file can be greatly reduced; and
3. through the auxiliary operation of the PREPLAN and the lead-in plug-in, the efficiency and the quality of the nuclear power DCS terminal wiring meter are greatly improved, and a large amount of time and labor are saved.
In the invention, the technical schemes can be combined with each other to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, wherein like reference numerals are used to designate like parts throughout.
FIG. 1 is a flowchart of a terminating file generating method based on an EPLAN platform according to an embodiment of the present invention;
FIG. 2 is a flow diagram of exporting and processing an EXCEL cable information file according to an embodiment of the present invention; and
FIG. 3 is a step diagram of the EPLAN platform-based termination file generation apparatus according to the embodiment of the present invention;
FIG. 4 is a flowchart of a nuclear power DCS terminal wiring table generation method based on an EPLAN platform according to an embodiment of the present invention; and
FIG. 5 is a flowchart of the steps of importing a Typical file to an EPLAN platform, exporting an EXCEL cable information file, and processing, according to an embodiment of the invention.
Reference numerals:
302-standard macro generation module; 304-Typical template generation module; 306-Typical file generation module; 308-a processing module; 310-terminating file generating module;
Detailed Description
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate preferred embodiments of the invention and together with the description, serve to explain the principles of the invention and not to limit the scope of the invention.
The invention discloses a terminating file generating method based on an EPLAN platform, wherein the terminating file comprises a terminal wiring table. As shown in fig. 1, the method for generating a termination file includes: step S102, making a standard macro required by a digital control system DCS on an EPLAN platform; step S104, making a Tyfocal template required by the termination file based on the standard macro, wherein the Tyfocal template comprises a macro name, a signal name and a signal type; step S106, reading in a database file of a DCS system engineer configuration diagram by using PREPLAN to generate a Typical file; step S108, importing the Typical file into an EPLAN platform, performing signal matching, and then exporting and processing the EXCEL cable information file; and step S110, importing the processed EXCEL cable information file into a PREPLAN platform and automatically generating a termination file.
Compared with the prior art, the termination file generation method provided by the embodiment can greatly improve the efficiency and quality of nuclear power DCS terminal wiring meter compilation by using PREPLAN, and saves a large amount of time and manpower; and by means of the excellent self-checking function of the EPLAN platform, the error rate of the terminated file can be greatly reduced.
Hereinafter, the epilan platform-based termination file generating method will be described in detail with reference to fig. 1 and 2. The termination file includes a termination wiring table. As shown in fig. 1, the method for generating a termination file includes: step S102, making a standard macro required by a digital control system DCS on an EPLAN platform; and step S104, making a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type. Specifically, the Typical template is an EXCEL file written in a specific format, and the standard macro comprises configuration information of placeholder object variables of a page macro, a layout macro and a schematic macro, and insertion coordinate information of the corresponding macro. The standard macro is a package of a part of a circuit or a circuit scheme and the like which are repeatedly used for many times and provided on the EPLAN platform, wherein when the standard macro is inserted, automatic filling of parts, names and position codes of the standard macro is realized by replacing placeholder object variables.
The method for generating the termination file further comprises the following steps: step S106, reading in a database file of a DCS engineer configuration diagram by using PREPLAN to generate a Typical file. Specifically, reading in a database file using a PREPLAN to generate a Typical file includes: reading in a database file by using PREPLAN and extracting termination information; and selecting a corresponding macro name according to the signal type and the number of the signal terminals and filling termination information into a Tyfocal template to generate a Tyfocal file. Specifically, the Typical file is an EXCEL file written in a specific format, and the page macro, the layout macro, the configuration information of the placeholder object variables of the schematic macro, and the insertion coordinate information of the macro are contained in the Typical file. Specifically, the termination information refers to information representing connection between the disk cabinets in the termination file, and the termination information includes a disk cabinet name, a signal description, a position code, and a connection mode.
The method for generating the termination file further comprises the following steps: and step S108, importing the Typical file into the EPLAN platform, performing signal matching, exporting the EXCEL cable information file, and processing. Specifically, importing the Typical file into the epilan platform and performing signal matching includes: importing the Typical file into a selected project of the EPLAN platform through an import plug-in, and specifically, using a database file read in by the PREPLAN to belong to the selected project; automatically matching the signals on the EPLAN platform; and performing matching detection and modification on the automatically matched signals until the signals are completely matched. As shown in fig. 2, exporting and processing the EXCEL cable information file includes: step S202, exporting EXCEL cable information files from the EPLAN platform; step S204, merging cable information, filling in a core sequence, cable codes and cable information to obtain a complete Cablelist information file; step S206, the Cablelist information file is imported into the selected project of the EPLAN platform again through the import plug-in; step S208, reversely filling the cable information in the Cablelist information file into a project; and step S210, exporting the EXCEL cable information table again from the EPLAN platform. Specifically, the import plug-in is a plug-in developed by the EPLAN API and used for importing files, and the import plug-in can be loaded into a form of the EPLAN platform.
The method for generating the termination file further comprises the following steps: step S110, importing the processed EXCEL cable information file into the PREPLAN platform and automatically generating a termination file. Specifically, automatically generating the termination file comprises: when the database file is a database file, generating an IED termination file according to a template of a selected LOT (LOT) package reference termination file, wherein the IED termination file is a disk cabinet termination file; or when the database file is a plurality of database files, generating an ICM termination file according to the selected LOT packet by referring to the template of the termination file, wherein the ICM termination file is a termination file of the whole project, and specifically, the whole project comprises a plurality of disk cabinets or racks. The ICM termination file is issued by taking an LOT packet as a unit, a data table of the ICM termination file is divided into a Cablelist and an NC _ level0 list, and all termination information of a certain LOT packet is contained for work use such as designing a cable path and the like by a design institute. IED termination file: and releasing the terminal information by taking a certain disk cabinet as a unit, wherein the terminal information comprises all terminal information in the disk cabinet as a field construction file.
Hereinafter, the termination file generation method is described in detail.
The application discloses a nuclear power DCS termination file generation method based on an EPLAN platform, wherein the termination file comprises a terminal wiring meter, and the nuclear power DCS termination file generation method comprises the following steps:
(1) on an EPLAN platform, a standard macro required to be used by DCS termination is manufactured, and the corresponding macros of various signals are customized according to the actual signal transmission requirement, if termination information of a certain termination device needs 3 wires, the macros of 3 core wires need to be customized;
(2) manufacturing a Typical template required by termination, wherein the template needs to embody necessary information of the termination and comprises a macro name, a signal description, a signal transmission type, an interruption point name and the like;
(3) the method comprises the steps that PREPLAN is used for reading in a database of a nuclear power DCS system engineer configuration diagram to extract termination information, a plurality of database files can be read simultaneously, and batch generation of the termination information is achieved, in the process, corresponding macro names are automatically selected according to signal types and the number of signal terminals and filled in a Typical template, and a Typical file is finally generated;
(4) importing the Typical file into a project specified by an EPLAN platform through a plug-in developed by an EPLAN API;
(5) on the EPLAN platform, automatically matching the signals, performing signal matching check, and analyzing and modifying the signals according to the check log until the signals are completely matched;
(6) and cable merging and coding, namely exporting all EXCEL format cable information from the EPLAN platform, realizing the coding and merging of the cables in the surface and the inside, filling in information such as the color, the category and the like of the cables, and obtaining complete CableList information.
(7) And reversely filling the cable information into the EPLAN project by using a plug-in developed by the CableList information file through an EPLAN API, and exporting the cable information in the EXCEL format again.
(8) And importing the exported EXCEL format cable information into a PREPLAN platform, and automatically generating an ICM (Internet control center) termination file or an IED (intelligent electronic device) termination file in a specific format by the program according to the selected LOT LOT (load order) package and referring to a template of the termination file.
Referring to fig. 4, the nuclear power DCS control cabinet set diagram method based on the EPLAN platform of the present embodiment starts from step S0, and in step S1, standard macros required by the DCS control cabinet are manufactured on the EPLAN platform, and macros corresponding to various signals are customized according to the actual signal transmission needs. Step S2 is entered, a Typical template of the termination file is created, and the template needs to embody the necessary information of termination, including macro name, signal description, signal transmission type, and interruption point name. And step S3, reading a database configured by a nuclear power DCS system engineer, and generating a Typical file. The process proceeds to step S4, where the Typical file is imported to the EPLAN platform, the EXCEL cable information file is exported, and the file is processed, including merging cables, filling in cable information, and the like. The process proceeds to step S5, where the processed EXCEL cable information file is re-imported to the EPLAN platform for re-matching. The process proceeds to step S6, the EXCEL cable information table is imported from the EPLAN again and loaded into the PREPLAN, and the program automatically generates an ICM termination file or an IED termination file of a specific format according to the selected LOT package and referring to the template of the termination file. The flow proceeds to step S7, where a series of operations for terminating file distribution are performed. And step S8 is entered to finish the flow of the nuclear power DCS terminal wiring table generating method based on the EPLAN platform.
Referring to fig. 5, "import typcal file to EPLAN platform, export EXCEL cable information file and process" the subroutine starts at step S4.0, proceeds to step S4.1, and reads the typcal file generated at step S3 using the typcal file import function of the API plug-in EPLAN. And S4.2, reading the data in the Typical file line by line, and inserting the macro corresponding to each line into the selected project. The flow proceeds to step S4.3, where it is determined whether the specified macro file exists under the default directory of the EPLAN. If the specified macro file does not exist in the EPLAN default directory, the step S4.10 is entered, and the error information is stored in an error log; if the specified macro file exists, the step S4.4 is carried out to judge whether the reading of the Typical file is finished. If the Typical file is not read completely, returning to the step S4.2, and re-reading the next row of data; and (5) after the Typical file is read, the step S4.5 is carried out, and whether the termination is the first initial edition or not is judged. If the termination is not the first initial version, the process proceeds to step S4.6, and the upper version Cablelist is imported to the EPLAN platform; if the termination is the first initial version, the procedure goes to step S4.7, and the EXCEL cable information table is exported from the EPLAN platform. And S4.8, merging the cable information, filling a core sequence, cable coding and cable information in the table. And S4.9, obtaining the processed EXCEL format cable information table. The flow proceeds to step S4.11, "import Typical file to the EPLAN platform, export EXCEL cable information file and process" end.
The invention discloses a terminating file generating device based on an EPLAN platform, wherein the terminating file comprises a terminal wiring table. As shown in fig. 3, the termination file generating apparatus includes: a standard macro generation module 302, configured to make a standard macro required by the digital control system DCS on the EPLAN platform; a Typical template generating module 304, configured to generate a Typical template required by the terminating file based on a standard macro, where the Typical template includes a macro name, a signal name, and a signal type; a Typical file generation module 306, configured to read in a database file of a DCS system engineer configuration diagram by using a PREPLAN to generate a Typical file; the processing module 308 is used for importing the Typical file into the EPLAN platform and performing signal matching, and then exporting and processing the EXCEL cable information file; and a termination file generation module 310, configured to import the processed EXCEL cable information file into the PREPLAN platform and automatically generate a termination file.
The termination file generation module 310 is further configured to: when the database file is one database file, generating an IED termination file according to the selected batch LOT package by referring to a template of the termination file; or when the database file is a plurality of database files, generating an ICM terminating file according to the selected LOT LOT package and referring to the template of the terminating file.
The terminating file generating device based on the EPLAN platform further comprises a plurality of other modules, and the terminating file generating device based on the EPLAN platform corresponds to the terminating file generating method based on the EPLAN platform, so that the other modules of the terminating file generating device are not described in detail in order to avoid repeated description.
Compared with the prior art, the embodiment of the invention can realize at least one of the following beneficial effects:
1. the automatic filling of the components, names and position codes of the standard macro is realized by replacing placeholder object variables, so that technicians are released from a large amount of repetitive labor, and the cost is reduced;
2. by means of the excellent self-checking function of the EPLAN platform, the error rate of the terminated file can be greatly reduced; and
3. through the auxiliary operation of the PREPLAN and the lead-in plug-in, the efficiency and the quality of the nuclear power DCS terminal wiring meter are greatly improved, and a large amount of time and labor are saved.
Those skilled in the art will appreciate that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program, which is stored in a computer readable storage medium, to instruct related hardware. The computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention.
Claims (8)
1. A termination file generation method based on an EPLAN platform is characterized in that the termination file comprises a terminal wiring table, and the termination file generation method comprises the following steps:
manufacturing a standard macro required by a Digital Control System (DCS) on the EPLAN platform;
making a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type;
reading a database file of a DCS engineer configuration diagram by using PREPLAN to generate a Typical file;
importing the Typical file into the EPLAN platform, performing signal matching, and then exporting and processing an EXCEL cable information file; and
importing the processed EXCEL cable information file into the PREPLAN platform and automatically generating the termination file, wherein the automatically generating the termination file comprises:
when the database file is a database file, generating an IED termination file according to a template of a selected batch LOT package reference termination file, wherein the IED termination file is a disk cabinet termination file; or
And when the database files are a plurality of database files, generating an ICM termination file according to the selected LOT LOT package by referring to a template of the termination file, wherein the ICM termination file is the termination file of the whole project.
2. A termination file generation method according to claim 1, wherein reading in a database file using a PREPLAN to generate a Typical file comprises:
reading in a database file by using PREPLAN and extracting termination information;
and selecting a corresponding macro name according to the signal type and the number of the signal terminals and filling the termination information into the Typical template to generate the Typical file.
3. A termination file generation method according to claim 1, wherein importing the Typical file into the EPLAN platform and performing signal matching comprises:
importing the Typical file into a selected project of the EPLAN platform via an import plug-in;
automatically matching signals on the EPLAN platform; and
match detection and modification are performed on the automatically matched signals until the signals are completely matched.
4. A termination file generation method according to claim 3, characterized in that exporting and processing the EXCEL cable information file comprises:
exporting the EXCEL cable information file from the EPLAN platform;
combining cable information, filling a core sequence, a cable code and the cable information to obtain a complete Cablelist information file;
re-importing the Cablelist information file into a selected project of the EPLAN platform via an import plug-in;
inversely filling the cable information in the Cablelist information file in the project; and
the EXCEL cable information table is again exported from the EPLAN platform.
5. A termination file generation method according to claim 1, characterized in that the Typical template is an EXCEL file written in a specific format, and the standard macro comprises configuration information of placeholder object variables of page macro, layout macro, schematic macro, and insertion coordinate information of the corresponding macro.
6. A termination file generation method according to claim 5, characterized in that the standard macro is an encapsulation of a part of a circuit or a circuit scheme provided on an EPLAN platform for multiple re-use, wherein the automatic filling of parts, names, location codes of the standard macro is achieved by replacing the placeholder object variables when inserting the standard macro.
7. A termination file generation method according to claim 3 or 4, characterized in that the import plug-in is a plug-in developed by the EPLAN API for importing files, wherein the import plug-in is loaded into the forms of the EPLAN platform.
8. A termination file generating apparatus based on an EPLAN platform, wherein the termination file includes a termination wiring table, the termination file generating apparatus comprising:
the standard macro generation module is used for manufacturing standard macros required by the digital control system DCS on the EPLAN platform;
a Typical template generating module used for generating a Typical template required by the termination file based on the standard macro, wherein the Typical template comprises a macro name, a signal name and a signal type;
the system comprises a Typical file generation module, a database file generation module and a database file generation module, wherein the Typical file generation module is used for reading a database file of a DCS system engineer configuration diagram by using PREPLAN to generate a Typical file;
the processing module is used for importing the Typical file into the EPLAN platform and carrying out signal matching, and then exporting and processing the EXCEL cable information file; and
a termination file generation module, configured to import the processed EXCEL cable information file into the PREPLAN platform and automatically generate the termination file, and the termination file generation module is further configured to:
when the database file is one database file, generating an IED termination file according to the selected LOT LOT package by referring to a template of the termination file; or
And when the database files are a plurality of database files, generating an ICM terminating file according to the selected LOT LOT package and referring to a template of the terminating file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010699650.5A CN111830919B (en) | 2020-07-20 | 2020-07-20 | Terminating file generation method and device based on EPLAN platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010699650.5A CN111830919B (en) | 2020-07-20 | 2020-07-20 | Terminating file generation method and device based on EPLAN platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111830919A CN111830919A (en) | 2020-10-27 |
| CN111830919B true CN111830919B (en) | 2021-10-19 |
Family
ID=72923920
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010699650.5A Active CN111830919B (en) | 2020-07-20 | 2020-07-20 | Terminating file generation method and device based on EPLAN platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111830919B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112948384B (en) * | 2021-03-01 | 2024-04-26 | 南京国联电力工程设计有限公司 | DCS wiring table automatic generation method, readable storage medium and computer program product |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504214A (en) * | 2015-01-06 | 2015-04-08 | 北京京诚瑞达电气工程技术有限公司 | Electrical schematic diagram generation method |
| CN107784139A (en) * | 2016-08-26 | 2018-03-09 | 沈阳鼓风机集团自动控制系统工程有限公司 | Compressor control system electrical schematic diagram automatic generation method |
| CN109062570A (en) * | 2018-05-30 | 2018-12-21 | 广州明珞软控信息技术有限公司 | A kind of method and storage medium automatically generating drawing based on EPLAN software |
| EP3525116A1 (en) * | 2018-02-12 | 2019-08-14 | Plmsoft Co., Ltd | Management system of electrical field circuit design |
| CN110909462A (en) * | 2019-11-13 | 2020-03-24 | 中国第一汽车股份有限公司 | Control cabinet automatic wiring method based on virtual environment |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003017096A1 (en) * | 2001-08-14 | 2003-02-27 | Humana Inc | Web-based security with controlled access to data and resources |
| CN104850715B (en) * | 2015-05-28 | 2017-12-01 | 中国北车集团大连机车车辆有限公司 | City rail vehicle wiring method based on EPLAN platforms |
-
2020
- 2020-07-20 CN CN202010699650.5A patent/CN111830919B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504214A (en) * | 2015-01-06 | 2015-04-08 | 北京京诚瑞达电气工程技术有限公司 | Electrical schematic diagram generation method |
| CN107784139A (en) * | 2016-08-26 | 2018-03-09 | 沈阳鼓风机集团自动控制系统工程有限公司 | Compressor control system electrical schematic diagram automatic generation method |
| EP3525116A1 (en) * | 2018-02-12 | 2019-08-14 | Plmsoft Co., Ltd | Management system of electrical field circuit design |
| CN109062570A (en) * | 2018-05-30 | 2018-12-21 | 广州明珞软控信息技术有限公司 | A kind of method and storage medium automatically generating drawing based on EPLAN software |
| CN110909462A (en) * | 2019-11-13 | 2020-03-24 | 中国第一汽车股份有限公司 | Control cabinet automatic wiring method based on virtual environment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111830919A (en) | 2020-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102043719B (en) | Method for testing IEC61850 configuration description file | |
| CN106293664A (en) | Code generating method and device | |
| CN111830919B (en) | Terminating file generation method and device based on EPLAN platform | |
| CN103208087A (en) | Power distribution network data checking method based on international electrotechnical commission (IEC) 61968 standard | |
| EP2511841A2 (en) | System and method for generation of cim-based power system circuit models | |
| CN111400169B (en) | Method and system for automatically generating netlist file for testing software and hardware | |
| CN101499015A (en) | Method and converter for converting high level language to other high level languages | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN112733234B (en) | Device for automatically calculating and generating three-dimensional bridge based on cable information transmission | |
| CN112397210B (en) | Digital design system, method and equipment for nuclear power plant control system of database | |
| CN104750887A (en) | Method for generating parameterized unit in modularized mode | |
| CN113705143A (en) | Automatic simulation system and automatic simulation method | |
| CN113536407B (en) | Method, device and storage medium for constructing project drawing based on unit equipment | |
| CN111580852A (en) | Method and system for identifying software change influence range | |
| CN111830918B (en) | EPLAN platform-based nuclear power DCS control cabinet complete drawing upgrading method and system | |
| CN112988120B (en) | Satellite telemetering downlink scheduling parameter dynamic online binding method and system for Ada language | |
| CN115576928A (en) | Automatic checking method and system for monitoring information point table of transformer substation | |
| CN114153911A (en) | Method and system for custom generation of database test data based on VBA technology | |
| CN107436928B (en) | Measuring price through-flow method of transformer substation engineering | |
| CN105279085A (en) | Rule self-defining based smart substation configuration file test system and method | |
| CN105678637A (en) | Data parsing system and application method thereof for vehicle charging posts | |
| CN112054509A (en) | Method, system, equipment and medium for identifying bus topological structure of transformer substation | |
| CN109543852A (en) | Optical cable link information analysis method and device for intelligent substation | |
| CN101753346B (en) | Method and system for leading in comprehensive webmaster data | |
| CN103064893B (en) | A kind of inspection method of the TAP3 data file based on UNIX |
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 |